Recent content by rrueger

Hello, Having trouble with a type mismatch error. I have form with 2 unbound combo boxes and 1 check box. The combo boxes are text boxes, the check box is a yes/no in table. Default Value of check box is 0. Lets call the combo boxes CMB1 and CMB2. and the Check box CK1 My code is breaking on...

Miller, Personally, I wouldn't run a macro in your instance. Do you have four different insurance cards for the four different plans? If so, I would have your customer info table, the create a form which runs a query based on the customers info you want it to pull. TBH I'm not sure if excel has...

I'm getting an object cannot be used with event error when I tried your code.

Hello, Just starting to grasp concepts, need help filling in some holes. Using Access 2003. If I had a form, w/ 1 txt box (txtNum) and 1 combo box (cmbType) with values of RS and CS. I want the combo box to input a default value based on what the user inputs into the textbox (based on first...

Thanks so much So if I had for instance two different fields that the number could be under "Reference Number or Account Number" Would the code be this? (just guessing).. and I did mention I'm using Access 2003. Private Sub CmdFind_Click() Dim db As DAO.Database Dim rst As DAO.Recordset Set...

Hello, General Info. I have a table with Account Number and Money in database backend I have an unbound form for input in the front end. I need to add a button, that when pressed opens another form. This form has one text box which a user can enter an account number to see if the account is...

The database is split at its current state, but both the front end and back end are on the companies shared drive, not the hard drive.

Thanks for the response! I love when it's something so easy. One question though; We have multiple users on the database, stored in a tblUsers table. Is there any way to filter the form so it only shows the information that was posted on the current days date.. for the specific user. I have...

Hello, there is a form at work which basically has a command button on it, when clicked is able to get data from what we call a session screen (basically like a dos screen with customer info) as long as its open, and places the info in the txt box. I have been asked to make another form...

Hello, I have recently been assigned the task of Database manager in my department. 3 weeks ago, I've never used access. 3 weeks later and two books, I'm getting the general concepts of access and vba (enough to write simple codes) to create working forms/tables/queries etc. Okay so I want to...