Search results

The report called "DraftCJP" in the attached database prints out on loads of pages, many blank, even though in Design View it looks like it is within the margins and it is in Landscape mode. In Print Preview without data it comes to 8 pages, when it should be 2 or 3. I've tried various things...

I have a fairly simple report which lists rows from one table with a little bit of logic. At the end of each row, I want an action button, which when you click it, goes to a form with the correct ItemID for that row. I tried the VBA code like this on the View button on click method...

Hi, I have a report called JobPlans which loads from a query. That query contains a column JobID from a table about jobs. (JobDetails) Inside that report I want to display a list box, with its rowsource as a different query. I'm trying to display items linked to jobs. There's a join table for...

I have a form that I want to open on a new record (with an Autonumber-based ID string that is a calculated field) and this uses a hidden field in the form when it opens to spawn a new record, ready to be related to some additional items in a join table. The user selects those from a list box. I...

Afternoon all. :) I have a list box (List25) that is generated from a query (qryThisBox). One of the fields in that query uses the criteria [Forms]![MyForm]![SelectedField] to filter. I also have combo boxes in the form that List25 displays in. Unfortunately, I want to requery the list box in...

I am using code like this to give warning messages and pass on focus to boxes only when things are selected. Private Sub TextBox2_Exit(Cancel As Integer) If IsNull(Me.TextBox2) Then MsgBox "TextBox2 cannot be left blank" Cancel = True Else ComboBox1.SetFocus End If End Sub I do this...

Tearing my hair out trying to find any help from any source (despite loads of searching and looking in books!) showing me how to make a validation rule for numeric values including a decimal place, eg, I want to allow double values. I have the table field set to Double, but I need to do the...

Hi everyone. :) I have several combo box fields in a bound form where they are selecting values from a list (values stored in a separate table) and then loading a number into the bound table field when selected. How can I put a text prompt in these fields when loading the form which gets...

Hi, I have to do a formula based on the input in four fields and display the calculated value in a report. I only need to use this calculated value in one report. Is the best way to do this to use a calculated field in the table where the four fields are located? Or should I be thinking of...

Afternoon all. :) I can't quite imagine how I do this. I have a form AddNewEquipment. This is bound to a table, EquipmentDetails. EquipmentDetails has a Yes/No field, 'ParentChoice'. So when EquipmentDetails.ParentChoice = Yes, I want to open up a new text box, AddNewEquipment.ParentDescr...

Afternoon. :) I have a combo box, 'Type' that has two values - "Instrument" and "Equipment". Another combo box control, 'Criticality', has an Enabled = False value set OnCurrent. When the user selects "Equipment", Criticality goes Enabled = True and when OnUpdate to "Instrument", Criticality...

I have a big table, EquipmentDetails and separately I have job plans. Job plans can have many pieces of equipment. I store the relationship in EquipmentDetails_JobPlanDetails, but am feeling frustrated as I can't seem to get Access to build the SQL query from this in the way I want. I am...

I've browsed this a lot, but can't see a solution that fits my need. I have a Job Plan form containing a selector that chooses a system number from another table. I want to (inside the same form) look in a third table that ties system numbers to equipment items (one system has multiple items of...

Morning all. :) I have a list box, List3, in a form, which is populated from a query. The list populates correctly. I added a command button which I want to open a new edit form with the selected record from the List3 control. I used this code on the DoubleClick event - it opens the form...

This is odd. :confused: I have a table x where the field value is selected via a combo box in a form that is populated from another table z. When I look in x, it appears to have correctly stored the text from z, not the ID number. I then built a Query, qX, which looks in x and grabs the...

Just a general query about the best approach to take for an editing form. I want to have two separate forms, one for adding a new record (have completed this) and one for choosing and then editing a selected record. In general terms, what is the best design approach for this type of problem...

Afternoon, I have an annoying issue. An old label, previously attached to a combo box, will not delete. I can't select it or move it. I've attached a print screen - it's the one in the lower left of the form called "DeviceTypeDescription". I've tried things like repairing the DB and also...

(Access 2013) This is strange. I deleted an old text box cell on a form and then I created a Combo Box from the design controls and it worked, but underneath it, the old label of the text box is still there, except now it's just described in the properties as an 'empty cell'. It still has the...

I have some code like this that sets some fields up to be disabled when the form loads, then enables them when a combo box ('Type') is selected to 'Instrument'. This works fine as far as it goes, but if the user has selected 'Instrument' and then goes to a new record, the fields remain enabled...

Hi everyone. My first ever posting. :) I have created a tab control called Localinfo in a form. There is only one page in the tab control called Localinfopage. I copied a textbox field called Town into the tab page. From a combo box in the main parent form, I am attempting to enable a field in...