Search results

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"

A client has decided to retroactively change the unit of measure field in his ERP database. :eek: I need to do a mass update to the entire database to change the old unit of measure to the new one. The problem is that the field "UoM" is actually stored in a multitude of ways. In different tables...

Thanks. When the board went down I improvised and created two fields, a Y/N if the stockcode was one of the exception and a Y/N if the customer was one of the exceptions. I then created a third field that looked the flags of the other two using IIf to insert the amount. Same thing, I was just...

I am writing a query to calculate commissions. The query is built except for the commission rate and commission calculation. The issue is that the commission rate is not stored anywhere in another table and the rule is dependent on more than one variable. The rule, in English, is as follows...

I had to leave the client's site. I can only get the OBBC connection while I am there as they dont have a VPN, the access Db is on my machine, and access is not loaded on their server thus when I RDP in I cant connect via ODBC. Im going back there next week and will try again. Thanks for the...

OK, I created a new .MDB. Created a new form. Put the command botton on the form. In the "on click event" I typed in "=CopyTable_Click". A module named CopyTable_Click was created and the following code was inserted into the module: Private Sub cmdCopyTable_Click() Dim tdf As DAO.TableDef...