Search results for query: *

I actually did want it in a list box and your thread worked great, thank you very much.

Can someone please help me query the field names in a table vise querying the actual data. Thanks in advance.

Thanks evalesthy, this should work.

Do you know how to create a table with on of the fields being an sequential autonumber. Thanks

dcode = 1000 dcode >= 1000 and dcode <= 2000 dcode >= 1000 and dcode <= 2000 or dcode = 1000 You helping dude, it's probably something easy.

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 >= &quot;80000&quot; And dcode <= &quot;8291*&quot;

Foolio12, why don't you recommend sort of thing? Is there something that I need to keep my eye on?

I am working with a recordset. Here is the flow. dcriteria = rstSubmeasureServiceCriteria.Fields(&quot;criteria&quot;) dcode = rstClaim.Fields(dcodetype) ' Example dcode would equal 80001 if dcriteria then ' Example dcriteria would equal dcode end if ' >= &quot;80000&quot; 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 >= &quot;80000&quot; And...

Thank you,

How many records can an Access table hold? and how big can an Access DB get without bugging out? Thank you,

Thanks MP9, this is perfect.

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

Perfect, thank you dougcranston

I want to the message text to have line breaks. For example, in the Message Text it Reads &quot;Program Managers,&quot; I want to start a new line with &quot;Please update your...&quot;. I basically do not want the whole message to word wrap. DoCmd.SendObject , &quot;&quot;, &quot;&quot...

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.

How do I link my acces Frontend Forms So that they use Queries in the SQL db rather than using queiries in the access db frontend with linked tables.