Recent content by uplink600

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

Thanks for your help and for moving the thread. 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. 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

Thanks, That works fine. One day I will realise that code is the way to do stuff but I'm not to clever with VBA. Cheers 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...

MStef I got this working in my db using the combo but I would like the selection to be in a textbox. I need the user to enter an account number in txtAccountNumber and for the customer name to automatically appear in txtAccountName. I've tried to play arround with your example db but can't...

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

You have a basic user interface. For the reports play around with the query and report wizards and see what results you get. You need to get a grip with queries as these are the most important tool for analysing your data and extracting records from the DB. You can create your reports after your...

Thanks Guys The problem is that when going through the import spreadsheet wizard, the option to import data to an existing table is not enabled. I can only import to a new table. When I import the data to a new table all the formats are correct. Any ideas? Thanks VC

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