Recent content by DiamondDust

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