Search results

Relinking Pass Through Queries through Code Hi all, I have a lot of pass-through queries in a database, the connection string is stored in the properties of the query, does anyone have any code to relink these queries when the database opens? I think querydefs might do it but I haven't come...

Hi SQL_Hell, Thanks for your input, I'll look at a forms solution instead. Regards Melt

Hi SQL_Hell, thanks for the reply & code I'd prefer not to post the trigger code in a public forum. I'm not having a problem with the trigger, it's firing and returning an error to 'odbc sql update' error, my problem is in capturing that error. The problem with form level permissions is that...

OK I got this sorted, I totally forgot about bracketing the names of reserved keywords...so instead of using Currency, I use [Currency] and now it accepts the insert. Thanks for the replies guys. Regards Melt

Hi Brian, It's a DoCmd.RunSQL insert. Putting the Currency field into my sql string below brings up an 'Invalid Sql' error sqlstr = "INSERT INTO SupportContracts" & _ " (DetailsID2, StartDate, EndDate, Expiry, SupportContractValue, Comments, AsAgreedinContract...

Hi all, I have a database and their is a field called 'Currency' in a table (a foreign key to a Currency table). Access is throwing an error when I try to run an insert into this field, (probably because it's a reserved keyword). Short of renaming the field and all the reports it's linked...

The update is happening from the 'inserted' virtual table that is available to the 'instead of' trigger.

hi SQL_Hell, I'm using sql server 2005. It's just a normal access query, however I have a fairly complex validation trigger on the table that either accepts or rejects the update. It's my trigger that is sending back the 'update error' message.

Hi all, How do I capture an error message from SQL server in an MS Access form? I have a trigger on a table in sql server 2005, the user is only allowed to update columns if the locked column has not been set to true. I'm getting an error message back from Sql server when I try to update the...

Hi all, My client wants a 'duplicate order' button so he can use previous orders as a 'template' for new orders. Duplicating the order itself is no problem using a 'Select' query to select the order, and an Append query(based on the select query) to insert the duplicate order. Similarly the...

Wow! that's a great little tool, it works perfectly. Thanks a lot Paul for the heads-up on that. Regards Melt

Hi all, Does anyone know a way to do a find/replace on all queries in an access database? I have table that has an apostrophe in it, and I need to get rid of it and update all queries that might be referencing the old table name. The Find/Replace in access only seems to work on the code in...

I think you're right Bob, I do seem to be stuck in a perpetual loop, but how to break out of it?

Hi Bob, I'm using the controls Before Update event. My code is: Private Sub Invoice_Amt_BeforeUpdate(Cancel As Integer) If ReadSecGrp(CurrentUser) = "Finance" Then Cancel = True Exit Sub End If End Sub Regards melt

Hi all, I'm trying to cancel an update to a control with: Cancel = True ...in the BeforeUpdate event, but for some reason I can't leave the control after I attempt to modify the data, the cursor just remains flashing in the control. Does anyone know what the problem is? Using Access 2007...

Thanks for the replies, missinglinq, thanks for the code, that seems to work fine, much appreciated. Regards Melt

Hi all, The following code will lock all controls on a form, but what I want is to lock all controls on a particular TAB, leaving the controls on other TABs enabled, does anyone know how to do that? Dim c As Control For Each c In Me.Controls c.Locked = True...

Hi all, Does anyone know how to encrypt a password? , I don't mean just seeing asterisks as the user inputs data. It doesn't seem very secure to me if I just hardcode my 'password' into my code, I was looking for something a bit more robust than that. Thanks

Hi Bob, The database would have been created in Access 2003, but it has not been converted, I'm opening in Access 2007 as an mdb. Is there a fix to the problem that you're aware of? Thanks for the reply

Hi all, In Access 2007 I've come accross an error where all the controls on a form suddenly start displaying in bold, click into a control and it goes back to normal. I have to restart my app to fix, has anyone else come accross this? Thanks