Search results

I have A2002. What do you mean by a "continuous" form (/subform). I can't seem to find any information on that. For the listbox option, what third party solutions should I search for? Do you know of any that wouldn't be too much trouble (or too costly) to implement?

Yes I have "compact on exit" turned on. Do I need to import them all into one database? What exactly do you mean by that? What if I have just been deleting the failed attempts? Have I lost essential data (it's only a trial at the moment but would be good to know for the future)? I can...

HELP: "Table 'TempMSysAccessObjects' already exists." Have been getting this message when closing my database recently and am a little worried about it. Anybody know what causes this and how I can fix it? Also, in the directory where my database is stored, other copies seem to keep appearing...

I thought it might have had something to do with what is described here but my table fields don't seem to have that property... http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=16072&highlight=record+color+colour

Hi, I can only find ways to change the background colour of whole controls or selections. What I would like however, is to highlight individual records displayed in the same listbox (to represent priority). Is this possible? Thanks, Joshua

When I create a button using the wizard, the VBA code always enters error handling data in there. What sorts of errors does this catch? Should I do this when I make my own modules and code for buttons? Can I manipulate this functionality to handle my own defined errors?

What sort of things cause a database to need to be "repaired" and how can I prevent this in the first place?

Hi, Just recently set up a database for multiple simultaneous users and I'm having trouble with a few bugs. I would like to be able to obtain user information from the "Microsoft Access Record-Locking Information" file so that I can ask those users to quit the program while I make design...

Brilliant. Cheers

Database size issues (also queries vs filters) Hi, On one form of my database, I use around 50 different queries. These handle searches displayed in about 8 different text boxes on the same form depending on my search options. I was told that queries were better to use than filters because...

That's got it. Cheers!

Combo box stuff worked but trying to test the enter key thing and can't find that Enter Key Behaviour option anywhere. The closest I can find is under Tools>Options>Keyboard>Moves After Enter but that just means that nothing happens when I press enter. Is it possible to make it so that enter is...

That's great! Thanks for all of your help.

Hi, I am using a text box on my form and I was wondering if anybody knows how I can cause the 'Enter' key to start a new line in the textbox instead of moving to the next field? Also, I use list boxes for most of my fields so that the user can't make mistakes in their selections...

Yep, the separate module has worked wonders. Thanks!

I have a public function declared in the module for one form public sub a() Do Stuff end sub The problem is that I don't know how to call that (and possibly declare it) correctly from another form's module. call a() doesn't seem to work... Can anybody tell me where I've gone wrong...

No, that's enough. Thanks for your help!

Sweet! Thanks. Do you happen to know any barcode readers that place barcode into keyboard buffer and perhaps attach "between" keyboard and keyboard port so that I don't have to actually replace the keyboard with a barcode reader? I don't want to stuff around with serial port communication if...

Hi, Just trying to use SendObject to send email notification of changes to certain users within our company. The generic email format at the company for internal is "I-LastName, FirstName". Unfortunately, Microsoft Access recognises a comma as a semicolon in the "TO" argument for SendObject...

Hi, I have done quite a bit of searching through the help files and can't seem to find out whether it is possible to obtain input from alternate (hardware) devices such as barcode readers? Does anybody know? Perhaps you could even provide a link to the information please? Thank you!