Recent content by Switchwork

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

Follow up/ Nice one for all the advice much appreciated. Here is a list of fields that are in my table. JobNo= Autonumber RefNo= Unique number supplied with each job from customer CustID= Autonumber on customer tble which is entered on to form CustName= Name of Customer (company) EmpNo=...

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

Thank you for this. Sorry I have not checked in for a while but had lots to do. Thankyou again for answering my queries however I am now confused, I was advised to design a new form for myself to add the extra data. This is the thing I designed the database with a form for myself to use to enter...

Thank you for that. This is what I am going to do. Didn't think I had to get into all this technical stuff when I designed the database as it was originally only for me to use. Now with the new computers it makes sense to split the database. However I have one more question. Can I also enter...

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

If I split the database to front end back end thing will I have total access to the database as I have just tried to design a new form and because a collegue of mine has it open I get a message saying that I do not have exclusive access to the database and should I make any changes they may not...

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

How do I go about doing that?? I thought it was something to do with bound and unbound txt boxes but don't know how to sort it out. If you could let me know what to do about this I would appreciate it. Thanx for taking the time to answer my posts most grateful. Will no doubt need more advice in...

That is what I am trying to find out mate. I thought by changing the parameter to invoice number I would not have to manually enter each invoice number. At the moment when I enter the parameter for the invoice report when the report comes up the invoice number has not changed. So then I have...