Recently had a problem with Access regarding invisible records. There are 3 linked databses: system, data, and frontend. In the data database there is a table called tempupload. This was used as a "workspace" table. I found one blank record "visible" in this table and wanted to create a method...
Thank you very much for your time and effort. I'll try this over the next weekend and week ahead.
This macro doesn't just send an email. With the Send Object it asks for an object and the type of document to send. I have an Access report (.rtf) that I want to attach to the email...
The macro that I use is:
Open Report (this opens the print preview)
SendObject (allows for the the email data)
Close (Closes the print preview)
Stop Macro (Ends the macro)
The email address' are listed in the options boxes of the Send Object command.
I have an Access report that I want to send (via Groupwise email) to various users. I have a macro that uses the SendObject command.
Everything works fine on the development PC (14 recipients). When the application is used by various users on various PC's the results are varied. Both 2000...
I have an Access report that I want to send (via Groupwise email) to various users. I have a macro that uses the SendObject command.
Everything works fine on the development PC (14 recipients). When the application is used by various users on various PC's the results are varied. Both 2000...
I have an access memo field that I import into a word doc with legal numbering turned on. When I bring the word doc back into an access sub-report it loses the numbering. I've tried increasing the margins to get the numbering to show. Nothing works any help would be appreciated, thanks in...
I'm fairly new to SQL. I want to execute a DTS package from Access. I found the thread from p27br (thread 958-848668) and followed the steps (Access 97 not in Access Project). I got the module to compile. However I can't get it to run. What is the next step? When I run it in the VB screen I...
Thanks for trying to help. Found what I needed. I don't have SQL problem. What I needed to do was turn on Totals in the query. What I was looking for was the last TIME (highest in 24 hour). Using the Totals MAX function I got just what I was after the last Time they logged in.
Thanks for...
I have a Db that tracks users logins. I have the time field set to 24 hours. I need to print a report from a query of the current day and the latest(highest) time a user logged in, FOR EACH USER.
I found this on the internet and attempted to use it in my query and in my report. Neither...
I want to document the creation and version number for later fixes/patches/changes. I want to be able to quickly check the version number and make sure I've got the newest version.
Uder the File menu, there is the "DataBAse Properties" selection, on the statistics tab there is a...
I've got a small DB to handle what you are asking for. If you will send me your email address I will send it back as an attachment. (I have look all over here to see if I can attach it here but I haven't found out how toattach it here). If you know how to attach to this reply post it here I'll...
I had to do some research into this subject (security). The best reference I could find was in the Que publication of Special Edition of Using Microsoft Access 97 (pgs 881-891). Another reference is in the Osbourne publication of The Complete reference Access 2000 (pgs 1084-1109). The second...
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.