Search results for query: *

Is there an easy way to delete rows which, when subtotaled, equal zero? Any help appreciated. Phil

In the page footer of a report, I have the following controls: txtPage: ="Page " & [Page] & " of " & [Pages] lblDCApproval (a label) linDCApproval (a line for a signature) lblDate (a label) lblDate (a line for a date of signature) In the OnFormat and in the OnPrint events of the page footer, I...

I am using the following code to recursively populate a treeview control. I modified it from the code found at MS's website. '================================================================== 'This procedure populates the TreeView control when the form opens...

I have a type of query which finds unmatched records in a table. The problem is there is a month and year field in the other table which I have to put a criteria on for the latest month and year. If I take off the month and year criteria, I get the results I want and if I put them in, I do not...

I am attempting to update data contained in a subform and I am getting the error: Field 'Fieldname' is based on an expression and can't be edited. I am populating the subform with the following code: Private Sub SetSubFormRecordSource() On Error GoTo Err_SetSubFormRecordSource Dim rst...

I have a table which has as 2 of it fields "Month" and "Year". What SQL statement would I use if I had the following data in order to return the maximum month for the maximum year. MONTH YEAR ===== ==== 7 2004 1 2005 If I select Max([Year]) and Max([Month]) together I...

I have a form which I am populating with an ADO recordset on the load event of the form. Said form has a subform control. My question is: Do I set the source of the subform control and the link fields in the design view of the form or do I approach it from another direction? I would like to use...

I am curious if anyone can shed some light on this subject. In the help file in Access under the CommandTypeEnum heading, it lists (among other options) adCmdTable and adCmdTableDirect along with the descriptions of these options: adCmdTable : Evaluates CommandText as a table name whose...

I have 2 tables which I would like to join. However, one table has a 7 character field which when parsed, can be joined to 3 fields in the other table. I would prefer not to actually parse the field out into separate fields in the table design if possible. I am thinking something like this...

I am using the following code to open an access database with the Shell function... Private Sub cmdOpenDatabase_Click() Dim strPath As String Dim RetVal As Double strPath = "c:\progra~1\micros~2\office10\msaccess.exe " & Me.Location RetVal = Shell(strPath, 1) End Sub I...

FYI If you refer to Article 209891 "Acc2000 How to Fill a Treeview Control Recursively" and attempt to do this in Acc2002, you will get errors. Here is the corrected code for Access 2002. '=========Load Event for the Form======================= 'Initiates the routine to fill the TreeView...

In Access, if you put an image on a command button, the "Picture Builder" wizard will activate. Does anyone know of where these particular bitmaps (I believe they are bitmaps) featured in picture builder would be located on the hard drive. Thanks. Phil Edwards

I am attempting to build a database that I can track other databases I am creating and maintaining. What I am trying to do is open any given database in a new instance of Access from my application. I have tried OpenCurrentDatabase and OpenDatabase. These seem only to apply if you are working...

I have an Excel file which contains cells like so: Column A Column B 2580 1432, 4321, 2342 What I would like to do is created multiple rows from this so that I get 2580 1432 2580 4321 2580 2342 Column B can have more than 3 values. The values...

I know there is a way to do this but I cannot seem to locate it in any of the books I have here at work. I want to print the page footer only if a group footer prints on the page. How do I do this. Phil Edwards

I was reading on Microsoft's support site that one of the ways to minimize corruption in an Access database is to minimize the number of connections made from a single client to the backend database. I am not totally certain about how to accomplish this. My first thought is this. Set up the...

I have a form which displays 2 records at a time (the before record and the after record). The is also a check box which the users check when they are finished processing the record. The form uses an ADO recordset that is based on an SQL string. When I requery the recordset and move back and...

I have a form with the source being and ADO recordset. I am doing this because I display 2 records at a time on the form, a before and after state of the record. There is a check box which the users can check and it updates the appropriate field in the ADO recordset. I use rst.Update do...

How would I show records where the value in the RecordId(autonumber) field is not equal to the previous record's RecordID + 1? I am wanting to show where there are gaps in the sequence.

If anyone has had any experience with this, or has any ideas, I would greatly appreciate it. I am attempting to build one or more tables to accomodate the business rules which define when an employee is eligible for vacation/sick time. I am unsure of how to go about this. Any help is useful...