Question database, table and form query from a self taught newb

[PNGBill]

You should attach a copy of your database that works (or doesn't), for the part in question.
Sample data is handy, if only one or two records.

 

[johncrofts]

Ok if im doin the wrong just let me know but i have a pic of my db

 

[PNGBill]

You should find better table, form and query names. Check out this subject as you wll save a lot of hardship by getting it right early in your database.

 

[johncrofts]

what do you mean by better? any suggestions would be great

 

[PNGBill]

tblClientList
tblFeeder
tblFeederJob
tblRegister
qryFeeder
frmFind - what ? frmFindQuote ??
frmRegister

 

[PNGBill]

Research Reserved Words.
You have a field named Date - This is a reserved word and can not be used.
JobDate, QuoteDate will work.

Spaces in names serve no good purpose. QUOTE NUMBER - QuoteNumber.
JOB NUMBER - JobNumber

CLIENT - ClientID
PRICE - SalePrice

Check Hungarian naming convention & Camel Case - Your choice but many before us have found these to be worth adopting.

 

[johncrofts]

i only have date received, date quoted and date accepted, and as for the frmFIND its not needed i know i just forgot to take it out is all. i learnt this lesson with field name the hard way on excel and i guess im gonna learn again.

but just curious as to know whether or not the basic setup i have done is enough or the right setup for my needs?? what are your thoughts

 

[PNGBill]

Table Client List has field name Date.
Also Sort and Status. While these two names are not on my list of reserved words, I wouldn't use them, just in case. ClientSort, ClientStatus would be my choice.

 

[PNGBill]

You are using lookup on table fields. This is not recomended. Others mmay explain why or do a search.
Better method is to use the form for lookup actions.
Once you become familiar with using Forms for same you have better control on your data.

 

[PNGBill]

Study the copy database.
I have added a Module with the Public Function to get the next Job Number. It would be very easy to build some samrt things into the function to have Job Numbers read Jobnnnn or some other idea.

I also added a Command Button that will appear when the check box is Ticked. This button will then be clicked to confirm you want to make the quote a job.

The are are bits of code to check for records already existing etc.