Search results

Thanks for the tip about upgrading the internet connections. The 1Mbit/s upload is being upgraded to 8 Mbit/s. Thats the maximum. For future use, it won't be enough. Maybe there is a way to virtualize Access, so it's starting Access on the Synology and only send the keyboard, video and mouse...

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

!? I think you are right! That is an out-of-the-box solution for me. I'm going to test

See the 2 examples. The table and the query (in a form). I want to conditionally color the shopnmumber in the query (in the form) if the same shopnumber has one row with the remark "stock" in the different table. Maybe it is easier to use a seperate query that lists the shops with "stock"...

Hi RuralGuy. I'm a NOOB in Expressions. I'm not sure how to implement this in an expression. Can you explain? Also I made a query with all the shopnummers that has "stock" in the remark. So is there a way: check if shopnumber is in this query. If so make a colour. It would be nices without a...

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, It works perfect! Briljant! I was struggling with the syntax, because I use another way for the SQL to run. What are the rows below and how to use them? Debug.Print sSql Currentdb.Execute sSql , dbSeeChanges

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

Thanks for putting me in the right direction you guys! The SQL below does work and still seems to be short tekst. UPDATE tblImport SET tblImport.date = Right([date],2) & '-' & Mid([date],5,2) & '-' & Left([date],4); When I was testing the column one time changed into a date field. How can...

To clearify. It's used as an import table. I receive the date format froma customer. Make changes to the import table and then proces it to a combined table. When I change it to a date field, the next import failed.

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 Minty, This is it. With this I use a after update event to store the delivery date in the tabel. Tanks! A last question: I can refer to the textfield from the from to use the deliveryDate (= Forms!frmImport.DeliveryDatefrm). But I can't use this when this form is closed. Also I can't...

Also did that. The problem is I can's change the value in the textbox. I can do a workaround with a click-event, but it is better to just change it in the textbox.

This is a good step Minty. I tried this before. I see the delivery date in the textboxon the formheader. also want to overwrite this int he formheader, so it is set in the table. Get rid of the spaces is a good advise!

Hi Minty. One user sets this date. Then import the files. During import I can do some checks with the delivery date. I feel a bit stupid. I made a textbox in the formheader and pointed it to =[tblDeliveryDate]![Delivery Date] . But nothing happend. No when I set the dat in the tabel and not...

Hi Ranman256. Thanks for help. This is step one. No I want to be able to user the textbox in query's after the date is set and the form (with the date) is closed. During the test I did, the date wasn't saved. So how can I save this date? With the option to overwrite and save again.

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 arnelgp, Thanks for the reply. This part I understand and this is the normal way of scanning. But now I want to save some scanned barcodes and read them later (when I receive the matching order-file). Then I want to be able to put the barcodes in the tblMutations and run the VBA code for each...

I made a frmScans/tblScans where I put the barcodes. Via a VBA Module I read the barcodes from the tblScans and write them with the rest of the barcodes in tblMutations with the code below. Function tblScansRead() Dim StrSQL As String StrSQL = "INSERT INTO tblMutations (barcode)SELECT...