Search results

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

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, 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, 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] =...

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

Hi, I need to write a query that will give me an accumulative total for each day of the month. Can this be done? I know it can be done in MSExcel so I assume it can be in Access, but I don't know how. Gezza

I have a graph the looks fine when I view it as a report but when I go to Disign View all I get is a blank square the graph is there but I can see it, which means I cannot edit it. Can anyone help Thanks Gezza

I have a need to be able to change Printer settings, specifically the Page Size, using VBA code. These are not standard Page Sizes but specific to a Sticky Label Printers attached to multible computers. Is this possible? And if so how. I have seen some code that nominates a specific printer...

Hi, I have a form that on closing comes up with a input box asking for "Enter Parameter Value" for a combobox on the form. How can I stop this from happening?

Hi All, Is there some code that can select all Check Boxes in a table as Checked or Unchecked at the same time?

Hi, Can anyone give me some code that changes Report Page Size settings in VBA code Thanks

Hi, I have a Crosstab query that gives me the message "The Microsoft Jet database does not recognize '[Forms]![frmMachineReports]![cmb_Machine_ID]' as a valid field or expression.". But if I type the criteria directly into the criteria field, the query works fine. Have I done something wrong?

Hi, I have several reports that print to a special label printer that is not set as the default printer. I wish to automaticly set the print settings to the label printer for when I need to print to it but not change the system default printer. Basiclly select the printer and the paper size...

Hi All, I am getting the error when I compile the database I have tried selecting the Microsoft DAO 3.6 Object Library in User references but this has not worked Hope someone can help,

Hi I would like to automatically send a report by Email through Lotus Notes. Depending on certain criteria if possible. Can anyone help?