Search results

Both Spikepl and plog are pointing you to the right direction. In short – they are asking you to first analyse the available data, and see if you can work our some pattern/correlation/algorithm. I want to add to the suggestion that: if by magic somehow you can get hold of a large bunch of old...

Hi ulieq, As you can see from the sample code, the variable f.SelectedItems(i) contains the file path. You simply assign that to a text box. me!myTextbox1 = f.SelectedItems(i)

Hi ulieq, You need to put the code inside, in between the "Private Sub" and "End Sub" of a button's code. It should work. Please try again and report back. Shadow9449: from http://stackoverflow.com/questions/1091484/how-to-show-open-file-dialog-in-access-2007-vba

Hi Cliftonx, Sorry to hijack the thread - I've just answered a similar question in a thread with sample code which might come in handy for you. http://www.access-programmers.co.uk/forums/showthread.php?t=217340 Greetings to Bob.

Hi shadow9449, Thanks for looking up and pointing out the possible issue. According to the links in my post, FileDialog works for 2007 runtime - although I cannot vouch for it (be it 2007 or 2010) as I haven't tried it myself. So in most cases the code should work. Your mileage may vary. :)

Hi ulieq and dferreira, Thanks for bumping the thread. Apology for my absence. I've done some revision recently, and there is actually an elegant way to do it. The following is known with work in in Access 2007 and 2010. Put the following code under an onClick event of a button. Dim f As...

Hi guys, I was following another thread about sending email in Access/VBA and someone quoted using this:- http://www.freevbcode.com/ShowCode.asp?ID=109 I haven't tried it personally but it looks feasible and neater if it works.

Hi SDK, This is a promising one using Microsoft WIA. Most newer scanners/cameras have WIA drivers, so if you figure out how to use this, you can control all those devices. http://www.access-programmers.co.uk/forums/showthread.php?p=841207 If you need to add the library reference in the...

Hi sseto23! Great to have the news and it has worked! Thanks for the feedback and we are glad to help! Now you deserve to have another vacation. :D I would like to thank vbaInet, gemma-the-husky, CBrighton and spikepl who also gave their input to this topic.

Hi Gary, I am glad to hear that your perseverance has given you a result. Don't worry that the code is getting heavier, that's normal for a professional app. Your Access VBA "Kung-fu" has reached a high plateau of enlightenment! Treat yourself a good pint of beer for making it so far, and...

Hi Gary, Nice to know that you are willing to give it a go. Yes basically you are picking up the source data a row at a time, perform a calculation and add it to the destination. The idea is to use a single loop, moving the source dataset one record at a time using rsQuotes.Movenext. Sorry...

Hi sseto23, Hope you enjoyed your vacation! Your plan using the macros all seems fine. Nothing is overkill. The initvar() is not such a big deal as long as it is called beforehand. Frankly it *can* be called multiple times and its not an issue. If you wish to just call it once like you have...

Hi sseto23 Nice to see you are back. You can call the InitVar() when the print report button is pushed (but before the date calculation begins) In fact you can call it anywhere (say at the switchboard). As long as you call it at least once, and after that you can then run your calculations.

You are welcome - we are all here to help! :D I was tearing my hair out using comdlg32.dll before, using the MS Office File Dialog is much easier. Come back here if you have any problems.

OK, I've done a bit more research into parametric queries http://forums.devarticles.com/microsoft-access-development-49/pass-parameters-from-vba-to-query-62367.html And here's my outline to show you how its done... your mileage may vary [CODE] Private Sub Search_Button_Click() Dim dbs As...

Hi Gary, That's exactly the problem! If a query that requires parameters is used as a recordset, one will need to use querydef and feed the parameter into it beforehand. In post #27 of this article is an example of how it is done...

Hi again Mary, I have to apologise - I was complete wrong about RecordsetClone. Using Access 2010 I made a subform with records, and I can change anything there using RecordsetClone. You were on the right track all along... I am looking for a solution for you... will keep you posted. Sorry...

Hi GaryPanic, Just checking - does the query "MultisysQry" run ok in a query window? Is it a straight forward select query or does it need any parameter input from a form/user?

Hi Mary, Yes, basically you will open a fresh recordset - either directly based on the table you want to update (maybe better or simpler), or based on the query of the form. Essentially the code hasn't changed much and will look a bit like this Private Sub InsertBtn_Click() Dim rst As...

Hi Mary, Recordset is read-only so you cannot edit it. That's why you were getting the error. http://msdn.microsoft.com/en-us/library/aa207086(v=office.10).aspx Just create a fresh recordset based on whatever you want to edit.