Search results for query: *

The subject line doesn't explain this question well. I have a table with several fields. One YES/NO field that indicates which is the active contest. I want only one record to be active at a time. I know I can do this with code, but I'm trying to use a macro to get this done. Here are my...

A have a switchboard that opens a form. The data source for the form is a query that can return ZERO records. How can I prevent the form from opening if there are NO records, or at least display a message, then close the form.

I wrote a little Access program to allow supervisors input the daily duty status of their employees. Managment wanted a report so everyday they knew how many people were at work. I have two tables, one is all the people assigned, the other is their duty status. I created an AutoExec macro...

This may be a stupid question, but I can't find the answer. I have a text file open, I'm extracting portions of the data in the file for import into a table. How can I move within the file. For example, I'm at the end of a page and I need to go back to the top of the page, or perhaps up 5...

I've got a form with several check boxes that users can check to indicate a required administrative task is complete. Checking also updates a time stamp in a table. Once the box is checked, it should not be un-checked, unless the user is a supervisor. So my question is, using the BeforeUpdate...

My users have a requirement to extract certain data elements and email them to another out of state office. They have been typing them, but I would like to simplify this to a button click, then paste in the email. My question, how can I build a multi-line formatted string, and copy it to the...

A clerk in my organization wants a report that shows how many customers she serviced in the last month. She doesn't want the current month, just the previous 12 months, regardless of year. I don't want her to have to enter anything. Am I going to have to right a loop and capture the current...

I'm working on a help desk app logging calls. Two events are captured, the "Start Call" and the "End Call". I want to calculate the length of the call (End Call - Start Call), typically never less than 30 minutes in duration. As there may be reports later down the line and I want to be able...

Hello all, I have a Access DB and want to add code that opens a hyperlink. So far, this works: Application.FollowHyperlink "http:\\www.cnn.com", , True However, users want an Option Group with either "Internet Explorer" or "FireFox". Depending on what they are doing and the URL they are...

I changed my default page from a ASP file to a HTML file. I discovered problems with the HTML file, so decided to rollback to the original ASP file. This is the only change I made, and now my web site doesn't display the default page. What did I do wrong? I'm an IIS neophyte, so speak...

I'm kinda new to the SQL Server world, so if this is obvious, please forgive me. I'm executing a job that has 15 steps, calling 15 different stored procedures. Each step errors with the following. Executed as user: SQLAdmin. Remote access not allowed for Windows NT user activated by SETUSER...

Which ODBC driver version is needed to access Paradox 9 table through SQL Server 2000. Also, where can I get them. Thanks Don

I have a program that is used for tracking customers as they appear at the front desk. When they log in I want to send a pop-up message to the person or people who are scheduled for the appointment. I was thinking about shelling to a DOS prompt and running NET SEND. EX. NET SEND JOE.BLOW...

I was given a spreadsheet and both the rows and columns are numbered, rather than the rows being number and columns ABC. Of course this makes using functions somewhat dicey. How can I change it back to the standard? Read the help file and can't find anything, and the spreadsheet owner doesn't...

I have two Access 2000 tables whose structure is identical. Every week I copy the contents of the TR table to the TR_History table. The code below is supposed to compare each record in the TR table with the History table. If matching records are found then I increment a counter, copy a string...