Search results

Probably an easy fix, can somebody advise. I have a form with a subform, if the subform has more than one line item, the print output will print the number of copies that relate to the number of line items. All line items apprear on all the printouts, how can I just print one report?

Can anybody point me in the right direction, I've build a basic database and sent it to a few users to test & for suggestion, the users are getting the following error when trying to access the "Search" option on the Switchboard. All users have runtime 2013. any help would stop me getting any...

Hi Guys, sorry if this is a dumb question, but here goes. I have a form with a Combobox which populates a customers address: Private Sub cboCustomerAddress_Change() Me.Address1.Value = Me.cboCustomerAddress.Column(2) Me.Address2.Value = Me.cboCustomerAddress.Column(3) Me.Town.Value =...

Hi Guys, Could somebody help with an issue I have regarding a date range search. I have a form with two date picker field (Date From & Date To) which set the range to select from a query. Below is what I'm using to set the date range, the "To" date works but the "From" date also selects dates...

Could anybody tell me if it is possible to set gotfocus on form loading, what I am trying to achieve is to change colour of each field when selecting. I can do this on individual fields but would like to set this parameters for all field service on loading the form. Thanks guys.

Would it be possible for somebody to point in the right direction with an issue I have with Not In The List option on a Combo box. I have a form for ordering parts with a sub form within for selecting the part, What I am trying to achieve is input a new part number into the Combo box which...

Hi Guys, I'm trying to open a form to a specific record, I have a navigation form with a button and text box where i can input the specific record number, although the form opens, it always opens to a new record, I'm using the following to open the form. DoCmd.OpenForm "frmDeliveryNote"...

Been struggling with this for a few hours, I have a form with a Combo box to select customer details, which works fine, however,, when I print a report the Combo box selection shows the record ID and not the Customer name (which is the combo box selection), can anyone help stop me pulling more...

Could I ask if anyone could answer if I can "add" excel cells to a form. The process we currently have is an engineer emails a single line of cells from an excel spreadheet containing details of parts required (Part No. etc.) we them add this to fulfilment spreadsheet and issue the parts, any...

Hi Guys, Is it possible to format a text box based on the selection in a combo box. What I need is when “Date” is selected in the combo box the text box needs to be formatted as a date field. Any help would be great. Thanks

Hi Guys, can I Ask for some advice. I'm fairly new to Access and have an issue regarding a search on a form. I have a combo box to select a table heading and a text box where I can input search criteria. The problem is that my search does not return some records based on a partial text search...

Hi Guys, I'm new to access and would like some advice if possible. I have a form with a subform that has a combo box for selecting part numbers from a parts table, is it possible to manually input to the combo box if no part number exists, which would then update the parts table. Apologies if...