Search results

The following is one way to approach it. There would be several ways to do so. 1. Put a command button "Run A Report" on the form. In the Click event of the button have it open a pop up form with 2 combo boxes, cboReport and cboPersonnel. 2. In the pop up form: cboReport data Report1...

You only need to set up 1 table eg tblStock. NEW STOCK Enter all your details on stock. Have a Primary field StockNoID, Autonumber as well. USED STOCK In tblStock put field DateSoldOrUsed, Date. When an item reaches USED STOCK status, then a date is entered into this field. ACTUAL...

Check all the properties of your combo box. Do you have the correct RowSource ppty etc. Make sure that the forms reference to the combo box is entered in the Age Criteria of the query. If all fails why don't you post your database - it should be something easy to fix.

Have done this in a report. This gives alternate rows of white and yellow, and on a laser printer the yellow shows as light grey. You should be able to apply similar to a form. Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer) Dim fColour As Boolean Const WHITE = 16777215...

Sorry Spoony, I sent you the Ak2 version - here is the A97 one.

Easier to do a small database than explain. It has 1 table, 2 queries and 1 form. Run the form to see if it is the result you want. There are several things that need to be done - the only item that isn't reqd was the form's On Open event -> DoCmd.Maximize (to make the form fill the whole...

... or perhaps: =IIF([Product]="Home",1,0) if the Product field is a Text(String) field.

I don't know whether this will help. qryTestData has about 10 calculated fields in it. Could you put these into tblTestData and have a form with all the fields from tblTestData - all would have Enabled = True and Locked = False except for the 10 calc fields which would be Enabled = False and...

Your query problem: qryEA... is built from qryTestData and then qryCombinedData links qryEA... to qryTestData via the primary key TestID. This effectively means that QryTestData is linking to itself using a primary key and therefore is not updateable.

Instead of '" & Me![Combo255] & "'", use """ & Me![Combo255] & """" - this stops the routine falling over if Combo255 has a ' in it such as O'Connor.