Recent content by Poppy

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

Hi SJ I have carried out your suggestions about the dates and made them into one field, however I am still experiencing the same sorting problem. And it does not even help when I use a query to try and retrieve the data. Eg I have this table: Cell Phone Number Date Rental Total Fees...

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

Then why does my table keep reverting? I don't get it. It's starting to give me a headache. :( I'm working with linked tables here with an index. Kind Regards

Aaaaaaaaaaaaaaaaaahhhhhhhhhh die! die! die sort die! Good day Experts (Make that bad day) :mad: Uum excuse my rantings. I really appreciate all the good advice given to me so far, however my user is now telling me she does not want the data sorted according to year and month at all. What...

Thanx Kind Regards

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

Well since the person working on the database is not very comfortable with pcs, she gets easily disconcerted when things aren't as they should be. I want to avoid all the questions now. And actually it's bugging me as well that things are not in order. Kind Regards

Hi Gizmo Is there a way to do this using a macro? Thanx Kind Regards

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

Thanx for all the help. Kind Regards

I'm running a macro that has to open and run code from a module, then open a table after it's done. The problem is that the user can see the code module a few seconds before the table is opened. This I think would give the user a bit of a fright. Thanx Kind Regards

Echo Hi Guys I first tried this from excel: application.ScreenUpdating = False That did not work, then I tried searching on the web, but got no answers. I have tried the echo method and it does not seem to work. In code this is what I tried: 'Screen.MousePointer = 11 ' DoCmd.Echo False Call...

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