Search results

I used a piece of code to pass a date from a form to a report. BeginDate = Format(TxtStartDate, "\#mm\/dd\/yyyy\#") I've spent hours trying to figure out what the second argument means...why the forward and back slashes?

Thank you for taking the time to send this link to me.....we are just entering the winter here and temperature is now below freezing every night.

John....I also found another way (Access 2010). File > Options > Client Settings > Behaviour Entering Field > Go to start of field...

John.....thanks for the reply....you've no idea how much I appreciate it. Learning this stuff is hard (at my age) and doing it in an unstructured way is probably not the right way to do it. Anyway...yes, it is a reference to "The Roaring Game". I live in the North of Scotland where it gets...

I have a Form with a SubForm. The Main form draws one piece of data (the client name) from a table called TblClents and the SubForm draws several pieces of data about that client's purchases from a table called TblPurchases. When I open the Form the "Client Name" (at the top of the Form) is...

Thank you guys very much. As an enthusiastic pensioner I spent 2 hours last night trawling the web and searching on line for the answer. I can't believe it was as simple as putting an equals sign followed by quoted text......shows how much I know

I have a text box in a form with a background image. When I view the form in "Design View" I can see the text I want displayed inside the text box. However when I view the form in "Form View" I see "#Name?" instead. Can anyone help?

I'm using Access 2010. When I create a new Report in "Report Design" and add a button, the Control Wizard does not activate, even though I have "Use Control Wizards" active. The Control Wizard works when I create a Form using "Form Design". Can anyone help please?

I have created a report in Access 2010. When in the "External Data" tool tab and I click "Email" and select any format I get the error "Before attempting to send an e-mail message from Microsoft access, resolve the problem identified in the previous message or configure your computer to send...

Solved. In the Properties Sheet of the report there was an "Order by" ..ClientDetails.ClientID...when I removed that the report works fine.

I created a query to extract data from a table (called ClientDetails) based on the criteria - "Between [Start Date] and [End Date]". The query runs successfully. I then created a report based on this query but when I run the report after being asked for "Start Date" and "End Date" I'm asked...

Figured it out myself... Between [Please enter the start date] And [Please enter the finish date]

I want to extract data from a querie based on two dates supplied (as parameters) by the user. How do I do that?

Yes it does help...thanks so much.....the answers are all there but it's just knowing where to look (if you have the time) or who to ask (like you)...I spent ages on this forum and scouring VBA books but you gave me the answer while I was asleep! This worked for me. DoCmd.OpenReportetc...

I have assigned a macro to a button that opens a report in print preview mode. When the report opens it is set at "Fit" in the tool bar and I have to zoom to 100% to see the data properly. Is there any way I can adjust the macro code or report properties to open the report at 100%

I think I figured it out....this works Me.Combo53.Value = Me.Combo53.Column(0, 0)

I have a value list on a form (the list is called Combo53 where I typed in the values) of 15 reports in my Db. When the form loads the value list appears with no text showing, but all the reports appear in a drop down list. How do I get the form to load with the first item in my list of...

Thank you very much for your prompt replies...I put that code behind the "button" and it works perfectly. You were correct when I said about print the "forms", the combo box actually contains a list of reports.....much appreciated....enthusiastic pensioner.

I have a combo box with a list of forms. I want to select a form from that list and print the form. What code do I use on a "button"? Thanks in advance

I've been playing around with VBA and need some help. The procedure below works when I pass the value of "CboWhereTo" from a list box on a form via a Button's click event. Public Sub WhereToNow(CboWhereTo) If [CboWhereTo] = "Address & Domain" Then DoCmd.OpenForm...