Search results

Basically I just need to know if there is a way to update after every keypress while leaving the cursor in the same place. If I use DoCmd.RunCommand acCmdSaveRecord then the cursor moves to the beginning of the field after saving. Please, does anybody have any ideas? Thanks! Scott [This...

Hi, Thanks for the reply. I was using it on the wrong event. Do you know if there is a way to force an update after every keystoke. I've tried using DoCmd.RunCommand acCmdSaveRecord to save the record but then it sets the cursor back at the beginning of the field so the user can't continue...

Hi Pat, That criteria works but I didn't explain my situation thoroughly enough. On my form I have a textbox where they enter the last name (cboLastName). After update of the textbox I have the following code: Private Sub cboLastName_AfterUpdate() If IsNull(Me![cboLastName]) Then...

Hi, I just found out that the search form we've been using for the last two years was fundamentally flawed- only showing records that were not null in certain fields. I guess there is ALOT of value in extensively testing before deploying!! Anyway- I have a query that receives its criteria from...

Hi, I have a search form where I enter criteria in a textbox and it limits the criteria of a query. The results are shown in the same form. I'm currently using the the following code to requery the the query after update on the textbox: Private Sub txtLastName_AfterUpdate()...

You know...the selfishness of some people will never cease to amaze me! Wouldn't we all just love it if an expert would wait patiently at their computer, emailing answers for all our questions. Let me explain something to you Dapple. The countless people who answer questions on this site are...

I have a checkbox and a combobox on my form. I would like the user to be able to choose a selection from the combobox , resulting in the checkbox being checked. Also if the checkbox is unchecked by the user, I would like the form to clear the entry in the combobox. Thanks for any help with...

Hi, I have a simple question about record sources for forms. I have a main customer form with a services performed subform. The services performed subform has a one to many relationship with customer number(in tables). I also have three buttons which bring up pop up forms. All the popup forms...

I believe that is the problem. When I go to the popup form without moving to another record(saving) the information disappears. When I first save the record and then go to the popup form then there is no problem. I tried inserting the following line (on click) for the button that opens the...

I'm having a problem with a subform that is based off a main customer form. My subform pulls up warranty information for the customer that is currently displayed in the main form. The problem is that whenever I enter a new customer into the main form and then go to the subform to enter...

Hi, I have two fields on my form. One is Unit Installed and the other is Unit Age. I would like to use VB to update the Unit Age field after entering a date into Unit Installed. I'm using this expression to find the age: =DateDiff("yyyy",[Unit...

Hi, I have a combo box on my form that has a list of builders. I have limited the input to the list but I would like to have the user be able to add additions to the list without having to leave the form. For example if the user types something that is not on the list, a message box will appear...

Hi, I'm kinda having the same problem with my form. To what event would you add the code listed above? My forms record source changes from a number of parameter queries depending on the button that was pressed on the switchboard. For example if the user wants to search by Company Name then...

Yes you were right. The problem was with the record source. I retyped in the default expression to equal customer number on the main form and now it's working fine. Thanks so much for the help! Scott

Hello, When I entered I get the error message #Name? - but that works for the customers who have records already or have been created in the tblModelSerialNum. The problem is that when autonumber assigns a customer number to the table tblCustInf I need it to also assign the same number to the...

Hello, I having a really hard time trying to get a form/linked-form to work together. My main form (frmCustInf) has customer information fields with an autonumber customer number field. On this form I have a command button which brings up another form (frmModelSerialNum)which has model/serial...

Hello, I have a form that is based off a parameter query that allows the user to enter a customers last name to find the record. When the customer record is pulled up on the form I would like the user to be able to press a command button that prints a report off the currently displayed...

Hi Talismanic, Yeah I got the database. That code worked great! I really appreciate it. I'm still having a problem with my form/subform. When I go to my subform the customer number is not updating. I have linked these forms using the wizard. My other subforms work but my Model/Serial Number...

Yeah I'll email it to you. It's only like 700K. It's awefully kind for you to take your time to help me- Thanks! Scott [This message has been edited by spalmateer (edited 12-14-2000).]

I'm actually not getting an error message. It's just not doing anything when I reenter a duplicate phone number. Could it have something to do with the input mask that I have on the phone number? Does it matter whether it is entered before update on the form properties or the field phone...