Search results

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?

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"”))

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

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

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

I have a small database, which has a form with a text box that is unbound. A report is based off this form. The user fills out this text box and then previews the report. The user, upon closing the report, is asked if they would like to save this information. If the user chooses to save this...

I have a text box that is populated by a table after a combo box selection has been chosen. I would then like it to replace a certain word (Place Holder) with one word that is a result of another query. i.e. My friend (FRIEND) likes widgets. The sentance comes from a table which is then...

I have a field where I would like my Date stamp to subtract a day where the time stamp is between the following. We keep getting a Invalid Syntax error, which has us confused. It keeps referencing the second colan in the time criteria. Does anyone have suggestions? iif([TIME_STAMP] is Between...

I have a query that returns a date that is formatted like mm/dd/yy hh:mm:ss The problem I am finding is that I would like the date result of this query to link to another table that doesn't include the time, only the mm/dd/yy. Therefore, I am not getting any results. How do I get both the query...

Good day, I have a line chart within a report that is populated by data based on a query run by date ranges. The problem I am experiencing is that when I run the report with a larger date range (It shows the data by month), for instance 12 months worth, it moves the vertical axis inside the...

I have a table that is full of golf scores the courses the dates played and so on. I have written a query that uses the Avergage function of all the scores played by a certain user based on Start and end dates. I have created a form where a user selects the start and end dates and a player...

I would like to set up an input mask that looks like this "01/01/2003 00:00:00" I am new and am having trouble getting this to work. Any ideas

I have a form based on over a dozen queries. There are 26 text boxes within this form all being populated by a Dlookup, Dcount etc. What I would like to do is somehow export the results of this form into an Excel file. I have a combo box that contains a month name e.g. "January". This combo box...

Good day, The following code is filling in my text boxes with 12/01/1898 and 12/31/1898. It is only supposed to give me, when I select the month from my combo box the dates of the month from last year. Does any one know how to re-work the code. Thanks Private Sub Combo2_AfterUpdate() Dim...

I have a combo box that has the twelve month's listed in it's row source. This combo box populates two text boxes when selected (Start and End dates for the form) I have it sort of working the way I like. When you select the present month, it populates the fields correctly. This is good. What I...

I have created about a dozen queries that pull up a variety of information. The only similarity between all the queries is that they filter by a date range. I have created a form where I can filter by the date range. What I would like is to create a "Refresh" button that will run all the queries...