Search results

Hi I know that it is possible to export a query into a comma delimited file from Access, however, my problem is that I have currencies in my table. I selected the field that is a currency in the query and changed it to a general number. I then exported it into a csv file, but the currency...

HI All I am currently modifying a db for a user in access and am come accross two road blocks. 1. I have included an extra (number)field in the db which allows the sorting of the db in the number order. What I want to do now and am finding difficult is: Every time the user adds a new record...

Hello All I just discovered the reason why my table has not been working the way I want it to. In my code below, I have set my rst to find the first record of the previous month which in itself is correct, however I just discovered that it is picking up the records in ascending order. Here is...

Dear Sirs/Madams Is it possible to split the data in a field into two using a query? AccountNo 58850119 45457489 58883939 86584747 TO THIS PubAccountNo PrivAccountNo 5885 0119 4545 7489 5888 3939 8658...

Goodday All I am having a bit of a problem with one of my tables. I am using VBA code to add data to one of my tables, my problem is that even when I manually sort the table, it still gives me problem. For example, I have a table that stores mobile numbers by year and month. I manually sort...

Hi Experts Is it possible to disable screen updates in Access modules like you would in Excel VBA? Thanx for all the help Kind Regards

Hi Experts I've managed with a lot of help to get my program to work, however when I try to run the module from a macro I get problems. When I'm in the code window of the module and click run, everything is fine, however when I use RunCommand and run the Command "Run". it does not run. These...