Search results

We have instruments that are calibrated yearly, I have written a small database to keep the records. On my report I have written the following to change the font colour to red if the calibration due date has been exceeded, this works fine. Private Sub Detail_Format(Cancel As Integer...

I have a table with a number of yes/no fields; this table is used as a source for a query, Now when writing a report based on this query, the respective fields return -1 for where I have said Yes and 0 for No, how can I make the fields on the report say “Yes” or “No” I was trying to do...

If I have a tabbed from of say 3 tabs, can I use each tab to populate 3 different tables or can each tab only populate one table, hope this is clear. I have 3 tables a) General b) Process Design c) Mechanical design By putting the tabbed form on a plain master form, I have to select one table...

I have a parent form called "frm_job_enter" and two sub-forms called "frm_fabricator" & "frm_engineer" On the sub form "frm_fabricator" I have a combo box and after updating this combo box (called fabricator) I would like the cursor to jump into a field called “ApllicationsEng” on the other...

When pressing F11 to access the data base window, somehow I have docked it in an awkward position on the screen where as the top of the box containing the minimise, maximise and close button are not visible, how can I drag the data base window to the position I want i.e in the centre of the...

On My form I would like to have code to limit what can be put into a field e.g If Me.Myfield is not = to A, B or C then message "You must enter A, B or C in this field" EndIf Any help please ?

Scenario frmpurchaseorder, for entering the supplier’s details, name address etc frmpurchaseordersub, for entering the items to be purchased frmpurchaseorder, populates the tblpurchaseorder frmpurchaseordersub, populates the tblpurchaseordersub Obviously, when the form frmpurchaseorder is...

I have 5 users who raise documents and am trying to construct an if statement to put their user name on the report without them having to enter it manually, I am picking up their network login name using a function from here If Me![LoginName] = "Fred" Then Me.Text89 = "Jack" Else Me.Text89 =...

I have field (SupplierID) set as Text and the field limited to 5. I want the users to enter the first three digits as text e.g "ABC" and the last 2 digits as numerics e.g "01", thus the input would be "ABC01", I can validate it to 5 digits but cannot get the validation working on the numerics...

I have a form with a sub-form eg Purchase Order with main details on (Po Number, Supplier etc) with a sub form carrying the line items to be ordered. Table PO Form PO Table POSUB Form POSUB When entering main order details into Form PO, why do the fields in the related table(Table PO)...

I have a Drawing Register Table, the drawing can be entered many times but will have an increment in revision eg. A765345 Rev A A765345 Rev B A765345 Rev C etc, etc I am using a combo box on a form to print all records related to the drawing no and it works fine, when dropping down the combo...

When using a combo box to enter someones name, I want the data entered to be from the combo box only eg. The Combo Box has a list of say three name Joe Bloggs Joe Bishop Mike Davies I do not want the field to allow the inputting of any other name than what are listed in the combo box What I...

When dropping down my combo box the field that i'm utilising has many record sets (ie job No) so this means that the Job No is repeated may times. I would like to restrict the drop down list in my Combo Box just to list only one instance of each record. Thank You In Advance for you help

When setting up my report, I set the page margins (print setup) to 15, 15, 10 & 10, this allows me to displlay all the data, when opening it up at the next use of the database the report has always re-set the margins to the default of 24.99, 24.99, 24.99 & 24.99, how can i set the report so that...

If i have a form such as a purchase order, and my first field in the form is line item, I can set a default value of 1, how can I make this field increase to 2 for the next set of records, then 3, 4 etc, thankyou