Search results

I've given your suggestion a try but I'm having a bit of trouble getting it to work. What event action should the requery be associated with ? Thanks !

I have a form with combo boxes used to select items for my master table. The first combo box has a list of facilities, say A, B, and C. The second combo box has a list of departments at each facility for example Facility A has D1, D2, and D4, Facility B has D1 and D3, and Facility C has just...

Thanks.

I have a combo box used to enter field problems and is later used to classify data for graphing. The problem is that when the users select the type of problem from the list, they then add notes to the text forming a new unique field problem which results in a new classification. For example...

I'd like to suppress the open windows that display in the tray at the bottom of the windows screen so as the user toggles back and forth between applications, only the active access screen will be available to pick. (otherwise, the user could choose any of the open windows and really get messed...

HELP ! Error - VB not running I've been developing a db for a few weeks and now today it seems I can no longer use VB. When I open a form that has event procedures, I get an error. When I go to design mode, in properties and try to get to any event procedure, existing or new, I also get...

HELP ! Forms will not open I've been developing a database for several weeks and today have encountered a strange problem that won't allow me to open any of my forms. I can look at them in design mode but I cannot open them for data entry. It doesn't matter what form I choose, I get the...

Very concise solution. I like that !! Thanks for your help.

Hello, I found a shareware code 39 extended symbology (with all ascii characters) and was able to print out some barcodes from my database after I loaded the font. I used the *text* format to allow the reader to identify the beginning and end of the barcode with the *. A case number in the...

I'd like to automatically repair and compact my database but NOT every time its used because it takes a very long time to run the procedure on some of the PC's on the LAN - some are old and slooooowwww. Is there a way to schedule a compact and repair say once a week using some code or using a...

I'd like to require the users of my db to press my exit button to exit the database so that everything closes properly without errors. The Access Menu bar at the very top of the screen allows the user to exit using Exit or by simply pressing the X in the upper right corner and above the Menu...

Your solution to the first part of my question works GREAT !! Thanks! I'm still struggling with the solution to the second part of the question. I've looked at the code for the OpenReport Method/Action and still I'm not sure how to maximize the form window when I'm finished viewing the report...

I've designed a db and have the basic functions working pretty well now and just want to clean up a few issues. First, when the user clicks buttons to open new forms and navigates thru the screens to use the forms and reports, I'd like only the active window to show up in the tray at the bottom...

Hello, I found a shareware code 39 extended symbology (with all ascii characters) and was able to print out some barcodes after I loaded the font. I used the *text* format to allow the reader to identify the beginning and end of the barcode. I used the barcode to produce a case number in the...

Hello again, This code has been working very nicely on my development version of the db. (I'm using Access 2002 to develop). This week I took the db in to my client (they are using Access 2000) and now its not working quite right. When the user partially fills out the form and presses...

Where do you select a barcode font ?

I've been testing a prototype db and have it ready to implement. During the testing phase I've entered lots of hypothetical data to test the operation of the db. I've now scrubbed this data but when the users begin to enter live data, I'd like the key to start at 1 again. Is it possible to...

I'm filling in a text box on one form and I'd like to refer to it in an event procedure on another form, how do I do this? Let's say the variable is temperature. When referring to the temperature on the Data_Collection Form, I use Me!temperature but when I try to refer to that variable on a...

I'd like to make decisions on what forms to open based upon a password that the user enters on a form called Pass_Ask. The logic for entering the password is working well. The problem I'm having is with opening the appropriate form. On the Pass_Ask form, I'm using logic as follows: If...

I developed a little db using Access - XP and brought it to the job site where they have Access 2000. The function Monthname does not seem to be supported by Access 2000. Is that true? How can I find out what "built-in" function incompatiabilities I may have in the future? I suppose I can...