Search results

Thought about that. But it's not the solution. The L column is has a long text in it. And the K only a time. So when this full text is shown it's nog clear anymore at whitch row the time belongs.

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...

Thanks for the tip. Well that seems to easy! Unfortunatally, this won't work for cross-table query's. These query's are not shown correctly. Any idea's how to handle this? I thought about, putting the 2 crossquery's combined in a table. But then I can't refresh the table very easally in the...

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...

Your suggestions do the trick! Thanks a lot

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...

Where can I find the meaning of the "Public Const" options? I also see the Const SND_MEMORY = &H4 lpszSoundName is a memory file of the sound. Not used in VBA/VB6. But i'm not sure what this does. There are 10.000 barcode scanned every day.

This is all the information I need! thanks. I had tot add the private const SND_ASYNC so the code isn't waiting fot the sound to load. Other question. I like the clean userinterface of the Countdown Timer. The VBA is shown with Alt+F11 but is there a way to switch between the clean interface...

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...

This does the trick strSQL = "INSERT INTO tblLabels VALUES (""" & rs!customer & " " & rs!Address & """);"

Thanks for the tips. I'm busy with option 1. I don't know how to select a value of the current record in my INSERT-statement. For now I use 'test'. Function CreateLabels() Dim rs As DAO.Recordset Dim db As DAO.Database Dim strSQL As String Dim i As integer Set db = CurrentDb strSQL =...

Hi Mark, We are importing an excel file from a customer. The amount is from a total column. So it's not a sum.

Hi. I selected my query and then the Create/Labels but I don't see how to use the amount. Besides the table/query changes every week.

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...

Re: When is "debug/<databasename> compile" option available or not grayed out? Thanks guys. There is certainly no VBA code added. It should have to do with the design. Some table-designs are edited with the VBA code. Can it do any harm to leave it like this? Or can it break the database if I...

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...

Still not sure if I declare the XL right and what you mean with "Private XL As Excel.Application" The code works. I tested it by changing the J2 cells in 0 and 1. Then: UseThisFile = .Range("J2").Value > 0 Only files with a 1 in J2 are imported. Also I changed I tested with changing the format...

The import is ok, but I can't get the check for the date. Is't standard text in format dd-mm-yyyy (short notation like 17-3-2018) in Column J of the files. Not sure if I declare the XL right and what you mean with "Private XL As Excel.Application" It seems to use the code below, because it's...

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 Mark, Its for the front and backend. Remotely we want to see history, load routes and other information. I'm not that familiar with SQL server and stored procedures. Can I compare VBA code with stored procedures?