Search results for query: *

Thanks, that was the key. The global once again saves the day. Appreciate your time and thought.

Sorry for cloudy description. I have three message boxes that check for data in two subreports and in the main report. They are activated by a check the .HasData property. First message from subreport "No records over 90 days old", second message "No records over 60 days old." Finally, it checks...

I have three subreport.HasData checks going on in the OnFormat event of the Report Header. They display fine but when I go to print they want display again. Have tried checking FormatCount but it remains at 1 even after it seemingly revisits header before printing. I have set my own variable to...

Bob, I won't have time to implement until later but can see the logic of your approach and it should be good from here. I've given you a star for "opening my window." Thanks again for your time. Jim Dalton

You understand perfectly what I'm trying to achieve. An SQL example would be much appreciated. Thanks for responding I had pretty much given up.

I have a one-to-many relationship between Customers (Primary Key=ContractID) and Projects. The relationship is displayed in a tabbed page Form/subform setup. I use a separate unbound search form to filter the qryCustomers querydef for the main form. However, on the subform I have...

Thanks, this accomplishes partly what I needed but I failed to mention that some of the records carry a blank in this field. These records are queried out. Is there a way that I can return records that have no data in the date field.

I am using an unbound form with various unbound text boxes as the source for a query's criteria. One of the optional unbound text boxes is a beginning date and an ending date for one field on the query. I am using the Between [beginning date] And [ending date] format as criteria for this...

I'm working on it locally as of now. I've gotten it to play if I create a new page and then review in browser. But if I put it in my old page it hangs. Have tried both methods: document and site specific. I'll include all of the original (old) page code. Let me know if you see something that...

I create the flash animation in Flash MX 2004 and it tests fine. I import to web page in Dreamweaver MX 2004 and play it from properties in design view and it plays fine. Then I preview in IExplorer and I get a white square and the page gets to "opening one item" and hangs on hour...

I create the flash animation in Flash MX 2004 and it tests fine. I import to web page in Dreamweaver MX 2004 and play it from properties in design view and it plays fine. Then I preview in IExplorer and I get a white square and the page gets to "opening one item" and hangs on hour...

I understand the DatePart() function but am having trouble with the logic of determining the 2nd, 3rd, or 4th occurance of a particular day of the week. How do you find the 3rd Monday in June of 2007 without using a calendar to manually choose it? I would like to automate and be able to choose...

I want to set up a scheduler that uses radio buttons that would pick 1st, 2nd, 3rd or 4th Mon., Tue., Wed., etc of more than one month. For example, I want to have a report produced for the 1st Mon in Jan., Apr., Jul., & Oct. or the 3rd Wed. in Jan. & Jul. In particular I'm unsure of how to...

I was not clear. I have a very large list of unique items. As each item is selected in the list box it is moved to an adjacent text box. I would like to be able to search the list box via another text box, click on an item it goes in the list box from typing an account number in the search text...

I am using Access 97. I have a multiselect list box that I would like to search using a text box to facilitate selecting items before applying filter. I've tried using snippets of code in these posts to no avail. Any help would be much appreciated.

I must have been "code blind." I put the right code in the wrong form's OnCurrent event. All is well now!

My Customer form opens the Experiment form with a button and they are linked by the CustomerID field present in both. I've written the following code in a form called Experiment's OnCurrent event to keep it synchronized with the Customer form while the customer Form is being incremented from...

I use both Access 97 & 2000. In Access 97 the create new form and report wizards work fine. In 2000 they do not. I also notice that my Tools/Add-ins menu item is greyed out. These seem to be the only things that are not functioning properly. I am using Windows XP on a Sony Vaio Laptop. I...

I use both Access 97 & 2000. In Access 97 the create new form and report wizards work fine. In 2000 they do not. I also notice that my Tools/Add-ins menu item is greyed out. These seem to be the only things that are not functioning properly. I am using Windows XP on a Sony Vaio Laptop. I...

Withe C drive FDISKed and Formatted and with system files transferred, I have rebooted using boot disk (with CD-Rom support). However, at the A:\ prompt when I type "setup" and [enter] I get the message that DOS does not recognize this type program. What have I done wrong. Jim