Hunter (hntr) wrote in ms_access,
Hunter
hntr
ms_access

  • Mood:

Hi

I was looking for some suggestions for a DB I'm working on.. I'll cut to give you the rundown.


Tables

Customers Information (ie. Business Name, Address, phone, fax, contact.)
Machine (ie. Model, SN)
Meter (ie. Model, SN)
Scale (ie. Model, SN)

All tables have a Primary Key of Customer Number.

The tables are already populated with records.

Query's

Look-Up Customer by Name
Look-Up Customer by Customer Number
Look-Up Machine Model (Gives me a list of all customers in town using a given model)
Look-Up Machine SN (Gives me Complete Customer information including, Machine and other equipment)
Look-Up Meter Model (Same as Machine counterpart above.)
Look Up Meter SN (Same as Machine counterpart above.)
Look-Up Scale Model (Same as Machine counterpart above.)
Look Up Scale SN (Same as Machine counterpart above.)

Forms (All open in Edit Mode)

Look-Up Customer by Name
Look-Up Customer by Customer Number
Look-Up Machine SN (Gives me Complete Customer information including, Machine and other equipment)
Look Up Meter SN (Same as Machine counterpart above.)
Look Up Scale SN (Same as Machine counterpart above.)

Reports

Look-Up Machine Model (Gives me a list of all customers in town using a given model)
Look-Up Meter Model (Same as Machine counterpart above.)
Look-Up Scale Model (Same as Machine counterpart above.)

Now All parts are Functional for existing records, But When trying to add a customer, it "LOOKS" like it worked, (I verify new record in all tables) hit save to be on the safe side, But when I do a query on the New Customer, or any of their information I get a blank respose as record not found.

Why would that be?

I've also tried closing the DB and reopening, then running a query on the new entry with same response... record not found.

Any suggestions?

Oh and I'm New to this group, so Hi!! *Waves*



My Sanity Thanks you in advance for your suggestions.
  • Post a new comment

    Error

    default userpic
  • 3 comments

Anonymous

March 13 2007, 13:42:41 UTC 9 years ago

Hi, welcome to the community :)

Could we have a little more info on how you're actually entering the data? Also, how are your tables related? Are your forms based on tables or on queries? Is there any VBA code that you could post?
Basically I Use the forms for editing. The reports for listing.

I Populated the records entering straight into the tables. Then as new customers need to be added, or old ones edited I'm using the forms.

All my forms are built off of my queries.

I've related the tables from the keys. in this order.

Customer Info - Meter - Machine - Scale

I thought about going
                       /----- Meter
Customer Info------ Machine
                       \----- Scale

But since they all are using the same customer number key, I figure I'd just go from one table to next.

With my Customers I can have one Customer with only one Meter and/or Many Machines and/or many Scales.

As I write this, I realize that I should have a form that feeds directly into the tables in edit mode. for NEW customers, instead what I had done was search for a non-existant customer and enter the new stuff in the blank form. The term pure laziness comes to mind. heh

I have no VBA coding in my DB, strictly basic Access.

thanks for your help.
Hi again, wasn't hiding earlier, just can't log in at work.

Sorry, I'm having a bit of a dozy day, could you post a screenshot of your tables in the relationship window, and expand them so we can see all the fields, if possible? I'm not quite picturing how they relate to one another somehow.

Also, could you post the text of your queries (the SQL)? Can can view it (sorry, you probably already know this) by opening up the query and where you have the button at the top left to flick between design mode and viewing the results, change that to SQL, then you could just copy and paste it in here? Depending on the joins and any aggregate functions in the queries, that could be why your forms aren't letting you add new records.