Recent content by PhoenixDon

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

So obvious, yet I'm so blind. THANKS!

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.

Thanks for the response. Problem solved!

PHV and Scottian, Thanks for the replies. My question is, why am I getting duplicate records? Thanks, Don

BTW, here is the example from the help file. DoCmd.OpenForm "Employees", , ,"LastName = 'King'" Don [bigglasses]

Open your Visual Basic editor, go to the help file, and type in OpenForm. In your case you're asking about the WhereCondition clause. "WhereCondition Optional Variant. A string expression that's a valid SQL WHERE clause without the word WHERE." As stLinkCriteria is not defined, it would be...

Off the top of my head, I would think you need two fields in your table. START and STOP. You could make a button for each and then the code to put the time stamp in. Private Sub btnStart_Click() START.Value = Now() End Sub

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

These text files are documents that I have to find a way to split apart. Typically they may be anywhere from 6 to 600 pages, with each document containing 6-9 pages, and they go to different people. A program we use currently converts them to a WORD doc, then emails it to one office. I want...

BTW, using VBA, if I wasn't clear. Open myFILE For Input As #1 Line Input #1, InputData Do Until EOF(1) 'need stuff here Loop

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 hang my head in shame.

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

Probably should be this too. For i = 1 To .FoundFiles.Count strFile = .FoundFiles(i) If FilesWereFound = True Then DoCmd.TransferSpreadsheet acImport, 8, Table1, strfile, True Next i