I've run into a bug, I think. I have a time field with it set to show "Medium Time" which is "hh:mm(AM/PM)", however, when I combine the information with another field in a query (=[OfficeDay]&" - "&[POfficeTime]), the time comes out as "Long Time" or "hh:mm:ss(AM/PM)".
End result is Wednesday - 10:30:00AM when it should be Wednesday - 10:30AM
Does anyone know a way around this?
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:
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?
Hi, I am creating a time keeping db.
Before I jump in and start creating a way to record times worked I thought it best to ask for advice.
The db is created and the last part is to capture by member:
Basically I have the following fields:
MemberID
Job Type
Date of Job
Time Started
Time Finished
From the data captured I need to create a report to show month and ytd hours worked.
It would be easy to ask the user to calculate the hours worked and input the number of hours, however I would like to capture start and finish times.
Can anyone give me any pointers on the best field types and field formats for capturing times which would then make it easier to work out hours worked.
Thanks in advance
Darrell.....
text59 is formated as general date. when the user dbl clicks the field i would like the value to go to "time_in" and formated as medium time.
Code:
Me.Time_in = Me.Text59 Format (Me.Text59 = "medium time")
The code brings the date and time to the time_in field...even with the time_in field formated as medium time
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 RelatedI 'm downloading the excel data from the site and connecting it to access.
In excel the particular column (Time Taken) is in the format of "00:12:26".
After connecting it to access and appending it to the table, the format changed to "12:12:26", the first two digits changed to "12" and the remaining are as it is how it looks like in the excel. I need to change it to format what it looks like in the excel.
I wanted to assign the field "Number of magazine" with special format based on date/time format but showing only year and month in the format: "yyyy-mm".
So in property of this field in format I put yyyy-mm and in input mask I type 0000-00;;-
I also created the form based on the table containing above field and I defined format and input mask for corresponding formant in the same way like at the table.
But if I try to type date for example 2014-01 in text box of the form it comes up with the full date 2014-01-01. Why does it do like this? What do I do incorrectly?
I have this code for an excel file in vba, strDate = Format(Date, "mm-dd-yy") & " " & " at " & Format(Time, "h-mm-ss").
I'm trying to put colons ":" instead of the dashs "-" for the time but I get a debug error, is there any way I can make it work, or am i stuck with dashes. Thanks.
I imported an Excel Sheet into a database. In this sheet were several coulums list travel time from one place to another. In this sheet the time in minutes. ie 120 was the same as 2 hours.
Anyway Now that it is in my database it is still in the number format. Is there an easy way to convert this to a time Format ie hh:nn
Hi all,
i've a field that contains the systemdate n time
i.e
txtDate.value = Now
will give me this 11/30/1899 9:46:00 AM.
How do i get rid of the second hands??
i want 11/30/1899 9:46 AM instead.
Thank you
Okay,
Missing something simple here and can't figure it out. I want to display a time in military 24-hour format but can't get it to show the first "0" between the times 0000 - 0959.
Current statement is:
datTripTime = Format(datArr, "HH:mm")
What am I missing please???
Thanks
I wish to insert in a table, not the date, but just the month and year (yy/mm or mm/yy), for example 05/10 or 10/05 for October 2005 (the order of yy and mm does not matter). In addition, I need to be able to sort the records chronologically using the same field.
I have tried various solutions with the date/time field or the number field (e.g. using yy.mm where the mm are the decimals). However, it does not seem to work correctly. Any suggestions for how I can do this by configuring the format, inputs mask and validation rule?
Niels
Hi
I'm very new to Access, so please be gentle;)
I have imported a appointment database that I need to analyse, however the Date & Time data within the table has been written as;
Date: 20051220 - which I would like to read dd/mm/yyyy (20/12/2005)
Time: 800 - which I would like to read as hh:mm (08:00)
I would like to produce a report of all the queries, i.e. longest appointment, shortest etc... but display them in the correct Date/Time format.
So how should I go about this?
I cannot alter the imported table in anyway.
1. Can I produce a mirror like table of the existing table, that automatically use the correct Date/Time format?
2. Can I alter the values within a query?
3. Can I alter the final output in the Report?
What is the best way to tackle this?
Hey guys, been away from Access and SQL for some time. I have a simple 2 column table with one thats set to Date/Time that displays the date only. Unfortunaly, when I run my query, the date comes out 7/9/2005 and I want it to come out as 7/09/2005. I know I am going to have to force it out with a format command, but its been so long that I have no idea how to. Right now my query, in SQL format, looks like this.
SELECT * FROM Table1 ORDER BY Date DESC
I just need the format command to force the date. If anyone can help, thx.
Hi,
I need to calculate the number of days between two days however the format on which i have my date includes the time in the same field -
2007-02-20 07:15:30.474
When I calculate one date minus an other the result is #error
I require the result to be in a count format e.g 2.3 days (like in excel)
Is there anyway to get around this without splitting the date and time?
Please help!:)
Hi everyone
I have 2 date fields date1 and date2 , and i have date/time data type but what i want to be inputed is in dd/mm/yyyy and not mm/dd/yyyy, what do i need to do in accees both date fields properties to make sure it is in UK date format. thanx
I have played with the format and input mask but i am lost dont know what to do.
Thanx
Is there an easy way to convert an integer into time? What I want is for the person to enter in 0820 or even 820a and then convert it to 8:20 am. This is mainly to save keystrokes.
View 5 Replies View RelatedHello,
Using Access 2000, linking tables to Oracle 10g with a db trigger forcing the default display format within Oracle to dd/mm/yyyy hh24:mi:ss (ie 24hr time format). Unfortunately MS Access displays in 12 hr format in the datasheet grid. A Sybase article reported this issue:http://www.sybase.com/detail?id=1024202. Do you know if this has been fixed for more recent versions of MS-Access?
Thanks
Pascale
I want to calculate total hours and mins by adding a load of times (in time format) on a report. I've got the total number of minutes and converted this to hours : [txtmins]/60
Now I want to get the remaining minutes by using : [totalmins] - ([totalhours]*60)
However, how do I round DOWN the [totalhours] before it goes into the above sum. I can round it, but it always seems to round up.
If anyone has an easier solution let me know
Recall
I have a small issue, but cannot solve it. I have a form with a textbox bound to a time(7) on a SQL server linked table.
Even if I put the format as "Short time 24h" or "hh:mm" it will always come out with seconds, nanoseconds, etc as soon as you change record. I would like to avoid using the "current" event to keep the "hh:mm" at any record change.
I have a field in my report [Idle]
This has a time in a HH:MM:SS format (so 01:38:23)
What I need to be able to do is sum this greater than 24 hours and keep the format of HH:MM:SS - ideally I need to do this in the form field that I'll be using to sum it.
I am struggling to change the format of 2013-07-29 11:33:03.6160000 to show dd/mm/yyyy
View 4 Replies View RelatedStarted working with access 2010
Have a text field in a form with following relevant properties:
Format tab - Format: Short Time
Data tab - Inputmask: 00:00;0;_
Data tab - Default value: =Time()
Goal: show a default but editable current time in HH:MM format
Behaviour: When entering form current time is displayed in HH:MM - problem is that when I enter field with the curser it automatically changes format to HH:MM:SS.
How can I avoid/control that behavior?
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?
I have strings with hours and mins i.e "1 hour" or "7 hours 30 mins" or "10 mins". how to convert it to timestamp hh:mm so i can caclulate the totals?
View 1 Replies View Related