Recent content by Ryker

attach your accessdb, and ill take a look at it.

open the table, go into design view on the table. then select that new field you created and look at the bottom there is a expression, type it in there. Hope this helps

create a new Calculated text field, for the calculation just type the following: [YearPrefix] & [YearID] this will display G1

What do you have set as the primary key? that is usually the unique ID that can't be duplicated. If this isn't what you want as a PK, then I would use a validation rule. You can go into design view on your table and at the bottom under general there is a validation rule area. Kind of like...

Click Design Click Add Existing Fields Click on the table you want, then right click and click edit record source. This gives you the query builder to add them. If you plan on using multiple tables you will need to use subforms, from what I have found. Someone may have a better...

Yea, I think the relationships you have could be consolidated, but unsure how exactly they relate. Wish you the best... lol im still trying to get past my roadblock!

Take a look at this, it will add it now, however you will need to setup the others before it will work properly due to the relationships and the requirements of the primary keys being needed.

Right now it looks like all you are trying to pull is the Dealer_Name? Is this the only thing you want to query and save to another table?

Under Design view, open up the property sheet. Click on the combobox you want to use, and then select Data. you should see: Control Source Row Source Row Source Type etc.. etc.. Control Source = where the data is saved to Row Source = where query is pulled from, or manually...

a shot in the dark, but try this: DoCmd.OpenForm "my_form", acNormal, , "ID=" & IDText.Value

That is correct. It sounded like you built the form off that. What is setup under Control Source on the combobox? Also, are you using the combobox wizard? you should be able to setup the query based pull from there, then at the end select where that data goes.

Do you have relationships already setup between the two tables? If so you could click Design on form, then click Add Existing Field, then click on Show all Tables, and then add the location you want it to go to. then add the source to achieve the drop down. Hope this helps!

Hope this helps, or gives you a better idea. This is what I found looking around, I am unable to post links at this time, but hopefully this get you going in the right direction. Create a subform, with your BookingDetails2, set it to continuous form. Then make a new form and add that...

I haven't merged the fields yet, since I do not have a solution to my problem. I currently still have the two tables. I had set NewPCNumber the pk in the NewPCtable I had set the OldPCNumber the pk in the OldPCtable

I wish it were that easy, The issue: I had set NewPCNumber the pk in the NewPCtable I had set the OldPCNumber the pk in the OldPCtable if I merge them I could make the SerialNumber the pk, however I am unable to due to us not know the Serial Number until we get the old computer from...