Search results

A guy I know has a batch file set up that downloads a data file daily via FTP. Last week he got a virus and brought it into Geek Squad. Something they did suddenly has blocked the download of the file via the batch file FTP. I temporarily removed the anti virus they installed, Windows...

Well, there is only one user of this DB and he is very responsible about letting me know errors because he wants them fixed ASAP. E-mailing the error data is also a good idea. Good to know about dbFailOnError. I would not have known to put that in there. So that command allows the error...

The user would call me on the phone as soon as he encounters the error. I just need to know what I'm looking for. Saving the SQL and error code to a table is a good idea. I just wanted to make sure the standard error handler (on error goto) would catch a SQL error such as a key or null...

It's just for the one time purpose of finding out why sometimes the record doesn't insert. Once I find that out, I can fix whatever is wrong so it doesn't happen anymore. I am not the one using the DB so I need the user to inform me when it happens and displays the error. Thanks

Greetings! I have a piece of code that uses SQL for an insert query. Every once in a great while the record that it is supposed to insert does not get inserted and I'm guessing that there is some kind of key or null violation that it encounters. No error is displayed when this happens and...

Even with a blank DB it would not let me set up user accounts so I'm glad this way worked. Thanks for all your help!

OK I found location of the system file. What I did was copy the system file from my old XP computer to the directory on the new Windows 7 computer and now all of my user names are intact and it seems to work! Otherwise, what could I have done with the existing system file if I weren't able to...

Well, I can do anything to the database itself, such as create and write to tables, etc. so that part of the DB is not read only. I looked for system.mdw and could not find it. There is a registry key that says C:\Windows\SysWOW64\system.mdw but no such file exists in that folder, and I am...

Created in Access 2000, being opened in Access 2000. Actually, it has nothing to do with the actual database but rather, Access itself. When I open Access and create a blank database the same thing happens.

Absolutely. I am the only user/admin of this computer. It's my home computer.

Been using XP all this time, just got a new computer with Windows 7. Still using old Access 2000, not my call to update as this is the decision of the guy who owns the database. Anyways, I opened Access for the first time, just a blank database so I can set up the user account. When I go to...

Perfect and easy. I had completely forgot about the running sum property since I haven't used it in ages. Thanks!

Phil, I don't have a problem with #2 but an example might be helpful because I'm a little confused. The visible textbox on the report is a calculated field in itself so how do you run a sum within a text box in the detail section? Thanks

=Sum(IIf([MyField]="Bob", 100, 50)) Well this was the very first thing I tried but I was told that it wasn't calculating the total correct so I was under the impression that it couldn't calculate right because of each line being a separate record with individual conditions. I will have to toy...

Well, I swear I have done this before with a report but I can't seem to figure it out now. I have a report with a field (txtAmount) containing a condition such as: =IIf([MyField]="Bob", 100, 50) In the report footer I want to sum this field but =Sum([txtAmount]) doesn't work. I tried using...

Yes, I do have the format property set to mm/dd/yyyy. I am appending the data to the table using VBA and I did try using Format$ on the date field when appending which made no difference so it had to be happening during the export to CSV. However, your advice to query the table using Format$...

Hello all, I am using this code: DoCmd.TransferText acExportDelim, "ExportScheduleCSV", "tb_WebScheduleCSV", strPath & "Band-schedules.csv" to transfer table data to a CSV file. This works just fine but in the process, the date format goes from 02/11/2012 to 2/11/2012 0:00. The table is...

Hey thanks for the link. This step did the trick: My first experience with a "phantom break point" :eek:

OK this is weird, never saw this before in 10 years of working with Access: When I open one particular form in Access, it automatically goes into VBA debugging mode, but only when I go to it from the main menu form. When I open the form from list of forms in the database window, it does not do...