It's taking the memo field in fine and converting to a string now the problem is that I am using a variable that is in the code in my string and it doesen't recognize the variable.
Here is the error message: Microsoft Access can't find the name 'dcode' you entered in the expression.
The value in the field I am using for the string is:
dcode >= "80000" And dcode <= "8291*"
I am working with a recordset. Here is the flow.
dcriteria = rstSubmeasureServiceCriteria.Fields("criteria")
dcode = rstClaim.Fields(dcodetype) ' Example dcode would equal 80001
if dcriteria then ' Example dcriteria would equal dcode
end if ' >= "80000" And...
I am trying to use a variable in an if statement expression. For example: If dcriteria Then
end if
dcriteria is equal to a field value which is of type memo.
in the field is criteria I want to use for the if statement. For example: dcode >= "80000" And...
Hi,
I want to use Microsoft Access to send a file through Outlook, but I don't want it to be generated through and access table or query. For example I have a file called file.pdf in the C:\ drive I just want to automate some system to send that specific file, totally not associated with...
I want to the message text to have line breaks. For example, in the Message Text it Reads "Program Managers," I want to start a new line with "Please update your...". I basically do not want the whole message to word wrap.
DoCmd.SendObject , "", ""...
Never really tryed to do what you are doing, But would setting up the query that is housing the report in a descending order work for what you are doing??
I have a DB on a network were the tables are linked to a backend and the frontend is all Access. There is a report that people may view if need be. When they print the report they meaning other than me the Date shows up on the report as
#Name? but on my machine the Date shows up just fine. It's...
I brought in data from a text file with this date format 19770127. I have to bring it in as string because Access does not read this format. Is there a way to change the data type to Date and have Access recognize that format.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.