Search results

Im relatively new to Access and I do not fully understand what you mean by "assign the text to a varible". If you do not mind, could you please describe that to me in more detail? Thanks

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

Thanks - I cannot believe I slipped up like that!

Close - need more Help The following code is giving me the following error. "The Select statement includes a reserved word or an argument name that is mispelled, or the punctuation is incorrect" I thilights the word "FROM" SELECT FROM PICKER_DATE INNER JOIN HR_ATTEND_MASTER ON...

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 am at work now I will post in a couple of hours. Thanks for your initial help.

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

THANK YOU!!!! I would like to personally thank you Ian for all your help. I have just started using Access in the last year or so on a very part time basis. This forum is very very helpful, and for you to spend some time helping us "Virgins" out is unbelievable. I find my frustration level...

Why don't you put a text box in the form that isn't bound to anything. I would then run a query off the text box looking for related records.

I assume you have a table with a low price range and a high price range.

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 each query only returning one record. I am basically retrieving information from various other databases for my boss who wants to see all this data on one form. I have linked to the other databases, and got the queries working well. He would like to enter a date range, which I have...

Thanks for your help

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