Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- I Don't have any experience with M$ Project, but...
- ... I've done a lot of things with VBA on Access, Excel, Word etc. The best way to get yourself un-lost is to record a macro of whathever you want to do:- Tools/Macro/Record new Macro...- change dates, color or whatever- Tools/Macro/Stop RecordingThen you open the VBA editor (Tools/Macro/Visual Basic Editor),...
- Tags: emil.hovsepyan@..., Finish, ms project, Start Date, VBA, windows
- Discussion threads 2005-11-10
- Access 2000 Date Validation
- Ok, so this is my problem.First, I am building a database in Access and using a form built in Access to add records. I am trying to do a form level validation with two date fields, a start and an end date. I don't want to force the validation at...
- Tags: Databases, DATEDIFF, end date, start date, Microsoft Access
- Q&A 2005-06-13
- Build Your Skills: Using class modules in an Access database solution
- After being hired to develop a solution to capture a client’s human resources data, I decided that, based on the size of the company and the client’s needs, I would use Microsoft Access. The database application supports Visual Basic and has the ability to link to COM objects, which provides...
- Tags: class module, database, Evan Stein, Microsoft Access, Microsoft Visual Basic
- Technical articles 2003-02-24
Additional Resources
- writing access code
- I am trying to write an expression for a query in an access database that tracks the number of restricted days injured workers have during their wc claim. I have a start date and an end date, i have had success counting the days with the datediff function, however I...
- Tags: dgearheart@..., Rest Duty Start Date
- Discussion threads 2007-11-08
- 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
- Tray Date (zip)
- Tray Date is a very small program that displays the current date in an attractive tray icon. You do not have to set the date. The program gets this information from your computer's operating system. Tray Date is a desktop enhancement and will auto start when you start windows. No...
- Tags: Tray Date, Desktops, Spyware, Spyware, Adware & Malware, Hardware, Security
- Software downloads 2006-06-02
- Titlebar Date (zip)
- Displays the day of the week and date in the titlebar of the active window. You do not have to set the day or the date. The program gets this information from your computer's operating system. Titlebar Date is a desktop enhancement and will auto start when you start windows....
- Tags: Window, Titlebar Date, Construction, Desktops, Spyware, Hardware, Security, Spyware, Adware & Malware
- Software downloads 2006-06-02
- ADODC1 syntax error in query expression
- Hi I am getting the an error stating syntax error in query expression 'start date LIKE '2%". The code concerned lookes like this: Adodc1.RecordSource = "Select * From projandpro Where start date LIKE '" & Text5 & "%';"Can anyone help me modify this code so that...
- Tags: syntax error
- Q&A 2006-09-02
- MS Project
- Can we assign the same resourceManpower for different tasks of same start date & End Date. I tried this thing by levelling but the date gets shifted. Even the cost get doubled. Thanx
- Tags: yogeshmaney, Microsoft Project, Microsoft Corp.
- Discussion threads 2007-07-24
- Date Range for ORACLE
- what is the Min/Max of the Date Range for ORACLE.What is the Month Day and Year ORACLE starts its clock?What is the Month Day and Year ORACLE ends its clock?To my knowledge there is no Start date or End date in Oracle. It uses the date 1-1-4712 as a standard...
- Tags: Date Range, Oracle Corp.
- Q&A 2006-02-20
- MS Project creating a dynamic Date Filter
- Hi all, Im trying to create a filter for MS Project 2003, that will fliter out and show only my milestone tasks. Also I want it to be dynamic, so I want to tell it to take today (current date/time) and look back 2 weeks for the start, and go...
- Tags: costantiniwm@..., Microsoft Project, Microsoft Corp.
- Discussion threads 2007-08-25
- MS Access Query, Date and Time Trouble
- Does anyone know how I can create a query that will let the user input a start date and an end date, and then show the results between specific, pre-determined times?For example: I want the user to be able to enter 8/8/07, when asked for the start date. Then...
- Tags: Microsoft Access, JBowles@..., Microsoft Corp.
- Discussion threads 2007-08-15
- XP will not update date & time out of synch
- I am trying to do updates afeter a Dell sytem recovery from disks. When I do I get "Your computers date and time apperar to be out of synch with an update certificate. To fix thisCheck Your Clock and DateI know for myself I reloaded Windows on a old PC...
- Tags: Casemaker, Microsoft Windows XP, software, windows
- Discussion threads 2007-01-11
- Concatenate date cells with text cells in Excel
- Sorting date columnsOne of the problems with converting the date to text is that it no longer sorts in date order. Once you have generated your date, you may want to convert it back to date format using the DATEVALUE function. These will sort corr
- Tags: excel, software, PeterSS, cell, Microsoft Excel
- Discussion threads 2006-12-13
- Date Stamp in Excel
- I am looking or a way to date stamp Excel spreadsheets with a creation date that won't change when the spreadsheet is updated. I do not want to have to key in the date, it should be an automatic date stamp. I saw something that said naming the formula...
- Tags: Microsoft Office, Microsoft Excel, johnsonsoftware, date stamp
- Discussion threads 2007-04-11
- calculate number of hours
- Is there an Excel formula I can use to calculate the number of hours that elapsed given a start date and time and an end date and time?This formula will give you the difference in minutes between two dates. Make sure the cells containing the dates are formatted as date...
- Tags: Sapinto
- Q&A 2006-05-02
- HELP Needed immediatly - Thanks
- hi, i am afraid this is an important one that needs doing asap, so for all you techies out there thanks in advance for your response.the scenario is:In MS Project i have numberous columns which include a "Start Date" and "Completed". its a simple task, i need a little VBA...
- Tags: Microsoft Project
- Discussion threads 2005-11-10
- Utilize a common definition for project start date
- Your forgetting that a project has a lifecycleYou're forgetting that a project has lifecycles, while trying to define "a start date". There is idea conception, possibly followed by any number of common lifecycle models that can be used to build deliverables. The definition of a start date can differ per...
- Tags: team, it management, project management, Nico Zwaneveld, hardware
- Discussion threads 2006-12-06
- if then statement code
- I am trying to write a statemtn in access that will determine if a date is null and if it is respond with "0", if it is true, I want to be able to count the days datediff between it and a second date. If the second date is...
- Tags: dgearheart@..., me.X
- Discussion threads 2007-11-07
- Date Validation in Excel
- I want to check whether the date entered is a valid date or not.For ex., if i enter 11/122006 instead of 11/12/2006 [a "/" missing ] , should indicate that string as invalid date..Actually the entered date is considered as String not as Date.. Is there any Specific date function...
- Tags: Scripting languages, vvelappan@..., Microsoft Excel
- Discussion threads 2007-10-17
- << Previous
- page 1 of 1
- Next >>
