Search results for query: *

Hi all, In an effort to try to reduce the amount of paperwork we are handling, I'm looking to integrate our online fax with our cash receipting database. Our faxes are stored as multi-page TIFF files on a network drive. My plan is to have Access cycle through all of the files in the directory...

Greetings all, Long time VBA programmer, first time VB6 programmer. :P I'm trying to reset a form without unloading and reloading it. I've tried this before however this seems to cause havoc with my five, yes, FIVE, timers. The timers run to monitor various inputs on a USB device and all have...

Hi all, I'm trying to build a custom USB device which I need to place approximately 12 metres away from my laptop. Trouble is that the USB standard only allows 5 metres of cable and I'm not in a position to be able to use extension cables (with joins in the cables every 5 metres) nor have...

Hi, Does anyone know (programmatically or otherwise) how to use a lookup to determine which cells should sum? The circumstances are: These are financial reports where the user enters which financial period the reports are being run for. The forcasting for the remainder of the year needs to...

G'day all, I've got an Access 2003 database that I'm developing for some work colleagues and I'm having problem with a couple of forms not allowing me to leave foreign key fields with a null value. I can however leave these fields null if I enter data directly into the table or the query that...

Hi All, I have an unbound subform which contains fields bound to a query which is assigned programatically using the following code: Forms!Main!MainSub.Form.RecordSource = "qrFrmSubSetup" The reason I have chosen to do it this way is that I have a temporary database which remembers the Event...

Hi all, I'm trying to use a single FileDialog to return the path (directory) and filename separately. Does anybody know how to do this? I have managed it using two separate FileDialogs and have attached the code for this below. Hopefully you can see from this why I need to be able to separate...

I have a single domain controller (Win2K) running IIS 5. When I type http://xxx.xxx.xxx.xxx from a computer WITHIN the domain, I am able to view the default web page. When I attempt this from a computer OUTSIDE of the domain (i.e. the Internet), I get a 403 error. I have the directory...

Hi all, New to this, decided to try a Win 2K advanced server domain controller (trial version) on a network with 2 Win2K Pro PC's and a Win XP Pro laptop. In addition to the server being the only domain controller, I have set up IIS on it and it has a static IP. The IP is 202.9.39.71...

Hi All, I've just finished setting up (for the second time in two days) Win 2k Advanced Server. Prior to setting up Active Directory on this server, it was taking no longer than a minute to boot to the login screen, however after setting up Active Directory, it is now taking 10 minutes to boot...

Hi Guys, You've been a big help on here in the past, so hopefully you have the answer for me here. I have a form, named Register, which has a combo box named DivisionID. I have never had problems with this form under Access 97, however after conversion to Access 2000 (under XP), I have run...

Hi! Hopefully this is a new one here and might give someone a challenge! The task I've been given is to get the details of a selection of clients for the previous 12 months. The selections are as follows: - Major clients who have approached us 3 or more times a month for the full year (on...

Hi, I'm using an idle time detection script to automatically log users out of our database after 30 minutes of inactivity. This is working fine. I have added a form which has popup, dialog and modal properties all set to 'Yes'. This form has a command button which resets the counter if...

Hi, I have a form (MainForm), which has a subform (MainFrame) consisting of two list boxes (YearList and Team) and a Command Button. At the moment, the user selects a Year and the Team list box will show a list of teams that played that year. The user selects a team and presses the Command...

Hi, I'm trying to create a query that will display its results vertically. I currently have a table with a RegisterID column and then a column for each year back to 1965. i.e. RegisterID 2004 2003 2002 ........ 1965 1 X X X X 2 X X...

Hi, I need to generate a report for matters recorded in a database which don't have a correct file number recorded. I want to find all records for a particular year where the file number is recorded incorrectly. The file numbers are stored in the format XXXX/xxxxxx where XXXX is the year, and...

To all you JavaScript gurus out there! Below is a copy of a script I'm working on that allows a user to export form values to a named Excel Spreadsheet and then allows the spreadsheet to be saved where the user chooses using the GetSaveAsFilename() function. It WAS working... to a certain...

Hi! I'm putting together a client-side script which takes data from an HTML form, opens an Excel template, transfers the data and then saves the spreadsheet to a new location. I have been able to use another form text field to enter the name the file is to be saved as, but cannot find a way of...