Search results

Hi I have a forrm (Orders) , with a subform (Order Details) Depending on a selection of a list field it makes certain field visible in the subform. If I go the next record and select the list field it updates fields in the subform ( Visible ( True or False ) But if I go back to the previousl...

Update on your advice Hi Mate Thank you for your detailed replied, I think i am half way there, what I have done is attached a test DB I am working on and the documentation that the user will use to enter on this database. The process is A Pre-Order is created. Once signed off it becomes an...

Selecting the correct table -------------------------------------------------------------------------------- I have an order table and depending on the the product grp it needs to then be able to select the appropriate size scale table. e.g. I order suits, and select a size grade A ( there...

I have an order table and depending on the the product grp it needs to then be able to select the appropriate size scale table. e.g. I order suits, and select a size grade A ( there are 7 size grades ) I then then to enter the size scale for that product. I am not sure whether to create 7...

Not to sure if I am doing the table structure correctly as you may come up with an alternative. I have an [Pre-Order] table, which is linked to an [Order Details], table. A product grp is assigned to each Pre-Order. One Order can have many colours. So what I need is to be able to have an Auto...

Is this possible.? I import daily into my Ms Access DB, 2 Excel csv generated documents. I go to file get external data import select the file and import it into the relevant table. This all works fine. Is there are way to write a macro or a module ( which I have no idea how to do ) to...

Hi My friend has sent me a db, to try and help, but I cant figure it out. She has lost all the default menu's tool bars, etc. when it starts up the design view tool button isnt there. and it automatically opens a form. I cant get to the back end to modify this. I have tried restoring it to...

hI pAT Can i ask another question In a report I have all years across the detail line. And All the Month as a header If I want to monus one year from the other how do I do it e.g January 2003 $ 10 2004 $ 25 so $10 - $25 as i am not to sure if you can refer to the detail line...

LOL

D'oh

Thank you mate, works like a dream

Hi Guys I have a report 2002 which has a Running Sum Caluclation for each month January to December. So February(RunningSum) = January minus February. and so on for March. etc etc This all works well, untill I get to January 2003 which is a new report, based on a new query, but I need the...

Attachment Hi Mate It is too big to zip up and send, do you have an email address I can send it too H

Hi Guys I have a report 2002 which has a Running Sum Caluclation for each month January to December. So February(RunningSum) = January minus February. and so on for March. etc etc This all works well, untill I get to January 2003 which is a new report, based on a new query, but I need the...

Something else have found out Something else I have found out that may help. I have tried again, creating 3 forms. for the 3 subforms subFrm_SHSummary subFrm_FoxOnePatrol subFrm_FoxTwoPatrol I am now opening the main form frm_EndOfShift Opening a Tab Control with 3 tabs for each...

Something else have found out Something else I have found out that may help. I have tried again, creating 3 forms. for the 3 subforms subFrm_SHSummary subFrm_FoxOnePatrol subFrm_FoxTwoPatrol I am now opening the main form frm_EndOfShift Opening a Tab Control with 3 tabs for each sub form...

FOxONe Hi Mate tbl_EndOFShift has one to many relationships with all other tables? so tbl_EndOfShift (1 to many) tbl_SHSumarry tbl_EndOfShift (1 to many) tbl_FoxOnePatrol tbl_EndOfShift (1 to many) tbl_FoxTwoPatrol Does that help mate. Thanks H

Hi I posted a topic earlier. I think I am going mad. Here is what I have done I have a main table tbl_EndOfShift Linked to that main table is many other tables, they are one to many relationships. I have linked them to the main table as a subdatasheet. And build the relationship. So Now I...

I have table with manu subdatasheets, with a 1 to many relationship. I ma crating the main form, and I want to give the user to go to a subform ( the subdatasheet ) if they want and have the form pop up, they enter there details and carry on. I have put on subform on my form and a command...

Thank u mate it worked