Hi,
several Access 2002 reports containing records with image and text should be printed and binded with pages numbered continuosly from the beginning of the binder to the end.
DoCmd.OutputTo will not work with images.
how to export Access reports with images and text to Word?
need a report with employee text fields stacked on the right side of a photo field.
some text fields of a record might be empty and the blank line(s) should not appear, instead the next text field(s) data should occupy the empty lines.
although I used the proper detail session properties of...
Hi,
small net has 3 xp stations connected via a Linksys dsl router, plus a Linksys printer server connected to the 4th port of the router as a station.
one of the xp stations can't see the print server although it sees and comunicate to the other stations.
have already uninstalled and...
Hi,
How to struture tables to allocate transportation resources to clients?
This an internal transportation service: internal clients call in advance to schedule a service with a certain type of vehicle on a certain date.
At the last minute, the dispatcher will assign the avaiable vehicle...
Hi
How do I get the string of the following register section, in Acc97 vba code? Is there a simple code for this like using the Environ()?
HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\User
Thanks
Hi
I need to export files to the My documents folder in Windows XP.
How to get the Windows user name to assemble the path string to its My documents folder (like the example bellow)?
C:\Documents and Settings\UserName\My documents
Thanks
I get 52 (incorrect file name) erros from the acc97 Dir() if it encounters a file name with too many ".", like "Caller ID CID, Speaking Caller ID....url" which is common on the Favorites folder.
How to solve or to circunvent this.
Thanks
Hi,
How to loop through the "Set Options from Visual Basic" (from menu\tools\options) to get their names and values with the Application.SetOption method on Access 97 VBA.
Thanks
How to alter the default path string in acc 97 menu\tools\options with vba SetOption?
Application.SetOption "Acc97OptionName", "NewPath"
What's the name of this option?
Thanks
Hi,
How to code Shift-F2 to the tools bar and to a button?
This opens a A97 window which allow the user to have a better view of the filed contents.
Thanks
Hi,
Is it safe to assume relative addresses in the vba code if the A97 application was called from (1) a shortcut which has the full path of the app defined or (2) clicked on the Explorer? A97 is used also with other app. If not, how to do it? How to define the path on tools/options with VBA...
Hi,
How I can check if a file exists without using the A97 dir() function? I need to check the existence of a possible new file name while on a loop that already uses dir(). The task is to traverse an hierarchy of folders containing sub folders and files, renaming some.
I got the function...
I created an Acc97 mdb to keep track of tons of documents created with several softwares like word, excel, paintbrush, etc. The main form shows records with name of the document, subject, notes, etc. To allow user to open a document I created a hyperlink field. Click on the hyperlink field and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.