Search results

  1. A

    Solved Creating an 'overflow' text box

    Hi all, I have an access database that I use to speed up my data entry into another program (SAP). I use it to concatenate multiple fields into one. One of my issues is that the field in SAP has a character limit of 40 and any other data must then the added to a 'long' text box beneath it. I...
  2. A

    Solved Run-Time Error 5, Joining Strings and Trimming end commas

    Hi all, I have a database where the user selects a number of tests and then a report is generated with a combination of verbiage for whatever tests were selected. In a field on the report, a string is generated that lists the names of the tests included, with commas as well as a final "and"...
  3. A

    Solved Update Query with Multiple WHERE Criteria - using YES/NO field

    Hi all, I have this update query that I'm struggling with, I do not have the right syntax but I'm not sure which the YES/NO field should use. Dim RecordUpdateSQL As String RecordUpdateSQL = "UPDATE [tbl_SNModifiers]" & _ "SET LastCoreNumber= '" & Me.LastCoreLink & "'" & _...
  4. A

    Reference to old DAO keeps breaking

    Hi all, I have this really old database that was most likely created in Access '97. A colleague got it working when we upgraded to 2016 and part of that was manually installing Microsoft DAO 2.5/3.5 Compatability Library. The issue is, every time this database is opened, the reference seems to...
  5. A

    Creating a Cycle Count DB

    Hi all, I've been thinking about how to implement a database to assist some of my coworkers in running cycle counts. Currently, the inventory system we use does not perform this very well so we do it manually via excel sheets. This is incredibly time consuming/tedious. This database idea has...
  6. A

    Conditional formatting on subdatasheets

    Hi all, Some more questions on the project I'm working on. I have an Order Details form that contains two subdatasheets. One for Line Items and the other is for Shipments. Each order can have multiple line items, and each line item can have multiple shipments. How it is set up now, when you...
  7. A

    Go to Record Combobox issues

    Hi all, I'm having some odd issues with my record selecting combobox on my form. Form name: frm_OrderDetails Bound table: tbl_Orders Combobox: GoTo (unbound, placed in the header of the form) Combobox settings - Rowsource: SELECT [tbl_Orders].[OrderID], [tbl_Orders].[Order]...
  8. A

    Hide subdatasheet headers if no data

    Hi all, I'm working on a form that will allow the users to look up orders. I have a subform that is in datasheet format. This datasheet also has a subdatasheet. Since this form is only to be used to look up records, I've suppressed the 'add new' blank rows by using Recordset Type: Snapshot and...
Top Bottom