Search results

I have a form that populates a field on a table. How can I get the field entry to populate a different table as well? Form records employee name and populates tbl_employee name field. I would also like that same entry to be recorded on a tbl_employee_end. I think an Afterupdate will do it but...

Here is a tricky one .. at least for me. I have 'Item' numbers down one column and the 'Year' down the next column. I have Months across the top. I would like to rearrange this data into Items down one column, but merge the Year to the Months and arrange all in a row going across. The reason...

You would think so but it doesn't work. I am, I confuse, a newbie. Neither the module nor the procedure are activate this way. I am reading up on the issue and the book (Running Access) says you can only call a function and not a sub function this way. But i don't know how to write a funtion...

You would think so but it doesn't work. I am, I confuse, a newbie. Neither the module nor the procedure are activate this way. I am reading up on the issue and the book (Running Access) says you can only call a function and not a sub function this way. But i don't know how to write a funtion...

How do I call a sub routing with a command button? I have a routine written to input a user entered number into one of the fields in all records, but I can't get it to trigger. I thought I read where I had to use a function procedure that called the sub procedure. Can any one give me some...

Incremetning / counting dependent on relationship FINALLY!!! Below is the code that allowed me to look at an invoice number and compare to the previous number and then create a field entry based on that relationship. Hoping it will help anyone else caught in the same predicament! Thanks so...

What is the best way to call a value in a field. I want to call the values in a field, one at a time, perform some logic operations on them, and input into another field in the same record. Then continue on to the next record. What I am trying to do is to count duplicate invoices which...

I am trying to remove the time stamp from a csv export but can't seem to do it. It comes out with the date and 00:00:00 trailing behind. I am trying to upload the export into Lawson but it fails due to this added info..it only requires date. Any ideas out there? Thank you. Merlin

Trying to valuate a field value against a previous field value. If they are the same I want to increment a number count. Field Value Exp:Seq count 211 1 No previous 212 1 Previous unequal 213...