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

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

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

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.

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

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

I have 2 tables that have an identical structure. I run 2 queries. 1 is an append to capture new records, the other is an update where I update every field. I have several tables that I need to do this for, but some of the tables have many many fields. I join the 2 tables and then in the...

I am using VB Code within Access to format a spreadsheet. That is working fine. Then I manually go into the spreadsheet to add code to the “Open Worksheet” event. Here is what I do manually: 1. Open the spreadsheet 1. Right click a tab and select “View Code” (or press Alt+F11) 2. Under...

Hi, I would like to create a Word form that a user will input data into fields and those fields will be added to an access database. I thought I could do a reverse mail merge. In other words, the user can input data into a form, and the data would be inserted into the database. However I...

Hi, This is probably a stupid question, but I am using Access97, in a large corporation, and have been told that I have Access Runtime. However, I don't kow where to find it or how to use it. I have written an Access Application and would like to distribute it using Access97 Runtime...

When I change the Start and Finish dates of a task, the dates of the resources change automatically. Is there a way to change the Start and Finish dates of a Task without automatically changing the dates of individual resources? The reason I want to do this is as follows: I may have a person...

I have a question on how to design my resources. Our company has a hierarchy that goes something like this: TOWER DOMAIN BUSINESS FUNCTION TEAM BAY Instead of assigning "people" to each task/project on my Gantt Chart, I want to assign "bays" (so a bay can be...

Can a report be set up so that when a user clicks the "X" to close it, that it does not prompt him to save it. It just closes without being saved? First I use this command: DoCmd.OpenReport "rptFlexible", acViewDesign Then, using VB, I populate a lot of the report based on selection criteria...