Search results

I have a form that attempts to do a "driver" lookup, based on a Driver ID. I have an After-update procedure, with the code listed below. The problem I have is that after entering a value in the Driver ID field, I get a Run-time error 3251. Any suggestions? Thanks. Private Sub...

I have a table that has items entered into it, each with a corresponding item #. I want on a form for the validation rule to be set so that they cannot enter an item number that is greater than the last record in the table. I could just say [ItemNumber]<Number, but the table will always be...

Is there a way to keep a combo box expanded at all times? So that it is never closed, and you never have to click on the little arrow on the right side? Like a list box but with the same properties as a combo box, that is still being able to enter data instead of having to pick from a list.

I have a subform, and on that subform there is a combo box and many other fields from a table. Is there a way for me to click on a record from a combo box, and have the existing record in the table fill in the fields on a form so I can edit it the existing record, instead of having to enter a...

I have code that uses the value of a field on a form to lookup a record inn another table. After the lookup is done, I want it to use and if/then statement to tell me if the box in the record is Null or has a value, and if it has a value I want it to open a form. Any ideas. I was thinking...

I have a form and a subform. On the subform I have some code which is supposed to be opening two tables and plugging in values using ItemNumber as the lookup. Here is the Code: Private Sub ItemNumber_AfterUpdate() 'Declare DAO object variables and string variable. Dim ThisDB As...

I have 2 tables and need to update fields in one table with values entered in a 2nd table. i.e., i have a transaction form that logs items IN or OUT of a location and datestamps the transaction. when this occurs, i need to update a location and date field in another table (Asset Table). I am...

I have a form with a subform on it. The subform is in the default view of "continuos forms". I have a couple of macros running in the background setting values to some fields, nothing special really. However I keep getting the error message when I open the form and start filling in the first...

I am designing a traqcking database for one of my clients in which they use barcodes. I have form which using the barcodes and some typing they can enter either "IN" or "OUT" for a secific thing. Pretty simple. The only catch is that I do not want to see everytime it was checked out or in, I...

When I open up a form the cursor automatically goes to the first box on the form and starts blinking. However when I hit the add record button I created on the form, the cursor does not re-appear in the box. Does anyone know how to make the cursor re-appear there without clicking on the box?

I am using a crosstab query for a report. In the crosstab query I have the column header being the date, and then then the Type of Toll is the other header going long the Horizontal top of the crosstab. The customer sometimes hasn't entered all the types that should show up on the report. So...

I need to generate a report, that sums up different transaction types. i.e., I have an ORDERS FILE, PARTS DETAILS FILE and LABOR DETAILS FILE. Within the labor category, there are 3 types: INTERNAL, EXTERNAL and MAINTENANCE. Within the parts category, there are 3 types: TIRES, FLUIDS and PARTS...