Recent content by Neilamc

Was hoping someone could help with this. I'm trying to search between two Issue dates in a form using Where = Where & " AND [DOI] BETWEEN #" + Me![IDStart] + "# AND #" & Me![IDEnd] & "#" This is converted into a query (QueryDEF): Set QD = db.CreateQueryDef("Dynamic_Query", "Select * from...

Hi I've created a form that will create a word doc (based on a template) with all the record info required (thanks to an attachment in a previous posting). I have also been able to open up the SaveAs dialog box following this event. Now, upon saving the word document I want to return the...

I've set up a search form that has text boxes to enter start and end dates. As there are a couple of date fields, there are 4 of these. What I really want is to be able to enter these dates using an ActiveX calendar 8.0 in a seperate form. This would be opened by a little button to the side of...

I've searched the forum but couldn't find an answer to this one I've created four cascading combos that are working fine. These use records from table (A) as a type of list in order to send users in the right direction on the form. Is it possible to record the data chosen in the combos in a...

I think i understand. I'll try that and the search you suggested but it'll probably take me a while to get round to it. Will start a new thread if I get stuck again. thanks for you help Tay (and speed of response!) NM

OK My aim is to produce a library system - something akin to directory filing - in which the choices availible in combo (B) are dependent on those made first in combo (A). Eg. Choose the building: 1 or 2 Choosing building 1 in combo (A) will produce combo (B) with the further choice of...

Tay First of all, apologies, I am very new to this but I have been attempting to do something very similar to mfaj5. I'd also appreciate a helping hand. I tried your method but it failed in a few different ways. The last attempt didn't produce error messages but selection with the combo...