Search results

Hi All I'm trying to set a day count based on the number of days in the year and take account of possible leap years. The table only ever contains a years cumulative data and the day count needs to run from the first of April and be flexiable enough not to need maintenance to account for a new...

Hi All I have some code that works fine in Access 2000 but not in 2007, it's from lebans HTML editor (if you're familiar), it goes like this: Private Sub cmdEditHMTL_Click() On Error GoTo Err_cmdEditHMTL_Click If IsNull(Me.testmemo) Then Me.testmemo = "" End If DoCmd.OpenForm...

Hi All I have a query that I use as the data source for a form but it isn't editable - I need it to be. here's the query: SELECT Tbl_PayrollData.Acc_Code_CC AS CC, Tbl_PayrollData.Acc_Code_AC AS SUB, Tbl_PayrollData.Employee_Id AS EMPID FROM Tbl_SubstantiveStaffLatest RIGHT JOIN...

Hi All I have a form linked to a read only query. I need to be able to lock out other users from pressing buttons on this form when someone else is viewing the particular record (viewed the record first)? The button has the effect of performing updates elsewhere that effect the readonly...

Hi there, I put together a subroutine that uses an ado recordset based on an existing query, it's worked before but doesn't work in my current query? The code is as follows: ... 'BUILD RECORDSET With rst .ActiveConnection = CurrentProject.Connection...

Hi All I have a form that has 3 combo boxes for the user to enter a date, one each for day, month and year - so far so good. The problem I'm having is trying to pass this date into a query, I have the query criteria as dateValue([forms]![cboDay]&"\"&[forms]![cboMonth]&"\"&[forms]![cboYear])...

Hi All, I've been using DCount to count records in an existing query, however I was finding this to bwe a very slow function and thought I could speed it up using ADO, my code is as below: Function GetRecordCount(TableName As String) As Long Dim rs As New ADODB.Recordset Dim ssql As...

Hi everyone, I'm no expert but a colleague of mine has stated that it's much harder to dump data from an SQL server into Access than to another SQL server, he's prone to trying to baffle people with technobabble so I just wanted to elicit some expert advice as to whether this is true? His...

Hi there, I have 2 tables, table A has a list with a primary key and dates, table B has a list containing a foreign key (to link to table A) with multiple entries for each key with different dates for each. The problem is I need to link table A to table B on key and only pull records from...