Search results

Still need some help Thanks for your reply. I enterer the code but it says the variable is not defined and highlights checkbox. I also maybe did not explain myself properly. Each box belongs to a contract number and to make the record unique it has to be contract number, box number. Both...

HELP!! Hi thanks for your reply but to sure what you mean. scott

hi again I hope you have patience? I have tried that but it does not work, must be me OK, each box belongs to a contract, so i have the following tbls tbl 1 contract no PK contract details etc... tbl 2 Contract no pk box no PK yes/no tbl 3 Contract no pk box no pk item no pk box...

hi What I am trying to do is have a form with the main details with the box ticked to say the box is in storage. when the box is unticked then the box is going out of storage, however i then need to fill in additional informationon where the box is going who requested it with dates. I would...

how do i make a form from a query using parameters. when the form opens i would like it to ask criteria to find the record. thanks

Hi I am trying to open a form when I untick the yes/no box and then to find the record I was working on in the original form. I would also like to open the form from the switchboard with a command button but acess to ask what record I am looking for, like a query does when you use [please...

Hi I am trying to get my db to open another form only when I untick the yes/no feature and then the form that loads is to find the record that has been unticked. I am running an archive register and when a box leaves the archive I un tick the box so it is not registered as archived. The form...

Hi I have a db and would like to use the yes/no feature, which is a control in a subform. I would like to tick the box and when i do so to open another form with the same records. A bit of background, I have an archiving db and the tick means that the box is coming out of the archive the form...

Hi all forgive my lack of knowledge but is the idea of a db to reduce data entry? If I had 3 tbls for the following, i would only need to enter the box number once. I have come up with the following what do you think as I still have one problem. tbl 1 tbl2...

hi again Ok, that works, thanks, wait for it haha! However, forgive my lack of knowledge but is the idea of a db to reduce data entry? If I had 3 tbls then i would onlyh need to enter the box number once. I have come up with the following what do you think as I still have one problem. tbl 1...

hi again That sort of works, but when I enter data I am entering box 1 ten times as there 10 items to a box, do I need a third table? If so how do I make sure it links back to contract number? tbl 1 contract number (pk) contract details.... tbl2 contract number box number (pk) tbl 3 box...

thanks for the help, still need assistance is it wise to have an auto number field as I would like to number the boxes 1 to however many there are for each contract. Tbl 1 Contract number (pk) Contract details etc... Tbl 2 Contract number Box number (left as text so I can number each one...

THanks for the reply One record can contain 1 contract number (primary key) with information e.g. surveyor responsible, date archived etc, so that can be one table. Then I can have any number of boxes e.g 10 boxes for one contract , 4 for another contract, it depends on the size of the...

I am using access 97 and looking to start a database for archiving and I require the following fields: Contract number with specific info e.g dates etc. Then relate this to boxes 1-10 although not all the boxes will be used, so I do not need to have 10 box fields. In these boxes each item is...