Search results

Private Sub SomeSub() Dim mypath As String: mypath = "C:\MyFakeFolder\MyFile.txt" Dim myfolder As String: myfolder = GetFolder(mypath) Dim fso: Set fso = CreateObject("Scripting.FileSystemObject") ' Create folder if necessary. If fso.FolderExists(myfolder) = False Then...

One way to do this is to use a table of tips, VBA, DLookup, and your form's current and afterupdate events... Option Compare Database Option Explicit Private Sub Form_AfterUpdate() UpdateControlTips End Sub Private Sub Form_Current() UpdateControlTips End Sub Private Sub...

Here's the code if that doesn't work... Private Sub Command0_Click() ' Get the data. Dim datalist As String datalist = GetFunnyList("CustomerProducts") ' Save the data to a text file. WriteToFile "c:\funnylist.txt", Trim(datalist) End Sub Function GetFunnyList(myQuery As String) As...

OK, this time I didn't zip the file; instead I just added the zip extension to the name so the forum software would let me upload it. So before attempting to open the file make sure you download it to your PC and then rename it by removing the zip extension. Regards, Tim

Enjoy the day...though it seems you already have.

Mmm. I always have to sign on...only now I discover that's the exception...

I know you're asking about handling over- and under-payments...but do you have a junction table (InvoicePayments) for your invoices and payments? You might want to consider creating one if the following is true: One invoice can have many payments and one payment can be made against many invoices...

See the attached file--just one line of code used. Not precisely what you're asking about...but similar... Regards, Tim

Another example attached. Regards, Tim

SELECT ID, DATE, COMMENTS INTO MyTable_backup FROM MyTable WHERE ID = Blah Regards, Tim

It's not well known but in fact she began her career in a mariachi band... Playing the horn...

Pretty good stuff at a glance... Just brainstorming a little...I'd be tempted to build a separate function for forms and reports rather than packing dual functionality into one procedure, which increases complexity, which typically makes maintenance more difficult than otherwise... Function...

Not a problem. Were you able to capture the property's value as well as the name? Regards, Tim

Ah, yes...it seems like it was only just yesterday when it was released...

Undulating Underpants Sweat Saki Pensive Squids Waffle Iron The Broccoli Sound Machine

Have a co-worker and a brother who love it...which persuaded me to do a few caches... It does get you out of the house...yet it's not something that has held my attention...

Generally in a disconnected world when it comes to working with back-end data (say, in ASP.NET) the (current) best practice is to be chunky rather than chatty. That is, you should usually grab as many records as you think you might need from your back-end and bring them on over to your...

...there are also cases where leaving the application idle for a period causes Access to forget the reference... Curious... Do you know why? As far as an option for persisting the data, could you hold it in a local table? Regards, Tim

Yes. And in the absence of any other info I recommend you do this. Regards, Tim