Good answer, and it helped me a lot, once I figured out that the field txtFilePath has to be an OLE type, and not a text field.
If this was utterly obvious to everyone else, sorry.
Brendan
"catch-phrases are just soooooooo last year
Right, sorry - didn't explain myself adequately. My sincere apologies.
I don't want to find records that already exist based on a date parameter chosen by a user, I want the dates that the user specifies to be added to the fields in the records in the query to be used in subsequent calculations...
Chuffin' nora - you don't hang about, do you? Well impressive.
So - if I set up two controls on a form that allows the user to choose from a list of start and end dates, those chosen two dates will be used by a query for all the records in that query?
Is that along the lines of...
I have a query that enables the user to input a start and end date into it, upon which several other queries perform calculations. I need the dates to be user input as they will vary from user to user.
Unfortunately, each one of the sub queries chucks up a parameter entry box asking for the...
Many thanks for replying, but I think I sorted it (got around it) yesterday.
The problem arose because I had an empty field - once I filled in the field, problem gone.
My apologies for not posting this sooner.
Thanks again!
I want to display data from a query that includes images.
I've stored the complete path and filename to the actual files themselves within a table, and then I use the Image tool to update the display via some simple code.
I get a Error 13 Data Mismatch message, when doing this when the query...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.