Hi Arnelgp,
Thanks for your reply.
I managed to get it to work somewhat differently, but it seems to do the job just fine.
Here is the solution i came up with:
Dim names() As String
names = Split(Me.qrcode, "|")
Me.boringnr = names(2)
Me.monstrnr = names(3)
Me.dieptevan = names(4)...
Hi,
When populating a field using a QR code scanner i get the following string: F-W7F5LA-LENO|0000-000000|B01|2|1.00|2.00|z
However, I would like to split these in multiple textboxes. The delimiter in this case is the "|" character.
Example:
textbox1: F-W7F5LA-LENO
textbox2:0000-000000...
Hi,
I have got a field with values like "12345_678910".
I know in a query i could use either Left() or Right() and set a the length of the string to determine which characters i would like to 'filter'.
However, the number of characters in front of the "_" is variable.
I am wondering if...
My apologies. I just found out i dont really need to copy data to the table. I might aswell use the imported table instead of the original 'Compression' table.
And as soon as ive calculated everything using queries, link the final query with the table with Labnr as primary key and then it...
The table Compression's key is ID which is an autonumbering field.
The user enters data using a form called LABDATA and as soon as all necesarry information is entered, a query will run to add given labnr to table Compression 6 times. Why? Because for every labnr the technician as to perform 6...
Morning,
I have 2 tables;
Compression and Compression_Import.
Table Compression is currently used to enter the load applied to the sample followed by a query that calculates the 'compression strength' using the entered load and the surface of the sample.
Table: Compression
.Labnr ...
Good morning Rx,
Thanks for the information.
To answer your question No, the database was developed in the same version of Access (2003).
But, i will try the steps you suggested anyhow.
The thing that makes me wonder the most is the fact that this error only pops up on 2 computers...
Good morning,
I have got a problem on one of our computers.
We use Microsoft Access databases to enter test data and eventually generate reports.
On 1 computers i get the following error when opening the report:
"Function is not available in
expressions in query expression 'Left(.....)"...
After checking that link and doing some more research regarding the Excel object within Access ive been trying to rewrite the code, but i still can not figure out how to get it to work.
Private Sub Knop312_Click()
Dim rstName As Recordset
Dim sfile As String
Set rstName =...
Right, so ideally the solution could be to copy the querydata below the previous exported data.
But dont i need to use Excel vba commands to look for the first empty Cell in Column A etc..
I can not just use Access VBA can i?
Good morning,
I use the following vba code to export Query results to an Excel file;
Private Sub btn_Excel_Click()
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Query_Controlekaart_Blanco_28d", "P:\17\10_Cluster_17_Algemeen\98_Overige\MSH\Vliegas_Testfase\Excel...
Good morning/afternoon everyone,
I have got an Excel spreadsheet with a graph etc. but i'd like to use Access (2003) instead.
Ive noticed that making graphs in Access is pretty basic and does not give you the options Excel does. So ive been trying some stuff in VBA and managed to export the...