Search results

I have a form that is bound to a query. The query pulls data from 2 tables. One table has company information including company number. The other table is the contact table (also has the company number field) which has contacts within the company. Editing and adding information to the contact...

Okay, I got it, setfocus. I just needed to dig a little deeper. I included the line forms!mainForm!textbox.setfocus in the false part of the previous if statement and it kick me out of the subform and to the next text box in the tab order of the main form. Thanks for the help! GGuy

Rich, Thanks, this worked great but at the point where it does Me.AllowAdditions = False I need the code to kick me back to the main form, to the next field in the tab order. Any thoughts? GGuy

I have a subform called volsub which is continuous and is defined so that it can only be used to add records. The user knows how many records will need to be added in volsub before he begins entry. Because this is a continuous form the user has to mouse click on a field outside the subform to...

Rich, I just moved up another tick on the learning curve. Thankyou! GGuy

This is probably extreamly simple, so thanks for any help because the things I am trying don't seem to work. I have a subform called volsub (continuous) in a form called test. Volsub has a field called z60_num and a total field for z60_num called z60_total. In test I also have a field called...

I was wondering if someone could help me with a meterology calculation. I am converting a Dbase V program to Access and I have been successful moving most of the calculations but this one has me stumped. In some test data I have from the old system I am given that X_WTR_TEMP = 48.8 which would...

Thanks, Doc_man Now that it is working, I can see that you're likely right and that I need to go back to the install CD for additional help files. I was thinking that I might not have a specific reference loaded. I have vb, Obj lib, OLE, activeX and DOA 3.6 obj lib loaded do you suggest others...

That got it! Thanks! Funny I don't seem to have anything in the help on format$ function.

Swing and a miss Peter. I am trying to show a start date on the form and in the table. When you open the form for a given invoice # and no value is found in the [startdate] field on the table then I want todays date. The if statement to find an existing [startdate] works fine. I had already...

I need to create an invoice numbering system. The current sequential numbering system is like this LB000102. LB stands for the system. 0001 is the invoice. 02 is year. The users are very adamnt that the numbering system stay the same. The problem is with the middle number which needs to be...

In the on current event of a form I want to set a field on the form to the current date. The code is simple [startdate]=date Putting =date() in the control source works but I want to use this field in an if or case statement. I just tried adding this statement in the on current event of...

Similar problem I am using Office XP Pro and am not finding the format$ function in the help. Do I need to add a reference? The old manual invoice system we are using records invoice number as LB0013. I can get the right 4 characters and add 1 but when I concatenate 0014 with LB I get LB14...

Thanks, That worked well for the Agency ID but I for the serial number I really didn't want the drop down list so I added the following code in the On Lost Focus; If (DCount("[serial_no]", "standard", "[serial_no] = [serial]") = 0) Then MsgBox "This serial number is not associated...

Rich, I added the combo box but it causes some problems. First, when I enter and agency number, say 5, it immediatley shows 5027. For this app the users will not want to look at a list, so, why does it jump to 5027 when 5 is a legit agency number. Second, if I enter Y5, which is not a legit...

I have stayed away from a combo box in this instance because there are a zillion agencies and 10 times as many serial numbers. When the user enters this info they have the product (serial number is stamped on the side) in their hand and a sheet of paper indicating the agency number. Therefore, I...

Is there a way to popup a message in a form when a record does not exist in a table that is not bound to the form. I am trying to automate some error checking in an application. I have a form that is bound to a table called Test. The user enters an agency ID and a serial number into this form...

I have a subform that is bound to a table called last_test. This subform show the first record in the last_test table. When I close the main form I want to delete the first record in the last_test table. So, when I return to the main form the next record is showing in the subform. I am looking...

This is what I have in the OnClick function; Private Sub Add_record_Click() On Error GoTo Err_Add_record_Click DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 DoCmd.GoToRecord , , acNewRec Exit_Add_record_Click: Exit Sub When I click the add...

I want to add a record to the table but not leave the form. I am using a command button to close the form and I realize that the record will be saved when the form is closed. I also have a command button to save the record and this button does save the record but after the record is saved I...