Recent content by kevinv

Thank you very much Paul, It worked as intented.

Hi Paul, Thanks for your reply. I have seen the post in your reply however could not make it to work. I created the module as indicated and saved the module. Then in the form I've selected the field where I want the username to appear and in the default value I mapped to the module, however it...

Hi, I am currently working on small access 2010 database where the database consists of a table and one input form. This input form will be mainly used by two persons. In the form there is a dropdown where one selects his name to keep record who entered the data, however I would like this to...

Hi. I have two separate tables where orders are saved. The first table contains the order header mainly the order number, order date, client’s name, salesman name, despatch date, credit days, credit limit and order notes etc.. The other table contains the details of the orders such as the code...

I have an acces form to input client orders. Each order has its own order number a different client. On the same form I have a button to generate a report based on the inpuuted data on the same form which works perfectly fine. Now I need to use same report to save each order in a specific...

it's named QRY.pdf. it's just under my name of my original post!

the original pdf files was over than 100kb limit size. A new upload has been added to my thread. thanks

I have a result for a query made from four different tables for which I would like to refine the result of this query grouping multiple rows into columns. Attached is a pdf file showing the results being obtained by my query and underneath is how the result would like it be after running the...

Yes the idea is exactly how you understood. Just for you to understand better the table where i'm going to store the records would look something like this; DATE INVOICE NUMBER STORES SESSION NUMBER 01/04/09 123456 DRY 21 01/04/09 123457...

Hi David, Thank you very much for your reply. Preferrably will be used in a multi-tasking environment however there might be the following working scenarios I would have only one person registering invoices at a time therefore would be better that on loading the form to register these...

I would like to create a form where a unique number is assigned to this form once it is opened. This continous form will include a number of entries one below the other. On closing the form I would like to update the table with the following fields, Date, Invoice Number and the session number...