Search results for query: *

I have a number of forms each with the following mouseover code: Private Sub Form_MouseMove(Button As Integer, shift As Integer, _ x As Single, y As Single) frmInfoActMPH.Visible = False End Sub Private Sub Image1_MouseMove(Button As Integer, shift As Integer, _ x As Single, y As Single)...

I have a single form with three ComboBoxes. The form displays the UserName, Company and Department. There is a table for each field - TblUser, TblCompany and TblDepart. I want the UserName to be the main source - when a user is selected from the drop-down list the appropriate company and...

I have an inventory access db for which I am creating VB user forms. The main form consists of a number of DBCombo boxes in conjunction with DataControls, successfully retrieve data from other tables. One combobox on the main form is “PlaceofPurchase”. On the main form this box is bound to a...

Thank you LambertH. I finally got your suggestion to work. Sorry it has taken me so long to respond.... Thanks ever so much for your help.

Thanks LambertH for your quick reply. I neglected to tell you that I'm using Access 2002 (Office XP Pro). It's looking for macro 'cmdbutton' I'm researching now how to perform dlookup's in Access 2002.

I have a main form, inventory, with its accompaning table. I have a second table, peripherals, which list the other equipment. The primary key in the main table is the inventory asset number which I have joined to a field in the peripherals table called location, which is the asset number of the...

I have a house inventory table with associated forms and reports. I am trying, unsuccessfully thus far, to include pictures of each inventory item. I have read that it is better to link to a picture than to embed it in the table. I cannot figure out how to do this. I have seen other postings...

Mickyjune26 - Thanks for your quick reply. You mentioned that using AllowEdits may not be the most efficient way to do what I want. What do you suggest?

I am trying to add an Edit Record Command button on a input form so the user must take some action to edit the information. I have the form set to AllowEdits=False. On Click event for the cmdbutton sets AllowEdits=True. My problem is that I cannot figure out a way to reset AllowEdits=False when...

Thanks everyone for the suggestions. I favor the one from johnwm - putting the validation code in the cmdCalculate click event. It works great! Thanks again to all.

I have a form with txtboxes into which data is input. I validate the data; something has to be entered into the txtboxes. After data is entered, either the tab-key or enter-key can be pressed to go to the next txtbox. Once the boxes are filled, the user can press a "calculate&quot...

I have a financial expendures workbook. There is a worksheet for each month. Each monthly worksheet has the following columns; date, description of expendure (normally a single word) and the dollar amount spent. The items are paid at different times during the month so the description and amount...

I have a lot of queries that extract data from a table. I had some problems with a query because the main table is named 'Computer Inventory'. I needed to rename the table to 'Inventory' to solve some problems, but dreaded doing it because of all the queries involved. What I did was to copy the...

Where to start....this is long... I have tried to accomplish this task using the form wizard but just can't seem to figure it out. A landscape page will fit nicely into a three ringed planner. I want to print addresses from a mdb, so that I will end up with four address pages on one sheet of...

Thanks again CajunCenturion. The code you provided works just like I want. Thank you....

Thanks for the quick response CajunCenturion and Dazz22. However, I don't understand how to validate. Is that coded or set in textbox properties? Thanks... O'Neal

Hello, On a form I have multiple text boxes, all of which must contain data so that a calculation can be made and put into the answer text box. I have code that permits only numbers to be entered into the text boxes, however, I do not have code to prevent the boxes from being left empty. I have...

Thanks to all of you now everything works the way I had envisioned it. I had neglected to set the focus. ONeal

I have multiple forms into which users enter numbers to calculate. I want to put a reset button on the form. Once they have calculated and wish to try different numbers, they select the reset button which clears all text boxes and returns them to the first box to enter new data. Any help is...

Hi I'm doing basically the same thing you're doing. The way I eliminated the "deleted" lines was to base my form on a query. To keep my query simple I included all fields and made it sort on one column. My macro includes the following: setwarnings - no hourglass - yes openquery -...