Hi all,
I have a table that has a long date format for example 05/05/05 02:40:34 AM how can I add an 8 hours to the date and time. Please help if you can because I"m going nuts!!! thanks. I want it to look like 05/05/05 10:40:34 AM
the source table needs to be formatted as short date...my form is pulling data from a query and I would like to change the row source of my combo box on the form to be formatted in long date. row source is as followed
Code:
SELECT [qrydateSUM].[day of event] FROM qrydateSUM ORDER BY [day of event];
I have tried this with no luck
Code:
SELECT [qrydateSUM].format([day of event],"long date") FROM qrydateSUM ORDER BY [day of event];
also changing the format option in combo box doesn't work...im thinking to add a day column to query...but there has to be a way to change row source
I have recently upgraded my Access 2003 application to Access 2010. I am running into a problem when formatting a textbox to 'Long Time' that is linked to a Double type field. The error that I get is 'The value you entered isn't valid for this field. You may have entered text in a numeric field or a number that is larger than the FieldSize setting permits.'
The textbox is linked to a field (double data type) and displays as the time in long format (4:06:17 PM). When I try to change to 4:07:17 PM I get the error. I tried removing the 'PM' and the colons but the error still occurs. The only way that I can get it to work is if I use a double value (0.735405092592593). In Access 2003 the time value would display properly, allow me to change the time and then save the time as a double to the database.
Hi people,
I could do with some help,
I have a combo box which holds a list of times which I have entered in it.
eg. 08:00, 08:30, 09:00 09:30, 10:00
I have set the format of the combo box to be short time 00:00
However, when I move the value that has been selected in the combo box to either an sql query or a text box say...
Me.txtbox1.value = me.combo.value
When the value is transferred I get a long looking time like this 08:30:00
Can anyone tell me why this is happening and how I can get it to just appear as a short time like 08:30
Many Thanks
Jay
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 a list of dates in the mm/dd/yyyy format and I am looking to get it into the fiscal format of yyyyww. I am able to do this with the datepart and format functions, but I need to make it so that the fiscal month begins in January but the first week starts if there are three or more days in the week. For instance if Jan 1st is a Friday then this stands as the first fiscal week, if it is a Saturday then it does not count as the first week.
datepart and format functions have the Use the first week in the year that has at least 4 days for the firstweekofyear option but I need it where it has at least three to make it work.
Using access 2010; i have a form that includes a date field. Is there a way to force the user to only choose a month end date? When the user clicks the date from the popup, they may use 9/1/2013 when the mgr. want them to use only 8/31/2013. I am thinking validation field to put a msg but want to be able to force it not the option.
View 2 Replies View RelatedI have a date and time stamp in a Date/Time field of General Date format (3/1/2006 7:52:25 AM).
I wish to select query on the table's Date/Time field by date portion only (3/1/2006) and not include the time portion (7:52:25 AM) of the field.
Using this expression in the query's criteria - "Between [Enter Start Date: (MM/DD/YY Format)] And [End Date: (MM/DD/YY]" will not return the date ranges as desired without also typing in the full time string.
How can the date integer be parsed out and the query properly expression ed on the criteria field without using VB?
On my report, I want rows with expired dates to stand out by having their borders thicker. Something like:
Code:
If Me.txtDate < Date() Then
Me.txtDate.BorderWidth = 6
End If
When I do that, it ends up formatting every txtDate field in the report if one of them passes the If criteria instead of only ones that are expired.
I have a training database in which I want to make a text box that data only needs to be entered once for 50 records (not once for each record). But I need to include the information from that box in a form that is already getting its info from another table. When I try to do this with a second table I get this- #Name. And if I include the needed field in my query I'll have to update each record rather than just one time. I have a different database that does this, but I inherited it from someone else, who locked out design view, and I can't contact him to find out how he did it. PLEASE HELP!
Thanks,
Scott
I do not know if I'm shooting for the moon here (I haven't seen anything like this yet). I have a database that keeps track of different flights for screw conveyors. The part number on these flights are based on many fields in the database, with a couple characters that aren't. I am trying to make a validation rule that checks to make sure the feilds that are a part of the Part Number match up, or if there is a way to have it auto-fill everything except the 2 characters that have to be entered manually. I don't even know if what I'm saying makes sense (Story of my Life).
Thanks to anyone who can help, and those who wish they could.
-Brian
im creating an error reporting database.
for this the hardware/system items need entering
they will have a unique id
to assist identification i would like the unique id to start with a 3 letter code refering to the type of hardware/system/periferal followed by the number
e.g a printer will ahve the id "ptr 00000" and a computer will have the id "cpu 00000" with the 3 letters automaticaly comeing from a combobox field in the same table (form to the user)
i have allready been able to get autonumbers with 3 letters before when i created the tecnitian id they are "TEC-00000"
any help thanked. im an A2 student so i know all the code stuff.
thanks in advance
Jimmythemadman.
I have an insurance policy database keeping track of insurance policy details for household and commercial shops and businesses.
Tables I have are tblPolicyHousehold, tblPolicyCommercialS (Shop), tblPolicyCommercialB (Business).
They each contain the following fields (the other fields they contain aren't relevant to this)... SumInsured, extCover1Desc, extCover1SumInsured, extCover2Desc, extCover2SumInsured, extCover2Desc, extCover2SumInsured
I want write a query to list all the policies with the building sum insured. Easy enough... Heres the catch.
In some of the extended cover fields it will say in the description...
"Building of 123 AnyStreet" so I want to get the value of that extended cover item where the description for it contains building...
So I want to get extCover1SumInsured where extCover1Desc LIKE "*Building*" and adding that value to the SumInsured field...
Any ideas?
I have one query that shows a NAME for each day.
Every day each NAME must have one and just one SITUATION.
So I'm trying to make a query that shows which have NO SITUAITON yet and other that shows which HAVE A SITUATION already.
Hi All,
I have attached a file which I need a help from, I need the subform to be populated based only on the Employee Code and the Dates where the employee logged-in a Job Order.
I dont have any code on the cmd button for I am lost on what will be the query statement to update the subform datasheet.
Thanks.
In Access 2003 we use an mdw file (unfortunately named system.mdw) that people are joined to (by using Workgroup Administrator) when they become a new user on the system. This works well except that it is time consuming to go through the process for every new user. I am aware that you can create a new mdw file using the user-level security wizard however I have extra problems. This was set up originally when access 97 was in use and the no of users was about 4, there are now 50 plus and growing. We have numerous databases that are all secured through the use of the same mdw file, however as people are only joining this mdw (by using the Workgroup Administrator), when we get someone with a little computer savvy they will figure out that by creating a generic system.mdw file they can escape all security levels that are in existence in the system.mdw file that we want them to use.
Is it possible to somehow get a database to associate itself with an mdw after the mdw has been extensively modified?
I am aware of short cuts that have the mdw file in them but they are easily bypassed. Furthermore as we have numerous probably 100 databases all pointing at the one mdw file is it possible to get them all associated with the same mdw file? I have looked through the forums and various others but have not found an answer that will help me. Can anyone help?
Hi all,
My boss has asked me if I could take a look at the following problem and whilst I've searched around and tinkered with it myself I'm not making too much progress!
Here is an example:
I have forecast data for working weekdays Mon-Fri. For the weekend I need to replicate data from Friday across the Sat/Sun rows. This is just outside my remit! The data is then exported to Excel where imbalance costs etc. are calculated.
Background: The result will be that management will be able to tell what value *weekend* work will have. At present I already have a set of results for all DF activity. If we take that figure and subtract THIS result we'll be able to see how much benefit working on the weekend has.
Something management are very keen on looking into :)
Any suggestions on where to start would be much appreciated.
Thanks.
Ok, I have a table that contains a number of yes/no fields depending on location.
There are two main parts of my db that use this, one is users (for their departments) and the second is changes (for secondary locations)
I want to have two fields in the table used to reference a set of locations. Meaning i can reference the table and get locations where userID = 3 or alternativly where ChangeNumber = 6
Can somebody help me in making this work. Im currently having issues with duplicate values etc
Hello all:
In table 1 I have some document #s
e.g.
320
321
322
170
171
172
151
152
In table 2 I have some document #s e.g.
170
171
151
I would like to create a query, that will look at the document #s starting with 17* and 15* in table 1 and look for it in table 2, if the document #s do not exist, I would like the query to spill out the following:
320
321
322
172
152
Is this possible?
Thanks so much in advance for helping!
Hi all - I am not sure if this is even possible, but I know if it is someone here will know how to do it. I have a table with a list of dogs names. The dogs run in a team so I have another table with their run record. Currently, the form would have a text box where you select the dog's name and then another text box where you select the position in the team so it looks like this:
name1, position1
name2, position2
and so on. I would like to create the form where the text boxes are aligned to look like the team and the person would just have to select the dog's name that ran that position and the code behind would create a record that looks like the one above. For example, here is what the form would look like:
Position1 Position2
Position3 Position4
Position5 Position6
I would like the person to be able to select the dog's name in the text box labeled Position1 then move on to select the dog's name in Position2 and so on. I am imagining the record will still look like the one above. Meaning,
name1, position1
name2, position2, and so on.
Does anyone know if this is possible? Thanks so much for all your help. This forum has been so helpful in the past, I thought I would just put this out there.
Therese
I'm probably approaching this wrong, as I'm definitely out of my depth - maybe someone can offer some advice
I have 2 spreadsheets. One is a simple parts list with a code and some other info - I've loaded this into Access no problem.
The second sheet is used for ordering - it contains one text field with a company name at the top, followed by a list all in one column of all of the item codes, and another column with a description, and a third column with an x in against each item being ordered.
What I would like to do is set up a new table with the company name, and then each of the item codes which have been selected (there will always be a maximum of 10 ordered so I envisage a field per ordered item code).
I haven't got a clue how to do this - Can anyone help?
I can then link the two tables and print a report - I could probably do this bit.
Thanks for any advice
Hello Everyone :D :
I have a reporting interface providing users with a multitude of reporting options and capabilities. One aspect involves utilizing the ability to allow users to save their settings on the interface due to the number of options provided. One of the aspects revolves around working with listboxes.
Each listbox is pre-loaded every time with a list of items from a master table pertaining to the listbox. The user selects their desired choices, saves*, etc...Once loading a setting, I'm looking to have the listbox pre-loaded (easy) but then auto highlighting the items selected or rather pulled from the user settings table (each listbox has own table for user saving of options). So, if a user selects items Alpha, Beta, Delta, and Falcon from a list of 100 choices, then those 4 items would be saved under that user setting, within the code table (user specific). When they load the setting back onto the user interface, it should pull the 100 choices and auto highlight the 4 items. Hopefully I've explained that properly.
*A user is able to save, save as, load settings, unload settings, etc...from the reporting interface. When a user saves settings, these settings are saved within the user settings tables. Each table varies depending on the nature of the values within the reporting interface. Listboxes have their own tables connected to the primary settings table.
Any ideas anyone? :rolleyes: :D
The date format from one of my access tables is as follows:
11051977
9101978
and I need to amend to following formats within my select query:
11/05/1977
09/10/1978
I have tried using formula:
Date of Birth: DateValue(Mid([DOB],7,2) & "/" & Mid([DOB],5,2) & "/" & Mid([DOB],1,4))
that results in an #Error messages
Can anyone help?
Thanks
Hello
Can someone help format the date correctly? I'm currently linking a flat file in access and then creating a table afterwards. The date comes in the following format below:
i.e. 30102006 - txt type
I wanted the date to look like - mm/dd/yy. Thanks for the help.
I have a date field in my table and my computer date is set as a custom long date, if I enter 24/2/07 in my date field when I press enter and move to the next field it is displayed as Saturday 24 February 2007 but when I select the date field again it reverts back to 24/2/07. I include the date field in a merge with a word document and would like the date displayed as Saturday 24 February 2007, but the merge is displayed as 24/2/07. Can anyone help with how to merge the date as Saturday 24 February 2007?
View 4 Replies View RelatedHello,
I have two pc's, both with Windows XP SP2 and Office 2003 SP2 (dutch) and the same input locales. I made a program in Access (connected to a MS SQL Server) where dates are stored. Now I want to built a report with a daterange. Because of the dateformat in SQL I made a function to convert the date because they enter it in Dutch format. The function is:
Function DatumSQL(datDatum As Date) As String
DatumSQL = "#" & Format(datDatum, "mm") & "-" & Format(datDatum, "dd") & "-" & Format(datDatum, "yyyy") & "#"
End Function
This works great on computer 1. But not on computer 2. On the second computer the date is converted again. When I don't use the function it works fine on computer 2 but not anymore on computer 1.
I searched for differences and found that on computer 1 the files in the map C:Program FilesCommon filesSystemado are from 3-8-2004 and on computer 2 they are from 2-3-2006.
How can this happen? And what is the solution?
I hope someone can help me.
Thanks in advance.
Benno