Search results

Thanks Bob. I thought I lost it for sure!!! Don

Bob, I can't find the drop down as you suggested. If you look at the first post in this thread, you will see that I changed the title but it doesn't show up anywhere else. I know I'm a little bit thick at times but this one has me puzzled. I even looked at one of my other posts but no drop down...

Thanks to both of you for your thoughts and a bit of education for me.:) The program I described will only be run about once every 2 weeks so speed is not a requirement. The program that that one will be incorporated into will run possibly on a daily basis and has about 8 queries that I am not...

Re: Form Focus???? Solved Thanks John, That's what I was going to try next until I read vbaInet's suggestion. I increased the timer to 5000 and it worked great. I cranked it back to 2000 and that seems about right. I just had a gut feeling that the timer should work but was dissapointed when...

Hello to all, I have a program that downloads info from the internet, imports it into Access, massages the info and then builds tables that are used in a different program. This program has one(1) form and about a half dozen queries. I recently moved the SQL for the queries to the Visual Basic...

John and vbaInet, Thanks for your help and suggestions. John, Your idea works fine but as you said, it's a little dirty. The message box opens all by its lonesome on the desktop. Once acknowledged, the input form opens and works as it should. Maybe I can find a way to pretty up the message...

vbaInet, I never uploaded anything before. Hope it works. I'm starting this program from a shortcut on my desktop.

Hello to all, I think we are getting a little off track with this so let's forget all the previous conversation and let me re-explain my problem. I have one(1) form with one(1) textbox for input. I would like to: 1. Open the form when the program starts. 2. Close or minimize the Access app and...

vbaInet, I tried as you suggested, using the full reference, but that didn't work either. Your analogy has me a little confused. Me is the form that has the controls and the code is being run from. They are one in the same. Getting focus to the textbox does not appear to be a problem since the...

Thanks for the quick responce. John, I don't know how to set explicit in a Sub. :confused: I did add Option Explicit at the top of the page but that didn't help. Same results. vbaInet, Good to hear from you again. Here's the code: [Private Sub Form_Open(Cancel As Integer) DoCmd.RunCommand...

OK, I give up! I have a very simple program. 2 tables and 1 form. The form is used to look up and display data from the tables. I set the form up to be a popup and I minimize the Access database with [DoCmd.RunCommand acCmdAppMinimize]. I also set the focus to the input textbox since it is the...

Louis, Glad to hear that you are making progress. I've never used a switchboard so I don't know how it is being called to open. If it's like other forms try adding "DoCmd.Maximize" in the code. Don

Louis, Maybe you're calling that form from the "Startup" menu and that's why you can't find it in an autoexec file. Look under Tools-->Startup. It's worth a try. Don :)

Welcome to the forum yogev. When I'm not sure where to post something I use the General portion of the forum. If that's not the correct place, I'm sure someone will let you (or me) know about it. I asked a similiar question some time ago. Maybe after you post your question I'll be able to...

Louis, Take a look in the Code Repository. I saw a couple of posts in there about Bold Message and MyMsgBox that may be of some help to you. If you browse enough, you can find just about anything you need on here. Good luck. :) Don

Vassago, Thanks for the reply. I did a lot of reading on the forum before I posted the question. I didn't want to ask a question that had an answer in plain sight!!! Thanks again, I can quit looking for an answer. :) Don

Mark a Thread as "Solved" - SOLVED Hello everyone, How can I mark my Thread as "Solved" or somehow show that my question has been answered by looking at the Thread in the category listing. I found an answer to my own question and posted it in my thread. The problem is that when you look ay my...

Re: Move or copy a "file" to a web site-SOLVED Hello to all, I finally found a way to do this with just 4 lines of code. Impossible, you say. Well here it is: First, you need to set up an FTP account on your website and set the path to the directory where you want to place your file. Probably...

Thanks spikepl for the reply. Your method sounds like it has merit and may work but injects another bit of code outside of Access. I would like for all of this to happen within the Access/VB database if possible. One mdb file to contend with. I failed to mention that the website is mine if that...

Move or copy a "file" to a web site-SOLVED Hello everyone,:) I'm back again with another problem.:confused: Not sure where to post this, so I'll try here first. I would like to copy a table from my Access Database on my hard drive to an Access Database on a website using VBA coding. Or just...