Recent content by RegionsRob

Thanks, JRBarnett. That DoCmd.RunCommand in your first response just stopped a major panic attack. I turned off the menus to the point where I couldn't get them back, and for some reason, the Shift key on startup wasn't letting me see them either.

The HP Laser Jets that I have used also have the .25" minimum margin (or even .33"!), so just getting a laser printer may not solve your problem either.

I was afraid that was what I was going to have to do. Turns out it wasn't difficult at all. However, even that doesn't get me where I want to go. What I need is this: I need a subform in Datasheet view where the fields are formatted as combo boxes. I want to select a state in one combo box...

Jim (or anyone else who can help) - How do I then take the value of the second combo box and get it into a field in the table that underlies the form? (since the recordsource has to be a query and not the field in the table)

You do NOT want that one user to convert the database! I'm currently having to convert my 97 databases into 2000, and quite frankly, it's scaring the you-know-what out of me. I think there's a way that 2000 can open a 97 file without converting it, but it doesn't let you modify any objects...

PDF is just a snapshot of the data. It is the format used by Adobe Acrobat. I'm not even sure how a database could be saved into PDF format. Reports could be saved in PDF. However, since it is an image of the data, and not the data itself, I don't think you can import it.

I've gotten this far in a database of my own. My question at this point is: how do I save the values in the 2 combo boxes to a table so that the next time I come back to this record, the choices that I already selected are displayed?

I've wrapped my brain inside out trying to figure this out. Task: save a code for each county in each employee's territory. I've got half of this figured out: using a combo box to choose the state, a second combo box that lists only the counties belonging to the state in the first combo box...

If this were a Form, I'd say check the "Display when" property of the label. Did you create the report from a form? If so, you may have to set the label property on the form and re-save the form as a report. (I just checked one of my reports saved from a form, and I can't see any way...

There is no "24:00". It is "00:00".

I think you can get it with LEN. Using the code I gave you before, try: ShortEmail: MID(TRIM([email]),8, LEN([email])-8) The 8 is the number of the character in the string where you want to start (skipping the 7 characters of MailTo: ). The second parameter is the number of characters you want...

If I'm interpreting you correctly, what you really want to do is show zero (0) if [Ordered] - [Delivered] is a negative number. Bev is on the right track. What I would do is make the source for [BackOrder] the following: = iif([Ordered Quan]-[Delevered Quan]< 0, 0, [Ordered Quan]-[Delevered Quan])

To get just the email address without the &quot;MAILTO:&quot;, I would create a calculated field in the query. Assuming that MAILTO: is at the beginning of each entry in the field in your table, you can use the MID function to start at the 8th character in the field and return the rest of the...

There are certain types of select queries that will not let you make changes to (update)the recordset. I don't understand exactly when it happens and end up with trial-and-error fixes to get around it. Anyway, if you search the Access help for Updating Queries, then select the choice for...

If you're going to use a text box, you don't need any coding at all! Just set the record source to the field that holds your yes/no answer, then set the &quot;Format&quot; property to True/False, Yes/No, or On/Off.