Recent content by Juan

I saw a comment some time ago (forgive me if it's a misquotation, but it conveys the philosophy): Tell me and I'll forget Show me and I might remember Involve me and I will learn I think that the vast majority here want the final option - I certainly do! I derive a great deal of satisfaction...

PMFJI - I've often found the same when searching for something. I do a search using criteria that I *think* will bring up some relevant information - but zilch. After that, I post a question and get a clue from one of the experts here. The clue might just be a key word or phrase and, hey...

I guessed that would be the way to do it. I just wanted to avoid having to copy associated files if I copy the db. I suppose I could keep just the db and these files in a specific directory and then copy the directory elsewhere. Thank you for the advice.

Hi everyone I know it's possible to use Access to create a Word document and think it's possible to have a button (or combobox) open a Word document saved on the hard drive. If I'm correct with the second belief, the Word file(s) would need to be moved with the Access database if it's moved to...

I guess that the example that you gave initially is relatively simple and the time differences are likely to be very small. I acknowledge the timer itself may be affected by other processes. I know that, as a relative newbie, I'm happy to create some code that works with a few data examples...

Interesting question - but I don't know the answer. I saw a similar question quite some time ago in an Excel forum. I think that the solution was to time the possibilities. Some timer code (Start and then Stop) was put around the code to be tested and, as the code would execute very quickly...

Check this out - it works very well. It doesn't only accept the correct format, but also validates it so, for instance, it wouldn't accept XY34 1PG even though it's in the general format that is consistent with a UK postcode. There is no city with the abbreviation XY...

The opposite of the NotInList Event - I'm interested too! I guess that the query that fills the combobox (assuming you've done it that way) will also have to be reset to give the new values.

Thank you Pat. That makes the situation clear for me now. I thought there must be a good reason why I'd seen the suggestion to use a query, rather than a table. I'll change my practice now.

Hi everyone I've seen a number of threads here, as well as elsewhere, which suggest that it's good practice to use a query to provide data to a subform, rather than placing data directly from the table. I can understand the need for this if a special function of the query is needed, such as...

I managed a workaround - I don't know how efficient it is, but it works. I checked the current record number. If it's 1 or the maximum number of records in the table, it jumps to some code to add a new record. The reason that I check for 1 or max is because I have records displayed in reverse...

Hi I'm not sure what happened because I accessed it via the link about two weeks ago. I agree that it's dead now! Try searching for the words <Access to Word Automation>. I just did that and it brought up the thread which was started by COJMORE at 08:49PM on 01-10-2003. There's a sample...

Hi everyone I posted this question about an hour ago but I seem to have been logged out by the time that I actually pressed "send", so I don't know whether it was posted correctly - I can't find it! I've created four buttons on a form to negotiate my way through the records. When I come to...

Hi Peter (again!) I just deleted and recreated the subform and everything works fine now. That's all very well, but I'm intrigued to know why it didn't work in the first place. None of the fields were locked and they were enabled. I could move to the second subform with the mouse to enter...

Hi Peter Yes, I did and I have no idea why this isn't working. I'm at the early stage of the database design, so I think I'll delete the second subform, save the database and then recreate the second subform. I realise that the code will throw up an error until the second subform has been...