Recent content by Bud

Hi all, I'm using a the following function to export data from a query: DoCmd.TransferText acExportDelim, "ExportSpec", strQryExport, FileName The query builds an output string into a resultfield, but it only outputs about 266 characters on a single line in the resulting textfile "FileName"...

Sorry sam! Sorry Sam for taking up your time. I feel so utterly stupid ... I just forgot the @$%#^$ quotes ("") with the [ID] field: glbMaxExportRecords = DCount([ID], qryExport) changed it to glbMaxExportRecords = DCount("[ID]", qryExport) And it works like a charm :D Pfffff (I was almost...

Hi All, Sorry for being an amateur here, but I really hope you can point me to the right direction. What I need to do is to is to reference a global variable in a separate module to the total (count) of all the records in a select query. I've read a lot of threads about counting records but I...

Do you think mighty "The_Doc_man" ... Thank you mcadle. Since he gets a lot of credit here ... do you think mighty "The_Doc_man" has any comments or suggestions? ;) Thanks! Bud.

Hi all, Is it possible to make a backend/frontend access system and putting the backend on a remote internet server. E.g. http://www.mysite.com/database/backend.mdb Because when I try this I keep on getting a message "Not a valid file name." Any suggestions apart from RTFM? Thanks, Bud.

Very nice solution! Thank you very much Paul, but there must be something I'm missing here. WHY do I not need the .Text property to set the new value of the field (sorry but I'm not a diehard Access programmer). Thanks again! Bud.

Tim, Thank you for responding to my question! The thing is, that normally when you scroll your records with let's say the mouse wheel, the control stays in the same field (you see the cursor blinking). If I want to update a label on the form (# of words in a certain memo field) I use a small...

Hi all, Maybe I'm being too bold here on my first mission :) but can anyone explain to me "how to save the current control state"? I'm updating my form (displaying the number of words in a memo field) on the On_Current() event. But because I shift the focus to this field I keep on ending up...