Search results

Awesome! Thanks.

I have a single table and need to switch from the same record in form A to to the same record in form B based off the same table. The problem is that something is always the same as itself, the OrderID matches the OrderID for every record so it always sends me to the first record.

I created a fixed header cross tab query that totals up how many photos of each size there is in an order. I wrote some visual basic code to total up the price (kind of complex with the different packages) but any orders without at least one of every size photo completely locks up Access. The...

I need to display the name and phone number of a customer on the appointments form but I haven't been able to get it to link right. I can create appointments with the customer number in a subform in my customer information form, but can't display any information about the customers in the...

I have a table "Orders" linked to two forms, "Summary" and "Complete". I want to be able to click on a button from Summary and have it open the same record in the Complete form. I have 'Access 2007; The Missing Manual' but all it tells how to do is open a predefined record.

Thanks for the tip, but I still get 108. :confused:

I'm trying to make a button that will calculate someone's age by their birthday using Visual Basic. Here is one of my many attempts: Private Sub Command16_Click() CCurrentAge = DateDiff("yyyy", CBirtday, Now) End Sub All I can ever get is 108 no matter what I put in CBirthday (box on my...

Using a query would be adding an extra step for me. All I need to do is have the customers name and phone number so we can print out a copy of the form instantly once it is filled out.

I'm having the same problem in Access 2007. All I want to do is take the phone # and name from my CustomerContactInfo table and put it on my order forms automatically when I enter the customer #. I have created a one to many relationship between the tables but can't get anything to work.