Search results for query: *

Hi, Can a table (or query) be used as a filter on a form? The record source of my form has a Product ID. I have another table that also has a product ID. I would like to use the Product IDs in this second table as a filter to my form. I know I could join the 2nd table in the record source...

That works great. Thanks!

I don't know if this is possible. I want to use a "Do" loop to run thru a series of controls on my form. The controls are named ctrl1, ctrl2, ctrl3 ... ctrl20 etc. The controls are check boxes. So I am trying to loop thru to determine which ones are "True". I want to use a DO loop to...

Hi, I have a question that may be a bit confusing. Can anyone help me? I have an unbound main form. The subform is bound to a table. I would like to open the main form with a filter to be applied to the subform. Actually, the filter is really another table with a list of IDs. (Does a...

When I run a report or query, the result keeps showing up "behind" my form. My form is NOT model or pop up. Any idea why this is happening?

I have upsized my tables to SQL. Now, a DBA is maintaining the production tables and I maintain the Access front end. Can relationships be set in Access to enforce referential integrigty to SQL tables? Or do the relationships have to be set within SQL. Also, with regards to "Cascade...

I have a form that is bound to a Query. When I type an "Employee Id" (for example the number 42) in the criteria of the query, it pulls up 1 record and the form shows the 1 record and it works fine. But I when I try to use the Filter property, nothing happens ... I get ALL records (I do not...

Hi, I have code that works fine in Access 2002/2003 with an Access backend. But when I changed the Back-end to SQL, I am getting errors. Here is my original code: Dim rstSchedule As Recordset 'Add user to schedule Set db = CurrentDb() Set rstSchedule =...

This seems ridiculously easy, but I can't figure it out. I have a form with Workstation information (Key is WorkstationID). One of the fields in the record is EmployeeID. I have an unbound combo box (cboEmployee) for Employees (key is also EmployeeID). When the user selects and employee in...

The paper size is not the problem. Even if I set up the report so there are only 2 tasks on the 1st page, the last task will still print on the 2nd page. I am not printing the legend, but I will try to add it to see what happens. The printer driver is the same as it has been. The report use...

No, Print Notes is not checked. Thanks.

Hi everyone, I am working on a project plan. In the page setup I select "Fit to: 1 page wide by 2 page tall". This has been working fine -- the plan prints 1 page wide by 2 pages tall. All of a sudden, it is printing 3 pages, with the last task on the 3rd page. In Page setup when I change...

It works great. Thanks!

I have a report that will be inserted into other documentation. So I would like my report to start at page 9. Currently there are no groups. How can I do this?

Is it possible to change the Column Headings property in a Crosstab Query using VB? Thanks.

OK, Thanks. I got it to work.

Hi, Can anyone tell me how I would print a negative value in red and positive values will remain in black? Thanks

Thanks, But I have already done this. The problem is that the error comes up because the query is expecting a field that is not in the excel spreadsheet. So the error comes up before the "On Error" takes place. If I click "cancel", my error handler does kick in and I get my message. But I...

TheAceMan1 ... I am interested in adding a browse button also. Per your question, I was able to find commdlg.dll but I could not find "Microsoft Common Dialog Control" in my References. I am using Access97 with Windows XP Professional. I work in a big corporation where it is almost...

Hi, I have created a form that allows a user to enter an excel file name. The code imports the file into a table. Then a query joins the table to another table and then exports the results out into another excel file. When the join field (Project Number) is not in the original file, the...