Recent content by MissCLuvr

I used the following code in a database which is having some minor problems. The user is to type in a date and the change should be throughout the document. This change is not reflected. Also, the user should be able enter a start time, calculate the end time and the start time for the next...

Thanks for the suggestion. Now I have another problem. I have an error on the On Open: Private Sub Form_Open(Cancel As Integer) CheckBroadcastDate End Sub is not picking up. What could be wrong. MissC

Maestro, To get to the document you have linked to the database. I would create a macro to RunApp and on the Command line type the path where your document is located: C:\WINDOWS\Application Data\Microsoft\O...\Office.doc After that go to the form you want to pull the macro from and create a...

I have a form which if a time to start a program is typed in (the programs has a table that tells the length of the programs) it automatically calculates the end time and the next row has the new time to start. Well, here's the problem if a time is entered that overlaps with the new time I...

Dr. all you have to do is go to tools and select Analyze with Excel. This will dump your data into an excel spreadsheet. Or you can ultimately do it from the table or query you designed for that form. Let me know if this works. MissC

Thanks for your help...but the freaky thing is that everything works from the replicated copy. When I transferred the replicated data to a new blank database to create a design master, in incurred that problem. The code has not changed and that is the only section of the database that does not...

I am getting the error message (The expression On Open you entered as the event property produced the following error: User-defined type not defined). The following is the code I used for the document: --------------------- Private Sub Form_BeforeUpdate(Cancel As Integer) On Error GoTo...

I created the data table as Grade Level with only K, 1,... to connect to my Grade Levels table which include K-1, K-2... and I added it to the query so that the information will be returned but it did not work when I tried to connect it to the Report. Can you tell me how you would write that...

I am having a problem with a list box where the user chooses several options to bring back data onto a report. My problem is that if the user selects K-1 (kindergarten to first grade) it only chooses K-1 information. What I want it to return is K-1 plus all first grade listings as well. If...