Search results

Hi I have developed a DB for work and it has grown, it is about 60Meg, all of a sudden when I am opening Design View in Reports, or queries it started running really slow. I always Compact on Close I have Split the DB. Still no Joy, I have a brand new Dell PC so nothing wrong there. What is...

Hi I have a form that creates an order, when you click on [new order] on the form it moves to a new record and it prints the Purchase Order automatically. This is fine. But I want to have an Tick Box which defaults to Yes ( to print ) but I want to be able to Un-Tick this box then when the...

Hi I cant get my head around this one, I have a Form that enters all details for an Order. On that form is a Tick Box that says Repeatable. If that box is ticked in the future I am able to repeat on that stock item. I have created a form with a List boxea that Lists all Suppliers Stock that...

Hi I have a form, with 2 Combo Box's and a List Box. The Combo Box's provide a search criteria and the results are displayed in the list box [searchList]. I want to be able to double click a record in this List box [searchList] and that will open a from [frm_SearchDisplay] with the selected...

I have a Report that I want to display certain fields depending on data in a field. ( Visible - true/false ) I have created an if statement If Me!SizeScaleGrade = 1 Then SizeScaleGrade_A If Me!SizeScaleGrade = 2 Then SizeScaleGrade_B If Me!SizeScaleGrade = 3 Then SizeScaleGrade_C If...

Hi I have a list box, one of the fields is a yes/no field. Is it possible to double click a record in the list box to toggles between yes and no ( hence updating the record ) ????? H

Silly query, think I am missing something obvious but I shall ask anyway.\ I want to update certain lists in my form do the user can select from this list to update a field, so i click on a button and open a table, update a record and then close it to return to the form. the List does not...

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

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

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

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

is there a way to have a currency field, that is the user enters 3 decimal places it displays 3 d.p. but in the same field if the users enters a 2 d.p. number it only displays 2 d.p with out the 0 on the end e.g $999.123 ( 3.d.p.) $999.12 (2.d.p) i dont want it to displa $999.120 does this...

Hi Guys HELP I have a report that is one report for many product group and depending on the type of product group it display the apprpriate heading, in a group for the details. If there is not an entry for a certain paremeter then the heading does not appear. but if a contract has 10 items...

Hi Guys HELP I have a report that is one report for many product group and depending on the type of product group it display the apprpriate heading, in a group for the details. If there is not an entry for a certain paremeter then the heading does not appear. but if a contract has 10 items...