Search results for query: *

HI there, The problem I have is I have a Word 2007 template, DOTX file that I wish to distribute to some low level users. Basically it's a form that they fill in using form fields. I need documents created with this template to be stored on a network drive, not the Word default. Some user...

Try searching the Forum and FAQ's (tabs above) I know this has been answered before but can't remember the solution Neil Berryman IT Trainer neil_berryman@btopenworld.com

The main problem is the Purchase data would be useless as the supplier id would not be able to look up names etc, that's why Access is making life difficult. Try adding a Deleted Yes/No field and adjust you queries to only show no. That will in effect Delete the supplier without the hassle...

Ok lets think of the easiest way Right click the Sheet 1 tab and select View Code In the left pane double click This Workbook Paste the code there and try that Neil Berryman IT Trainer neil_berryman@btopenworld.com

Create a blank Use the Combo box wizard to create a combo box that looks up the name Give the combo box a meaningful name and save the form and leave it open Create or open a query to look up the name you want and in the ID FIELD (the combo box will have the ID and display the name) click in...

Coopy and paste this into your VB editor. You need to save the file for it to work (no save, no path) Private Sub Workbook_BeforePrint (Cancel as Boolean) Activesheet.PageSetup.LeftFooter=ThisWorkbook.FullName End Sub Neil Berryman IT Trainer neil_berryman@btopenworld.com

Been here before. I have a database that stores the file and path name and then displays the picture when you open the form. So long as the name is the same it will change the picture. The file is at home so if your still stuck e mail on Friday and I will send you a copy Neil Berryman IT...

( before Int and (( before Datediff =Int(DateDiff('d',[Date_of_Admission],[Date_of_Discharge])) Doesn't =[Date_of_Admission]- [Date_of_Discharge] give the correct value? Neil Berryman IT Trainer neil_berryman@btopenworld.com

In brief Create a blank form and add a combo box and name the combo box. Leave the form open edit your query and in the criteria field delete the parameter and click the build button and run the Expression Builder. Double click Forms, Open forms and select the Combo bx created earlier. The...

Many thanks, I will try that out later. As for the data design, I inherited it and have only just managed to convince them that a workbook per dept is not a good idea (18 depts) Thanks again Neil Berryman IT Trainer neil_berryman@btopenworld.com

SOrry for the delay in getting back, bit busy. OK, so far I have a 12 sheets 1 for each month and a summary sheet. I also have a Logindetails worksheet that has a list of Departments and passwords in the next column. On open a user form is displayed with a combo box that looks up the values...

I have a workbook that requires the users to selet their Department from a combo box. A filter is then applied to the Department selected. What I now need is a password routine like so. Select Department and type password into text box. Check department name and password allocated,(both in a...

I have very good Excel skills but very poor VBA. I have the following code (thanks to this site of course) and need a little more help. I have remarked out the first few lines as I could not get it to work and added the other lines to filter each sheet in turn. What I need is to add a...

Not sure I fully understand but try: 1. Use the form Wizard to create a Main Form / Sub form and see if that is suitable. 2. Use the Command button wizard on your form and select Form operations, Open Form and select the find specific record option and that should do what you want Neil...

Yes, make sure that you don't choose the "upgrade" option and they should run OK Neil Berryman IT Trainer neil_berryman@btopenworld.com

The general opinion form other Tek Tippers is to store the filename in a text field and show the image at run time. I have an Access 97 database (I think I may have 2000 as well) that uses code supplied by Tek Tips that should point you in the right direction. Send me an e mail if you want a...

Not sure about an FAQ but try: thread68-223068 Neil Berryman IT Trainer neil_berryman@btopenworld.com

This should do the latter, if you need more let me know, I have the code to inport the text files somewhere. Declarations Option Explicit Private Const MAX_PATH = 255 Private Declare Function GetTempPath Lib "kernel32" _ Alias "GetTempPathA" (ByVal nBufferLength As Long...

The neatest way is to use a Snapshot. The viewer is available on the Office CD or from Microsoft.com. Think of the snaphot as an Access PDF file. Neil Berryman IT Trainer neil_berryman@btopenworld.com

Try Tools, Options and I think it's Delegates tab. Re post if that doesn't do it Neil Berryman IT Trainer neil_berryman@btopenworld.com