I currently use this line of code to output reports in .doc format in my database: DoCmd.OutputTo acOutputReport, ReportName, ".rtf", PathAndFileName Where...

I am trying to filter my data so that a record that has been accesses in the last 5 hours does not come up. I have a SaveDate field (dd/mm/yyyy) and a SaveTime...

I have a Count query with the code: SELECT Count(*) AS FROM qry_Searcher; and a DLookup when the qry_Searcher has run: DLookup("Count",...

What's the fastest way to display all the dates between dates x and y in a combo box without having to type them all out? -- Adam Thwaites Access Database...

I haev a command button that I only want to be clicked a maximum of once a minute. To start with it has a picture MS Access Report 2. Once clicked it changes...

?Now()-TimeValue("00:30") 39363.7287384259 ?Now()+TimeValue("00:30") 08/10/2007 18:29:39 These two formulas give different results in Access 2003, one...

I've used the readily available code from the internet to send out e-mails from Access through Lotus Notes. Currently the message is sent from my forms as a...

I'm doing some pretty big data imports into Access, and the system is killing its self trying to enable the Undo feature through out this, to a point where...

I have a query looking at 3 columns. I have three global variables which can contain values to look up in any of the three columns. The variables can also be...

Hi, I want to be able to turn on the vertical scrollbar if the amount of text in txtbox is greater than 300 characters. The text is loaded on a command button...

Hi, I have a text box with verticle scrollbars enabled but you can only see the scrollbar when the text box has focus. How can I make it show the scrollbar all...

I have to following code to hide the Database Window when I press the H key, but without the name Access has given to the Database Window I can't shift focus...

I need to totally close (not hide) a form by clicking a button on another one. How do I do this? -- Adam Thwaites Access Database Designer Manchester, UK (I...

I have a continous form running off a query. The first text box is called txtFrom but for some reason when I try to make code for it refers to the text box by...

I have a search form with a text box for the search criteria and list box displaying a query which is requeried and made visible after the search button has...

I have two forms, frm_One and frm_Two. There is code on frm_One to check if frm_Two is open and if it is switch to it: If Forms!.Visible = True...

Hi, I have the following code to close a form by clicking anywhere on it: Private Sub Form_Click() Forms!.SetFocus DoCmd.Close acForm, "frm_DueBack" End...

Hi, I have two forms, Form1 and Form2. Form1 contains a Public Sub called PublicSub1 which I want to run from a click event on Form2. Is this possible? -- Adam...

When you create a text box it has a label attached to it which turns bold when you select the text box on the form. If you delete the label how can you make a...

If I type this in the run box it works fine: "C:\Program Files\Microsoft Office\Office11\msaccess.exe" "C:\Database\PAF Address A-C.mdb" /compact How ever...