Search results

Thanks! Thanks, the combo box approach seems to work; now I'll just play with the code.

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 anew question, I figured out a work around. Can I stop access from giving me error messages except for the MsgBox I programmed in? I made a MsgBox() in the on Error of a form. It works, but I also get like 3 error messages from Access like Primary Key cannot be null, and you cannot save...

I have the table ordere by item number. So the highest item number is the last record in the table. And that last item number is what I need.

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...

The data type in the table is text. Is there a way to set the data type on a text box. I have never heard of it. Anyway i still get the data mismatch error.

I get a data type mismatch. I don't know why.

the line ' look = Me!ItemNumber ' I am trying to lookup what was entered in the text box ItemNumber on the form, in the table Item File which is the recordset. It doesn't work though.

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 am not sure why it is giving me an error, but on the line Dim ThisDB As Database when the code tries to execute I get a compiler error, saying "User-defined type not defined" I have no idea why that is. The code is right. I also changed it to ____ Dim db As DAO.Database and I still get...

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...

query Is there any other way to do it without having to use an update query?

Links don't work I tried all three links, but they all just bring me to a page advertising a pop-up blocker!

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...

Narrowed it down I narrowed it down I think, by playing with the form a little. When I have the table 'ItemFile' in my subform query it gives the jet engine error I spoke about earlier. However, if I take that table out of the query I don't get an error. The two tables in question are 'Item...

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?