Search results

Thanks David I was concerned I would lose the relationships, but of course, they are now in the Back End !! Cheers :D

Thanks David I split the database & then applied a password to the BE, I went & opened the FE & went to 'External Data' & selected 'Access' & selected 'link to datasource by creating a linked table'. The wizard then links all the tables & adds '1' to the table name - I then deleted the...

Hi As 2007 Access doesn't have user level security, I've applied a simple password entry form for the User to access the Front end, the code looks at a table for the Username & checks the password matches the password entry. Problem is when I apply password encryption to the Back End, the...

Thanks JANR but I've already seen this & it doesn't provide the Reference Library required for WNetGetUser, only Mprdll which isn't what I need. I have another db where the below code works OK & I have made sure all the same libraries are selected except for one which is a part of SP4. I'm...

Hi I'm getting a 'Sub or Function not defined' error when the MS Access 2007 code comes across 'WNetGetUser'. I'm trying to out why this happens as I believe it's because the Reference Library isn't available to it. I can't work out though which library is required, any suggests??

Thanks thingssocomplex !! I removed the declarations & set statements & added your code & it worked well. If I wanted to display the mail before I send it - is there such a thing like 'DisplayMail' ??

Yes, vers 12 Outlook Library is checked. With the below declarations, I'm getting the 'Object variable or With block variable not set' error from the 'Set' line; ----------------------------------- Dim OutApp As Outlook.Application Dim OutMail As Outlook.MailItem Set OutMail =...

A bit more info, if I run the examples as they appear in Ron Debruins worksheets, I also get the file attached as an image. Can anyone try to run one to see why I'm getting this result when the attachment should appear as a file? Thanks

Thanks but that's where I got this example. It works but attaches an image & you can't click on the Excel icon & open the file. Ideally, I'd like to see a working example & the code that supports it in Excel 2007.

Hi I want to attach an Excel spreadsheet to an Outlook e-mail & the below code works OK, only I find it attaches an image of the Excel icon instead of the file itself. Looking around, I've found 2 methods to attach a file, 'AddAttachment' & 'Attachment.Add - which one is correct or is there...

Hi I have the below code taken from the examples db on this forum to perform a Mail Merge with a saved Word doc. It's throwing an error as it tries to find the Word doc for the 'oMainDoc' variable. I've checked the ref libraries & used a 2003, a 2007 docx & also a 2007 standard Word doc...

Hi Laxster Can you post an example?

Hi Coldsteel Can you post an example of the Excel spreadsheet & also the data that comes into it from Access? Are the field headings coming from Access exactly the same? Also, is the date formatting exactly the same as the date format in Excel - ie; no hours/mins/secs after the date etc...

Hi prabhu I'm using Office 2003 & I created a chart with just over 2 weeks of data in daily intervals. I then right clicked on the 'X' axis to open 'Format Axis' & changed the 'Major' & Minor Unit' value to 7 under the 'Scale' tab. This changed the daily values to weekly intervals. Could...

Thanks vbaInet - once again

Re: Adding names to a mailusing Outlook No problem :D

Re: Adding names to a mailusing Outlook Hi Smudger1803 Try this code which is based on a query you create that gives the e-mail addresses for the people you want to send to. You can add the subject line, the body & add an attachment also if you need. ---------------------------------...

Why don't you use Excel VBA to run your 'query' & export the file - I'm not sure how you would bring a query from Access to to an Excel file?

Hi Access9001 I'm not totally clear what you mean but will this help? Use the Transfer spreadsheet method from Access to move the query results to Excel - using vba. DoCmd.TransferSpreadsheet acImport, 3, _ "Access_Query","C:\Location_of_Excel_file", True, "Range you want to paste to...

Just thought I'd ask if 'Wrap text' is enabled & Row 409 happens to have a lot of text in it?