I have tried several ways to make the dlookup work on a form I have in my database and it is not returning any results any help would be appreciated.
I have a table (tblWorkRequest )with the following fields ID (PK), WorkOrderNo, RequestDate, RequestedBy, Location, Description, AssignedTo, ScheduledComple tionDate, and ActualCompletio nDate.
I have two forms (frmWorkRequest and frmAssignWorkRe quest).
frmWorkRequest...
SDaxx
Last Activity: Feb 28 '14, 04:07 PM
Joined: Nov 6 '13
Location:
-
Find Last record in table by information in a textbox on a form
I am still learning access, vba and sql and am in need of some assistance. I have a table (tblCommercial) with the following these fields: ReferenceNumber (autonumber) AccountNumber, CompanyName, ServiceAddress, DumpsterSize, Frequency. I have a form(frmCommerc ialChange). The AccountNumber textbox on the form has an AfterUpdate control that populates the CompanyName, ServiceAddress, DumpsterSize and Frequency from the table. The form also has two... -
Thank You! It worked great.
SDAXX -
Thanks for the information it is a good starting point. However it does not have a timeclock feature for employees to clock in and out and that date and time of that action to be captured in a table. Any help would be appreciated.
SDAXXLeave a comment:
-
Time Clock/Punch Clock Database
Has anyone created a time clock Access database?
I'm referring to a database that will allow the user to sign-in at the beginning of the day then sign-out for lunch, sign back in then sign out at the end of the day. Then be able to total the number of hours worked. I also need to be able to track the time for those employees that do not sign in and out.
What I'm 'hoping' for is that someone has a sample database or... -
1. Yes I am using Microsoft outlook.
2. Send a single e-mail to all the e-mails in the table is what I would like to do, but do not know how to do that.
Any help would be appreciated.Leave a comment:
-
Send e-mail of Form
I am using Access 2007. I have created a form (WorkRequestFor m) and I want to send the information in the form to specific email(s) after clicking the submit button (cmdSubmit). I have a table (tblEmail) with one field (Email) with several entries. I want the email to go to all the emails in the table. I have tried several times to get it to send to the email address in the table and can not resolve it. To make sure the rest of the code was working... -
Thank you, that resolved the issue. Sometimes it is the simple things that are missed.
ShariLeave a comment:
-
Auto-Increment number on October 1 of each year
I am new to access and vba and am trying to have a text field (txtFiscalYear) increment by one on October 1 of each year. For example on 9/30/2013 the field is 2013 and then on October 1, 2013 the field is 2014.
Here is the code the I have but the field is blank:
...Code:Private Sub Form_Load() Dim txtFiscalYear As String txtFiscalYear = Year(Now()) If Date >= #10/1/2013# Then Me.txtFiscalYear
Last edited by zmbd; Nov 6 '13, 08:53 PM. Reason: [Z{Please use the [CODE/] button to format posted code/html/sql/formated text - Please read the FAQ}]
No activity results to display
Leave a comment: