Recent content by Icebot53

Hi John, Thanks for the feedback. Yes it is a industry thing where I'm from :P... Okay, I changed it to qry_deliveries and that fixed the blank in the column, but some of the records are stilling through as duplicates. If you run the query, you will see that the first two records are duplicated.

Hi Man, Thanks for the help. I tried doing everything you suggested, however, when I add an additional project it freaks out a bit. See attached screenshots: It has something to do with the sorting. I would like it: Project: Itemcode Qty Itemcode Qty...

Good day, I have the following two tables: tbl_transactionlist DOC_NR | TRANS_TYPE | SITE | TRANS_DATE 000001 | DELIVERY | PRO1 | 14/02/2017 000002 | DELIVERY | PRO1 | 15/02/2017 000003 | RETURN | PRO1 | 16/02/2017 tbl_transactions TRANS_NR |...

Good day, I came right by using the following code: Private Sub Command17_Click() Dim db As Database Dim rs As Recordset Dim DocNr, TransType, Site, TransDate, HireStart, Comments As String 'I am naming going to do the code in three parts for the three column in the form Dim a, b, c As...

Hi, I came right with another solution, but you are saying that the way I am doing it is slow. Slow in which way? Will it cause problems later with the Database or is it only when you are adding large volumes of records at once? The way you are doing it seems interesting however, I am still...

Here is the document :)

There will be a total of 33 possible records. On the form there are 3 columns of 2 x Input Boxes. Attached is the database.

Okay: I have a form which contains a delivery note number, delivery date, and then a bunch of combo boxes to select which items were delivered (using the item code). Then there are text boxes next to the combo boxes to record how many of that specific item was delivered on this delivery note...

See, I named my combo boxes and my text boxes like this: Combo1 Text1 Combo2 Text2 Then the save button must saved each combo box and text box combo as a single record. So I was thinking of just doing something like this: A = 1 For c = 1 to 11 !Product_Code = combobox & a !Quantity =...

Hi Ridders, It doesn't work. If I use your code, it says "Error 2465 - Microsoft Access can;t find the field 'txt11' referred to in your expression. See, I don't have too much experience with Access. In Excel I always dimmed my a,b,c, as long as that was the way the example on the net showed...

Hi, I use the variable later on in ' a = a + 1' There are more than 30 text boxes and 30 combo boxes to be used. That just speeds up the coding process for me. Maybe I am wrong? Any advice will be appreciated.

DATA TYPE CONVERSION Error with VBA - Solved Good day, I have the following code attached the the click event of a button. I am receiving a Data Type Conversion on this part of the code: !Quantity = "txt" & (a) Any help to solve this will be appreciate. Private Sub Command17_Click() Dim...

Here is the database.

Hi Guys, I am relatively new to access, and i am trying to build a database that we will use at our company to track actual wages vs forecasted wages and this will be done in weekly periods. You are able to add employees and their rate per hour to the DB as well as certain projects with a start...