Search results

I have a form based on a table that has a memo field. While on the form if I enter data in the memo field with a line break the underlying table is not updated with the data after the line break. See attached image

I attach a slimmed down version of a db. When I select a specific "fish type" from the Combo Box on the form, I get the answer I expect. If I select "all fish types" nothing is returned. What is wrong with the onClick code of the command button?:banghead:

I have a form that has only two controls - name and district. When I open the form it fills the whole of the work area in access. I have looked everywhere but cannot find how to set the height property. I've tried using "Pop Up", and altering the height property of header, detail and footer...

I have a form with a combo box that has six values being pulled from a table "Catches 1 - 22 Salmon", "Catches 1 22 Sea Trout" plus another 4 values. I have six corresponding reports called "Cathces122Salmon", "Catches122SeaTrout" plus another 4 reports. What I want (obviously) is to open the...

I'd like to have a button on my dashboard that gives the user the ability to back up the database and save it with a different date. For example, existing database called "Fishing.accdb" and I'd like to have code behind a button that allows the database to be saved as "Fishing0711.accdb" I'm...

I have a main for with sub form. The main form has personal details and the sub form has list of fish catches per person. The main form has several fields like Name and Surname...I would like to put a a search facility on the main form based on Name and Surname fields that are linked to the...

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?

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

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

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

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

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

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

I'm very new to VBA and don't want to look an idiot in the open forum but I'm studying alone from books and for "fun" and it sometimes gets very frustrating when I can't find it on the web. I'm covering "debugging" at the moment and looking at how to use the "immediate" window. I understand...

How do I split "Hello World" into two distinct objects: String 1 = "Hello World" (I then want) String 2 = "Hello" String 3 = "World" Do I use the Split function? Regards

Each record in my form(s) has a "Last Updated" button which updates a text box with today's date. The DB opens with a "Switchboard" with links to each form. I would like to place a button on the Switchboard that says something like "Update All Records".....any advice? Thanks in advance