Recent content by alpine82

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!