Search results

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

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

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.

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

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

I'm trying to have an "Edited Date" field automatically filled in whenever any field, per record, on a form is edited. This sounds like a simple enough task to program, but I am confused about what commands to use when entering code. I thought I could enter an expression in the Event Field...

Suddenly, in an existing database, queries are behaving strangely. I created a new query and added an expression to it: TotalHours: Sum([Hours]+[2ndDesHours]) In the past expressions like this have worked well. This time though, it is causing the query to go into a cycle. One that states...

Three of my forms will not allow updates to occur. Whenever I try to add information to the subform I get an error that says: "join key of table 'tracking' not in record set". This is the same error I get for all three forms. There are several other forms that are also linked to the tracking...

I am trying to use conditional formatting on a subform, but it's not working. This is what I'm doing: In the conditional formatting dialog box I choose "Expression Is" from the formatting criteria drop down list. Then I entered [Forms].[WindowTreatmentQuerysubform]![Original?]=False I want...

On a report, with a subreport, I am using the HasData expression to pull the value from a control on the subreport onto the main report. =IIf([Consultation Subreport].[Report].[HasData]=-1,[Consultation Subreport].[Report]![TotalFee],0) In the report footer there is a series of grand totals...

In a report section footer I have a text box with the expression =([TotalSell]-[TotalNet])/[TotalSell] This works, except when there is a zero (sometimes the users do not need to add pricing info, but the zeros still need to be shown). I found a code in a programing book that will deal with the...

I have a report in which in a footer there are two calculations totaling, and also there are two subreports. Everything functions fine. The problem is that when there is enough info in one or both of the subreports, the footer will be printed on a new page, many times leaving 1/2 or 3/4 of a...

I would like to use parameter queries to make printing reports easier for the user. Unfortuantly, it they are making things more difficult. I made one query into a parameter query, which causes all the wanted reports to prompt the user for a Name. The problem is, on reports were there is a...

I think this is a query issue, but if it's not please forgive me. I have a database with two tables one listing all our reps, with all their personal info and center. The second table contains all our center info: Location, address, phone, etc. They are linked by the location field. The...

I have a main form with two subforms that track employee time-off. The main form displays the employee name and anniversary date. The first subform displays to time given, and the second subform displays the time taken. I need to subtract the taken time from the given time, so I used unbound...