Search results for query: *

Once again Thanks alot for the help and the code FancyPrairie.

Thanks for the info FancyPrairie. Now I have to figure out some code to loop through the 3rd table to know which one to select.

How can I have a List Box with some of the items already selected? Here's what I'm doing or trying to do, I have 3 tables, 1 table of people with info on them, 1 table with skills, and the last table is the list of skills for all the people since everyone can have more than one skill. Now what...

Hi, I'm working on project, which has a form with some sub-forms, the sub-forms are displayed as "Datasheet" view and not a regular "Form". Is there a way to have the "*" add record at the top of the list and not the very last one. I want to be able to add from...

I really hope someone can help me. I made a Report with data from a Query, the Report displays data between a specified Starting and End Time; using the following Between statement: "Between [Enter Starting Time:] And [Enter Ending Time:]" in the Query's criteria section of the Time...

Here's my situation, I designed an Access database for one of my client. This database contains approximately 20 reports. Now my client wants to be able to view these reports over the internet, since he need access to them from multiple locations. Is there any way to make all these reports...

I hope someone can help me. I'm using Crystal Report 8.5 and I want to add some hyperlinks to link to websites. In Crystal Report the hyperlinks work fine in the "Preview" mode. However when view the report from another program with the viewer the hyperlinks are not active and not...

I hope someone can help me. I have a database with the following fields, PART_NO, PART_DESCRIPTION and PART_IMAGE. The PART_IMAGE is a text field of an image name example: logo.bmp. When I create a report in Crystal Report, it display "logo.bmp", what can I do to make it display the...

I have 10 to 15 different reports and most of the have to be previewed and printed on a LEGAL paper and LANDSCAPE. When different people on different computer preview these reports sometimes they preview and print fine but sometimes they preview and print on LETTER paper and PORTRAIT. How can I...

I have built a query from multiple tables with a specific criteria. In my results from the query I get the right information, from the specific criteria but some info is doubled, some even tripled. What did I do wrong and how can I fix so I get the proper information showing only once? I...

Hi guys & girls, I developped an Access 2000 inventory system for a client, and when I run it on my computer it works fine. However, when my client runs it on some of his computers, some of the code does work properly. For example on a click event of a button, I get the right responce, but my...

The use of ItemData(0) did not work for me, however I was told else where that I could use Me.cmbSubCategory.ListIndex = 0, which works for me, but after this code I want the focus to be removed from this combo box and be set on a text box. I tried the follpwing code...

Here is the situation, I use the following code to set the RowSource of a combo box: PartQuery = "SELECT [Parts].[PartID], [Parts].[Part] FROM Parts WHERE [Parts].[PartID]= 1 Or [Parts].[SubCatID]=" & Me!cmbSubCategory & " ORDER BY [Parts].[Part];" Me!cmbPart.RowSource =...

Thanks for the help "ntp". I really appreviate it.

I want to populate the second combo box "cmdSubCategory" from the first combo box "cmdCategory". I have placed the following code in the "Private Sub cmbCategory_Change()" section.. Dim ListData As String ListData = "SELECT [SubCategories].[SubCatID]...