Search results for query: *

I have an Access 2003 project where one of the views/queries is selecting data (an employee list) from a table in a different SQL Server (2000) database than the one associated with the project. No matter what I do the number of records returned is limited to 10,000. There are about 13000 or...

OK, here's a really simple question for Access 2007. I've been using Access since 2.0, so this annoys the hell out of me. I can't figure out how to show the header and footer in form design mode (although I did it once somehow), but even with the form I made that has a header and footer, they...

I have been using Access 2000 and 2003, mainly with Access front end applications connected to a SQL Server 2000 back end. I just purchased Access 2007 at home and am experimenting with it, both using my home business databases and to check some things out for my daytime job. Although I've...

I have two list boxes, similar to the standard method of selecting columns from a table to be used for output, sorting, or whatever. My data source for the first box is a two column query with the name of the column in the table and the "column name" I want displayed to the user. I can't find...

I have a form which can be in three states: AllowEdits false or true while AllowAdditions is false, or the third state of AllowAdditions is true. There is a button on the form which enables the user to change the state of the form from AllowEdits false to AllowEdits true and back. The label...

When users enter data in the last field in the header of a form and press <Enter> or <Tab>, I'd like the cursor to move to the first field in the (continuous) subform, which is in the detail part of the form (and is the only control in the detail area). However, the cursor moves from the last...

Is there a way to create a custom toolbar that will appear in the report preview window? I'd like one to move among the pages and print the report.

Is it possible to create empty recordsets that have empty rows that could be used for data entry from a form? What I'd like to do is create an empty recordset (based on a table layout) that would not be tied to any table. If necessary, I could see that I might have to specify the maximum...

In SQL Server 2000 I'm trying to create a view that will give me a range of record references for summary levels. I can build views that will give me the starting number for each range, but the ending number would be lower than the starting number for the next range and I can't figure out how...

I have a form with two subforms. The main table includes a last updated column. Whenever any of the data is updated (including the subform data) I'd like to post the lasted date/time into the LastUpdated column. I can do that with the main form data using before update and before insert...

I'm running into a problem with toolbars taking up too much space on users' screens when they are in a lower resolution (800x600), but I can't find a way to stop the toolbars from showing. Is there some code I could put behind a form or something else I could do that would suppress the display...

I'm trying to create a recordset using an existing query and when the code executes I get the error message 3061 "Too few parameters expected 1." Everything sees to be correct, yet I can't get the recordset created. Here's the VBA code I'm using to open the recordset (DAO): Set rstDelays =...

I need to select data from a table that is in a database on a different server. What is the syntax for the select statement used to create the view? This is initially for a database originally on SQL2000 that, in a view, selects data from a different database (I'll call it "Reference Data") on...

Is there a way to open an SQL statement in Access Project (2003) in VBA code? Basically, I'm looking to temporarily create an SQL statement and then open it, normally to get the typical spreadsheet-like display of the result. This would be defining a pass through SQL query in regular Access...

I have developed many applications using an Access front end and a SQL Server back end. Recently I went back to trying Access Project for an application I need for myself (and some other IT people). A concern I have for using Access Project for general use is that I can't figure out how you...

I have a SQL Server database table with a column that is an image type. Using either Access 2003 or Access 2003 project, I would like to create a form which will enable a user to load an image into that column for each record in the table; however I can't find out how to do that anyplace...

I've set up a report that I will use to produce three different variations. When producing the report, I would like to bold one of the controls based on which of the three versions was selected to be run. I tried the following code in the form's on open property and then in the details area...

I was developing a report in Access 2000 (with SQL 2000 back end). Tested the report and it ran slowly, but was OK, but needed more work. I went back in and tried to change the name of a control and it froze. Had to close Access (through task manager) as a result. Tried to get the report...

I'd like to send every line of a selected report to a table and also include additional data at the beginning of each row of data. If necessary I can do something within each report for the added data. My primary question is if it is possible to send each line of a report to a table (as a row...

I have a "main" form which incorporates a sub form (I'll call this the "primary sub form"). The sub form has pages, two of which have their own sub forms. Those two sub forms are related to a value in the primary sub form, but one of the two is only used to display data, not even permitting...