Recent content by Mike_In_Ga

Hello Ken, Your help a few months back was a big help. Would it be too much to ask for an upgrade? :D To refresh your memory, we put together a module that does a mass find/replace by referencing a parameter table that houses the Tablename, fieldname, old value to be replaced and the new...

Easy answer. Because I am not a programmer and get by with access because the GUI wrotes the code for me. If I had to write the code myself it would take me a week and if I went that route Id just do it directly on SQL server. Someday Ill learn VB well enough so that something that takes you...

I have connected to a SQL Server Db and pulled in all the "tables". The problem is that some of the "table" are actually SQL views. How can I use the Linked table GUI to ull in only actual SQL tables and exclude the SQL views? It seems that the ODBC connector tool treats a SQL view and SQL...

Shoot me an email at flacrwdog at yahoo. If you are good with SQL stored procedures I probably have some work I can throw at ya

That did the trick! Thank you sir very much.

Here ya go. I took out a lot of the tables to lighten the load

Unfortunately yeah. Im just a poor accountant trying to learn greek in a day. I posted up above that your approach won't work because I have non text fields with "UoM" in the fieldname. I have to pull from the table I created to get the specific field and table names. I also posted different...

Ken, Going line by line, the code is hanging up on the line 'Next td' I think I see what is going on. Instead of getting the table names and field names from the "ChangeUoM" table, you are going throught the entire Db looking for fields that contain "UoM". That wont work because there are a...

Here is a different approach with a different problem. The code works but when run it asks over and over again for the old and new UoM values. These two message boxes pop up over and over: Private Sub ChangeUoM_Click() Dim db As Database Dim rs As Recordset Dim strTABLE As String Dim...

The update works SQL statement works. A couple of things: 1 - I went back to the ChangeUoM table and took out all records where table name <> dbo_ArCstStkPrc and reran your code. I still got the same error message but the records updated. 2 - I added all the records back into the ChangeUoM...

Not sure how to put in breaks.....I put in the STOP command just after the 'DoCmd.SetWarnings True' line. In the locals window I saw for expression 'fld' : strSQL : "UPDATE dbo_ArCstStkPrc SET dbo_ArCstStkPrc.PriceUom1 = 'EE' WHERE (((dbo_ArCstStkPrc.PriceUom1)='EA'));" : String That...

I understand what you are asking me to do, but how exactly do I do that? Sorry for the newbie hand holding and I appreciate the help.

Ken, I tried your code and got an error. By the way, in my sample I table Ihad the old and new values flipped so I changed that in your code. The error mesage I am getting is: Datatype mismatch in criteria expression. The debugger highlighted the line below (see RED line). Option Compare...

Not for me. When I took that line out I got the email.

I took this line and it worked for me (changed the email address to myself) ".Attachments.Add FileNameZip"