Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Use Access queries to archive old data
- Chances are you regularly access only a fraction of the Access records that live in your system—so why not archive the ones you don't use as often? It's not only possible but simple to selectively archive your Access databases. Mary Ann Richardson shows you how. An Access database can...
- Tags: Microsoft Access, Databases, Microsoft Office, Storage, Mary Ann Richardson, Workforce management, Click Employees table, Click Yes, Termination Date, Termination Date field, termination, database, Microsoft Office Suite Access Tips Newsletter, Employees Table, Enterprise Software, Software, Data Management, Office Suites, Human Resources, Hardware
- Technical articles 2006-10-24
Additional Resources
- Access 2003 Auto Date/Time field
- I have two fields in my table one a Yes/No closed field and a date closed field. When a rep closes a case I would like them to click the Yes/No field. I would like access to then date/time stamp the record and record it in the date...
- Tags: sonya.d.pewtress@..., Yes/No, Microsoft Access
- Discussion threads 2007-05-08
- Date Field
- In Word 2000 if I open a saved document the "date field" automatically updates to the current date. How can I stop the automatic updating? It is sometimes crucial to have the original date on the documents.Thanks for your help.Use the SAVE AS command.Tried that. Still does not solve the...
- Tags: Microsoft Word, Word processors, Microsoft Office, Date Field
- Q&A 2006-04-12
- Help with Datediff function in MS Access
- Hi,I am trying to calculate the number of days between 'today' and a 'date of birth' field. In the field properties Default Value I am using =(DateDiff('y',Date,[dob]) where Date gives today's date and [dob] is my 'date of birth' field. However, this is not working. I get an error "(The...
- Tags: Databases, rajdeepsokhi@..., Microsoft Corp., DATEDIFF FUNCTION, Microsoft Access
- Discussion threads 2007-05-14
- DOWNLOAD: 10 useful MySQL's date and time functions
- http://techrepublic.com.com/5138-10585-5693575.htmlWhat other date and time functions do you find useful. [b]Provide examples like those in the download and we will add them for the next version release.[/b]What else would i like to see in this ?What i would like to see is a way to add time to a table...
- Tags: Mark W. Kaelin
- Discussion threads 2005-05-03
- Using an Sql query to update a date field in Access results in a US date
- I need to insert a date into a date field in access using VBA code, but when I do, it converts to US Format - i.e. 4th October turns into 10th April. All settings on my PC is in Aus locale. I have read posts about other users...
- Tags: Scripting languages, jdbee@..., Microsoft Access
- Discussion threads 2007-10-01
- Question on Calendar Control in Access
- In Access 2002, I design a form with a field called "starting date", and want to add a calendar control beside this field: when user select a date in the calendar control, I hope the field "starting date" will automatically set its value same as calendar control. And user can...
- Tags: Microsoft Office, Databases
- Q&A 2005-02-24
- Date and Time Field Types
- I am working with a database in which the administrator has made a Date and Time field as a "text" type field. Now when I want to define a "between" date parameter, in my query, it won't pull the proper information. The Field is displayed as shown:...
- Tags: Databases, kwis@...
- Discussion threads 2004-12-03
- printing the received date in ms outlook
- I would like to be able to print the received date/time from my received messages in ms outlook 2003.I can temporally achieve this by opening the received message and then going to tools - forms - design this form - adding the received field from the field chooser - ...
- Tags: Document management, steve.mills@..., received message, date/time, printing
- Discussion threads 2007-11-21
- Convert Julian Date to a regular Date
- I have an Excel spreadsheet that has Julian Dates. How do I convert the Julian Date into a regular date? For example 2005270 = 9/27/05. ORI have a dates (example '42001') that I'm trying to convert to a regular date 4/20/01. When I change the cell...
- Tags: cell, cheldt@..., date field, Julian Date, Julian Dates, Microsoft Excel, regular date, windows
- Q&A 2005-09-28
- cat v cable termination
- what is the color code for terminating a cat v male end termination?
- Tags: Workforce management, j.gladd@..., termination, cable
- Discussion threads 2007-10-15
- cat v cable termination
- what is the color code for terminating a cat v male end termination?
- Tags: Workforce management, j.gladd@..., termination, cable
- Discussion threads 2007-10-15
- Lotus Notes Developement question
- Greetings,Is there any way to refresh specific fields only?Actually I have two fields one Date/Time Editable named "Expire_Date" which is the expiry date of an equipment. And another computed field named Status. Now I want the Status field display "Expired" if the Date/Time field is passed from now. I used...
- Tags: Basir_Noutash@..., Expire_Date, IBM Corp., IBM Lotus Notes, programming, Status
- Q&A 2004-12-18
- Termination Proofs for Systems Code
- Program termination is central to the process of ensuring that systems code can always react. This paper describes a new program termination prover that performs a path-sensitive and context-sensitive program analysis and provides capacity for large program fragments together with support for programming language features such as arbitrarily nested loops,...
- Tags: Termination, Workforce Management, Human Resources
- White papers
- Use an Access function to add a new field to your table
- More precisely, you are Utilizing a Calculated Field in a QueryYou are not actually adding a field "Date Vested" to the Employee database you are just using the ability of the Access query to create a calculated field based on a field already existing in the table.If you added a...
- Tags: tcosmas@..., database, table, normalization, hardware, Microsoft Access
- Discussion threads 2006-05-30
- Validation of a date filed in MS access
- I wish to create a field to store a date of birth, however I do not want it to accept a date either after to day or more than 120 years ago.I know that now gives me the current date, and that I can set the validation between "a start...
- Tags: Microsoft Corp., f.budge@..., Microsoft Access
- Discussion threads 2007-10-12
- Using Auto Date Update in Word/merging
- I merge documents a lot in Word, but I have to keep typing the date, either in the data file or main document. I tried using the auto date update but the problem with that is it will keep updating the date even after the documents have been merged, which...
- Tags: Microsoft Word, suzanne_juszcyk@..., UPDATE
- Q&A 2006-07-25
- Formatting Date in MS Word
- I am trying to build an RTF template for XML Publisher I need date in specific format like dd/mm/yy or ddmmyy. I am trying to use Forms, Text Form Field, changed the type to date. ENtered a ddefault date and gave the format in the date format. But no Formatting...
- Tags: Word processors, Microsoft Office, Microsoft Corp., vidhyaprasad_99@..., Microsoft Word
- Discussion threads 2007-03-20
- Access date field
- I have a table with 3 fields.DateSubmittedStatusDateClosedDateSubmitted is set to date/time nowStatus has a drop down box to choose "Open" or "Closed"How can I have the DateClosed field filled to current date/time based on choosing "Closed" from the status field?I'm new to this so I'd appreciate any help,Thanks, JoeIf you...
- Tags: Joemede, Microsoft Access, programming, Status
- Q&A 2004-10-13
- Using the Year() function and updating another field in Access
- Hello,I am trying to do something to help users of a program I am writing. I want it such that the user finishes typing in the date, and when they move on to another field, it does the following:-automatically takes the date (in this case: DateCall) and breaks it...
- Tags: toddmehl@..., Microsoft Access
- Discussion threads 2007-04-01
- << Previous
- page 1 of 1
- Next >>