Search results for query: *

Dear All, I've been tasked with updating an Enumeration in a vb.net 2003 solution. The existing enum looks as follows A = 48 B = 49 However, the requirement is now that each item can result from multiple values. For example: A = 48 or 65 or 66 B = 49 or 67 I have tried amending the enum as...

Dear All, I have an application that monitors keystrokes to dictate how long a user has been idle. Once a time-limit is reached a modal .Net form pops up and locks the keyboard until biometric authorisation is provided. My question is regarding how to get the timer application: 1 -...

Sorwen, Unfortunately using the mapped drive letter causes exactly the same error as using the share path. Thanks anyway. If I find a solution for this issue I'll be sure to post it here for reference. Ben C

Sorwen, Thanks for the prompt reply. Unfortunately the method you supplied causes the error "The workgroup info file is missing or opened exclusively by another user" when I try to run it with my own username\password. I've researched connection strings on a few websites and when using jet to...

Dear All, I have a number of text log files sitting on a server. As this server is on another domain it requires a username and password to be entered before the user can access the drive (mapped on each user's pc). I am using an OLEDB connection to display the contents of a log file. This...

Dear All, I'm working on an application to automatically map the many printers that we use at work. I have succeeded in mapping the printers, but they don't appear until the print spooler is restarted. Does anyone know how to automatically stop\start the print spooler in VB.Net 2003? Any help...

Dear All, I have a form which allows users to select a database file to add\edit data in. Once the user has selected the database, code runs to set the DatabaseName of a data control on the form to equal the chosen database path\name. I've found that once the path of the data control is set, it...

Dear All, My Goal is to create a form where users can specify their scheduling requirements in various fields and then click a button, which will create the windows scheduled task for them to minimise user involvement. I've searched around and can't seem to find any sample VB code to work from...

OzzieOwl, Try thread73-1173745. It should give you the answer. Regards Ben Cooper

Combo, If I open Excel prior to running the schedule the result is still the same. I'm using Access\Excel XP and have sufficient memory resources to run far larger reports than this when my PC is unlocked. My hunch is that Windows somehow reduces the memory allocation when the PC is locked, but...

mrmovie, I've manually hacked the registry to disable the Locking of windows in order to get around my problem. Registry hacking is however, strictly against corporate policy, so ideally I'm looking for a solution that will enable the schedule to run on a locked PC, or code so I can unlock the...

Dear All, I have a number of scheduled tasks that run an Access module which: * Runs and exports a crystal report as an Excel file * Loads the exported file in Excel and applies standard formatting (bold font, size etc) * Saves and closes the Excel sheet This code runs perfectly, except when...

Dear All, I have a module which stores a number of Constants that specify average action rates. I need to allow a superuser to change these rates, but am reluctant to provide them a function to open the module as they would then be able to view\edit all my other code. Does anyone know of a...

TrooDOS - Thanks for your suggestions, I'll be giving them a try when I can get time. Simon - I encountered the same problem with the notes password. I understand from other posts that this is a bug in the Microsoft API (I think) code. I haven't searched the Microsoft knowledge base yet, so...

TrooDOS, Thanks for the post. Unfortunately my company is still stuck in the dark ages of Notes R5. You were correct in that I'm running this code from an Access module. I'll be looking into your suggestions although I agree that it would be much easier if I could just log into the account...

Dear All, I currently use VB code to automatically send emails from my Lotus Notes account. However, I now need to send these emails from a departmental Lotus account, which is causing a problem. Whenever the code sends an email from the dept account it incorrectly shows as if it has come from...

Dear All, I currently use code to automatically send emails from my Lotus Notes account. However, I now need to send these emails from a departmental Lotus account, which is causing a problem. Whenever the code sends an email from the dept account it incorrectly shows as if it has come from my...

scottian, I'm not 100% sure what your problem is, but it may be to do with the references you have enabled. I had the following libraries referenced in this order: Visual Basic for Applications Microsoft Access 9.0 Object Library OLE Automation Microsoft Outlook 10.0 Object Library Microsoft...

Dear All, I have the following problem, which I am really stumped on. I have a database to store details of building projects, which can be funded from one or more budgets and also have a financial year attached to them. On my data entry form I want to enter the relevant data and have access...

Dear All, I have the following problem, which I am really stumped on. I have a database to store details of building projects, which can be funded from one or more budgets and also have a financial year attached to them. On my data entry form I want to enter the relevant data and have access...