Hi, We have a report in MS Access 2003 that changed depending of the user selection. It shows stats for days from 1 to 7 seven days. Now, when we have the whole 7 days, we need a full length legal paper, landscape format. However, when we display 5 or less days, we don't need that much space, so we would like to switch to letter format....
Hi folks, I've been using the following code, given to me by HansUp (cheers!), and it's been working great: SELECT g.ID, Count(t.Grade) AS Total FROM grade AS g LEFT JOIN (SELECT Grade FROM telephony WHERE [Date] BETWEEN #08/16/2010# AND #08/20/2010#) AS t ON g.ID=t.Grade GROUP BY g.ID ORDER BY 2 DESC; I'm now looking to find the...
I am using Ms access 2000, This query is filtering when I use "=" condition, but it is not filtering when i use "<>". What might be the problem? SELECT tblRevRelLog_Detail.RevRelTrackingNumber, tblRevRelLog_Detail.PartNumber, tblRevRelLog_Detail.ChangeLevel, tblRevRelLog_Detail.Version, tblRevRelLog_Detail.JobPnType, tblRevRelLog_Det...
Back story if you want it: I have an odd situation. An organization affiliated with my own provides us with a database that we use heavily; a few other organizations also use it, but our records are easily more than 90% of the total. We have a web frontend for data entry that is connected to the live database, but we only get the backe...
Hi, I have a database in Access 2003 that I only want certain people to be able to access. In my database I have a table which lists the people that should be able to access the database. (Tbl_BIRT_Users). The table contains their name, ntlogin and email address. It also has an 'adminstrator' field. My question has two parts: 1 - On ...
I have an Access 2003 database which uses a main form with a datasheet in a subform. The main form allows the user to select from a menu which updates the recordsource of the subform. The subform also updates the number and type of fields available for editing based on the number and types of fields in the form's recordsource. It's basic...
Ok. Quick background: MS Access 2003 with 2003/2003 format MDB file upgraded from Access 97. For the purposes of this example, there are two tables. Table 1 Asset ID - (text 20) ParentID - (text 20) Other fields AssetRels ID - (text 20) When a record is added to Asset, the ID is added to AssetRels. From Asset.ID to Ass...
Hi, This query displays partnumbers which have eventtype is not equal to "PNremoved FROM Wrapper". This query is displaying the right data. Part number may be removed from this tracking number, but it can be entered using another tracking number. In that case it is not working. I want the query that works when we enter the same part n...
I've been recruited to work on a form for tracking specimens. Each specimen is associated with a subject; each specimen also has a particular slot in a 9 x 9 storage box. For ease of data entry, I think it would be best if the Access form mirrored the box itself (and the paper forms that will be used to enter data into Access): nine co...
Hi, In a parent-form, I filtered a table on a candidate key consisting of multiple values, so the result should give a single record. Now I can't get the subforms to synchronize to that. It keeps showing the same record (with the possibility to loop trough all values using the buttons) Either the applied filter does not work, or there i...
I'm building a client and case database in Access 2003. The parent client table has fields for the clients' names, company (if any), status (value list) an additional note (text or memo type), and a Y/N toggle box for our mailing list. The PK is in incrementing AutoNumber. Following a normalization tip from a thread elsewhere, addresses ...
I have an Access 2003 application that I would like to create reports for using stored procedures via pass-through queries. Everything works fine with one exception. When I specify the stored procedure to use for the pass-through query I have to choose a DSN to provide the database connection info. I need to be able to change the connect...
So I have an access mdb file that was originally create using Access 2003/Office 2003. Since I have recieved a new image at work that has 2007 Office installed. The file extension of the access database is still mdb., and the convert was done to 2002-2003 Access database previously. Here is my question: I have users that still need to a...
The use of lockWindowUpdate API in VBA code avoids screen flickering when updating screen content. It also greatly improve calculation delays, as the computer do not have to refresh the screen after each calculation\update made on the underlying recordset. Unfortunately, I cannot have it work correctly with Access 2007 runtime! On some...
In Access 2003, there are ways of running code when a form or database is opened, but what about when the database is closed? My motivation is the unavoidable use of a somewhat buggy third-party COM library. Releasing the COM reference (by setting the variable to Nothing) causes it (correctly) to disconnect from its server. The trouble ...
Are there ways in Access VBA (2003) to cast a COM reference to an integer, and to call AddRef/Release? (which give the error "Function or interface marked as restricted, or the function uses an Automation type not supported in Visual Basic") I'm using a third-party COM object which doesn't handle being instantiated twice in a single pro...
I have the following problem with MS Access: Suppose I have a list of companies with monthly performance values. I can view the performance of a single company in a chart by hooking the chart into a query with a Month column and a Performance column. Now suppose I want to display a chart for N companies. I could theoretically do this i...
Following function is for evaluating dates called by procedure CheckEventDataIntegrity. This does only for events but now I want to add partnumber along with event type. Means it should evaluate dates with event and partnumber.How Can I do this?? '----------------------------- '----------------------------- ' Function : EvaluateDates ' ...
I have a form called Group in my MS Access ADP. On it is a tab control, and in each of the tabs there is a subform. The first tab contains the subform Users, and it isn't showing up in form view. Subform Users shows up in design view. Any clue as to why this might be happening? ...
I'm trying to filter the records shown on a subform based on what is typed in a textbox on the subform. The subform is called Users, and it is on the Group form. On the Users subform there is a textbox called txtFilter. If I type "W" in txtFilter, I want to show only records in which the User's lastName or userName begins with a "W". As ...