Search results

Multiple people can change a given Report?

Just as a side note, I know when i have done this in the past, You need your row source on your third box to be a combination of the first two. Otherwise you will populate all data where condition 2 is true. But really what you want is for condition 1 and condition 2 to be true.

I think that's probably more SQL and web based. You can create web based applications using Access, but i think to track changes (and i could be wrong here) it would be a very complicated manner, one that probably wouldn't be justified for "interm" solutions.

Outlook is an email client, if you want a template, Create a distribution list in outlook, and send a word attachment to all recipients. Get them to fill out out and return as attachment. I fail to see how this is a database related question. (Should probably make myself clear, not trying to be...

(Sorry, didn't mean to Hijack this thread)

I did know that, noticed it once when i was playing with a front end i was working on. I guess it just never mattered to me because once my front ends are created that means my backends are also created and therefor i really don't care if it's locked because i wont be changing the design of the...

to be honnest, i've never come accorss that issue.. I had no idea that you could view them all in the lockfile with notepad, that's neat. I personally don't worry too much about it because my front ends are stored locally

I use the Explorer, and just look at the owner of the lock file... Would that yield the same results? I've never used the notepad method.

I have been informed that you can open a database exclusivly using the command line DatabaseName and "/excl"

To make your life faster you could do a search and replace on your forms... Seach for the docmd.close and replace it with SOS's... (??) code

GREAT! well that makes me feel better.. Nice to know it wasn't all a waste of effort. I did see an auto update package, but i decided to go about it myself, thought the experience and learning would be beneficial (i like to know how stuff works) Thanks guys!

Hey Everyone, I have created a Database on our network. Now I know that people can open the database front end right on a network share without a problem. And call me crazy but i just prefer that the front end database be stored on a user's local machine. So i created a method that, on open...

Could you not just set the focus back onto the form once the message box has been closed? Msgbox Setfocus close command, or query or whatever.

I think this site will give you what you want.. more or less. http://www.vadriano.com/excel-vb/2007/04/12/how-to-open-excel-files-in-a-new-application-instance/

The only thing i will add is, I agree that you should reformat the drive and start fresh, nothing worse than working on someone else's problem where you have no idea what they did. Secondly, I did have a similar situation where i was not able to access my BIOS and the only solution for me was to...

No Problem at all, glad i was able to help you.

The only other thing i can think of is that your control is not named attachmentfld. I believe this error can be caused if you get the name wrong. use me.attachmentfld just to make sure you don't have a typo

Have you ever stepped through code? I would recomend trying it. place a stop at the start of that if statement and see if it actually goes into the 'do nothing Or if it see's it as ELSE it might be a case of the field not actually being null but rather "" in which case you would want to also...

If you have a calendar, then i would simply add to the code to get it to add the value to both fields at the same time. me.startdate = calendar1 me.revisedstartdate = calendar1 or something to that nature.. but I don't know what a "pop up" calendar is. i've only ever used the calendar control...

leave it blank. or do as i did, and just put a comment that says do nothing. Just as a note for VBA inase you are not familure, Comments turn green and are marked with a ' the are NOT part of the code execution, they are designed so that programmers can comment their code and save hundereds of...