Search results

The assignment of data is within another block of code: If !RACFException = 0 Then j = j + 1 mudtOutputRowsMatched.Count = mudtOutputRowsMatched.Count + 1 ReDim Preserve mudtOutputRowsMatched.OutputRow(j) mudtOutputRowsMatched.OutputRow(j - 1).FullName = !FullName...

I have a User Defined Type which stores an array.. I have 2 instances of this UDT, one storing matched data, the other storing exception data I was to parse these arrays to an Excel output routine. However, the parameter variable contains no data when accessing it.. Here is my code: UDT...

Still struggling with this... anyone else have ideas ? ETA, didnt realise you had responded again as it rolled over to 2nd page vbaInet... I've been looking at this example... http://swansonsoftware.com/acme/default.asp I'll spend a bit more time on this now and post with my findings...

you fixed this yet bloke ?

Hi tried this example... this is my code (DAO).. still get the error .Edit !Access = txtAccess.value strPermissionString = Trim(txtPermissionString.value) !Dataset = cboDataset.value .Fields("PermissionString").AppendChunk strPermissionString !Hash =...

DAO code... Private Function mblnSaveRecordDAO() As Boolean On Error GoTo PROC_ERR Dim blnReturn As Boolean Dim db As DAO.Database Dim objRst As DAO.Recordset Dim strSQL As String Dim strPermissionString As String Set db = CurrentDb strSQL = ""...

Tried altering the ADO code as suggested... Still same error.. Private Function mblnSaveRecord() As Boolean On Error GoTo PROC_ERR Dim blnReturn As Boolean Dim objConn As ADODB.Connection Dim objRst As New ADODB.Recordset Dim strSQL As String Dim...

'frmProfiles' (Continuous Form) bound to the following SQL: SELECT Dataset, ArchivedDate, ProfileID, PermissionString, Access, Hash, IIf(IsNull([Archiveddate]),0,1) AS Archived FROM ProfileMapping ORDER BY Dataset, ArchivedDate, Access; Edit button on 'frmProfiles' opens...

I've changed the code to use DAO but still have a similar problem.. ERROR: 3188 Could not update; currently locked by another session on this machine. Error is strange as I'm running this on my C Drive.. I've checked the properties on the continuous form as mentioned above... Recordset Type...

Never used this method.. Quite a messy way of doing things and would have to be rewritten if splitting data out to a seperate data file (we dont do linked tables here as network performance is so bad).. Also need to handle apostraphes etc... Tried this initally.. Didnt work hence trying...

In my dataset which lists configurations, some records contain up to 6000 character configuration strings in a Memo field (named 'PermissionString'). The Memo string is hashed and saved to another field for joining to other tables. The configurations are displayed on a continuous form with all...

I work as a developer for a large corporate co.. We have moved to a Citrix environment, so the users run a standard build, everyone running Windows 7 64 bit.. The infrastructure team are looking to roll out either Office 2010 or 2013.. I'm yet to find out if this will be 32 or 64 bit.. I...

Thanks for the link.. All of the databases here have been built this way, mainly for performance reasons as the network/ fileserver performance is a real issue. We dont have the option of putting these on SQL Server atm..

How would i go about doing this? I've done some basic work with arrays.. writing array data to form list objects.. I have no idea how to use an array as a data source for a report? Would i need to create a recordset and populate it with the array, then bind the report to it ? Anyone got...

I'm really confused with this.. I have two queries, both delete from the same table and both have joins... This one works: DELETE RequestCheck.* FROM( SELECT TOP 3 PayRequest.RequestID, PayRequest.GBPAmount, PayRequest.Currency, PayRequest.RequestDate FROM PayRequest WHERE...

Yes, this only just clicked after I posted it.. As the DB engine cannot guarantee returning the same 3 records each time the SQL is run, so needs further criteria..

Its just occurred to me that the problem is caused by the ORDER statement.. If i RequestID to the ORDER statement it works fine.. The SQL now looks like this.. SELECT TOP 3 RequestID, GBPAmount, Currency, RequestDate FROM PayRequest WHERE Currency="CAD Canadian Dollar" AND...

Hi Guys I'm a bit confused by this.. My statement below is current returning 4 records. Two of the records have the same GBPAmount value. RequestID is the Primary Key SELECT TOP 3 RequestID, GBPAmount, Currency, RequestDate FROM PayRequest WHERE (((Currency)="CAD Canadian Dollar") AND...

If you create a config table in the back end with a bit field named 'GetOut', that you can edit manually. Build the app so that the forms check this flag every minute or so using the Form_Timer() event. Build in some code that checks the flag, and closes the users front end within a few...

+1 Your system is working.. there is no need to change it..