Search results

Okay, so thinking on it more (Rx_'s post helped nudge me back into action), I have now found a work-around (funny how these things take a while to come to you, three hours of hard work previously and nothing, half an hour now and *ping*). Anyway, this is somewhat convoluted, hence being a...

Ahhh, shame. As I was beginning to fear though. Thanks for responding.

Hello O venerable people, It's a long time since I have posted in these forums, and I don't recall ever having made my way into the Excel forums before, so Hi! Having done a couple of searches (and scanned over 500 thread headers) I have to come to the conclusion either I'm not searching...

Glaxiom, thank you for bringing this issue to the attention of the wider community. Would you please care to provide at least one example of an API which is commonly available and how it could be implemented (or a link to a suitable article)? Cheers, Tim

As a quick fix I've learnt how to use VBA, in the On Current event for a form, to set the value of a text box to the logged on user name, e.g: me.txtBoxName.value = Environ("UserName") You should then be able to use the data as you see fit. Have a look at this thread, which might help. I was...

I've got a similar problem. Unfortunately the Application Save just causes Access to crash. The initial symptom was Access reporting that it could not perform a Save action on the form due to a lack of system memory. The system was restarted, but no joy. I've attempted to Export/Import the...

Okay, update time. Having received no suggestions I went down the Virtual PC route, which worked as *a* solution, although not necessarily available to everyone (you need to be running Vista Ultimate (I'm not sure if either of the Vista Business options are viable but the Home ones are not) to...

Vista Ultimate 32 with MS Office 2007, MS Office 2003 and Visual Studio Tools 2003 installed. I am trying to use the Package Wizard to create an Access 2003 distributable (with the Access run time files included) from a split database. Unfortunately everytime I try to cache the language files...

Hmm. Nothing definite but maybe a couple of thoughts will help you. 1. This isn't the only command that you've got in the button code? 2. Are all of the references that you require present? (Open VBA editor (ALT+F11) \Tools\References.) 3. Are you using Access 2003 on a Vista machine that also...

The yes/no box needs to be in the underlying table, otherwise it can't appear in the query... Other than that, your plan looks sound. Tim

Welcome to the forums! Where are the records from query B being displayed? Is it the case that you have a single form that shows the result set from query A but when you check the box it then displays only those records that are in query A which have no corresponding record in query B? If so...

I can see why. Because I used a single form (rather than three forms) and changed the Record Source on it, I could keep the frame and its code on the form which was changing. Because your need three forms you need to move everything on the to main form. Unfortunately you didn't modify the...

Very weird. Any chance of posting the db? (Remove/alter sensitive data (ensure that the db is otherwise 'normal', sometimes removing certain data can change the way it works), Compact and Repair and then Zip it up.) Tim

Great, I love to hear about it when things go well (it makes such a change... lol). Glad that you're getting it sorted. Tim

The way I had implemented the code the Before_Update event was running on the form that held the text box (into which the 'classification' text was being placed). Does your implementation still have this condition? If not you should move the code to the same form as the text box. As you have...

Errrr, sorry, how did I upset you? I did say where it was, which was your question. I'd hope that my explanation to you questions would be seen as helpful, rather than critical. If you took my comment so then I apologise, they weren't meant that way. As I failed to point out clearly, the...

Welcome to the Forums! I guess that the 'reason' for an Event should be recorded in whatever table you use to record an event instance, if there is only one reason for any particular event. So this would be a single attribute of the event table. If each Event could be run for more than one...

Huh? Now I'm confused. Duplicates in whose tables, mine or yours, and did you or didn't you remove them? It is in the table SheetMachine. It's not in the SheetDetail table because SheetDetail is based on SheetMachine so it inherits its classification from SheetMachine. If you need to find...

Okay, had a look at things. Hopefully the relationships in the attached as similar enough for you to be able to adjust as required. I've only adjusted from the concept I was working on before, rather than trying to get it like the one you posted. Also, all of the format for the fields are...

You're welcome to the help. I hope the code is working for you. Regards, Tim