Search results

Hi, I have an automated Excel-file import where the user can choose the excel-file with routes to drive. DoCmd.TransferSpreadsheet acImport, 8, "tblRoutes", selectFileWithoutDoubleCheck(), True, "!A1:L1000" The headers all aready there in tblRoutes. Now every day column K1 of the Excel file...

Hi guys. In my WMS I want to add some checks for administration. When the click a botton a popup form must be displayed. The form have some buttons for actions and some to show tables/querys This is the easy part. What I don't know is how tot add more than one table/query in a split form...

Hi, I have a complicated Access file with a lot of tables, query’s and VBA. It works roughly like a Warehouse Management System. The Access file is used to import orders from a couple of customers and then use barcodes scanners to collect this orders. In the Access file the scans (for...

We use a barcode scan-application witch is made in Access with a lot of VBA. When there is an error with a scanned barcode the DoCmd.Beep will run. This works excellent whitout any delay. But nog I want to add an second sound. This can be done with http://www.cpearson.com/excel/PlaySound.aspx...

I want to print labels. These labels are created from a query. At the moment the query has two columns. 1. The labeltext 2. The amount For instance [TEXT] [AMOUNT] Address1 3 Address2 4 Address3 2 Is there a way to change or use his query so that I get the right amout of labels for each...

When is "debug/<databasename> compile" option available or not grayed out? Yesterday a critical access-file crashed. The tables where ok, but all the VBA code where gone. Also after using the “database repair and compress” the VBA code wasn’t available. I think this has to do with my latest...

Hi Guys, I have an Access database with order information. Per client I have an Excel file with the orders. I have an import button for the diffrent clients with an automated process for extracting the data to combine the orders. One client is an expection. The deliver a lot of seperated...

Hi guys, A couple of months ago I started to program an Access database to process orders, scanning and drivers papers. This database sits on a Synology NAS. For the warehouse it's a good solution. The last months I programmed a lot of VBA code for all kind of things. The database will grow...

Hi guys, I’m struggeling with a condition formatting expression. I have a table with the colums shopnumber, product, quantity, remark. Like: 1000 A 2 stock 1001 A 2 345 B 1 stock 1000 C 1 1001 A 1 1000 C 1 Then I have a crosstable query that sums up the quantity of the same products per...

Hi guys, I have a report. In this report I show a Routenumber. This routenr can be variable. So I thought I make an inputbox in VBA at the open-Event of the report. Then the inputbox ask for the routenumber, and I can use this variable in the report for Dsum, Dlookup and as tekst. The...

Hi guys, I’m struggling to put a access-query into VBA with the right syntax. The query is working and gives the SQL: UPDATE tblMutations, tblDeliveryDate SET tblMutations.DeliveryDate = DLookUp("DeliveryDate","tblDeliveryDate","Search=" & "'1'") WHERE (([tblMutations].[Customer] Is Null)) I...

Hi guys, I have a short text field with a date (yyyymmdd) and want to convert it to a short text field as dd-mm-yyyy. So 20171128 must be converted to 28-11-2017. I can do this with the CDATE, but then it converts it to a date, and I want it to be a short text field. I want to use an update...

Hi guys, Maybe a newbe question, but I can't find the right answer. I have a form witch is used as an import module for different files to fill an orders-database. In this form I want to set the delivery date, so all the rows of the import get this delivery value in a column. Also I want...

Hi guys, I have a program in Access 2016 for barcode scanning and matching. I receive files with orders (barcode, product, quantity, shipdate) and make an orders-table of it. Then I have a form/scantable for scanning the barcode and fill some columns with the information of the orders-table...

Hi Guys, I'm still a newbe in Access VBA. I want to make a macro/module that does the following: -insert 3 records in a table (one for each product with a dummy store) -then run a make table query -then modify the table properties of the new table to set a propertie -Remove the 3 dummy...

I’m a beginner in making Query’s (and SQL). In the Example file there is a cross table query (qryCountPerStore) with the information I need. I want this information in a table. I do this with a make table query (Kopie van qryCountPerStore). The table thas is made (tblqryCountPerSore) is not...

Hi. I’m a beginner in Access VBA. I started a learning project for scanning and matching barcodes. We receive shipments (physical) and orderfiles from a couple of customers. In these orderfiles we get the barcode, storenumber, shippingdate en quantity. We put these files combined in the...