Search results for query: *

Hi, I have transferred some tables to a my SQL Server 2008 backend and need to modify some queries. I was told to use a pass through query so im trying to convert the Jet SQL to T SQL but I don't know what to do with these iif statements. EXP_D...

That was the problem. Thanks!

I'm having a problem. I changed a line of code to match a line in some of the error handlers. Your original code works great but when I made this change to it it did nothing. This is your original code on line 33: ''The list returned is of modules containing this line sFind =...

Ok sorry password. Silly me. :)

How do I run the code? Main("Database Path","?")

That's absolutely fantastic!

So every time it finds a line with "On Error..." i want it to delete that line and every time it finds "Exit_...:" it deletes that line and everything below that line before end sub or end function. I just don't know how to code that.

That looks great. How would I modify it to chop out the error handling from my procs? Obviously when the procedure name is mentioned it will be different for different procedures. So is it possible for it to find the error handling code when it will have different procedure names for each...

PHV no i can't. I'd love to know what to change but I don't. I've been searching all over the net for help on the issue as I'm not familiar enough with VBA to do this. I understand how the module works but i don't know how to change it to get it to do what I want. Remou I have mz tools 3 and it...

Hi folks, I have a large Access 2003 database with a lot of forms and I am implementing an error logging system based on a code module i found online. The module checks all of the forms subs/functions to see if there is error handling and if there is none it inserts error handling code into...

Awesome.

I have MZ tools 3.0 but i cant find what I need. Apologies for posting in the wrong forum, I posted rather hastily. Thanks for the tip MakeItSo, the only thing I have in every sub is my error handling goto. Is it ok to do something like this at the start of each sub: DoCmd.SetWarnings...

Hi Folks, How can I add a line of code to every sub in an access VBA project. I need to add DoCmd.SetWarnings False to the start of each sub after the OnError. I really do not want to do this manually is there a quick snippet of code i can use in the immediate window to do this? Thanks in advance.

Hi, I'm having trouble booting XPe from disk 1. I have dowloaded the evaluation version which does not come in ISO format. When i burn the files in the Disk 1 folder to a CD it is not bootable. According to the instructions Disk 1 is a Windows PE bootable disk. Does anyone know where I can find...

Text field max length is 255 characters. Memo fields max length is 65,535 characters.

Its all working good now.

I have tried a different workaround. Instead of importing the Reports, I deleted the forms in the old database and imported the new forms and modules from the new database. Seems to have worked. Only noticeable difference being that the buttons are all old looking.

Didn't work maze. Thanks though.

It keeps giving me different errors or no error at all. I tried the exact same thing again and it produced the error: The microsoft jet database engine could not find the object 'DigSig'. make sure the object exists and that you spell its name and the path correctly. I do not know of any...

I tried importing it to the same blank database just there and im getting an error message saying Property not found.