Search results

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

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, 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(.....)"...

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

Goof Afternoon, I am working on a database for our laboratory and ive come across the following; The database i have been working on is for our concrete lab. They make prism's and they perform a couple of tests on those prisms. (Flexural strenght and Compressive Strength). Basically they...

Good morning, I am working on a small database for performing concrede tests. One of the tests is the 'Bending' test. Basically, the people in the lab make a prism of concrete. And according to the dimensions (length, height and width) of the prism they calculate the 'stress rate' they...

Good Afternoon, I am working on a logging function (to log changes made using forms). I got it almost figured out. There's just one thing that i cant seem to figure out though. I am trying to log the value of a field, on the form that is active at that time. Ive been playing with the...

Good morning, Ive got a graph on a report. At this point, the scale of the graph is set to 'Auto' . Which works, but the graph-line is not in the centre of the graph. Due to the fact that we have to send these graphs to our customers we would like the graph to be presented perfectly. What...

Good morning, Ive got a (small) question regarding the detail section on a report, which is acting like a continuous report. Ive got a total of 4 records. Each record has a sample number. Ive calculated the average of sample number 1 and 2, 3 and 4. At the moment it looks like this...

Good morning, I am working on a database which is supposed to be able to aid the people working in our laboratory by doing calculations, making graphs etc. Everything works great, but theres just one thing that i can not figure out. The basic idea is, that the manager of the lab registers...

Good Morning, I am currently using the SetFocus event to generate a number Private Sub WetDensity_GotFocus() mycounter = Nz(DMax("mycounter", "tblverdgrdnucleair")) + 1 End Sub as an alternative to the Autonumbering option. But, when i use this on a continious form, i have to...

Good Afternoon, I started to work on a database a few months ago, but never got to finish it. Now i got some spare time again, i really would like to get back into it. But i am encountering the following "problem". Ive got a table named : tblfielddata This table is the source of a form...

Good Morning, I am working on a report. The report as a query as a source, and from that query i would like to use the following data: PercentageAsphalt PercentageSand PercantageBrokenStab PercantageCement These fields represent the composition of a sample used in the lab. At this point...

Good Morning, Currently i am working on a database which can be use to register incomming samples. Ive made a form, where the user has to enter a serial number, which belongs to the project the sample is from. But a lot of times a project has multipal samples. Which gives me the...

Good Afternoon, I am working on a (continious) form with checkboxes. The checkboxes are stored in a table. What i want to do, is add a checkbox on the top of the form, and if the user clicks/checks it, then all checkboxes should be checked. The checkbox in the table is called "thrownaway"...

Good Morning, Ive got a form which is based on data input from our lab. The query looks like this: SELECT queryveldgegevens.tbllabgegevens.proefnummer AS Proefnummer, queryveldgegevens.*, queryveldgegevens.prctrnr, queryveldgegevens.natdchthd, queryveldgegevens.mpdepd...

Good Morning everyone, Ive got a question regarding populating a textbox by looking at the test input (value). Ive made a table which is going to be used by our people in the lab, by entering test data. This can be done by using a form. To keep it short (i try anyways), the field that is...

Good Afternoon, I am working on a report, and i was wondering if its possible to hide labels when a vaue of a field isNull or Empty. Ive tried an If statement, and a Select Case statement. But both methods result in not being able to open the report (it closes straight away). The names...