Over 1 million tech questions and answers.

Access Input Mask for Medium Date

Q: Access Input Mask for Medium Date

Hey, could someone pls use the input mask feature in Access and select "Medium Date" and also "Short Time" and tell me what the actual code is? My mask function isnt loaded on my computer and I cant find the Access disk...so I have to type the code in manually. Thanks so much...also thanks to the guy that helped me out with the Phone Number mask earlier today!

Preferred Solution: Access Input Mask for Medium Date

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Access Input Mask for Medium Date

Here ya go:


Read other 1 answers

Hi guys thanks for clicking in

A few problems, most of which shouldn't be too much trouble to you, I hope.

I've got the input mask for a field : >LL0\ 0LL;0;" " .. Ok so that's fine when actually entering data in the database as in actually physically in the table itself, but what I'm struggling with is that with the form I have created (and user HAS to fill this field in from the form) it won't give me the validation text, all the other input fields in the form work - just this one doesn't. I can enter whatever the hell I like and it will accept it and store it to the field in the table. So I'm wondering how you get the form to recognise the input mask and display an error ?

The other problem is so simple I don't really believe I'm asking it, for a field that should allow no integers of any type, it would be all char's right ? Well I originally thought you would do ...

Between "A" and "Z" ... turns out it's not that simple (I wish), anyone got the simple answer on how to make an input field exclusively char's only. (Form again)

Thanks very much for your time, no rush on this but it's essential that I get it sorted.

Cheers! Iron.

EDIT :: For the second part I also played around with LIKE for the input mask to see if i could get it to make it exclusively char's but to no joy lol.

P.P.S - Whilst I'm here in one thread, how do i got about printing out the databs... Read more

A:Input Mask - Access 2000

Try this for part 2:

I'm out of time to look up part 1.

Read other 1 answers

Is there a way in Access to hide only a portion of the field. For instance only show the last 4 of a SSN



A:Solved: MS Access Input Mask question

Read other 16 answers

I posted this thread last week, but didn't get any responses, so .... trying again.

I've tried input masks with/without the "!", I don't see any difference either way. The Help screen reads "Causes the input mask to display from right to left, rather than from left to right." Would appreciate somebody explaining its purpose.

Thanks .... Rick

A:Access - Exclamation mark in Input Mask

Rick, I didn't answer last week because I also couldn't find out what difference it makes.

Read other 1 answers

I've tried input masks with/without the "!", I don't see any difference either way. The Help screen reads "Causes the input mask to display from right to left, rather than from left to right." Would appreciate somebody explaining its purpose.

Thanks .... Rick

Read other answers

Hey, can someone pls use the input mask feature in Access for the phone number and tell me what the code is? My mask feature doesnt seem to be working so I will have to type it in manually...ghar! The proper format should look like this: (555)555-5555

For instance, to make things all caps you can manually type ">LL" in the input mask field and everything entered in that field will be uppercase. The ">LL" is the part I need for the phone number...

Thank you so much,

A:Access Input Mask Code for Phone #

How do you make a phone NUMBER uppercase?

!\(999") "000\-0000;;_

Read other 1 answers

Running Access 2010. I am building a database that requires a time field and I would like to make it as simple as possible for the user to enter the time in standard 12 hour mode. For 6:00 am I would like the user to be able to enter 6a, for 12:35 pm I would like them to be able to enter 1235p, etc. No spaces or colons to enter. I cannot seem to devise a custom input mask to do this. I am not very proficient at VB but am willing to try with some clear direction. Any help will be greatly appreciated.

A:Solved: Access Input Mask for Time Field

You could use
but might have to use 99:99:99 as a short time format usually has seconds
6:00 am would be 06 as Access assumes values less than 12 are am, likewise 12.35 is pm as 35 minutes past midnight is 00:35.
So in the table and form set the
Format to Short Time
Input mask to 99:99
and the
Default Value to 00:00

Read other 3 answers

I am trying to make an input mask for a MS access Database that will display the "MM/DD/YYY" characters in the field when I click on the field. Is there also a way of having the cursor start on the first character so the user can just start typing in the date information without having to move to the first character?

Thank You

A:MS Access Date Input Masks

Read other 6 answers

Need Assist to Find Available Rooms on Date Input using access query
I have attached a small access database, for which I'm trying to use a query to input a date and see what rooms
would be available on that one day at the different time slots when run.
Thank You for any assist. on this issue
John B

A:Need Help to Find Available Rooms on Date Input using Access

I'm no good at access but the query would be to loop through the room numbers on the chosen date and check the start and end time but I would not know how to do this in Access

Read other 2 answers

I'm not an Access expert, but I can use it fairly well. My problem is that I have an HR data base and I want to use an Input Mask for the last name field so that the user won't have to use the upper case. Well, of course, the input mask isn't good for that because we have many with two last names and suffixes and the mask can't address that situation. I've found some code to address this that was given out on the internet, but I don't know where to put it. Can you please help me with this? Thanks a lot.

A:Input Mask Doesn't Help

Read other 16 answers

i need an input mask and or validation rule

it should look like this[6:30 - 22:00] for example

both of the two time must be between 06:30 and 22:00
the 2nd time (22:00 in the example) must be later than the first time
there must be a dash between
my current input mask is ##:##" - "##:## and it works, so i guess i need a validation rule instead

please in christmas spirit

A:validation rule & input mask

nice smilies

Read other 2 answers

Hi. I'm and newbie and I'd like to set up a field's (ACCT#) input mask to change according to the type of account.
I have a table that lists the possible types (TYPE)
On my form I have a combo box that lists the available (TYPE). I want the input mask field for (ACCT#) to change based on the selection in (TYPE).
I'm not even 100% sure that I've created the input mask correctly.
These are the masks I've tried:
"0000/ 0000/ 0000/ 0000" and "0000 0000 0000 0000"
"0000/ 000000/ 00000" and "0000 000000 00000"
I've also tried the following code:
= IIf([Type] = "XXX", [ACCT#].InputMask = "0000 0000 0000 0000",
IIf([Type] = "YYY", [ACCT#].InputMask = "0000 0000 0000 0000",
IIf([Type] = "ZZZ", [ACCT#].InputMask = "0000 000000 00000",
[ACCT#].InputMask = " ")))
Private Sub TYPE_AfterUpdate()
If [TYPE] = "XXX" Then
[ID#].InputMask = "0000 /0000 /0000 0000"
ElseIf [YYY] = "VISA" Then
[ID#].InputMask = "0000 /0000 /0000 0000"
ElseIf [TYPE] = "ZZZ" Then
[ID#].InpuMask = "0000 /000000 /00000"
End If
End Sub
Any help will be appreciated.


A:input mask for credit cards

Read other 13 answers

I have an input mask on field (txt result) on form to allow only digits, input mask e.g. #99.
The problem is that the field datatype is text in the table.

This is field (txtresult) is reused on other forms to collect data that is also text - so I cannot change the datatype to number.

Problem is that they are able to add - or + in this field with input mask. Is this because it is a text field? Is there a way to change the datatype in code?


A:input mask for datatype text hat allows only digits in a textbox

I don't know what you're trying to do, and I'd hate to inherit it, but it sounds like the application's behaving correctly given the input mask

#99​The initial # accepts a space, a digit, a plus, or a minus. If you want a 1- to 3-digit unsigned number use

999​as the input mask.


Read other 3 answers

Tech Support Guy System Info Utility version
OS Version: Microsoft Windows XP Home Edition, Service Pack 3, v.3264, 32 bit
Processor: Intel Pentium III Xeon processor, x86 Family 6 Model 23 Stepping 10
Processor Count: 2
RAM: 1981 Mb
Graphics Card: Intel(R) G41 Express Chipset, 256 Mb
Hard Drives: C: Total - 39989 MB, Free - 5211 MB; D: Total - 36294 MB, Free - 8687 MB;
Motherboard: ECS, G41T-M
Antivirus: PC Cleaner Pro, Updated: Yes, On-Demand Scanner: Disabled

Hi All
Im using the attached vba code and would like to use the "title" format function to show the date of the day in the User Form, is it possible and is there any help on this matter.

Thanks in advance

Read other answers

I need to create an input mask to force the person entering data into my access database to enter 4 numbers for the post code. I also need the 'Post Code' column in the table to display four zero's by default. I've tried entering 0000 as the default value and tried changing the 'Data Type' from Text to Number but to no avail. I'm really only a noobie when it comes to Access so any help would be appreciated!

A:Solved: Input Mask for Post Code (Zip Code)

Read other 6 answers


We're using a main DB in which the data of a field data is stored as e.g; 00.00.00 000-00. Other DB's are linked to that one and are retrieving selected records (by user) of that main DB.
When the DB's are retrieving the data, the imput mask is automatically transferred too. Is there a way to make that the number is imported as 00000000000 and not with the imput mask?


A:Solved: Access imput mask question.

Read other 16 answers

I am using the "microsoft access date/ time picker" control to pick dates. These dates like termination date of a contract will end up in the database. The problem I have is that when I do this,

rst!dateIntoForce = Me!ActiveXCtlDOForce

I end up with this in my database:

1/6/2003 5:48:43 PM

How can I extract only the date part from "1/6/2003 5:48:43 PM" so that only


goes into the database

A:Date Part only from MS Access Date picker control

Format the date before it gets entered into the db. Format([Date], "m/dd/yyyy")

Read other 1 answers

Hi there

I know how to do add a criteria to a Query. For example in the QBE pane in design view in the criteria row I enter this statement: Between [Start Date] And [End Date]. When I open up the form that is bound to the query, a message box pops up and I enter the required dates and I get the required data that is between the dates that I specify. However, I'm now finding out that this method is now becoming a nuisance.

Is there a way that I can have 2 unbound controls - one for the start date and the other for the end date in a criteria form. This way I input the dates I want for a particular customer and the form with the required data shows up. For example, I have already developed a criteria form for customers. I have an unbound combo box control that has customer names and when I click on a particular customer name, all the data for that customer is displayed in a form. In the row source of the unbound combo box control there is a SELECT .... FROM ... statement. I also have a button next to the unbound combo box control that opens up the form for that particular customer. Now I want to add two more Unbound controls in the criteria form, one for Start Date and another for End Date.

This way I can select a customer from the customer combo Box, select the start start date from the start date combo box and the end date from the second combo box control and get the desired data for that particular customer between the specified dates. I have attempted to do this bu... Read more

A:Access - Start Date and End Date in a Criteria form

Mario: What you want is called a query by form (QBF). I don't know how to do them myself, offhand, but here's the MS Technet article:

Read other 2 answers

I have a Date/Time field that I need converted to just a Time field.

It comes back with 2/11/12 0:00:00

I need just the 2/11/12

I thought about changing it to a text field but I think there will be an issue with the month because it does not bring back a 0 in from the months with only 1 digit.

This table that I am creating is being sent to a txt file and that is where I see the issue. It looks good in Access, but not the txt file.

Any suggestions?

A:Solved: Access - Convert Date Time to Date

Read other 10 answers

Hello, I use online accounting software (KashFlow) and part of entering invoices involves clicking into a date input field.  It is one of those where a little calendar shows when you click into the field.  You can also manually type a date into this field too. However. On my brand new Yoga 920 using Chrome and Firefox the date input fields are greyed out and a red 'no access' icon shows when you hover over them.  But you can still click it and the calendar pops up as normal.  The only difference is you can NOT type into them anymore. When the source for the page is viewed it looks like the fields have been designated 'readonly'. There is no such problem on any other computer I own, even when using Chrome or Firefox.  The date fields work perfectly well on these other computers - even on a Sony Xperia tablet I own. The only browser that works properly on my Yoga is Edge.  The date fields work as they should.  It's just Chrome (my main browser) and Firefox where they don't work. This seems like a Lenovo-based problem.  A little Google has revealed a couple of similar problems with other Lenovo users. Does anyone have any clue on how to fix this?  This is utterly bizarre behaviour and it's preventing me from working properly. I have attached a photo showing the problem when using Chrome.  These fields should never be greyed out. Thanks,Matt

... Read more

Read other answers

Need Assist to Find Available Rooms on Date Input using access query
I have attached a small access database, for which I'm trying to use a query to input a date and see what rooms
would be available on that one day at the different time slots when run.
Thank You for any assist. on this issue
John B

Read other answers

Hi there. i have some problems need helping.
1. My keyboard cant properly type in " without me inputting another input. so everytime i wanna type in " i need to click space just to make it appear. how do i make it normal?
2. My date and time keeps changing and its kinda annoying since it makes me lose track of time quite a lot. its already set to automatic internet time, but it keeps changing still. i keep changing it back, resyncing and stuff. any idea on how to make it stop?

A:Keyboard delay input and date time keeps changing.

You may have a malware. I'd do a complete scan using

The free version has the same scanner as the paid.

Read other 1 answers

Hey guys. For some reason, my IE won't let me go to security level medium low...I want to try that out, because I'm having trouble with javascript and flash. I've done some java tests and I am 'enabled' yet some sites, such as weather.com, say that I am not. I also have trouble loading java links - in the bottom corner i get the "javascript: void(0);" I'm using windows XP and IE 6 with windows service pack 2. So if anyone knows why I can't go lower than medium on the security settings please tell me - and how to go lower. any help at all is appreciated. Thanks.

A:security settings -= medium/medium-low

Read other 6 answers

I'd like to create an input form similar to the form called "TestForm" in this database. I think a single line, where the user selects a manager from the MgrName drop down above, and fills in CfDate, CfValue, CfTypeId, and CfNote below. The input form should know the MgrId because its linked in from the dropdown.

I'm learning as I go here, so I'm really looking to understand what I'm trying to do. And if I'm going about this all wrong, please let me know. I think I need to create some sort of append query, and create a form similar to the one I created called TestForm. Is that right, or am I misunderstanding conceptually what I am trying to do here?

Any help you can provide will be greatly appreciated.

A:Access Input Form Question

This is how I would do it.
Note the Master Child Link between the 2 forms is the Manager ID.
I have also removed the existing key fields from the Subform's table as it would make partial data entry impossible and added an Autonumber key field instead.

Read other 3 answers

I have build a table in Access 2000 with several fields including "Part Number" and "Serial Number." I am trying to input these numbers using a bar code scanner. Once the numbers are entered, how can I automatically go to the next field? Both values vary in length and format. There is no standard format for either number. Here are some examples:

Part #'s


Serial #'s



A:Barcode input in Access 2000

Try doing it with a form, it will either work automatically or you can code the part number's textbox's "Afterupdate" property with:

Read other 1 answers

Does anyone remember the command/code to let you input the "criteria" for a query in Access?

Like I want to be able to input the date-range so I don't have to either edit the query each time, or write different queries for each range. I used to do this (and know how) but I'm drawing a blank today (it was one input for each end of the range, and I had modified the field to show date values as "200800205" rather than "2008-02-05" kind of thing).

I've got another field with values between 1 and 99 that I need to specifically select for, which should work the same way.

I just don't remember how to write the code?

Any help here would be hot!!!


A:ACCESS input control question

Read other 10 answers

I am using MS Access 2002. I have no experience at all of Access, but am quite good with Excel.

I have been asked to create a database that alot of people in our company will be using. The best thing would therefore be if they could access an input form and a search form, but nothing else. The database looks like it is going to be quite complicated so i'm trying to understand the basics and take it from there.

As there will be lots of separate tables getting data added to them at the same time, i was unsure if the best way would be to use subforms or unbound controls. I had a look at master and child fields but i'm floundering around in the dark. I have most of the tables made, not too sure about queries and the forms are just giving me an ulcer. I have a rough idea of how i would like the finished form to look from creating a userform in Excel, but i can't even do the basics in Access.

I have attached a dummy database and would appreciate any comments on what the best way to populate all the tables at once would be. It will have the Department, Surveyor and Salary. How would i update the relevent tables at the same time as some parts are dependent on each other. And would it be better to do a large project unbound or using userforms (fiddly things to move i've found)

All comments and advice are most welcome.

A:Access - Beginner's Input Form

Read other 16 answers

Hi All.

I am flying off to Florida tomorrow morning, but wanted to leave some of you Access guru's access to a database I worked on, and now have to figure out how to add something.

You can download the database here.

What I am trying to do is create an interactive Product Listing.

From Switchboard, access"Enter/ View Orders by Customer"

and on the screen that pops up, at the bottom there are several buttons. One is for Product Order. First thing I would like to get rid of, or have automatically found, is the Shipping fields that pop up wanting to be filled. You can leave them blank.

Now we have a Report that lists the Client information, and then a Product listing. What we would like to do is to make this into a Form, that can be interactive with the rest of the database. Basically, we would like to enter the order information through this Form, and have it capable of filling in the appropriate tables, etc. Orders would be placed within the Color columns, and tallied to the left of the Product Name. That total would then carry over into the Orders by customer, etc.

Any assistance by y'all is not expected, but would be most appreciated. This is not my job, and I haven't the necessary knowledge, or time to sort this out. I'm positive I could tack something together at some point, but I'm hoping one of y'all will be a little bored, and feeling extra helpful.
When I get back on the 23rd of October, I'll check to see if anyo... Read more

A:Access 2000: Input on Form

Read other 8 answers

I have an Access module that opens an Input Form. Is there a way to add code to the module to center the Input Form on the screen?

A:Solved: Access Input Form

Read other 16 answers

I have created a simple Access database for home inventory. What I want to do is have an input form, and when you're entering information on an item, there will be some kind of control to add a picture of the item (basically where you can click an icon, then you will have a dialog box open to your hard drive and you can drill down to an image and have it added to the database as a field). This will then tie the picture of the item to the proper information. I hope I didn't confuse anyone, and any help would be greatly appreciated.

A:Access 2002 Using images as input data

Hi, Boy. Welcome to TSG.

I strongly advise AGAINST storing pictures in your DB. You will end up with it all bloated--electronic DB size too big too quickly. However, to do so, you need a field in the table with type OLE object.

On your form, you can right-click it and hit Insert-Picture.

See www.theofficeexperts.com/downloads.htm and check out the MyPictures DB (free download). There, we don't store the pictures in the DB, we just link to them...

Read other 2 answers

I am working on a project in Access and would like to know how to query the user for data input. Right now I am using a query with a [] criterion (e.g. [Enter the date of interest]) as data for the report but then I must have a different query / report combiniation for each situation (Example: "Show the results for all dates" compared to "Enter the date of interest"). This means I have two reports to maintain and keep identical, etc. I notice the report has a filter parameter but am unsure how this could change values in the same report.

Is it possible to do this in VBA where the same report is brought up either with or without a limiting "where" clause in the VBA command? It seems that I can put a message for the user to the screen with a msgbox but then how do I capture the response? I have looked for an analogous situation in the Northwind database but maybe I've missed it.

A:Solved: Data Input from the Keyboard in Access VBA

I'm going from memory here, but I have a question: is this query populating a report or form?

If you're going straight to a report, in the On_Load, you could prompt the user with a message box, saving the value they enter as a string variable

strMyVariable = Msgbox("Enter date, use this format mm/dd/yy", etc.)

then use an if then else to determine what to return:

if strMyVariable = "" then
strMyQuery = "Select * from myTable where Date = " & strMyVariable
doCmd.openreport etc, etc, strMyQuery
strMyQuery = "Select * from myTable"
doCmd.openreport etc., strMyQuery
end if

I can't remember the exact position where you need to place your strMyQuery, but this should get you started.

Hope this helps,


Read other 2 answers

Have a very strange problem with an Access 2000 input form. The form has a name-find combo box on it that allows users to enter at least part of a name and after hitting enter, the record for that person is displayed. BUT. . . we just discovered that if you enter a name with an apostrophe, like "O'Reilly", it bombs. Get error message that asks if you want to debug. You say yes, and the module reads like this:

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

Set rs = Me.Recordset.Clone
rs.FindFirst "[LastFirst] = '" & Me![Combo205] & "'"
Me.Bookmark = rs.Bookmark
End Sub

The line starting with rs.FindFirst is highlighted when the debug module opens. When originally written, that line did NOT have the & "'" after it. That happens after you try to search on any name with an apostrophe.

Anybody know what the H*## is going on here?

A:Lookup combo box on input form in Access

Read other 12 answers

Hello Everyone!

I have a field that has Days (Ex. Monday, Tuesday etc...)

Is there a way to turn this Days into a nearest date coming up. So for example if i have Wednesday on the field as a value and today is tuesday... I want the date for tomorrow displayed.

I have been doing research but I cant find anything. I have found the opposite but it doesnt do me any good. Thank you very much.

A:Access 2007 Day To Date Help

Read other 16 answers


Wondering if someone could offer some advice on an Access question.

I have three date fields in a table and I want to return an Approved/Unapproved in another field within the table based on these dates. I'm not really sure how to do this.

If I were to write out what I am trying to do, it would look like this...

If today's date < 60 days of DATE1, and < 365 days of DATE2 and DATE3, then put APPROVED in the approval field
Else put NOT APPROVED in the approval field.

Could someone help me with the syntax for this?

Also, where do I put this syntax (ie in the approval field of table?).

Thanks in advance


A:Access Date Question

Read other 14 answers

Hi.. as you can guess I am not that good with access. I have done a data base and what I want to do is search by a time period.
example. I have 5 pieces of data 3 in jan two in feb I want to show only those pieces of data in Jan .. How do I do it. One of the variables in the data base is disptached date which is a pre set date.
Can i set up a data critera where it will ask for a start and end date for the search and show only those pieces of information.

Also. while I am on. another search I am in need for is. I have created a order book and what I would really like is for to print out a report that will show by date ( as above) but only showing orders acepted and not just quoted for or visa versa. when I do a quote there is a box for their order number and a box for quote date is there a way of making access check to see if there is a varible in that the order No. box and if their is to print it out IF its in the date range as well.??


I know it is asking a lot. but that date range search would be very helpfull and I know if anyone can help you can.. thanks

A:date searching access 97

You might try posting your question on http://www.wopr.com/cgi-bin/w3t/wwwthreads.pl too. It's specifically for MS Office Applications and has a category for Access.
Edited to fix link, hopefully this is what you wanted

Read other 3 answers

In Access I want to view all the records for one week. I was hoping this would work. "Between [Enter Beginning Date] and [Enter Beginning Date]+6" What am I missing? The goal is to only have to enter one date.

A:Access query date

mcookaz, it is better to use a form to either enter a date or select a date from an ActiveX calendar, you then use
Between forms![Formname]![Enter Beginning Date] and forms![Formname]![Enter Beginning Date]+6

It can be used on as many queries as you like as well.

Read other 1 answers

Sorry to bother you guys again, you must hate me by now.

I have attached an access database which explains what i need.

I hope im not bothering you too much.

Thank you

A:Another access date problem :(

Read other 9 answers

Am trying to autocalculate a field in a form.

The field is a sum of a frequency (in months) plus a date.

(ie: I want a date for the next car service due: first field = service due every xx months + second field= last service date).

How do I add a figure in months to a date?

I have had some results by entering a short integer in the first field but it adds the number to the date in days only. I need to have the number added to the months and not the days.

appreciate any assistance that I can get.


A:MS ACCESS 97-- help with date calculation

Read other 7 answers

I want to automatically list the date everytime I open up a particular access record. I know how to do "Now()" and this works fine for long dates but i want to list
#1: SHORT DATE (Jan 23, 2004)
#2: MONTH ONLY (Jan 2004)

Its a database to track phone calls and I need want to be able to quick list them as to date called and month called in a report.
Steve Passmore

A:Access Date Macro

It isn't entirely clear what you are trying to achieve. What I don't know is what field(s) currently exist in your table/form for date...

For the sake of argument, let's say you have a field that contains the date the call took place.

You can have that field on a report or form as many times as you want (make sure only one of them is editable) and each one can display the data differently: one for input is straightforward Short Date, the next one, in the field's properties>format, you could put "mm yyyy" (without the quotes) and make this one non-editable, and it would give you the Jan 2004 view.

In a report, though, you can control how you view records by "grouping and sorting".

Hope this makes sense,


Read other 1 answers

In access 2000 I need to find the length of stay for residents of a facility as of aug 31,2002
My field is adm_date (date of admission to the facility)
What is the best way to do this

A:Access Date Calculation (Down, where are you??)

Read other 9 answers

I am trying to build a table with a date expression in a field relating to another field.

In the help file it gives an expression of "=DateAdd("y", -10, [PromisedDate])" as an example.

I have added this to my table under Default Value and changed it to "=DateAdd("y", -84, [WithdrawalDateFrom])" which i think gives me a date 84 days before the date in the field Withdrawal Date From.

However, when i go to save it, it says that it can't find the field WithdrawalDateFrom.

Firstly, can you explain what the "y" is in the formula, as it is the only part that i don't understand, and also can you explain to me why it doesn't recognise the Field, that is very plainly there.

Thanks in anticipation


A:Access date expression HELP PLEASE

Read other 7 answers

I'm trying to run a simple query in access using VBA to construct the SQL. My problem is that on a BETWEEN...AND part i'm using a date which is in dd/mm/yyyy. As will be obvious to some this causes problems with VBA using US date format. So I thought the following code would work, it doesn't

Dim strDate As String
If DateCheck = True Then
strDate = " "
Else: strDate = "AND tblWholeOrders.Date BETWEEN #" & Format(Me.DateFrom, "dd/\mm/\yyyy") & "# AND #" & _ Format(Me.Dateto, "dd/\mm/\yyyy")& "#"
End If

It gives error 13 type mismatch

A:Access SQL Date problem

You can get an error 13 type mismatch by using DAO when your Access is set to use ADO.
But I would run the query using the original format and then display it in the format you prefer in a report or form or whatever.

Read other 1 answers

I want to have the last access date listed for all folders in XP Home SP3.
I can do this using one of the methods listed in the closed topic
Solved: Last Access file date attribute worthless? http://forums.techguy.org/all-other-software/865800-solved-last-access-file-date.htmlClick to expand...

which includes the reply copied below.
But how do I apply this method to all folders, as in the many subfolders in some larger folders?
Using the method below works only for the folder being specified. To do this for all folders and subfolders would take hours.



Computer Specs
Trusted Advisor with 8,864 posts.

Join Date: Aug 2007
Location: Oregon, USA
Experience: Intermediate
04-Oct-2009, 02:25 AM #3
In Explorer/My Computer:
Click View | Details
Click View | Choose Details...
Place a check mark in front of Date Accessed
Or, from a Command Prompt, navigate to the folder containing the file
Type Dir /TA Filename.ext
or from any folder type the complete path to the file:
Dir /TA "D:\My Folder\Filename.ext"
To sort files in a folder by date accessed:
Dir /TA /OD

Don't forget to use quotes if the filename contains spaces


JerryClick to expand...

A:Folder access date

Hiya Robert.

At the top of any open folder and after making any changes you want to, go into the Tools drop-down menu and click Folder Options. Now click the View tab and at the top, there`s a button to `Apply to All Folders`. Is that what you`re looking for ?


Read other 1 answers

I am having trouble with a date range in a query. What I want is to have a permenant starting date (1/7/94) and the ending date to always be "todays date" (ie the date the query is being run). Is this possible and if so how do I do this. Thankyou

A:Access Date ranges

Set your criteria for the relevant field to:

Between #01/07/94# And Date()


Read other 1 answers

Hello, I have a database used for projects. Im creating a query that has dates that the project where open and closed and when they should be done. What i would like is have the query ask for a date range. For example, when i run this query i would like to beable to put in 1/1/2007 to 1/30/2007 and have it show me just those records. Now the thing that is stumping me, is in the table the open_Date field has the date and the time, so is shows up 1/1/2007 10:31:21. How could i get the query to do this, I have tried a few thing but my query comes up empty. Thanks for any help

A:Date question in access

Chris, see my email.

Read other 2 answers

Hya folks,

I need to enter a date in a table in access, however instead of using a normal input mask of DD/MM/YY I'd like to use the format DD.MM.YY as this is in line with the date format of all our bespoke software.

I've tried editing the input mask list to no avail. I'd like to keep the field as a date/time field as we need to do queries using it.

Any ideas gratefully recieved .



A:Date Format in Access

Read other 7 answers