Search results for query: *

Patrik Thank you very much that has done the job nicely and saved me hours of work - incidently the solution I used was your first post and I didn't need the amendment /7),0) (in actual fact changing to this caused an error) Thanks again

I have a summary sheet with several sheets of data behind. The column headings on both summary sheet and data sheets are week commencing dates. On the summary sheet I have a list of several hundred customers and below each customer name are 6 rows of data pulled from 6 seperate data sheets...

Thanks Zum I will try first thing in the morning and let you know how I get on.

I installed Veritas on our main server and agent on all remaining servers. All went well for many months until the back up started to fail. I established this was due to a lack of hard drive space on the servers root drive (C) however on the E Drive there is 328Gb free. When I try and install...

Jennifer The tables and query sound fine although you don't need to include both tables in the query - define the link in relationships. Just go to Tools - Relationships and make sure both tables are in there and linked on the Plan Type. In your query then you only need the one table which...

Jennifer I suspect that you have a problem with the query - as you select the first combo box the After Update Event triggers the query to run which the contents of the second combo box are based on. Please check the query and in particular the [Forms]![frmYourForm]![cmbCategoryList]...

Monomax A few quick questions to establish more facts ...... Have you ever had this database running succesfully ? How have you imported the data from Word / Excel ? Is the database file stored locally or on a network ? And a quick check ...... Just to establish that you have exclusive...

Rick You are of course correct in your statement on security - it was a sweeping statement that I made. It really depends on the environment you are working in and the security measures already in place and ultimately how critical it is that nobody accesses the data you are trying to protect...

Cantech I am assuming you have 2 tables - Categories and SubCategories. Their must be a relationship between the two. There should be a lookup field in the SubCategories table to the Category field in the Category Table. On your form firstly create the combo box for Categories.For the...

Hi JH I have written a Purchase Order database and needed to prevent users from seeing other users Purchase Orders but at the same time allow senior Managers to approve purchase orders. I am assuming as you have multiple users that they will be members of a network and therefore have a User...

Jaycast You don't have to use a page header. Just build all the detail you want on the first page in to your report header and then the information you want on the subsequent pages in the detail section. The report header will only print on the first page. Leaving just the detail on the...

Greg I don't know of a way to do this however you could try the following. A work around is to draw a small square on your report - change it to the colour you want - drag your checkbox over the top - click format and bring to front. The check box will float over the square and add some...

Linda Yes this is possible - Instead of an e mail link use a command button on your form. Put code behind the command button to e mail the form. Private Sub EMailYourForm_Click() On Error GoTo Err_YourForm_Click Dim stDocName As String stDocName = "Your Form Here&quot...