Search results

Hi I have a Query and a form which shows records on a table where a Table field matches a field on a subform(ATRNumber). The records outputted by the query are mainly identical records. I want to be able to add a unique string(generated by a DO Loop based on a count of records with...

Hi Firstly sorry if this is not the right section for this. I have a String variable that gets it's value from a textbox. This value can be anywhere from 0000001 to 9999999 Or 000001 to 999999 Or 00001 to 99999 I need to be able to add one to the value on each iteration of a...

Hi I have a Form called FrmAddDueIn which is for adding multiple records into the Table DueInTable. Im using a textbox on the form called AmountTxt to specify the number of records to add when the Button SaveItemsBtn is clicked. I am passing all values to variables before the Loop which...

Hi I have an aggregate query that I'm using to count Items on an order based on part number as well as giving total items on the order. This works but the first line in datasheet view is an empty line other than the order number and a count of 0. Is there a way to stop this line from...

Got a weird problem with my form FrmAddDueIn. I want to create a OnChange event on the textbox NumberTxt that updates the subform ATRRecordQuerySubform. My problem is that the form for an unknown reason will update the subform based on NumberTxt value and the value of the combobox...

Hi I have a Table called DueInTable. This holds a list of items on a order that are due in. Each order has a unique identifier called ATRNumber. What I want to do is create a query that counts the number of Items on the order with the same part number() on the selected order and the output of...

Hi Im trying to copy records from one table to another using a combobox to filter which records to copy. BookInTable = destination Table DueInTable = Table with the records I want copied ATRCombo = ComboBox to select the records I want to copy ATRNumber= Field in DueInTable...

I have a form with a ComboBox which uses the SQL line: SELECT DISTINCT ATRNumber FROM DueInTable; as it's row source. When I run the SQL in query builder it works fine. But via the form the ComboBox list is just showing blank. I thought maybe I had the wrong Bound Column so I...

Hi I have a form called CableBookOut which has a subform called CableSubform and a textbox called ItemTxt. the subform displays records from the table Cables which has a field called box number. I am trying to filter the subform so that it shows records that contain the number entered...

Hi I have a table called components which has fields called Quantity and Min Qty. I want to apply a filter on a subform so that the subform(when opened) only shows the records where the Quantity Field is less than or equal to the Min Qty Field. Any help would be appreciated.

Hi I have a form called ComponentBookOut with a Textbox used for filtering records called ItemTxt and a subform called Componentsubform Which shows all records from the table COMPONENTS I am using the following code to filter the records shown on the subform Private Sub...

Hi I have a main form with a subform. When I open the Subform on its own all records are shown. When I open the main form only one record is shown. how can I get it to show all records when I open the main form? any help would be most appreciated

Hi On my database I'm getting a invalid use of null error when I click save if I leave the notes empty. From what I have read a string can't be Null. So you use Nz. But how do you structure the statement when defining your string variable? I have included a cut down copy of my database...

Hi Im trying to add a barcode to a report which I can scan with a barcode scanner. I have downloaded A code39 TrueType font and created a textbox and have put the following in the Data, Control source ="*" & [Barcode] & "*" but when I print out the report its only converting the field...

Hi Im using a button to print a report based on a text box values on the form. the code for which is below Private Sub SaveBtn_Click() DoCmd.SetWarnings False DoCmd.RunSQL "Update BookInTable SET DateBookedOut = '" & Me!DateTxt & "' WHERE BarCode ='" & Me![BarTxt] & "'"...

Hi I am having a problem setting the margins to print labels in access. I go to page setup and change the margin size click ok and nothing happens to the label and when I go back to page setup the margins have returned to their original values. I have already selected the label printer and...

Hi I have a button on a form which is used to print shipping labels. This button runs a Query and then a report using the code below. Private Sub SaveBtn_Click() DoCmd.SetWarnings False DoCmd.RunSQL "Update BookInTable SET DateBookedOut = '" & Me!DateTxt & "' WHERE BarCode ='" &...

Hi I am trying to make an amend record form which gets values from a subform. Most of the values that I need to amend on the form do amend. My problem is that I need to amend a value that is also used to find the record. The value in the Table(BookInTable) that I am trying to amend is Barcode...

Hi I have a problem printing a Subform that uses multiple criteria(in textboxes) as filters. The search portion of the form works fine. The problem is I have created a report based on the subform and am using the following code to open/filter the report Private Sub...

Hi I have a form with a subform which searches the database using multiple criteria using Text Boxes and a search button. One of which is a date range(The code for which was kindly provided by another member) which is entered into 2 text boxes(SDTxt and EDTxt). At first glance the code works...