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?

Now a Join Error Appears I made a few changes and now I get the error "Syntax Error in JOIN Operation": SELECT [tbl_Join_Model&StandardFeature].[ModelID], [tbl_Reference_StandardFeatures].[Feature], [tbl_Reference_PackageItemCC].[Item], [tbl_Reference_UniqueChaparral].[UniqueItem] FROM...

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

I am not familiar with a built in analyzer.

Answer found Hi, I found the answer to my question over the holidays. Thanks so much for responding.

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

Thanks Anyway. Once again I fixed my problem.

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

Thank you so much for all the help. My problem has been fixed.

FYI - The brand is selected from a combox box and all data selected in the form is sent to a table called tbl_Inventory_Main.

Does this mean I should not be using a Select Case statement? All I need to do is get the right report to preview based on which Brand is selected on the form.

Please know I am not real knowledgeable on select case statements but I believe this is a way to achieve what I need.

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

There are tables and querires set up which are also involved in the process. I'm sorry for not being better at explaining this. But it is a little difficult.

I have a form for entering model specific data about boat inventory. On the form is a button for defining what colors the boat is available in. Another for defining what options are available on the boat. Another for defining what standard features are on the boat. The colors and options...

Here is VB code I believe completely involves the problem. Public Sub sSelect(intSelect As Integer) On Error GoTo ErrorHandler Const strColors As String = "SELECT tbl_Reference_Color.ID, tbl_Reference_Color.Color " _ & "FROM tbl_Reference_Color " _ & "ORDER BY...

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 really need the contents of the package to indent under the name of the package. I indented them when posting the question but noticed the indention does not show to viewers. I really need to get this working today and have worked many hours trying to figure this out. The answer is...

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