Search results for query: *

Thanks Jay. So I'm on that path. Here is my Create table. I'm basing my synatx on other posts here. But I'e got something wrong. CREATE PROCEDURE qryResDisplay @today datetime AS CREATE TABLE #qryResDisplay (memtoday int, restoday int, bedid int, firsttoday varchar(20), lasttoday...

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.

Here is my code..... sqlc = "INSERT INTO tblCHARGES ( PPAY, PPAYDATE ) SELECT (tempMaster_P.PPAYAMT > 0) AS PPAY , (CASE tempMaster_P.PPAYAMT WHEN tempMaster_P.PPAYAMT > 0 THEN #" & startdate & "# ELSE "" END CASE) AS PPAYDATE FROM tempMaster_P;" Thanks again in advance for your help.

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...

PHV, BRILLIANT! It worked like a charm, now a follow up question..... I want to populate another field with a date variable called startdate if tempMaster_P.PPAYAMT > 0 and leave it null if not. What would the syntax be for that?

First of all Thanks! But none of these options worked. Tried em all. Without quotes around the first argument I get an "Object Required" error. Here is my statement. sqlc = "INSERT INTO tblCHARGES ( PPAY ) SELECT " & IIf("tempMaster_P.PPAYAMT > 0", True, False) & " FROM tempMaster_P;" Ay...

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...

PHV Got it Thanks for your help!

BRILLIANT! I, however, am not. Could you give me a bit more guidance as to how I might accomplish what i need to do? Thanks PVH! You ROCK! Scott

That control is populated with an appropriate value. Thanks for sticking with me here PHV!

strSQL gets populated from a multi select list box using the following Dim frm As Form Dim ctl As Control Dim varItem As Variant Dim strSQL As String Set ctl = Me!lstREGISTRATIONS strSQL = "SELECT qrystCONTIG2.*, qrystCONTIG2.BEDID FROM qrystCONTIG2 WHERE (((qrystCONTIG2.BEDID) = "...

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...

Thanks VBSlammer! You ROCK!!!

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

WOW! That was easy and incredibly helpful. Thanks very Much! I appreciate you prompt response.

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...