Recent content by dsigner1

Thanks for the fast response. I will check it out but perhaps not so quickly - Working in a south facing office with minimal ventilation probably 90 something. Will report back when it is running.

A thought to add to this. MS are incapable of making decisions so both ADO and DAO are likely to run on and on. Since they are quite different you will most likely find that you need the other one sooner or later. in any event I would suggest explicit definitions e.g Dim Db As DAO.Database...

I have a fairly simple Access Application that needs to create a Word file in one form; And then open that file using the created name and path in another form. The word document should open in a separate window and when the window is closed, return to Access. I do not need to transfer any...

Thank you Jdraw. I thought there was some reason that I had steered clear of the "facility" before. It just seemed to fit the requirement because i got a bit rusty. I'll just create my own 3 state. What a fantastic forum this is. Someone always knows the answer and gives the time up to tell you

Hello Everyone, I have been away from Access for about two years. Now I have offered to help a friend with a program he has. He uses quite a lot of tick boxes for Yes/No questions. he asked me if it was possible to show the difference between entering an actual NO and never ever visiting the...

Thanks Bob that is exactly what I had in mind. Dave - A useful start point but I wanted to know how to deal with all the different types of recordset that are available. The combination of the two should help any one else who gets confused by these pesky but useful objects.

I have always just "bodged" recordsets because I have only needed the odd one or two and got by finding an example to copy. I now need to actually understand the things properly and can't find a decent in depth tutorial. With ADO and DAO, SQL clauses etc it is really a bit of a mine field...

Can anyone tell me how to use a public varable (from another module) as criteria in a query? Say to filter name on "Smith" using Pubvar where PubVar has been set to "Smith" somewhere else. I can't work out how to build an expression which uses a public variable, probably because i don't use...

Everything so far sounds like good advice. let me add a little. You will learn about Access by doing it and inevitably you will change your mind on some things. Don't try and do this in one pass. Identify a mini-database which does a small part of what you want to do and make that work...

hypothetically, simple is good.

Gemma, I am not sure that I unstood the original question that well. I did not think that thew rules were just filters. I am not advocating that the users be deprived of choice in general. Just here it seems that a little bit of work would provide a fixed rule set which would give them 90% of...

OK, I have wasted everyone's time. The error was completely unrelated and not obvious. The two calls actually work fine. Thank you for helping I am back on track.

Giving the user complete freedom for the rules equates to a complete migraine for you. Can you negotiate a compromise? If you can store a reasonably comprehensive set of rules to choose from then your task becomes possible in reasonable time.

Thanks for this reference Hitech

I can call the second popup form from another command button just by pasting the call across and it works just fine. Here are the calls "DoCmd.OpenForm "ThingTypePopForm", acNormal, , , , acWindowNormal DoCmd.OpenForm "ThingSubTypePopForm", acNormal, , SubTypePopFormFilter, , acWindowNormal"