Search results

To follow up: Set myShell = CreateObject("Shell.Application") If strUser <> "" Then strConnect = strUser & ":" & strPassword & "@" Set ftpList = myShell.NameSpace("FTP://" & strConnect & strFTPLocation).Items I have only listed the problem lines. This vba code works correctly, downloading a...

I have spent several days trying unsuccessfully to make this work, and have run out of ideas. When I single-step and check values, myFolderItem.name shows <Object variable or With block variable not set>, and therefore MyFiles remains = "". Private Sub Command62_Click() Dim myFolderItem As...

arnelgp, I am still getting the run-time error 91. I have added Microsoft Shell Controls and Automation to my references, which made no difference.

Struggling here. I am getting Runtime error 91 on the code line: Set ftpList = myShell.Namespace("FTP://" & strConnect & strFTPLocation).Items If I get past this point, I will have a few other questions, but first things first! Thanks

My db's files are mysql files housed at my website. Is there a way to upload pdf files and open them from a form in the db? Or, if I uploaded the pdfs into a folder in the website, is it possible to open them from the db? If so, how do I get the url for the uploaded file? The only way I have...

Oh dear! hope your phone gets well soon! Thanks for the suggestion--now that my code is working I think I won't touch it again for fear of breaking it. Have a good day!

I just commented out the if-end if lines and retyped them below and all works! Thanks for looking at it. 'Tis a mystery.

Yes, both i and k are defined as integers.

Well, I thought it was simple! The following code throws a compile error. I have deleted it, reentered it, done compact and repair, etc., and finally imported the whole thing into a new db. What am I doing wrong? Me.[piecework subform].SetFocus DoCmd.GoToRecord , , acLast...

So simple! Why didn't I think of that? Thanks so much.

I have already tried that--just didn't like the way it looked. I guess I will have to settle for that. Thanks for answering.

Is there a way to move/keep the subform's scroll bar to the bottom so the most recent records are visible?

When I rewrote it in vba I was able to remove the filter, and that let me goto a new record. Thanks.

I did that, after which I was unable to goto new record because it kept remembering the filter. Think it is a bug in 2010 (read that somewhere as I was researching). Even if I closed the form and reopened it, it always used the filter. I am now in the process of trying to rewrite this very old...

This shouldn't be this hard! Using a macro, how can I find and change a specific record in a hidden form? Each record has a unique line number that will be the search criteria. Thanks!

I have a split payroll db. Both front end and back end are passworded. Works fine. Now, I have created an input only db as a .accde with all menus, etc. hidden, but which adds their input data to the passworded backend. I don't want these users to know the password for the full program. Is...

AutoCenter No, AutoResize Yes (I checked these settings with settings in your demo), and popup and modal both no. It is called with: DoCmd.OpenForm stDocName, , , stLinkCriteria. What I have done with the many other forms in the application is to open a background form maximized followed by...

I have done as you suggested. The form in question (frmpwrk) is opened by click of a button on the main menu form. I changed the call to gfncCenterForm(Me) to the OnFocus event of frmpwrk, since OnOpen didn't get the job done. It opens maximized. I added a button to center it like in your...

Oh, wow, HiTechCoach! This is exactly what I need if I can get it to work. I called the function in onLoad, then tried it in the OnOpen Sub (Call gfncCenterForm(Me)). It opens the form to its original design size (obviously what I wanted) but doesn't center it. It also unmaximizes the...

I surely do wish I had never embarked on a rewrite! I decided I must be better writing Access now than I was back before the turn of the century when this db was written, that after I made a requested change and got it working, I would make it more professional looking. Bad idea! In order to...