Recent content by nsohenick

I got it working. Thanks again.

Mine still doesn't work, but we're getting off the Access subject... Could you offer anymore advice on batch files? The Access part is working great! Thanks!

Duh... It still doesn't work somehow. I made a copy of the database on c: and I created a batch file just to clear the records. Here is the line in the file: "c:\Progra~1\Micros~1\Office10\MSAccess.exe" "c:\db1.mdb" /x Clear I also updated my code to set warnings to false. Here is that code...

No you didn't miss anything. I am better at using the built in GUI in the accounting package to choose the fields to export than actual programming. So I went back to my original plan since I already had a working batch file to export the data. As for the "Clearing line" in the batch file, I...

Thanks. I used this to clear the records and it works. Function ClearRecords() stDocName = "JC1_JobMaster1" DoCmd.OpenTable stDocName, acNormal, acEdit DoCmd.RunCommand acCmdRecordsGoToFirst DoCmd.RunCommand acCmdSelectAllRecords DoCmd.RunCommand acCmdDelete End...

My macro in the Access db is not working. Maybe you can tell me what I'm doing wrong. It doesn't seem to run at all. It is still appending. As for adding a line of code to the batch file. I'll need help with that too. I created the batch file from a help file from within the accounting system...

I am using a batch file (Scheduled through windows scheduler) to invoke an export out of my accounting package. The export appends to and odbc table in Access. I want to simply overwrite, but I do not have that option with the package. I can write perform logic to run before the export begins...

BTW... The Accounting package does not have the ablilty to use SQL statements

I was going through the Access object browser and saw two access vb constant functions that looked like they's do the trick. They are 'acSelectRecords' and 'acDelete'. I could not get any syntax or examples has anyone used these before? I was hoping to use use them like this: Function IsLoaded...

I am using an export module in our accounting package to export 4 fields into an access table. I had to create my very first ODBC data source. I works ok. The problem I am having is that every time I export the fields it appends to the table and creates duplicates, triplicates and so on. Is...

No problem I was on the beach for a week anyhow. Thank you that did it. Thanks a lot, Nicole

Thanks. It got me started. My db is much simpler. Maybe you could have a look. I only have 2 levels and want to display a text box with a value in the second table. My combo boxes are working, but the text box shows "#Name?" Thanks, Hay

I am creating a very simple database. It is a knowledge base. I have 2 tables. 1 for Departments, the other for Issues and resolutions. I want my form to work so that when you pick a department from a drop down, you see only issues regarding that department in a second drop down. Thr resolutions...

That did it. Thank you for all your help!

I was able to get the report running. I changed the macro to run on open to the "Department # Dialog Box Macro.OK" macro and it worked without the error. Is it possible to ask for 2 parameters in the report such as date range? I already have the form and macros set up for another report can I...