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'...
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)...
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...