Search results

Hi Thanks for your response, I'm using a Make Table query to export a table to another Access database (make a copy of it), the original table has a primary key, but when I run the query the resulting table does not have the primary key This query is run using MS Visual Basic code I've tried...

Hi, Hope someone can help, Is there a way of keeping/setting the primary key when using a make table query? Gezza

Thanks again for your response, sorry I've taken so long to reply, (no excuses). That code stopped the error from occurring but did not delete the record. The "DoCmd.RunCommand acCmdDeleteRecord" does delete the record before I get the error message. Will keep persevering and will post if I...

Here is all the code, I have taken your suggestion and removed unnecessary code, "I inherited the database". Error is still occurring Private Sub btn_ClosefrmAction_Click() On Error GoTo Err_btn_ClosefrmAction_Click Dim DelAction As Integer DelAction = MsgBox("If you EXIT from...

Sorry RainLover, got to many things happening. This is the code, error comes up from the "DoCmd.RunCommand acCmdDeleteRecord" Line CMD is short for "command" DoCmd.SetWarnings False DoCmd.RunCommand acCmdDeleteRecord DoCmd.Echo False DoCmd.Close acForm, "frm_Action" DoCmd.Echo True Gezza

Yes Win7 & Access 2003

Hi I am getting the "No Current Record" on the "DoCmd.RunCommand acCmdDeleteRecord" when I run it the first time, when I run it again it runs without the error message? This is run just before a Close form CMD Hope someone can help Cheers Gezza

Hi, I am trying to allow users to attach a picture file to a 2002 database, to do this I have created an object on the form which the user can Right click, on the Right click a Microsoft drop down box appears and this allows them to browse for the file and attach it. However when the database...

Hi, I need some VBA code that can check if there is a Linked Attachment attached to an object (text box) on a Form. I have tried IsNull() but didn't work, any suggestions will be greatly appriciated Cheers

Hi Pat Hartman, File is not locked in the DOS attributes and macro settings are as low as possible

Hi Pat Hartman, thanks for your response I've tried changing the Trust Centre settings for my own PC but still get the warning, which is:- <Microsoft Access Security Notice A potential security concern has been identified Warning: It is not possible to determine that this content came from a...

Hi, Is it possible to send an email in Access using VBA without using an emailing program like Outlook or Lotus Notes

Hi, I am in the process of upgrading from Access 2003 to 2010 the current databases are split and users run the application in runtime. I have been able to upgrade successfully except for the Security Warning I get when opening the database in runtime. Have tried changing settings in the Trust...

Hi Isskint, Thanks for you help :), That's the solution I was looking for Cheers Gezza

Hi, Is there a way of attaching a hyperlink to the body of an Outlook email using vba code? I have already created code for creating and sending email and have worked out how to add attachments but how to add a hyperlink eludes me Hope someone can help Gezza

Hi hope someone can help, The code below gives a Run-time error 2448 on the highlighted line? Private Sub Form_Open(Cancel As Integer) Dim LastMonthlyReportDate As Date Dim NewMonthlyReportDate As Date Dim LastArchiveDate As Date Forms![frm_HiddenOpen]![txb_NewMonthlyReportDate] =...

Yes the database is split, only tables in the back end, and the front end is only on my machine.

Hi, I have a problem with a Form that takes a long time to load. Its activated by a command button on another Form, there is some vba code in the Form Open event but the delay happens before the vba code is activated, it's like it is waiting for something or doing something in the background...

Hi, I have a database with multible users (20) and if I need to do some changes to the backend I have to get everyone to log out before I can make any changes. Is there a way of killing of the connections? Regards Gezza

Thank you, I have had a play with DSum and have got it working fine Gezza