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 -...

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...

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...

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...

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...

Dear All, I have a form "frmDevtargets" with a subform "frmTask". These forms are based on "tblDevTargets" and "tblTask" respectively. Before opening the form I create a backup copy of each table so if the user chooses not to save their changes I can...

Hi All, I have two tables [tblProject] and [tblLetter] with a one to many relationship between them. When a letter is sent for a project a record is created in [tblLetter], but if a letter has not yet been sent then there is no record in [tblLetter] for the project. I have a form with combo...

Hi All, I have two tables [tblProject] and [tblLetter] with a one to many relationship between them. When a letter is sent for a project a record is created in [tblLetter], but if a letter has not yet been sent then there is no record in [tblLetter] for the project. I have a form with combo...

Hi All, This sounds like a stupid question, but I can't find an answer anywhere. All I want to do is to put a carriage return between two lines in a label on one of my reports. I have tried using the Chr(13) solution, but it just takes it as part of the caption. Is there any way of doing this...

Dear All, I am using the "Analyze With Excel" button to convert an Access report into an Excel spreadsheet. However several of my fields don't appear in the column order that I would expect. This only seems to apply to fields, which were added after the main bulk of my fields, so I'm...

Hi All, I have a split front/back end Access database. What I'm trying to do is run some code in the front end, which copies an existing table, renames it, and links the new table to the front end. I've no idea how to achieve this. Any help would be much appreciated. Thanks in advance BenC

Hi All, I'm trying to create a split, back end/front end database. I've designed the database and have used the Access database splitter to create the back/front end parts. Obviously my recordsets aren't working now as the tables they are created from are in a different database...

Hi All, What I am trying to do is import an email containing name and address details from Outlook into Access. The problem is that if the email text has a carriage return in it then access only copies up to that point and doesn't copy the rest of the message. Therefore, I can copy an address...