Search results for query: *

Hi, I have the following code that creates an e-mail from a query if multiple parameters on a form are met. When the email is created the information from the recordset is listed line by line. If the EmailText string is over 120 characters it creates an extra line break. I have tried vbnewline...

Hello, I am trying to create a query on a payment history table that shows the time in between payments to locate missed payments. Each customer is required to make a payment each month. Each payment is stored in a row in the table [CHECK_REGISTER]. I need to group the query by [CUS_NUM], and...

Hello Everyone, I am receiving a compile error on the following code for method or data member not found. Any help would be greatly appreciated. Thanks! Dim Mysql As String Dim RS As Recordset Mysql = "Select [CountOfCUS_NUM] from [tblUploadDuplicates]" RS.Open Mysql, CurrentProject.Connection...

Hi, I have a form that is running the following on close event when I get the runtime error 2465 for cannot find the field. Here is the code I have: Private Sub Form_Close() If Me.STATUS = "COMPLETE" And Me.[CASE NO] Is Null Then MsgBox "CASE NO IS REQUIRED IF THE ACCOUNT IS COMPLETE"...

I have a query that captures the userid when then enter a form in Access 2003 and appends that into a logon table so i can see who logs on and when they leave as well. One user gets the "operation must use an updateable query error" error when he opens the DB. I coulbn't find an answer to why...

Hello, I have the following code that gives me a compile error: invalid use of new keyword. I have a form that reps can edit if they are in the table tblHOUSING_REPS. They can edit the contents of the form by clicking an edit button. When they do that I get the compile error which higlights the...

Hello, I have a form 'CLIENT_CALL_INFO' that has 20 text boxes on it with client information populated from my table 'tblCLIENTINFO'. It is accessed through a form 'CLIENT_LOOKUP'. I need to lock the 20 text boxes for most users but allow edits for 6 users. The users may change occasionally so...

Hi, I am running a totals query on a Yes/No data type field. The field contains an Accepted response or a Declined response. When a reponse has not been received the field is null. But when I query the field the Null values appear as false so I need to differentiate between them. My expression...

Hi, I get a Compile Error: Expected:= on the following "OK" message box I am trying to create. Private Sub DUE_DATE_AfterUpdate() If Me!DUE_DATE < Me!PMTPOSTDT + 29 Then MsgBox("The Next Due Date Falls within 30 days!",vbExclamation,"Warning") End Sub I am not sure what is wrong here. Thanks.

Hi, I have an existing DB with linked Excel spreadsheets that I am modifying. I have users add information to the spreadsheet and run an update query to populate certain statuses. I get an error when I run the query: "Cannot update '(expression)';field not updateable". The user who created this...

Hello, I have a table that contains EMAIL, CLIENTID, DATE, USERNAME. Some of the EMAIL addresses are the same but with different CLIENTIDs. Most are in the table multiple times with different dates. I need to run a query that tells me what lines of data contain the same EMAIL address when the...