Search results

tbh i think im going to have to find some other way of doing this. I would of thought this is pretty simple in a database but evidently not. there is something wrong that i dont think anyone quite understands. Ive tried everything now and im still getting the same compile error, wrong...

A button in a form

Fantastic but how do i store that result as something i can use in VBA? for example the Defininition for Mail i.e. TS is the name of a folder in an outlook account therefore to refer to the correct folder TS will be required. currently in my code refering to the folder it is fixed in the...

Ive played around with defining result as variant, string and integers and all 3 generate the same result. I have attached the actual database if you could have a look. I do understand however if you dont wish to download it, it is purely a test bed that i use to test thingsbefore adding them...

thats all correct yes. I have attached an image that shows everything you will need to see. the code should return "TS" but its just failing. I genuinely have no clue where im going wrong??

nope that makes no difference, its almost like access doesnt recognise it. if i press f1 there isnt an entry in the help which is weird

Hi all, im trying to return a single value from a table and assign it to a string to be used later but Dlookup isnt working at all. below is the code im using and the error message im recieving is "wrong number of arguements or invalid property assignment" Sub boo() Dim result As Integer...

Hi all. thanks for your reply however they are going straight over my head! if i pose you with what i am trying to achieve i would be grateful if someone could provide the correct syntax. basically i need to look in the config table and return the definition where the parameter is Email...

thanks for the reply bob that seem to get it working to the next stage however no its saying it cant be found.im presuming then that the code is working but ive named something wrong, can you see it. the table is called Config the field i want to return is Definition the criteria is where...

Hi all, this is my first attempt at SQL, i have copied the syntax directly from a website but im getting the error stating " A run SQL action requires an SQL statement" Any help is appreciated Dim varX As String varX = "SELECT Config.[Definition]" & _ "FROM Config " & _...

Thank you very much

Hi, im unsure of the best way to achieve this so any help is greatly appreaciated. I have several pieces of equiptment that register data every minute, is there a way to do like a 5 minute average i.e 00:00 - 00:04, 05:00 - 09:00 NOT 00:00- 05:00, 01:00- 06:00 and so on. thanks for any help

Hi all, I will try to explain myself fully as im not all that good with access and i dont want to lose myself. 1) I Created a button that imports data into a table (Hours) 2) I created a query that finds duplicates in that table 3)I created a form put the button on said form 4) I dragged my...

thanks i will have a play with that tomorrow but right now its home time :)

thanks for the quick reply, my problem is im not familiar with how access objects work. the below code will work in excel no probs (I have added excel to the object lib) I really would have a few questions relating to it; 1) will this code need to change at all to function properly with access...

Hi all, I have a requirement to create a piece of vba that will open all xlsx files in a folder one at a time then import the data in a range (sheet1!A1:G14) into a table named Weekly Input. seems quite simple when i wrote it down lol thanks for any help