Search results for query: *

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

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

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

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

Can someone tell me how to set the validation property for a field that insures the new value is greater than the last entry in the same field?

The following works but only returns to me the DateReading field part of the record. SELECT tblCustomers.CustAcctNum, tblReadings.AccountNum, Max(tblReadings.DateReading) AS MaxOfDateReading FROM tblCustomers LEFT JOIN tblReadings ON tblCustomers.CustAcctNum = tblReadings.AccountNum GROUP BY...

I have a table with Customer information keyed by CustAcctNum field.The Many table has account activity associated to CustAcctNum. I want to query just the latest by date(Max)from the many table and retrieve all fields for billing purposes and I want the customer information associated with...

Is it possible to mail merg from Access into the Form Fields in Word 2000 and how?

I'm wondering if there is an easy way to save a duplicate workbook so that all the information is automatically linked to the original so updating to the original will automatically take place in the copy.

How would I go about generating and displaying an automatic and distinct work order number each time a form is opened and before the information is saved to a table? Regards, JD

When I try to open Photo Draw (Office 2000)I get the following message: The instruction at "0x77fcb007" referenced memory at "0x6d695340". The memory could not be "written". Click on OK to terminate the program. Click on CANCEL to debug the program. Any...

I am using a dialog box that takes one address entry and searches three fields for matching records. I want to be able to let the user enter only part of a street name and/or number and get back records that he could manually look at for the correct record. For Example, to find 67 DANIELS RD...