Search results

Thanks Nidge Me!BulkAttachment.Value - worked a treat... Cheers Dave

The 'find file' function is a standard function used in the form - Me!BulkAttachment = tsGetFileFromUser() The function opens a dialog window where the user selects a file and then it assigns the filepath and name to a control on the form. Another button on the form collects the email...

Hi Michael, Thanks for the response. The error message is - This object does not support this property or method. The string is valid - "C:\User\George\Documents\File.doc" If I replace the reference to the control BulkAttachment with - .Attachments.Add "C:\User\George\Documents\File.doc"...

Hi all, I'm using a piece of code to open a dialog window to find a file and then add it to field on a form where the file will be attached to an email and sent out automatically. The code - If Not IsNothing(MySet![email]) Then Mailcount = Mailcount + 1 Set appOutLook =...

Thanks Spikepl, Worked a treat... Dave

Hi All, I have a report with an address block consisting of 5 controls (street,area,town,county,postcode). It has to be positioned correctly for a windowed envelope which in itself is relatively easy. My problem is I have a piece of code to shift the controls town, county and postcode up if...

Thanks for that Bob, but I was hoping to find out how to set background colours for text boxes etc...from VBA... There must be a way of setting white as a background colour as I managed to set it red using 255 If you set the Back Color on the property sheet for the control to #FFFFFF then it's...

Hi All, I tried to use this on an AfterUpdate on a textbox Control - If A>B Then Me!Control.BackColor=255 Else Me!Control.Backcolor=#FFFFFF End If I want it the background to red if A>B and to remain white otherwise but all I get is a black background when it should be white. I...

In Windows 7, Windows explorer I found that by right-mouse clicking on the folderpath at the top of the window and looking at the different options available, you can eventually see the full pathname... Hope that helps Dave

Well, the compile worked this time...found a better command line that worked properly. C:\program Files (x86)\Microsoft Office\office14\msaccess.exe /decompile C:\dbfilepathname\filename.accdb Have now copied this command to a Word doc to use until MS sort out the bug. Happy Days

Has anyone else experienced their database close normally but fail to open with a "MS is unable to open" message? I can export all of the reports, tables and queries into another blank db but forms and modules hang. If I open the db in design mode, all's well until I try to open any code then it...

Talking of buggy...has anyone noticed how the text labels don't line up with the text boxes in the 2010 version?

Hi RuralGuy, Yes, tried that. Had to re-install access to get this to work, in the end. This is the most buggy version of Access I've ever worked on... Thanks for replying... Dave

Has anybody had this problem with Requery? I have used this so many times in databases and had no problem, but in Access 2010, apart from other buggy issues, the requery won't work properly. This is what's its doing - 1. Open Main form with subform containg records in continuous form. 2...

Ok, I have code that is supposed to check for changed in a text box called 'Member' and apply a continuously updating filter to to a sub form... the code is - OnChange - Forms!AAA!AAASub.Form.Filter = "[Surname] Like " & Chr(34) & Me!Member & "*" & Chr(34) Forms!AAA!AAASub.Form.FilterOn =...

I have done this before by selecting the record from the table and copying (Ctrl-C) and then opening the other Db and highlighting the empty field at the bottom of the required table and pasting (Ctrl-V). This, of course, assumes that the tables are identical in fieldnames and structure. If...

Hi Petros, I use Outlook to send record(s) from Access by using the SendObject command. (Using Access 2003) Create your message by using lines like... MsgStr = "Report No: " & Me!rptNo & Chr$(13) & Chr$(10) MsgStr = MsgStr & "Report Date: " & Me!RptDate & Chr$(13) & Chr$(10) MsgStr = MsgStr &...

Hi All, Scroll bar in a sub form showing up to 30 records... When the receord list holds 30+ records the vertical scroll (wheel mouse control) works fine but when the list holds less than 30 records the wheel mouse will scroll but loses the top record form view and won't scroll it back. The...

Hi ByteMyzer, Worked fine... thanks for the prompt response - much appreciated Dave

Hi ByteMyzer, So if the Editmessage option is true the email opens for editing... I'll try that Thanks very much for the help Dave