Search results

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

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

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

ok all i have is a copy so far with no coding just physical table without data should i input the codes i have first and then post it up and what exactly should i post just the codes or some pics of the stuff created

can i email u a copy instead there is no data in it yet but as im starting from scratch but need to continue the numbers i have forms and everything setup i have codes written for it at work that will do my numbers its just the acceptd field a dont want to it create a job number until i do i...

i dont quite understand what you mean, i will have a form for input which loads up when register opens and another for find records, so when we get an acception of a job i will find that record and click the yes/no checkbox on the form and viola i want to see an automated number i dont know how...

So scrap that last 1 i figured that with a dmax but now i only want to show up in the table if i click on the yes button because i dont want a job number for a quote we dont win how wopuld i code this up

ok so i finished most of it off sorted out my auto numbering but now i realise i can only have 1 autonumber which is good in a way but i do need another automated column for my job numbers as they are considerably lower lets its something like q9200 and jo3251 i dont want to have to remember the...

hi guys i have been working on my registry again and its kickin my ass, i decided to make it one table and now all i need to do is continue with the original numbers of my quoting system. lets say i am upto quote number 9256, i want my new access table to continue with this number sequentually...

thats exactly what it is to be, any ideas on layout

regardless of the client the way we have it setup in excel is we input data about a quote only the clients dont get there own file or database right now the person inputing the data copyies and paste client details from an earlier entry and which is slow, this is why i have created a table with...

both u guys are awesome i'm just getting back into it now i am going to start all over again from scratch with the new quote regi but i need to continue the numberd seq as i do with the job regi but both your ideas are fantastic i just have to make them work which 1 i dunno yet whatever works...

thanks for the reply, i thought about using 1 table but the thing is i work with people who are scared of computers and the change it can cause although for the better they just dont understand, so i was trying to keep things similar to what we have now in excel just better. i also dont want...

hi guys, im very new to access but i think its been easy enough so far to teach my self on the fly like i did with excel, that aside i have created a table called quote register which is where we store all quotes i.e: quote #, dates, client details, etc etc, this table is linked to my contacts...