Recent content by jimfrmla

I need to create a query in access from a combo box that allows me to poplulate the entire form once a value is selected from the pull down list. This form is actually a subform. Any suggestions would be greatly apprieciated. Thanks

Perhaps I should explain this better. I am attempting to have a value from one form once entered into a combo box that is not in the Ship to table then trigger the opening of another data entry form so it can be entered into the ship to table and have the value entered into the 1st form that...

I'm still not able to get this to work. I'm new to access and visual basic. I know that the NewData parameter works because the value entered pops up on the prompt part of this code just fine. I just can't figure out how to pass the value to the first field of the blank record when it pops up...

I figured out what the problem was with the rounding. In fact had I just left the field as a text field it would have worked just fine. Thanks everyone for your help.

To PHV, thanks for the code but unfortunately it didn't work at all. The numbers still keep rounding up to the next whole interger. There must be a setting somewhere to turn off the rounding. Thanks Again

I am adding some values from other fields into a calc field. The values keep getting rounded up to the next whole number and I need to turn off the rounding so that this does not happen. I tried specifying the fields as decimal and currency in the table and on the form. It still rounds the...

I've been playing with the NewData parmameter and I still can't get this to work. Below is the code I have tried so far. I'm very new to Access and VB programming. Any suggestions would be greatly apprieciated. Thanks in advance. Private Sub Ship_To_Number1_NotInList(NewData As String...

I had a problem figuring out hot to trigger a form opening up from a combo box when the value didn't exist in the subject table. I figured out what to do to get the form to pop up. In the notinlist event I only put the 2 statements below and eliminated everything else. DoCmd.OpenForm "Ship...

Thanks but I figured out what to do to get the form to pop up. In the notinlist event I only put the 2 statements below and eliminated everything else. DoCmd.OpenForm "Ship to" DoCmd.GoToRecord , , acNewRec It opens the form to a blank record but what I would like to do now is trigger the...

I have tried several interations using the response to this and couldn't get it to work. Perhaps I am typing something wrong. I will explain in detail with actual table and form names below. Starting form name = "Orderdetail1A" Field name of Combo box = "Ship to Number1" Name of table that...

Does anyone know how to create and autonumber field where. You proceed the the number by the current date and then you compare to the last number accepted to generate the next number. Example MMDD-nnnn (format) 0721-0034 0721-0035 0723-0036 (next day) 0723-0037 0723-0038 0724-0039 (nex day)

Does anyone know how to get a data entry window to pop up after you compare a value to a table and the value doesn't exist in the table? I now how to create a combo box and have it auto populate but this isn't the same thing. If the value typed into the field does not match anything in the...

I finally got this to work but only because I deleted the field that was to be auto pulated and re-inserted it again after using this statement. Me![relevant control name] = Me![combo name].Column(1) . It only works if you delete the subject field and re-inserted after putting in this VB...

I tried severa this and several variations of this over the past fee days and still couldn't get it to work. Maybe I don't have enough details. Could somebody give me step by step instructions. Thanks

I need to automatically trigger a data input form from an combo box when the value entered does not match anything pre-existing in the table. Example. The form ties a shipper number field which is linked to a shipper table with full shipper information. When keying a shipper number in the...