Search results

Hello I would like some information on how to go about creating a way of entering the ID number for ie a customer and there Name appearing in the field space on a form. Is this auto lookup and if so how do I do it. Another thing I am not sure of is the filling out of my forms. If I have a...

Hi all long time no write. I designed the database but would like to attempt a better made one. Basically I would like something like the sample database on clients and orders. You know Clients details at the top and there orders or in my case jobs we have done for them (courier company) at...

Hello all I was reading a post just now and noticed that someone mentioned splitting table into smaller tables. My main table has 23 fields so I was wondering if I should maybe split it down into smaller tables is that supposed to be done?? And if so how do I do it?? Do I then have to split the...

Please you gotta help me with this as I have been working on this since 7:30 am. I had to re do the design of my invoice report. Basically I have a subtotal which adds together the Total cost I used the Summary part in the report wizard to do this part. I then had to add a calculated text box...

Sorry I am here again. Just want to clarify a few things that I have found out!! Just to be on the safe side before I attempt to do this split. The problem I have come across is this. I use my computer which is the one that the two other computers are linked to and the database is in the shared...

I have been doing this database thing for just over a year now and I still have lots to learn. The problem I have at the moment is this: I have a customer field and customer ID field and when i designed it I thought that when I entered the customer ID number into a field it will automatically...

Please help me with this one!!! The problem I am having is this. When I designed the database for our company is was only me that would be using it as no-one else in our office had any knowledge what so ever of Access or even much knowledge of computers in general. So I never designed it for...

I have not posted here for a while but I thought I was doing ok in the database situation. But now something has gone horribly wrong and I don't know how to fix it. I am in desperate need of your help!!!!!!!!!!!! The problem is this. I have been using MS Access 2000 (i think) at work. My boss...

Hello people. I have designed a database and have been using it since before xmas. However as it is my first database design I have noticed the odd thing that I could make better or things that I did not think about putting in to the database. I now want to make the database better but don't...

Hello everyone. Needing more help here. I run a invoice report from a parameter query using the parameter Invoice No. I used to use the Start date and end date parameter but changed it to Invoice No as I wanted the invoice number to appear at the top of the invoice. By doing the Start dAte...

Parameter query gone nuts AGAIN!! Hello peeps. Please forgive me if this is a simple thing but trust me I have tried everything that sorted this similar problem last time. Problem is: I have an invoice report generated from a parameter query. The parameters asked for are [Enter Customer ID]...

Hello only switch here. I have a problem very similar to one I had yesterday that was solved by help from this very forum, however the way I got rid of it yesterday is not happening today. I really don't know what the hell is going on but i have faith that it can be fixed. Right the thing is I...

Hello I want to assign each job done for every customer an Invoice Number. However I am not sure how to go about doing that?? The problem I am having is obviously I don't want duplicates. One invoice number for one invoice each month. However there may be a number of jobs to go on that invoice...

Hello I have generated an invoice report from a parameter query and I want to put a Invoice Number in the Report. However I don't have an Invoice number field. If I was to make an Invoice table with an Invoice number field can I add it to the report now?? Or is there another way of doing it...

Hello peeps. Needing your help again. The problem I have is I have set up a parameter query to generate an invoice report. The parameters I ask are Start Date, End Date and Customer ID. However when I designed the report I changed the way Weight was written in the label so that it fitted in...

Returning queries with no prices. HOW? Hello all. Thanks for all of your help for 2003. Now I need help in 2004. The problem I have is: I am designing a database for a courier company that I work for. I want a query that brings me all the records I have from certain dates that have NO Prices...

Hello Switch here Hope everyone had a nice xmas and I wish you all the very best for the year 2004. Ok I do have a bit of a silly problem. I have tried to find the answer in a number of ways before posting this question and I can't find the answer that I want. Well I'm not even sure if it is...

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

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