Here is the code:
Option Compare Database
Option Explicit
Global User1 As String
Private Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal lpbuffer As String, nSize As Long) As Long
Function CreateCalObject()
Dim MyOlApp As Object, MyNameSpace As Object, MyFolder As...
We have an old access database that we enter truck receiving dates and times into, which then calls a routine to put it in a calendar in outlook. I have not gotten into this database because it has worked fine for years. This past weekend, our IT department moved the outlook program to a new...
I send a report out as a snapshot (report has embedded pictures in it). Users want to save only 1 page of the report, when printing that page to a file, everything appears OK, but they cannot open that file. Any suggestions?
We ahve an access application that monitors deliveries. Whenever there is a problem, a photo is taken of the merchandise. Is there a way to import photo into the access application, and subsequently attach it to an email or print it right on a report? Thanks for any help.
Thank you very much! Is there a manual I can purchase to guide me through these changes? Does the FE and BE need to bee on different servers, or differently mapped drives?
Maybe I am not understanding the password workings. If I password protect the database, theyn enter the password to have access to enter data...with this access, they can also change forms, reports, queries. Can I change that?
The ACCESS databases at my workplace can be modified by anyone opening them, which is real scary. Can anyone point me in the right direction to get this protected? Equipment needed? Software changes needed? I thank you in advance for any information.
Does anyone know of a way to compare the minutes of a time field to a number. For example: I need to compare the minutes of a clocked in Time, if it is > 53 zero out minutes and add 1 to the Hour. If it is between 46 and 53, make it 45. etc. Maybe something like this is too much for Access...
I need to overwrite start and stop times with even hours:
for example, if time entered is >7:53 and <8:07 I need to make it 8:00. Does anyone have a routine to handle this?
Thanks n advance for any aid you can give.
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.