Search results for query: *

Otto, It works great. Thanks a bunch, I really appreciate your help. Sydney

Good Morning, I've been attempting to create a trigger that updates multi rows based upon the date criteria of what was entered into the the inserted table. Even after reviewing other examples on this site of triggers (some used the inserted and deleted tables joined together), I haven't been...

MP9, That worked great. Thanks so much for your help. Sydney

Good morning, I am attempting to filter a form on the open event using the DCount of the underlying query when it matches a certain criteria. I 've created a variable "Days" (integer) in the code that needs to equal a field in the query. I'm adding 1 to "Days" within a loop until a a...

Pwise, Your updated line of code worked! As RoyVidar (and thank you too for your help) stated: It had to be delimited with Single quotes for SQL Server. Thanks so much your help. You've made my day. Sydney

Pwise, Thanks for the quick response. I upated the line of code to include the space after the name of the stored procedure. And now have the following: Dim mydb As DAO.Database Set mydb = CurrentDb mydb.QueryDefs("qryCompanies").SQL = "sp_qryForeclosureReferralMain " &...

Thanks for your help. I have the following code Dim mydb As DAO.Database Set mydb = CurrentDb mydb.QueryDefs("qryCompanies").SQL = "sp_qryForeclosureReferralMain" & Forms!frmReportMenu1!txtBeginDate & "," & Forms!frmReportMenu1!txtEndDate DoCmd.OpenQuery "qryCompanies" But am getting a...

Good morning, I have a stored procedure in Sql Server 2000 that accepts 2 input parameters. It is linked to an Access 97 DB as a pass through query, which is named qryCompanies. I am attempting to call this query from a button on a form where the user will input the parameters in 2 text...

Thanks for the help.

Good morning, I'm attempting to create a 90 day bucket in SQL where it begins on the second day of the month and ends on the first day of the next month. So far I have the following code, which I transferred from Access and then adjusted for SQL Server, WHERE...

Thanks for the reply. I've tried to use error handling in several events on the subform, before insert, after insert, the form overall error event and the only event that appears to acknowledge the error is the before insert. But even after I trap the error in the before insert, I still get...

Good Morning, I have a subform that is linked to a combo box on the master form. I want to be able to add a new record to the subform before there is a corresponding entry in the linked combo box on the main form. I am receiving an error message when I enter the first character on the subform...

Tom, That works like a charm! I still haven't grasped the single and double quotes that have to be used in text and combining fields. Someday I'll get it. Again, Thanks so much for your help. I really apreciate the time and effort you've taken to help me. Sydney

Tom, Tried the code and am now getting a syntax error instead of the Expected expression error that I was receiving. Thanks, Sydney

Yes. The error states "Compile error. Expected expression" on both of them. It did state syntax error on the way I had it before I submitted the code here. I then changed it to what I submitted here and got the above error right from the start. Thanks again for your help.

Thanks for the reply and help. I added the apostrophe at the end after the "', but am still getting a syntax error. Again, thanks for your help. Sydney

Hi, I'm trying to use dcount to see if the 2 fields combined are unique in a query. The user doesn't like the error message that is returned from SQL Server (Access frontend and SQL Server backend) using the unique index for the 2 fields. Both fields are char (text in Access) in Sql Server...

Using convert with the commas solved all my problems. Thanks so much for your help. Sydney

I ended up using cast(coulmnName as varchar(12)) as ColumnName. It returns 0.00. Thanks again for all your help. I really appreciate it. Sydney

Hi, I just noticed that when the origianl amount is 0 using this method it is converted to .00. Is there any way to make it 0.00? Thanks again for all your help. Sydney