Search results

Thanks for the quick reply. But the same effect. Selecting on one record sets the button state for all buttons, all reports. Private Sub Form_Current() Me.Name_Report_Button.Enabled = Me.Hit_by_Name Me.SSN_Report_Button.Enabled = Me.Hit_by_SSN End Sub Private Sub...

I have a rather large list of reports that I want to present to the user as a continuous subform with buttons on each record for the user to print that particular report. The form draws from a table that has the report name and a flag indicating whether there is data for the report to display...

Re: Re: Shivers? Not me Not really, wife didn't have a headache the day before. :D

Wife: Do you like this paint color? drapery? furniture? Me: Yes, Yes, Yes. Can we have another baby? Me: <cringe> 17months later... Wife: Can we have another baby? Me: I'll do anything if it cures your headache!

I just wanted to say you guys Rock!

Oh...I'm using Access2k on a Win2k workstation.

I even made a backup and removed all queries, forms, tables and reports - There is literally nothing in the db except a date conversion function, pass one date is, it passes back Friday's date - I compacted and repaired and still get the error when I try to open the module. Db's attached...

DBrooks, Did you make any progress with this problem? I am getting the same error messages. My module has one small function in it. The db resides on my desktop where I have full rights. All tables are links an SQL server. I also tried refreshed the linkks.

You problem is a bit hard to follow. Can you describe you problem in more detail? Have you tried a requery on the combo box?

I wish my stock would double. You wouldn't happen to work for a stock exchange? lol. Run your query without the sums. Check for duplicate records. It sometimes helps to bring is more, if not all the fields from the tables to see where dupes are coming from.

From the microsoft web site: 180985 - OL98: How to Customize Outlook Calendar Holidays http:// support.microsoft.com / default.aspx?scid=kb%3Ben-us%3B180985 Summary: This article describes how to customize the pre-defined Calendar holidays in Microsoft Outlook 98. The technique involves...

Having said that, you might not be interested in this option. It reminds me of a workaround microsoft posted for outlook where holidays past a certain year didn't migrate over to the newest version. The solution was to edit a text file that stored the holiday information. I was shocked that...

You have to test the denominator for zero. Then either pass a 0 for the full calculation. Try this: LgQty: IIf(Nz([No_Lg_Containers])=0,0,(Nz([WtInLg])/Nz([No_Lg_Containers])*Nz([LgfrWharf]))))

Thanks for the reply. This proved to be more than I can handle myself, so its in the hands of more experienced programmers. We're going with some event driven process executed during the first print run.

Pat, thanks for the reply. Never thought of that one. Another option I was thinking of was some manipulation of results from a cross tab query, but your right, its best coding.

I am trying to create a simple query that will keep a running list of first names, but am having problems. It was done in the design view but here's the sql for discussion purposes: PARAMETERS RunningList Text ( 255 ); SELECT Family.LastName, ([RunningList] & ", " & [FirstName]) AS RunningList...

If I understand you post correctly, this would work if the number of records per page were constant. The report is pretty complex with several groups and headers/footers and grow/shrink fields, so the number of records that fit in a page varies.

I have a report of customer info that is currently sorted by customer number. There are 1000s of customers and the report is well over 5,000 pages. I've been asked by the bosses on high to sort the report by the number of pages the customer receives so we can sent the smaller reports to a...

Shivers? Not me Reading this thread makes me appreciate my wife that much more. Beauty, intelligence, and none of those hang-ups that I'm reading about. She's a good mom too. Maybe its because I answered those questions truthfully before we were married. Now I don't have to fib and she...

Duh - sometimes I get involved in such complex tasks that I forget the simplest ones. Maybe its just burnout. Thanks!