Search results for query: *

Hello, I am Upsizing an Access 2003 db to Sql 2000. I have one form that the dataset is based on a summary query which is in turn based on 9 queries that rely on a value in a control on the form. I have the individual parameritized stored procedures working well, but I can't figure out how to...

Is there any way to delete all occurrences in any field of an apostrophe in a table? I'm specifically looking for this to happen before a large import from a MySQL db into an access db. Thanks for your help in advance.

Follow up to an earlier question Subject "IIF Type Mismatch"... Trying to populate a date field if tempMaster_P.PPAYAMOUNT > 0. PHV Hit it right on, but now i need to populate something other than a yes no field. I think I might need to use a CASE statement, but I keep getting a "Missing...

I am trying to populate a Yes/No field based on wether or not tempMaster_P.PPAYAMT, a currency field, is greater than 0. I am using the following in the Values portion of my SQL statement. I keep getting a type mismatch error. IIf("tempMaster_P.PPAYAMT > 0", "-1", "0") I have tried so many...

What the heck am I doing wrong here? It seems so simple and I just can't figure it out. I Keep gitting the "No Value Given for one or more required parameters" error. My strSQL is "SELECT qrystCONTIG2.*, qrystCONTIG2.BEDID FROM qrystCONTIG2 WHERE (((qrystCONTIG2.BEDID) = 33) OR...

I have a db that I recently secured and I am having problems working with a recordset that worked previously. Basically, I'm grabbing records from an attached MySQL db, Creating a table from them, modifying the table, then trying to open a recordset to check to make sure related records exist...

How do you check the current users group membership before an action? I can't find the code for this anywhere. Thanks in advance for any help. Scott

I need to create a table from the combination of two unrelated table. I have a table of dates and a table of rooms. I need a third table with a record for each combination of room and date. I know there is an easy way to do this, but...... well..... I'm dumb. Thanks very much for your help...