Military Time - No Colon Separator For Key Entry

Mar 15, 2014

We have a new contractual requirement to track all time spent on Military contracts and report it to our Prime Contractor annually.

I am trying to put into Access 2010, basically the same functionality that I have built into Excel time sheets for years; that is simple entry of time in military time using 3 or 4 keystrokes depending on the time of day.

I have a table which records an employee's employee number and job that he or she is working on. I have formatted fields to short for Start Time and Stop Time, and I have a Calculated field also formatted short for elapsed time, however I need to have it simplified to where there is no colon separator on key entry in the form to 700 for 0700 hrs military and 1317 for 1:17 PM.

I will be using this database on several computers, but only a couple that will be used for time entry.

The Excel spreadsheets work well, but I have found them cumbersome trying to dump all the information into a Master spreadsheet from several different individual spreadsheets and I am using Access as our ERP so it will save time if I just add a simple form to track time from there putting it in the hands of the Repairmen and save someone from data entry late.

View Replies


ADVERTISEMENT

Subtracting Military Time

Oct 21, 2005

My new job requires me to use access so I'm learning as I go. :confused:
I have already used previous threads from this forum to answer another problem I encountered. Thanks for providing this forum to the public!

I am attemping to run a query that will subtract military time. (I am not allowed to change the format of the times in the original tables. )

Example:

Column A Column B
1111 6.5

I need 1111 - 6.5 in Column C

View 4 Replies View Related

Input Time Without Colon

Jul 25, 2005

I have done a bunch of searching and reading and playing with time formats and can't crack this nut. Is there a way to have a user type in the time without the colon. I can format the field to be "hhnn" but it still requires the colon on entry.

Thanks in Advance,
RichB

View 2 Replies View Related

Military Time Format Need To Include Seconds?

Mar 19, 2015

I am currently working on a database where my source data has the times in military format which includes the seconds; 18:45:30. All my time fields are set to data/time and format is Short Time. The Short Time format gives me military time but only down to the minute. I need to include the seconds into my time fields. I tried creating an input mask but it converts it to standard time.

how I can show military time down to the seconds as in my example above?

View 4 Replies View Related

Calculating Military Time And Putting Result To Nearest .25

Mar 14, 2013

I have to fields in military time. I need to calculate and have the result in decimal format to the nearest .25 minutes.

View 1 Replies View Related

Queries :: Employee Time In And Time Out Entry

Jul 18, 2013

I am trying to create an Access database where I can let the employees enter their time-in and time-out, at the end of their shift. I already created this function working, but running into another issue. Everyday, employees need to enter a break. Sometimes they take a break and sometimes they don't, if they work shorter hours. Thus, the break is not a default 30min and has to be enterd by the employee.

Below is the code I have to calculate the total hour:

txtCalcTime has the below code in control source:
=Int([CalcTime]/60) & ":" & Int([CalcTime] Mod 60)

Control source for this form "FrmTimes" property, in which Txtcalctime resides:

QryTimes
"QryTimes" query has the code below:
SELECT TimeID, TimeIn, TimeOut, Brake, DateID, DateDiff("n",[TimeIn],[TimeOut]) AS CalcTime
FROM EmpTimes;

This shows the total number of hours worked. But how can I make it to substract the break time entered by the employee in "txtbreak" on FrmTimes

View 12 Replies View Related

Remove Colon From MAC Address

Oct 24, 2005

When TableA is imported from Excel, it has the MAC address as xxxxxxxxxxxx.
When TableB is imported from Excel, it has the MAC address as xx:xx:xx:xx:xx:xx.
In a query the TableA and TableB are joined by the MAC address. Obviously I get no results from TableB because they aren't the same.
How do I remove the colons from TableB.
I know I can do it in Excel, but it is tedious. Thanks

View 2 Replies View Related

Modules & VBA :: Extract Strings From A Field In Table (Separated By Colon)

Oct 21, 2013

I have a field in a table that I'd like to extra the texts from. The are stored in below format (separated by colons). They don't always the same amount of characters and not all of them have the same amount of texts.

Some may only have Text1:Text2::, while some may have Text1:::Text4.

Text1:Text2:Text3:Text4

View 8 Replies View Related

Time Entry Validation

Mar 3, 2005

I am trying to validate a time entry in a form, where the time is part of a Date/Time field. What I am trying to ensure is that the time entered is in working hours (in this case 0900 - 1700). I want to raise an error message.

Thus: 20/02/2005 08:30:45 is not OK, while 20/02/2005 09:03:45 is.

Can anyone help me on this?

View 1 Replies View Related

Short Time Entry

Jan 5, 2008

I'm trying to refine another of my time entries. To enter a Short time (eg 10:35), I have to type in the four digits AND the semi-colon in the middle.

I would like to be able to enter only the four digits with Access making it into the correct format.

I have achieved a similar effect in Excel using code like

TimeVal = Left(Value, 2) & ":" & Right(Value, 2)

I tried writing something similar in the Before_Update Event, but it was rejected!! Any ideas? - Thanks, Andrew.

View 5 Replies View Related

Reports :: Changing Character Separator

Jul 16, 2015

I'm working on a report in Access 2013 and I have a multivalued field that stores employees names in the format "Last, First" and when I put it on my report it displays all the names as "Last1, First1, Last2, First2, Last3, First3" and so on. That's a lot of commas and it was suggested to me by my boss that I change access to use semicolons between the employees as he would like to keep the names as Last, First.

View 7 Replies View Related

Forms :: Number Separator In Subform

May 15, 2013

I needed to change the decimal symbol from a dot to comma for use in Europe. On changing the the settings to a comma everything works fine but for the field that I have the code in the AfterUpdate properties

Private Sub SprayCfuelC_AfterUpdate()
Me.Dirty = False
CurrentDb.Execute ("UPDATE ProcessData SET ProcessData.SprayCFuelC =" & Me.SprayCfuelC & " WHERE (((ProcessData.AuditNo)=" & Parent.[AuditNo] & "));")
Me.Recalc
End Sub

Now when the data is changed I get a run time error 3144 - syntax error in UPDATE statement.

View 5 Replies View Related

General :: How To Remove Date Separator

Jul 16, 2012

I have a lot of dates in one column (dd/mm/yy), and i somehow need to duplicate them into another column where they are shown without the date separator (ddmmyy), so that i can use that figure in a future calculation where a variety of fields are combined to show one unique product number.

View 7 Replies View Related

Simplify Entry Of Date/time

Jun 29, 2006

Hi, hope someone has an idea of where to start on this.

Our company offers projects to multiple contractors and we have to enter when we spoke to them and their response. I put a textbox with default of Now(), thinking these would be recorded in real time and it would be no effort at all. But the offers are frequently entered days later, and keying in dozens of specific dates/times in the long format is very irritating for users.

Does anyone know of something similar to the DatePicker or calendar popups that will let you use arrows or comboboxes or something to quickly enter a time? We record date, hour & minute (no seconds) because it updates the contractor's order on the rotation list (i.e., next call is made to the contractor who has been waiting the longest for an offer). No ActiveX please, we're in secured network environment.

Thanks in advance.

View 3 Replies View Related

Queries :: Semicolons As Parameter Separator In Functions

Sep 8, 2014

I used to use commas as a parameter separator, but for some reason it is now a semicolon. How can I change it back to a comma?

Currently this works:

Code:
SELECT IIF(MyExpression; TrueThing; FalseThing)
FROM ...

Want to use (and have used before):

Code:
SELECT IIF(MyExpression, TrueThing, FalseThing)
FROM ...

View 3 Replies View Related

URGENT!!! Time Registry On User Entry

Nov 21, 2006

Hi I'm a newbie in access, i've read almos all of the threads posted

my problem is that I need to register times

for example
I ask for user number (this is an exlcusive number)
and by the time User clicks on Accept i need acces to record this time

user 19394 time 7:35 am (for example)

can this be done in access??

and another i need acces to display a pop-up message like

"User 19394 Jhon Smith
is this correct?"

can you help me

View 1 Replies View Related

Forms :: Text Box To Store Numbers - Thousand Separator

Aug 11, 2015

I have a user input form with a text box that stores a number. When the user inputs the number, I'd like it to display the comma separator (e.g. "1234" becomes "1,234". I've tried putting "#,###" and "#,##0." into the format property of the text box, but I still get 1234.

View 4 Replies View Related

Modules & VBA :: Can't Get Data Entry Form To Add New Record After First Time

Aug 6, 2013

I've got a data entry form bound to one table. The form has four buttons:

- Clear Fields
- Cancel
- Save and exit
- Save and add another (which should save the user input to the subform/table, clear the input fields, and allow the user to add another record)

I can't quite seem to get the "Save and add another" button to work. When I put some information in the input fields and click the button, it saves it to the subform/table perfectly, but when I try to do it again, it just edits the last record (the one just created).

How can I get that button to place the information from the input fields in a new record every time?

The _Click event for the button looks like this:

Code:
If Len(Me.field1 & Me.field2 & Me.field3) > 0 Then
Me.Refresh
btnClear_Click
DoCmd.Save
End If

View 5 Replies View Related

Import CSV File - Field With Numbers Containing Thousand Space Separator

Aug 12, 2014

Any way to import a file containing numbers with a "thousand space separator"

example :

1 000
2 000
3 000
4 000 000
5 000 000 000

Only workaround I found so far is to import de numbers into a text field in a temp table, do an update query to remove the spaces and then transfert the data into the real table that has a numeric field.

View 14 Replies View Related

Queries :: Tracking Time Spent On Customers Records Based On Date Of Entry

Apr 17, 2014

I have two tables, One table containes customer name, etc., tblcustomers the other table contains the tbltimelog, log of activity start time end time. No issues. I want to generate a form based on the dateofentry for the time record. I am not able to get a summary lets say I spent 20 hours on ABC and 20 hours on CBS. If I spent 3 different days on ABC and 6 different days on CBS it will not add them together it will list it ABC 3 times and CBS 6 times. I have tried the distinct function but it doesn't work because the date is distinct. Is there a way to do this as an SQL or whatever. Thinking I could just create a new table and calculating the totals but that seems to be a waste.

View 3 Replies View Related

Queries :: How To Trigger By Date To Create A New Entry In Database Based On Old Entry

Aug 6, 2014

I have a database that makes use of standing orders. That means that if a client has a standing order to receive products during for example 4 time as year (quartely at the end of the month). to automate the new entry by copying an old entry in the database.

Let's say I have a client where we will have to send a product at the end of June, it will look at a field where the next send date is, and when it reaches 2 weeks for that date, to create a new entry in the database based on that entry. This way, it will pop-up in our open cases and we are aware of it and also will be visible in our report.

View 1 Replies View Related

Forms :: Combo Box To Verify With Last Entry And Display Other Options Than Last Entry

Sep 8, 2013

I am working on creating an access database for tracking physical assets linked to locations. I need to make a combo box list to show items other than the current location of the asset. Basically I need it to refer to last enery of the user and define the new possible entries. so we have a unique relationship between location and asset. The assets and location will always remain fixed and there is never going to be any addition. I am creating a web form so that it can be uploaded into sharepoint.

View 3 Replies View Related

Time Format - Short Time Displayed As Medium Time

May 23, 2006

I have an application with a backend db on PC 1, and the same application on PC 2 linked to the backend db on PC 1 via the network.

The link works fine but the time formats are different.

On PC 1 the time format is shortime and displays as it should i.e. in 24 hour clock format

However on PC 2, opening the same database via the network, the time format is still shorttime but when you read the time within the code it comes out in AM/PM format. Also, when the defaul tiem should be #20:00:00# but this changes to #8:00:00 PM#

Weirdly though, when you just open the table, the times are in the correct shorttime format.

Guessing, it must be a setting within the main core of Access 2003 that is different between the 2 instances?

Any ideas?

This screen shot may help:

View 2 Replies View Related

Time Format - Short Time Displayed As Medium Time

May 23, 2006

I have an application with a backend db on PC 1, and the same application on PC 2 linked to the backend db on PC 1 via the network.

The link works fine but the time formats are different.

On PC 1 the time format is shortime and displays as it should i.e. in 24 hour clock format

However on PC 2, opening the same database via the network, the time format is still short time but the format is in AM/PM or medium time.

Guessing, it must be a setting within the main core of Access 2003 that is different between the 2 instances?

Any ideas?

View 1 Replies View Related

Reports :: Auto Populate Date And Time Every Time Form Is Updated

Nov 8, 2013

I have a database that stores information for lab testing. Each time a tech does a "step" in the test process he logs it in the table, using an input form. There are different categories, for example preparation, testing, analysis, etc, and each of those steps take time. I have the form autopopulate the date and time with NOW() evertime the form is updated. What i want to do is calculate the time it takes to do each in days. I can easily get how many days it was from now since they logged the test, =NOW()-TestDateTime. What I want to do is get the number of days it took to do each step, ie the number of days between each event. Is there a way to do this?

View 3 Replies View Related

Forms :: Add Time Value To Time Data Type SQL Server Field In Access

May 6, 2015

how to be able to enter time in access form the same way as if would be an access table (1p = 1:00 PM; 1.25 = 1:25 AM etc)

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved