Search results

Hi Guys My Access App connects to an SQL Server to collect product data that we print 2D matrix barcodes for. In general that all works really well. However, currently if the ODBC link is down for any reason the App Errors out and crashes. I have put trapping code in now to check the Internet...

Hi I used Access to develop a 2D label printing App connected to my clients ERP system. We use Bartender Label Printing to automate the Barcode printing and this all, in general works really well, over 3 millions labels printed from in WW. This requires Bartender automation system to be ready...

Hi Guys I have built an Access app that uses Bartender to print labels. Bartender requires some windows processes to be running. I have been able to read the status of the processes and run commands to stop/start the required windows services. However, this running the app in Administrator...

Hi Guys This has confused me a lot. I want to read the value of yes/no value in a table. This value is set (ticked) when I do the dlookup of the value it always returns NULL. I was sort of expecting 0 or -1, Or true or false. I just want to reflect the value of the Yes/no data in the table...

Hi Guys I've been having a hunt around the web and not been able to put together a solution for this maybe you can help me please? I have an Access db which is stored on a server on a network and used on multiple computers, mostly with few issues. in the UK. But I have been recently been...

Hi Guys I'm helping to assemble data that will be passed to SAP as flat csv files to populate some of our stock. I need a column of sequential number just 1 to n, no fancy conditions or groups. However, when I select stock from location A everything I need is there, but the RowNum (1 to...

Hi I have a couple of forms with subforms that collect data for good inwards and dispatch. I want to create a tracking system and log some products seperately in a table. The data from the forms seems to get put into the main tables fairly automatically I assume as the control is bound to...

I have a system in place that records various controlled widgets in and out of the warehouse. usual things, like the supplier, the stock code, description, qty, batch and expiry date. together with who we supplied the widgets to with similar data. I have to track the daily in and out of...

Hi Guys I have a Form which has a datasheet subform, The user has a search as you type popup form to search stock items and find the code for one of the controls in the datasheet. I have managed to get a double click to enter the stock code of the selected item into the subform data sheet...

Hi Guys I would appreciate some help with a query I'm trying to construct. I have 4 basic tables. TblIncomingItems which has supplier, description, qty, batch etc TblSuppliers suppliername, address arrival date PONumber etc and TblDeliverNote has Customer, Name, Date and PONumber etc...