Search results

I've been googling this for days and everybody says me.move 0,0 should work in a form_load event, but IT DOES NOT WORK. Private Sub Form_Load() Me.Move 100, 100 End Sub Everybody seems to think that this is an easy way to move a form to a fixed screen position on load, but when I try to do...

Don't know if anyone but me will find this useful but I had to write a function to calculate what the third Wednesday of the month of a date argument is. For example, if the argValue=8/2/07, the function returns the date of the third Wed of August, which is 8/15/07. Function thirdWedofMonth(dte...

Don't know if anybody but me will find this useful, but here it is. You can change it to any weekday on any interval by changing the values 15-21. (The logic is based on the fact that the third Wed of every month must necessarily be between the 15th and 21st inclusive.) Function...

Hi all...trying to add functionality to my custom browser to link directly to the results of a serach in this very forum's search page. For some reason it's not working, I am thinking it's either because it's PHP code, or because the target input field has an illegal name. My form that has the...

Hi again all! I have a form in Access with an ActiveX WebBrowser control in it. What I want is for the user to select some text within the browser, and for that text to be captured in a string variable. I've been scouring the web all day for a clue as to how to do this, and this is all I could...

Hi again all! Before I ask my question let me just say you folks have always been kind and helpful, and I appreciate your time. I did search this site and several others via google and I found some progressbar code that I Frankensteined onto my own Access project. It works...the problem is the...

Hello all! I'm working on a project that integrates an Access database with several Word "templates" via mail merge. I've worked most of the kinks out, but I have a few loose ends that I was hoping someone would be able to assist with please? Right now, there is a form in access with 9 command...

I have a large macro that calls a bunch of queries, and somewhere in the middle I need to put a piece of VBA code that is stored in a module. So my macro looks like this: openQuery openQuery openQuery openQuery openModule openQuery openQuery openQuery The module is a blend of select and action...

Does anybody see anything wrong with this Update query please? mySQL2="UPDATE Interp rates SET Interp Rates.Next Rate=nextrate WHERE (((F1)='ZAR')and (isnull(F5)=True))" (The table is [Interp Rates], the field I want to update is [Next Rate], and the set is any record where [F5] is Null and...

OK I think this should be working, and I can't figure out why it isn't, maybe someone can see what I am missing here please? What I am trying to do is isolate chunks of a table, and use each chunk as a recordset and do some rs.movelast, next, etc manipulations. I have a string array variable set...

Hi Folks, I have a problem I've been mulling over, and I thought I'd just post it here and see if maybe someone has already gone through this and might be able to tell me what I am missing. I have an access database that contains a table of currency rates by forward date. So for example, there...

Hello all, I'm new to the site, hoping someone familiar with both continuous subforms and option groups could give me a hand please? I have a "dialog window"-type form with a subform in it. The subforms are in continuous mode, and I have a scrolling window in my main form that contains one...