Recent content by jmofstead

JANR - I am just playing around with this specific form (not hidden) and when I just close this form it give me the error: The Expression you entered refers to an object that is closed or doesn't exist. My code is as follows: Private Sub Form_Unload(Cancel As Integer) Me.DOE = Now() End Sub I...

vbaInet - pardon my novice knowledge of Access 2007, but how can I interrupt the form's event?

JANR - I tried that and it still give me the same error, but when I hit END and the form closes, it does give me the date/time stamp. Any suggestions?

So, in my database, I have a form that automatically pops up when opened. It is a hidden form, but esentially it give me our user's ID, and the date/time when the enter into this database. I want to add the date/time of when the close out of the database so that I can see usage, etc... I have...

Do you have any suggestions on how to make it better? I've always wondered if there was a way to have a set month and day, but the year be like an astrick...not sure if that would work at all... I tried adding = but it's still not working. Esentially what I was hoping to do, but it's beyond my...

Hello all, I am trying to write code that would automatically assign a training year depending on when an employee was hired and for some reason I cannot get it to work. Here is what I am looking to do: In our form, we want to automate the training year. So what I've done is pulled the Hire date...

I have no idea what I'm doing wrong. Esentially what I want to do is create a code that if a facility name equals a specific facility I want to run a macro. For some reason i've run into a problem that since i'm using a continuous form, it only queries the first record. So I've attempted to...

Hello all, So I am trying to automate an automatic update of a report to PDF. I am attempting to do it in a Macro since i will be vacating this position in a month and the person who is replacing me has no knowledge of VBA. Hence, I am not familiar with using Macros, I prefer using VBA...

I'm not too sure but can't you just set the default value on that text box in your table, to the code, i.e. =GetUser() That way it automatically populates the form, thus the table?

Okay Bob, thank you for your patience, I have made the appropriate changes to your code you gave me and I go into create a new macro and choose "RunCode" I then select the function from Armen Stein, which I relabeled Email Test and I open up that function and it gives me four choices...

Thanks Bob, I'll try to work on this ASAP. I have a quick question, the code Armen Stein wrote, do I need to replace any elements, or is it a general code? (sorry if this is a stupid question) And your code, Do I just add this to the bottom of the code by Armen Stein? Thanks! Julie

Cool Thanks again

That's what I thought. :) I would appreciate the help tremendously. I've looked online at this forum and the codes aren't exactly what I want since I need to have the addresses pulled from the Query/Report. I can also turn the query into a "make table" query if that would be best. Bob, your...

Hello! I am a Business Analyst tasked to create a tracking database. I am an intermediate user of VBA/Access and I am learning at least one new thing a day.

Hello all, I am attempting to create a SendObject Macro that sends an email to managers who have not completed certain assignments. I run a query that pulls out those managers and their email addresses and create a report with that information. How can I get the To action arguments to pull from...