Search results

Good Morning The following code (created by Access) produces a report for email and I would like the option to produce the report in PDF format. Private Sub cmdEmailReport_Click() On Error GoTo Err_cmdEmailReport_Click Dim stDocName As String stDocName = "LiveQuotes"...

Good Morning I have a button on a form that runs a query and produces a report with the relevant records on it. Is there an easy way to set this up so that the report is produced in PDF format and then possibly automatically emailed to predefined recipients. I would appreciate any help and...

Simple this one but it's something I can't seem to get working so I thought I would ask as I'm missing something obvious. What is the correct expression to use in a query to select records with particular dates. The database contains information on quotations and each record has a follow up...

Hi Is there a way I can get a text box to only accept a date if it falls on a particular day of the week. For example only if the date happens to be a Tuesday. Can anyone advise some VBA code to achieve this. Thanks VC

Hi Is there a way I can get a text box to only accept a date if it falls on a particular day of the week. For example only if the date happens to be a Tuesday. Also posted this question in the VB Code forum. Thanks VC

Hi Is there a way I can get a text box to only accept a date if it falls on a particular day of the week. For example only if the date happens to be a Tuesday. Also posted this question in the VB Code forum which is probably the better place for it. Thanks VC

Good Afternoon Folks I have a DB where all records are entered using a form in the usual manner. I have a combo box where the user selects an account number and the customer name appears in an adjacent text box. I use the following set up for this. In cboAccountNumber I have SELECT...

Good Morning Guys This is a form related query problem. I have set up a dialog box/form to act as a custom query builder. The user can enter various search information using a selection of textboxes and combos. The query design as as follows. (this is just for one field of the query, the...

I have set up a dialog box/form to act as a custom query builder. The user can enter various search information using a selection of textboxes and combos. The query design as as follows. In the field section I have the following [SalesPerson]=[Forms]![Search]![cboSalesPerson] Or...

Good Afternoon I'm trying to import some data from an excel sheet to a table in my database. The import wizard won't allow me to import the data into an existing table, only into a new one which is a nuisance. The data formats are the same. Any idea's what might me wrong Please. Thanks VC

Hi I have a table in my database with customer records including account number and account name. On a form I would like to set up a combo where the account number is selected and for the corresponding account name to appear in an adjacent text box. The customer account number control is...

Good Afternoon Dudes I have deleted all records from a database and wish to re-set an autonumber field back to 1. At present when we start re-entering records it starts from record 769 where the old records finished. Can you please advise how we can do this. Thanks

I have the following line of code in the form_Current event of my main database form. Me.[FollowUpDate].Value = Me.

Hi Dudes I have a text box on a form which is formatted as medium date and I want it to default to the Monday of the following week. So for today it should have 07-Mar-05 in the text box. Can anyone please advise a method for this. Thanks VC

I have created a form on which the user enters or ammends records in the main table of the database. One of the fields displayed on the form is the record number which is an AutoNumber and the primary key of the table. This is updated when a new record is created and can't be edited on the form...

Hi Can anyone advise me on the following. I need to use a series of combo boxes on a form so my user can select certain criteria for a search query. What I need is for the first combo to dictate the contents of the second depending on what was selected. For instance if "France" was selected...

I have a table that contains customer details such as Account Number, Account Name & Phone Number etc etc. On a form I want to create text boxes to display/change the information. In the first text box (this will possibly be a combo), the user will enter or select the Account Number and I would...

Can someone please advise me what the VBA event is when you scroll through records on an access form (ie when each record is opened). Thanks

Good Afternoon I have a custom pop up form set up as a query dialog on which a user will enter or select certain criteria for a search query. This is done using text boxes and combo boxes. How do I use a check box on the form to exclude certain records from the search. For example tick to...

I have two yes/no fields in my database and these are represented on a from by two check boxes. One field is called order won and the other is called order lost. I am going to add another field to the table called "status" and this will appear on the from as a label or text box. I would like the...