Search results

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.

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...