Search results

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

Thanks for your assistance. I am however; a little confused. What do you mean by "Assuming DateDiff("d", Now, TheDate). Where would I put that. I am new to code. What I am having trouble understanding is why the one form closes but not "KYLE" No matter what we try we cannot get it to close...

I have some code that is getting stuck. Could someone please look at the following and see if they can figure out what is wrong. The form "KYLE" just displays when the user has to exit the form. Any help would be greatly appreciated. Private Sub Form_Timer() Dim ETIME ETIME = DateDiff("n"...

I have a form with a bunch of text boxes that are unbound. I have only one text box that is bound to a field in a table. As the user enters their information into the form I would like to immediatley upon exiting of that bound text box to write that data into the field. I can only seem to get...

THANKS!!!! Thank you very much for all of your assistance.

Unfortnatley I cannot open it. I am using Access 97. Are you a newer version that is not compatible?