Search results

Damn, that's awesome! Thanks so much!

What is the "old method" that you're referring to?

Well, that was an adventure! I used the wonderful examples provided, but ultimately because of the expression I used in the filepath I found it unworkable. In the end I decided to just rewrite the 20 or so Saved Exports to VBA. I spent much more time trying to get it to work than if I had...

Thank you all for your help. I have a follow-up question that is related, but not identical to the first. In my original post I stated this. "I have a reference in VBA, for example to "C:\Data\BoatForm.pdf" I have changed that text in VBA code to read...

I just HATE it when the solution is so simple! I can do the replace from there and be done in two minutes! Thank you sooooo much!

I have a long established database and the users all log into their Access copy on their own C:\ drives. The company is moving and is going to a 100% remote access format. There will be no "office" per se, and the logins will be established through hosted servers on a private cloud. One of the...

Mark and dbguy, thank you both for your input. Right now I'm just gonna focus on the solution isladogs offered and install the tool. I'm hopeful that's all I'll need. Regardless I really appreciate the input.

thank you isladogs. That is a really awesome tool and it may be the answer to my prayers. I'm gonna download and install it and see how it goes. I'll let you know in a week or so whether it has solved my problem. Thanks again.

To all you brainiacs out there this may not be a difficult thing to resolve, but it's got me pulling out what little hair I have left. Starting at the beginning, I have an Access 2007 DB front end running on SQL Server 2016 back end with about 20 users. Some have Win7 and others Win10 on...

jdraw, thank you very much for all the threads you linked. I read through them all and actually responded to one of them because I thought that a solution I had come up with might help someone else. Old thread, I know, but ya never know... The thing is, I already have an assignment list...

Thank you but it doesn't solve the real problem I'm puzzling over. I really would like to use a simple DLookup expression and use the int result as the name of a TempVar. My objective is to look up that WebID number 12345 and create a TempVars!12345 from it. I really appreciate your code but...

It's interesting. I used a simple macro with a SetTempVar event. I put =UserName() into the name field and it works fine. TempVars!MyUserName works perfectly. Then I tried ="My"& "Var". Again, TempVars!MyVar works as expected. However, if I try =6+3, TempVars!9 fails, as does just a simple...

OK, I'll try to be clear. When a record appears in the holding table, I'm creating a process which automatically assigns that record by moving through a list of available processors, call them Joe, Tom, and Sally. So Joe's up first, but he's doing something else and can't handle the new...

I have a table that is constantly changing values. It's just a holding table for incoming things until they are dealt with, and then they are deleted, so there's only a few items in it at any given time. One of the fields is a unique value called WebID, and I would like to create a TempVar...

I want to thank all of you for your help. In the end, I settled on a very simple solution. The OnOpen event starts a timer, and the OnTimer event closes the form. I can leave the form visible for any length of time I choose and just have it go away. It may not be elegant, but it serves the...

I've got news for you. It's not something I've ever considered in the past, either, and I've been playing this game since 1995! It's sorta like losing your virginity. It's scary the first time but after a while you get the hang of it.

Thank you all for your replies and help. I agree about popups. They can be annoying and distracting, but that's the way they want it done. I'm going to experiment with the different methods offered and try to decide which is most effective. No one responded to my own suggestion of identical...

Yes. In my earlier post I explained that I want to be able to programmatically close specific messages, and only a form will allow that.

I understand your point and I can see the validity of the reasoning you offer. As I'm thinking about this during this discussion I think I may have come up with a simple and clean way to accomplish what I want. I'd like to bounce it off all of you for your consideration and comments. Suppose...

Every work station is running the full version of Access 2007. We have no runtime environment. And you will see that the compact/repair is not an issue for us. I am constantly working on/improving the database. I work in my own copy, and when I've finished adding some new feature I compact...