Search results

The more I think of it the more I think the Like criteria isn't going to work anyway. Logically, am I asking Access to find something in the database that contains what is in the text box, which includes the zeroes at the start. If it were the other way around (zeros contained in the data but...

Hi Tera, I will give that code a try. I have used that code but had "'*" closing the criteria. It basically goes like this: 1. Barcode is scanned into an unbound text box which triggers an AfterUpdate event 2. A new form opens where the code that was scanned is placed into a hidden text box...

Hi theDBGuy, Unfortunately this is not the case due to our wide customer base. Some customers use letters and characters in their IDs and the challenge all along has been coding the system robustly enough to retain customer data for ease of reporting rather than assigning additional IDs to...

Hi all, Shall keep this brief thanks to exhaustion: Say I have a pallet ID 123456789 That ID goes into our system (this is how it is received as transmitted data from a customer) However, the pallet itself has a barcode that scans as 00123456789 When I scan the barcode (into a form control...

Hi, Sorry I have not responded, I have been on the road for work. Appreciate you taking the time to help out. Your comments about some redundant data storage has got me thinking and I may yet implement some changes going forward. Since this is all SharePoint data, the less I put into and...

Hi tbeDBguy, Thanks again for your response. If I understand what you are saying, I should just have a material number for each line item stored in the main table, and use this to call on the item description for the likes of reports and subqueries etc. While I have dabbled with this in an...

Hi theDBguy, So you mean DLookUp("description","tblProductList","[materialnumber]=" & [tblImportTemp]![F2])? I don't think I explained the function of the process very well in the OP. The update query is to overwrite existing information in the main table where a material number will change...

Hi all, This is probably a super simple question, but DLookup and I never seem to get along. I have an update query that I wish to run that will use the DLookUp function to update an item description based on a material number. I have three tables in play here: 1. tblImportTemp: a temp table...

Thank you arnelgp. I added a little bit extra to the code to remove any compatible pallets from the list: Private Sub Text4_BeforeUpdate(Cancel As Integer) 'assign the txtPalletID to listbox Me.List13 = Me.Text4 'If the ListIndex = -1 then the pallet is not in the sales order 'also if it is in...

[SOLVED] Checking multiple values in textbox/list Hi all, First a bit of context: The data I am using relates to pallets with individual bags on them. Each pallet is identified by a unique number (like a SSCC number for people who may work in a relevant field). A pallet may be broken down into...

Sorry, I forgot to mention that you can just skip past the 'Pallets' part (leave blank). Not sure why that comes up but it may be because in the query 'Pallets' is an expression (Count) of another field. The pallet size is already stored in the ProteinPrime table ('P Size') when the pallets...

Hi jdraw, I have attached as requested. In terms of how it all functions: (NOTE: tblProteinPrime is the master database; 'Job No' is the field 'W/V Dkt In and 'Delivery No' is 'Del Dkt In') 1. I run the form 'frmInvoicingTransportInMg' and enter the date range for which I want to run the...

Hi all, Hopefully I can spell out my issue coherently enough for people to follow! I have a report that is based on a Union Query that is generating an invoice for transport jobs. There are two numbers that I need to quote on the invoice that relate to each individual job (Job no. & Docket...

Hi arnelgp, I tried your first suggestion and it worked an absolute treat! Thank you so much for the quick response!

[SOLVED] Keep random numbers for multiple records Hi all, I am using a form to allow operators to scan barcodes one-by-one into our database. The operator will initially enter some text information which will be attached to the barcode's record in the table. I am successfully using the...

Thanks! Worked out a treat! Not sure where I got all the extra code from in the past, but glad I do not need it! Thanks again.

[SOLVED] Combo box losing functionality Hi all, I have a combo box (cboMaterial) on a form that updates a number of text boxes with values from a table (tblProductList). The purpose of the form is to allow easy data entry for staff where a whole lot of product data auto loads based on the...

Thanks, Minty. I have created a bit of a work-around using an update query that triggers upon losing focus on the unbound boxes. It's a little unpolished but seems to be working for a starting point. The operators have a chance to check all entries before closing the form at this point. Thank...

Hi all, I've been staring at my screen for hours trying to find a similar situation/solution to the issue I am facing, which has two criteria: 1. Form will be editing existing fields in a table that are blank (not creating new lines of data) 2. Form needs the fields to remain pre-filled with...