Recent content by ggj13557

I am trying to place items in a "Value List" RowSource Type. However, I can't use an item with a comma in the rowsource treats it as a separate item. Is it possible to use a comma in a list as such: "CONFIDENTIAL;FOR OFFICIAL USE ONLY;SECRET;SECRET//NOFORN;SECRET//FRD;SECRET//FRD, NOFORN"...

Rickster57, I don't see an attached file.

I am trying to reference a variable that was created within a form and use it as the title of a report. I have tried to make the variable public but still don't know enough to be able to make the report read the variable. I have attached a small database that provides an example of what I am...

Also, the Tool_ID field contains tool ID's such as G004, AIS018, ...etc. However, the query that I created to pull only the information from one tool has tool ID's that are all numbers and I need the field to be treated as a number in that instance only.

I could use the IIF statement like you suggested but it still won't change the type to a number. Within the query the new field will still be "text" or am I missing something?

I have a table with the following fields: Tool Text Tool_ID Text Description Text The Tool_ID field holds a number if the tool provides a tool id. However, if the tool doesn't provide a tool id, the text "No tool ID given" is automatically placed into the field. Therefore, it...

Uncle Gizmo has the solution to this problem but I can't make it work with my database or version of Access. Here it is if you want to take a look. http://www.access-programmers.co.uk/forums/showthread.php?t=71302 ~ Greg

Ken, I didn't see a report in the DB you attached. My query looks a lot like yours but I want to (using your example) create a report grouped on Client ID and lists the Med Descriptions horizontally vice vertically for each Client ID. Thanks ~ Greg

Uncle Gizmo posted a response to Ziggy1 back in August about this same topic but I can't make it work in my database for some reason. I suspect it's because I am using Access 2002 :confused: I have attached the .mdb and hope someone can explain how to make the IP Addresses in the report...

Rich, Can a command button be coded to copy the customer name of a selected record to the customer name on the invoice form? ~Greg

Please help. I have a form (frmAddress) bound to a table (tblAddress) where customer address information (name, address, phone, etc...) is stored. I have another form (frmInvoice) bound to a table (tblOrders) where I enter new orders. The first part of the frmInvoice form is where the...