Search results

Hi, I have 3 tables, tblCompany, tblBranch & tblJobs all linked together. 1 Company to many Branches and 1 Branch to many jobs relationship. The problem is that when I create a lookup field in tblJobs to look up the company (for easy insertion) I get a number instead, rather than the Company...

Hi, Thanks for your response... So, if I have Joe Bloggs & Co, based in London (HQ), and then Leeds, Newcastle and Glasgow and then another co named Access Ltd in Leeds (HQ), and then also in Liverpool, Sheffield, Nottingham and Glasgow... Would I have to create a table for each branch and...

Hi all, I am creating a demo recruitment db and need some advice in knowing how to design it. Basically, an employer (tbl_Employer) will most likely have more than 1 branch. Would I have create a separate table or do I include all the details in the main table with address, phone numbers and...

HI, I need to create the following: "S" = 5 days "M" = 3 day "N" = 0 days So if a user selects from a drop down list 1 of the 3 options (S,M,N) then I need to add the number to the present date. If S then (5 + 3rd June 03) = 8th June 03 How do I tackle this? TIA

Hi, Each time I create a form the font size seem to be small ie 8pt. I have had a quick look in the Tools > Options...but couldn't find anything. Is there a way of setting the font size of forms to something like 12pt? Thanks!

Thank you...I see your point. Date returned is not important in this case as it is an internal library, and if someone has a document their name comes up too. So when a person takes out a doc they just date it and 'sign' it, from a drop down field (tblStaff). Am I going the right way around...

hmmm, a bit confused...you gave me a bit but I coudn't take it to a mile...anyway: I have a DateOut field and next to it (in the query) I have the Returned field, which is the 'yes no'. I tried the expression above (under the Returned field) and all the fields were blank...am I doing something...

Hello all, I have a date field which is filled in by users when they take out the relevant material and a 'yes no' field, so other users can see if it is available or not. Is there a way of automatically making the 'yes no' change to yes/no when the date field is filled in? This I would like...

Is there a sample of the 'video store model' anywhere?

Thank you for your well explained answer. I'll give that a try.

I've done the search but found things relating to loans of a different kind. I've also tried library and got weird answers. Is ther anyone who is willing to help? TIA

Hello, I am trying to create a Library DB, and noticed that we have more than 1 copy of the same book. I have set the ISBN number as the primary key - so I think that I may need to change it (?) The advise that I am seeking is how do I go about showing that the library has 3 copies but only 2...

Hello, I've created a form and juggled with the form fields and sorted out the tab stops. What I need to do now is to get the Focus to display on the first field when a making a new entry. Any advice appreciated. TIA

Hi, I need to set up a DB for our computers, ie an inventory. What I am having struggling with is the first bit of the design. Basically we have, STAFF, PC's, but only 1 PC per user. Does this mean a 1-to-1 relationship? This I have tried and when creating a form to insert details; it is still...

Hi, I've been away from Acces for some time now and having some difficulty with calculating dates. I have an 'InstallDate' field, which I would like to work out the difference from todays date. Basically this would tell the user (when opening the DB) the age of the installation. I hope this...