Search results

sri I should add, I tried putting a /excl switch at the end but it says I don't have permission to open it for exclusive access

ok I'm back !! While I can now open the database, unfortunately it won't let me make changes to it as it keeps saying I don't have exclusive access to it. How do I get around that? I noticed the same thing happens when I am onsite even if I make sure no-one else has it opened? tks

Thank you so much that worked beautifully !!

Thanks for that I'll give it a go. I'm usually really good at searching and have found most of my answers that way, but for this one I didn't really know how to search cos I wasn't sure how it would be worded !:) tks

ok I shouldn't have been so hasty in my reply ! how do I create a shortcut? I tried creating a shortcut on the desktop and then just changing the target path to your suggestion above (with my parameters) but it says it's not valid and won't allow me? Did you mean something else by a shortcut? tks

Great I'll try that thanks !:)

That subject line probably doesn't really explain it ! I am doing some support for a database that has group level security (I can do the support and make the changes they want but I'm not so hot on the security side of it !:o Anyway when I'm in the office that's fine, but when I want to work...

I'm going to go on site on monday so I'll have a look then, what do I do with the MDW file? Do I take that as well? if you can give me the steps I need to make a local copy on my laptop that would be great thanks, I'm not familiar with the whole security and network side of things, so need to...

HI I'm doing some support for a company who's access is on a network. I think it must have been setup so that their login to the network determines whether they can access it or not, although it still asks for a username and password. Anyway I have a local copy of the database and a username...

That works perfectly many tks ! BUT!! I noticed it throws up another issue (that mightn't actually be an issue) but some of them don't have any emails at all !! (grr -imagine !) anyway it means just a ; is returned which may cause a problem with the email sending anyway is there a way to say if...

I have two email addresses in a table one personal and one work and a question asking which to use, I have a query running from the table and have an IIF expression creating a field which looks to see which one to use (that all works fine !) anyway my client has now asked for an extra field in...

OK I have read through I think every post with the word email in the title ! and in the subject... and tried various bits of code that were posted, but can't get anything to work... :mad: Here is what I want to do. I have a form (based on a qry called "QryInvoices Due") which brings up a...

Ok I got it ! Just needed square brackets around the field names ! just in case anyone else needs this info ! :)

Ok I'm back it's not working for me ! I keep getting an invalid syntax error saying I may have entered an operand without an operator. I've tried playing around with it and adding [ ] brackets at various places, but then it seems to think it's a parameter query and looks for more info? cld the...

Thanks Nad I think thats exactly what I was looking for I'll give it a go ! rgds

Hi, I am working on printing a letter from a table of contacts. (it will be a report) The contacts have 2 addresses each, home and work and a field which states which one to use for their postal address (e.g postal addr: work) Here is my question. Obviously I want to print the correct addr on...

Thanks Thanks Pat once I know there is a solution of some kind I can search further, I just didn't know if this was something that cld be done rgds

Ok this might be a really stupid question, but in the quest to always make my life a little bit easier thought i would ask ! I have been asked to find the relationship between a number of tables and queries, so that this company can find out which tables and fields in tables are no longer...