Recent content by sullivan

I need to have a message box open up once every 60 days. I think I should be able to attach the box to the applicable form, but I'm having trouble figuring out the code to force the box open. Is this idea even possible? Does anyone have any suggestions or ideas of where I can look...

Thanks for the reply. I already have the form and report created, this db has been in use for a few years now. The users have requested to delete the stored data - they find it unnerving to have it stored, and they won't listen to reason. I guess my question is: what would be the best way...

Within a split database I have a table that I probably don't need, but I'm not sure. Right now, the table holds data that is entered to create faxes. Part of the data for the report is pulled from another table in combo boxes (fax number & company name) the rest is entered by the user, and...

Thanks :) I knew it had to be something easy.

In a summary report, that lists totals of hours worked over either a week or two weeks, I'd like to display the earliest and latest dates of the data. There is a [date] field that corresponds to each record, but I only want to see the earliest and latest on the report. Is there a way to do...

I have been using an existing table for just over a month. Two days ago I entered approximately 30 entries into my table. About 20 of them did not carry over into the query. The criteria in the query had not been changed. When I attempt to change the criteria to test one of the "missing...

I have a report, that is based on a union query. The report is set up to seperate the information from each seperate query, that are joined in the union. For Example: Wallcovering - all the charges for a customer Flooring - all the charges for a customer Window Treatments - all the charges...

I have a report that is based on a union query. Within the report there is one subreport. I need to find a way to pull customers whether they have data in the union query and the subreport, or just the subreport. The constants between the reports are the [DrName], [Job#], and a check box...

Is there a way to limit the verticle size of a subreport? I have a subreport that is a list of names and voicemail extensions. I'd like to control it so if there are a certain number of lines, it will start a second or third column within the subreport. Thanks in advance.

The compact & repair hasn't done anything. I've tried it several times throughout the day. Thanks anyway. Anyone else?

I'm having some new problems with my database. Specifically, when I try to open a few reports and a union query I get an error that says there is not enough memory to execute the command. The union query will open in datasheet view, and display all the correct information. However, when I...

I got the code to work, finally. I thought I'd let you know what I did. It's so simple, I can't believe I've been missing this the whole time. I added a general declaration that defines mboolFirstLabel: Option Compare Database Option Explicit Private mboolFirstLabel As Boolean Now...

please help So far no one seems to know what I should do. Should I try to debug the code? Does anyone have any suggestions of how to do this or a place I can go to get help? I'm very frustrated and don't see what's wrong. Any help would be appreciated.

Recently I posted a question regarding a program to force a label report to skip a specified number of labels. My problem at that time was with the IsLoaded function. That is now working. However, now that everything looks right, the program doesn't work. It goes through all the correct...

There are directions in Alison Baxter's Access 2000 Development book for creating a form to skip labels on a label report. I'm having problems with the event procedure for the Report On Open Event. The book tells me to enter: Private Sub Report_Open(Cancel As Integer) If Not...