Recent content by DJ_DEF_CON_1

Thanks! Thanks very much. That works like a charm

I have created a mapping spreadsheet where users can hi-light and move cells around a map with other information and the spreadsheet would show the updated information with it. Here we go: Cell A1 has some conditional formatting 'IF B$1$ <> C$1' then change the color of the cell. The user...

I have a text box on a form that contains a fixed number (9) for example. I have a date and time field and I would like to add them together. The problem I am finding is that when I add them together the text box adds 9 days as opposed to 9 minutes. How do I get it to do that?

Thanks - That solves the problem

I keep getting a syntax error for the following. Could someone look it over and see if they can figure out what I am doing? =DLookup("CONV_FACTOR","DM_PLUS_ITEMCONFIG_UOM", ("ITEM_NUM = ITEM_NUM") And ("DFLT_CONFIG = CONFIG") And (“UOM_TYP_TXT = “PAL"”))

Thanks - I learned something new. I appreciate the help.

I have a hidden form with a text box field that I am trying to query. The following is giving me problems. Any ideas? If Forms![SCRATCH_PAD]![tbxUSER_ID] = 'DELUCAK' Or 'MOULTONM' Or 'ROBERTSD' Or 'SCALFD' Then When I select the command button that has the above as an event procedure, I get a...

Please forget it. I have now noticed that this field is a text box, not a date field

It is a regular select query. Under one field I put >now()-30 and after I exit it looks like this >now()-"30"

I am working in a query. In the last few days something has happened where quotation marks are being added to any criteria I am adding. I have to go into SQL mode to delete the quotation marks. Does anyone have any ideas?

I put the changes into my database exactly as directed above and had no issues. Could you be more specific? The directions that are the most critical are the following: What is missing from this equation would be another table to base the form and report off of. call it tblTBox and have only...

I am having trouble moving the tab order from a Text box in the detail section of the form to a command button in the form footer. Does anyone have any ideas? Thanks:confused:

I am running Access 97 and am trying to repair and compact a database. I can repair it fine (Or so it says), but on compacting, I get the following message. "Record(s) can't be read; no read permission on "My database" Any ideas would be appreciated

Thanks - - That solved it. :)

ETIME = DateDiff("n", [TIME_OPEN], Now()) If ETIME > 15 And ETIME < 30 Then DoCmd.OpenForm "KYLE" Else If ETIME > 29 Then DoCmd.Close DoCmd.Close "KYLE" DoCmd.OpenQuery "qryDeleteInfo" End If End If End Sub What I'm trying to do is, if ETIME is greater than 15 minutes but less that 30...