Search results

Just a follow-up to say that I'm settling for an interim solution until I learn more about some of the other options. I've created an identical table on a new DB and linked it to the existing web formatted DB. I then setup a macro to run an update, append and delete query that refreshes the...

Hi, I'm working with my first SharePoint linked DB, which is an experience, and noticed that I can't use the 'Create E-mail' facility on the external data tab anymore. The point of the DB is to manage global contacts, which I want to do by providing people with access via SharePoint but also...

Hi Minty, thanks again Just a quick good news/bad news update Good news is that it works perfectly when I run against the table that holds the source data - so I'm really happy that it's working the way you said it should Bad news is that it won't work with the query data One long winded...

Thanks for that I'd actually reached that point and thought I'd gone horribly wrong somewhere The problem at this stage is that the query won't accept the syntax - it returns the following message "The expression you entered contains invalid syntax. You may have entered a comma without a...

Yes, I want them all to receive the same email - the To: field is fine since it'll always be an internal email You're code has worked great but I'm still stuck on adding the email addresses I've had a look at the site you linked but it's beyond me to be honest I have a field called 'E-Mail'...

Thanks for the quick reply Possibly a daft question, but how do I assign the Variable_To so that it takes the entire query list please? Thanks

Hi, I've setup a selection form that returns a specific list of email addresses in a query. What I can't work out is how to press a button and have the email addresses populate the To: field in a blank Outlook email - I don't need any bells or whistles. I thought it would be simple but I'm...

To be honest, because I want to use the crosstabs across a few different queries, labeling the column headings will save me a bunch of time in the long run because I won't need to keep adding to different parameter lists. It just wasn't something I was aware of but wish I had been some time ago...

Yes on both counts I hadn't tried the "()" originally but have now and it didn't work although the result was slightly different If I run the query with the form closed it seems to work. Once I open the form and leave any of the parameter fields empty the query is blank again

Hi vbaInet I'd setup a select query to look at a form combo box. If the parameter matched then it was to return only the related data but if the form was left blank then it should return all data. Simple enough using '[Forms]![FormName]![Field] or [Forms]![FormName]![Field] Is Null' The...

Hi, I'm losing hair over this one so any help would be very welcome. My parameters are linked to a form and say: [Forms]![FormName]![Field] or [Forms]![FormName]![Field] Is Null Ordinarily this works fine in returning either the selected value or all values if left null. I need to pull in...

Thanks for your answer. I created a new button with the macro and that worked but then things got strange. After creating the button I clicked on 2 of the 3 original buttons while logged in as administrator. Nothing unexpected, they always worked with admin rights and continued to do so...

Hi, I've looked in a few places for answer to this but not found the answer yet. I'm running Access 2010 but using an .mdb to maintain user level security. For the most part everything is working as it should. I've rolled out a new version of the DB for 2014 (don't ask, but it is necessary)...

Here's the boot user link mentioned above http://www.datawright.com.au/access_resources/access_tips.htm#tip_boot_users

Thanks for both of your replies. Once I'm out of options I'll probably look into the SysTools suggestion but it just feels like I'm missing something really simple, possibly even obvious. An older test version of the same database (also running on 2010 as a 2003 .mdb and using the same...

Hello, I'm trying to pull data into Excel 2010 from Access 2010 (running as a 2003 .mdb), which works fine on all but one database and I can't find the reason. On every other .mdb or .accdb I use I can link up via the wizard easily but this specific database makes a Data Link Properties window...

Perfect!!! Works like a charm...thanks very much!

I've just come accross a problem where pasted data dissapears from view. It's caused by people being a bit careless and copying the line above (from word or notepad for example), which adds a return and then the data drops out of view. I really want to create a validation rule to make it...

Thank you for your answers. I've tried them both and they work great. In the end I went with Alansidman's suggestion because it means I can quickly boot people out and do what I need to when I'm pressed for time. Thanks again, very helpful.

Thanks pr2-eugin, I'll look into that too :)