Search results

Thank you , thank you , thank you!!! I am so very grateful for the time you have taken helping me in my minute of need. Thanx again and Respect!!!

Thankyou and respect for your reply thing is I was thinking the exact same thing about defeating the whole object of a relational database. I have a jobDetails table , CustomersTble Employees table and Vehicles table. The JobsDetails table is the main one this is linked to both the customers...

Thank you for that. I can;t believe that it was as simple as that. When I first read your answer I was kicking myself for not figuring it out myself how dum can you get init?? Thankyou very much. I promise I will have a good think before I post such a stupid question again. Respect to you for...

NOT Sure?? Hello and nice one for the information on this problem I had. However I am not sure what you meant by "Replace vbMonday by the integer, 2 or and may need to replace , by ;." I get the bit about changing , to ;. but the vbMonday to integar I don't get at all. so If you could...

Customer Contact list??!! Hiya all!! Need a bit of help with reporting now. I have done my invoice reports and they have come out looking very professional. My boss is extremely impressed with me. (Good G00d) Anyhow seeing as I got that done pretty easily I thought that doing a report of all...

Combo boxes!! List Boxes!! Just need a little bit of information really. Basically I want to add a Combo or a List box to my Job Details Form as I am getting annoyed in keep inserting the same thing over and over again. I have the JobDetailsTble with fields Customer and Employees. I also have...

Need help again!!!!! Hello and thank you for the help I recently received on this topic. However I totally forgot one thing. My original question was about where I have to enter jobs that have been done the day after the jobs have been completed. I was given a perfectly wonderful answer that...

Thankyou. Is that it?? I thought it would be really hard!! Just goes to show doesn't it? You learn something new everyday! Well You definetly do on this website and thats the truth. I have basically learnt how to design a database from Access books and subscribing to forums such as this. You...

Thanx for that but how on earth do I do that?? I have no idea where on earth I put codes or anything. Strings? I don't know what they are?? So if its not to much trouble could you please let me know exactly how i go about inserting this code. If its not to much trouble!! I am sorry but I don't...

DATEs on tables?? Hello switch here long time no write My problem this week is DATES. I have a Job details table (I work for a courier company) where each day I have to enter the jobs that have been done the day before. At the moment I am entering the same date over and over and over again...

Hello Switch here long time no write! The problem I am now having is with my Invoice numbers. I have obviously been using Invoice numbers when doing the invoice numbers manually. Now I have set up this database I want to be able to continue with the invoice numbers where I left off. Do you...

Yes I Know!!!! Hello and thanx for answering me on this one!! That is one of the questions I wanted answering. Do I have to have both the CustomerID and CompanyName? So I should just have one or the other? And the TotalCost field I need to generate the invoice reports. See the JobCost and the...

Ideas on courier databases.?? HELP ME!!! Hello basically I would like some of you to give me ideas on how to design a database for a courier company. I'd like to know how you people that have experience with these things would go about designing a database that is not like any sample database...

Thanx so much pal. You have totally understood what I was going on about. Didn't think anyone would get it!!! But you did and you explained perfectly. Thanx again. Any more questions that sound complicated to me I know where to come!! I do have other questions but they don't belong in this...

Not Sure On Pk Hello to clarify something. When designing a table you need a PK yeah?? Well when you design a form, for example i have CustomerID in the Customertble. When designing the form do I need to use the CustomerID field in the form or can I just use the Customer name field...

Thank you for that Pbaldy. So it's not that difficult to do then?? Thanx for reassuring me on that one??!! I thought it was something about MACROS?? And I also thought that they were complex business ya get me?? If a wizard pops up then it should be a piece of cake I will let you know how i...

Why Sql???????? Hello Is it easy to learn SQL???? and is something I really need to learn to use MS access??? I keep coming across SQL and am wondering what its all about. I know that when you do a select query in access that access does all the SQL behind the scenes for you. So I am...

Command buttons??? SwitchBoards?? Hello Peeps!!! Wondering if someone smart could provide me with some help here!! I want to know how to create a command button??? I originally thought that this was complex stuff but was assured that it is not??:( Not sure though??!! Just want to know...

Command Buttons??? How do I create a command button?? I thought that was getting into the complicated stuff?? Is it easier than I thought?? I would appreciate someone letting me know how to go about creating command buttons. One more thing can I use command buttons to print reports and...

Thank you for that. Is it easy done???? There is another thing I was wondering if it could somehow be done or something like it?? When I run the query to find the jobs that have been paid is there a way of Archiving those jobs (put them into a JobHistoryTble) or something?? Basically I want...