MS ACCESS :: Employee Time Card System

Help With Time Tracking System
I have a time tracking system where users can clock in and clock out. I want to have an error message when they clock in and then accidently clock in again. Therefore, they can only clock out after they have clocked in. The data goes into the table called "Timeclock Table". The fields in that table are SSN, Clock-In, Clock-Out, and TimeStamp. The clock in and clock out are check boxes. can you guys help me?????? Im just a beginner.

View Replies !

System Date And Time
Hello,

I have a form that displays the system date and time for every entry.
When the data gets stored in the table, the date and time do not get stored. How can i save the date and time with all the other information.

Also, everyday when i open the form, it shows me all the data from the previous day but the date for all that data has changed to taday.
I want that everyday when i open the form, it should be blank and all data from the previous day must be stored in the table along with the date and time.

Hope someone can help me with this
Thanks

View Replies !

Time Tracking System
I have a time tracking system where users can clock in and clock out. I want to have an error message when they clock in and then accidently clock in again. Therefore, they can only clock out after they have clocked in. The data goes into the table called "Timeclock Table". The fields in that table are SSN, Clock-In, Clock-Out, and TimeStamp. the clock in and clock out are check boxes. can you guys help me??????

View Replies !

Rnd Based Off System Time/date
Hey all,

I'm trying to find a solution to a problem. Is there any way using VBA to generate a random number, based off the current system date and time? The theory is that a random number seeded by the system date/time will be truly unique and the possiblity of it ever occuring again will be nearly nil.

Or is there a better way to create unique ID's (such as member ID's, or something similiar) based off the system date/time that can be used as a primary key in a relational db.

View Replies !

Time & Billing - Project Management System Upgrades
We'll it's been out for a while so now I'm gonna give people who use it or would like to use it the chance to have there say as to what goes into the next version.If you've got any idears for something that you think should be included with "I've Got Time To Bill Ya Now" nows your chance to have your say.Main Topic http://www.access-programmers.co.uk/forums/showthread.php?t=121117

View Replies !

Creating A Timer Event That Checks System Time?
I need a query run that brings up a list of customers that need maintence after 6 months after their last maintence service. As soon as you open the DB, the event/query runs and if there are any customers past due to display them. And if there are none, to not even show the query at all.

I have very little experience with timers and if/then statements and don't know how to set this up.

Any help would be greatly appreciated. Thanks in advance.

View Replies !

Comparing A Date/Time Field To System Date
Hi,

I am trying to compare a value in my databse produced by the date() function, short date format, to one that is exactly 24 hours after the value recorded by the date() function. If the value in the database is 24 hours prior to the current date(), I need to flag a text box a diffrent color to alert the user. I am unsure on the If statement that I will need to produce this result.

Any help would be greatly appreciated!!!!
Thanks
Mikeco555

View Replies !

Using A * (Wild Card) In Pop Up Box?

Is it possible to use a * (Wild Card) in a pop up box for a query?

I read the previous post about pop up boxes for quires and it worked worked great! I created one for my month field

My criteria in my search fieled is a follows:
05-May
06-June
07-July
08-August
etc...

As you can see someone would have to type a 08-August to get the results for August, can a wild card be used? Example 08* would return all of 08-August data. I tried it but it wouldn't return any data.

Any help would be appreciated.

Thanks, Scott

View Replies !

Wireless Network Card
Sorry All,
I have a simple question, how can I tell if my laptop has a wireless network in it. Thanks.

View Replies !

Fried Graphics Card. What Do I Do?
Hi,

I'm in a a lot of trouble. My graphics card has stopped functioning, leaving me with a perfectly good computer that I cannot use.

In order to retrieve the information from the harddisk, I got a cable between this computer and another one.

This is my plan:

When the "blind" computer is started, I will enter the cmd. From there I would like to be able to "share" one of my folders on the small network (ie the two computers). Is there a DOS command for this?

second question:

If I have VNC server installed, will I be able to see the desktop from another computer allthough I can't see it on the blind computer? Does that information go through the graphics card before it is sent over the internet, or after it has arrived in the VNC viewer computer?

Fuga.

View Replies !

Magnetic Card Reader
Looking at creating a database that looks up records based on a number from a magnetic card. Has anyone ever come across any code that will pull the info from the serial port? I have been looking for 2 days and not able to find anything. I have the card reader but do not have any software to get the info from the serial port and my limted coding does not even come close to what I need. Any help or a push in the right direction would be greatly appreciated.

Thanks,
Matthew

View Replies !

Business Card Scanner
I want to use a business card scanner, and use the data for my Access 2000 order database. Most card scanners, can send data to Outlook, can you go from Outlook to Access? Any advise would be appreciate it . . . THANKS!:o

View Replies !

Wild Card In IIF Statement
I am using a criteria entry form as the source of parameters for a select query, and I am using IIF statements in the query so that if the user does not want to specify for that particular field, the search still works based on the other parameters specified. Therefore the statement I am using is;

IIf([Forms]![Criteria Form]![Customer Account] Is Not Null,[Forms]![Criteria Form]![Customer Account],[Data]![Customer Account]).

This works.

However for some of the criteria I want to also use wild cards, so that the user can enter just part of the data, and the relevant records will be returned. I understand that wild cards cannot be embedded into the IIF statement above.

I have tried many methods, and trawled the web for ideas, but I cannot get this to work. I either want the user to enter the wild card themselves ie "100*" returning records starting with "100", or for the query to append the wild card itself.

Can someone help please?

View Replies !

Wild Card Name Searching Help
How would I make a query find a person like this:

Inputted Data: Smit
Outputted Data: Smith, Smithy etc..

The formula I have entered in the criteria of my query is:
Like [Enter the person's last name]

With this formula, if I type Smith, then the data that comes out is Smith. But if I type in smit or smi, Smith doesnt come out.

Thanks.

View Replies !

Wild Card Searches
Ive read loads of posts about Wildcard searches but am unable to find the answer to my problem. In one of my boxes on my search form the user places in the search criteria value, this can be from A1 - A16 all the way to G16. At the moment i'm using this as my seasrch query:

[Forms]![Search]![BoxNo]

So if I put in C1 then I get all the C1's, great. If I want to wildcard then I put in Like "*" & [Forms]![Search]![BoxNo] &"*", and again it works, this time it call enything with C1 in it i.e C13.

How can I adjust my query to do both, sometimes I only want the exact match othertimes I want to wildcard :confused:

View Replies !

Credit Card Processing
Does anyone know of any software or have any code that would allow to process credit cards.

View Replies !

Access Wild Card Search Help
Hi

I have a query that depends on the input (several parameters) from a form. The form has a list object that shows the results of the query. For example, when I type in "s" in last name and "b" in city, it shows everybody whose last name starts with s and city name that starts with b. The problem is that it excludes all the records with blank cells in either last name or first name or city. In another words, the list is already pre-filtered with records that contain all three fields (city and first name and last name). For example, the record (Last name: Mosby, First name: Ted, City = blank) will be excluded from getting displayed because it contains no characters. Can someone help me out with this issue? I would like to include those people on the search even though their city is not entered in the table. With the query parameter empty, I would like to show a very raw list (a list that is not filtered at all).

The Query is built as follow:
The criteria for the field "Last Name" is
Like [forms]![simform].[lastnamesearch] & "*"

The criteria for the field "First name" is
Like [forms]![simform].[firstnamesearch] & "*"

The criteria for the field "City" is
Like [forms]![simform].[city] & "*"

View Replies !

Wild Card On Search Form Issue
Hi all,

I need a little help with a wild card issue, Ive looked and looked and cant spot whats wrong.

I have two forms "Requisitioner" & "Engineers", each form has a subform.
These are basic search forms (unbound) that find related records in the subforms. The work is done in the query of the subform and then the form is refreshed. I have used this approach many many times without issue until now.

If the engineers form is opened "G*" is entered into the text box then all the entries beginning with "G" are found in the subform.

If the "*" is then removed from the text box leaving "G" no results are found in the subform, (Working Correctly)

Now if the "*" is added again "G*" then the subform shows all the entries beginning with "G"

Everything is good with the Engineers Form, If the same steps are made on the Requisitioners form after adding the "*" again no records are displayed.

I could change the way this works by doing a recordset find but i really want to know why this is working on one form but not on another.

I would appreciate any help with this.

Garry

View Replies !

Seeking Much Help With Generating A Card Number From Another Field
Hi guys,

I need some help here and any would be muchly apprieciated.

I am building a database for a theme park fast pass system where a customer can book themselves a place on a ride at three session times a day.

Now my problem is, that I need to generate a card number. 5555 1946 as the first 8 digits (this always stays the same) and then the last 8 digits is the customer ID number, which is in the same table. So there are 16 digits in total.

Let me give you an example:

A new customer registers and are assigned a customer ID of 1000 0001. Therefore the Card Number for that customer must be 5555 1946 1000 0001.

I have used auto number for customer ID so when a new customer signs up, there ID is 1 more that highest already in te database.

Simple question really...but how is this done?

A million marks for someone who breaks it! Hehe

Thanks

View Replies !

ID Card Making Printing And Data Base
I have got a dbase created however getting it to print in the order I need for the PVC Id card just is not working.

Any Ideas

thanks
Matt

View Replies !

Validation Text For An Expiry Date On A Credit Card
Basically, i have a field where the expiry date of a credit card is input, but i want to set an input mask so that it loks something like this:

MM/YY but i cant find a way of doing this!

I then have validation text which makes sure that this value is either equal to or more than todays date! this looks like this:

>=int(now())

So the input mask has to accept this validation...

If you could help, i would be very greatful!

Cheers

View Replies !

Converting Filter From Wild Card To Extact Match
I have a search box and it looks up project id number.
the orginal code works but filters anything with that particular number.

I like to adjust the filter to equal to the number enter.

ex,, I enter 22 , i get records with 622, 223, etc
I want it to be only 22

I can't seem to figure this out.. here's te code

Private Sub txtSearchString_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

LSearchString = txtSearchString

'Filter results based on search string
LSQL = "select * from [Projects - Active]"
LSQL = LSQL & " where ID LIKE '*" & LSearchString & "*'"

Form_frmSearch_sub.RecordSource = LSQL

lblTitle.Caption = "Project ID: Filtered by '" & LSearchString & "'"

'Clear search string
txtSearchString = ""

End Sub

View Replies !