Search results

Is there a way to tell a subreport (printing on a report) to print in a particular order. FYI - it is being told to print in alphabetical order but there are a couple of the items we need to print at the top, then we want the rest to print in alphabetical order. Can this be done?

Can someone please help me with the answer to the error "Syntax Error in FROM Clause": SELECT [tbl_Join_Model&StandardFeature].[ModelID], [tbl_Reference_StandardFeatures].[Feature], [tbl_Reference_PackageItemCC].[Item], [tbl_Reference_UniqueChaparral].[UniqueItem] FROM...

Does anyone know of a speed enhancer for Access. I have split the database. It has been compiled. And I often Compact and Repair the Database. Is there a way to speed enhance the database.

I get the error "Syntax Error in Join Operation". The record source reads SELECT [tbl_Reference_StandardFeatures].[Feature], [tbl_Reference_PackageItemCC].[Item], [tbl_Join_Model&StandardFeature] FROM tbl_Reference_StandardFeatures INNER JOIN ((tbl_Reference_StandardFeatures LEFT JOIN...

Is there a way to list several items in one field, but to get the list to print on separate lines in a report? Example in field in table: Fishing Seat w/ Pedestal, Tackle Organizer, Trolling Motor Example to Print in Report: Fishing Seat w/ Pedestal Tackle Organizer...

I have a form which previews a report at the end by clicking a command button. I need the report being previewed to be determined by a choice during completion of the form. Example: If Brand = Harris Flotebote Report to Preview = rpt_WindowSticker If Brand - Nautic Star Report to Preview =...

I've been working on a database for many months. It is almost in a workable state. I am having trouble on one of my forms getting a button to show data when clicked. I am desperate for an answer as this program is needed in our company ASAP. My program is big in size so I cannot attach it to...

We have a report with 2 subreports. One of the subreports lists option upgrades to units in inventory. 1st Question: The options listed are the options selected for that particular piece of inventory. However, the options list multiple times. Why? I wondered if the problem is that the...

I have a report on which I need a list of items to print. The report is similar to a window sticker on a car and gives details about a unit in our inventory. The list I need to print is a list of standard features for the unit. The list comes from a table. Of course, there are multiple...

Can anyone tell me how to find and correct an application-defined or object-defined error? When I click the OK button, the message goes away and my form page works fine. But the message appears everytime the form page is opened. I have checked the help section and cannot find mention of this...

I have a text box which populates when you double click an item from a list box. Likewise when you double click an item in the text box, it should remove the item. The purpose is to select options on a vehicle in inventory. The list box shows all options available and the text box shows the...

3 forms exists. frmInvEntry frmInvEntryPg2 frmInvEntryPg3 Question: When I move from frmInvEntry to frmInvEntryPg2, selections made in frmInvEntry carry forward to frmInvEntryPg2. However, when moving from frmInvEntryPg2 to frmInvEntryPg3, prior selections made are not carrying forward. Why...

I have a query that includes a field for ModelID and one for MotorID. The criteria for ModelID is 125 (for ModelID 125). The criteria for MotorID is a range of numbers, not necessarily consecutive. MotorID = 6,16,17,18,19,20,21,30. (The motors with these MotorIDs are the only motors...

I have the following tables: tblModels --fields-- ModelID BandID ModelName MotorID etc. tblMotors --fields-- MotorID MotorBrandID MotorName etc. I need to link the 2 tables via MotorID. The data type for the MotorID field in both tables is "number". Please note that not all motors are...