Tracking Dates For Future Occurrences
Can this be done? I want to track a yearly review. I would like the date,
once entered - say 6/1/2009, to conditionally format to change yellow 30 days
before, then red 15 days before, and then to stay red until the date is
updated again for say 6/1/2010. Can this be done? I am new to all this,
In 2007 Also..
> Can this be done? I want to track a yearly review. I would like the date,
> once entered - say 6/1/2009, to conditionally format to change yellow 30 days
> before, then red 15 days before, and then to stay red until the date is...Use Form to prompt for report criteria
I have a form that I am using to prompt for report criteria. When I run the
query outside of the form, it works fine - prompting me for both criteria.
However when I run from the form, I get #Error#. Can you see what I am doing
wrong? Thanks in advance.
I have two combo boxes that I have put in my underlying query. In the
fields of the query are:
[Forms]![frmSelection Criteria Form]![OfficeNumber]
[Forms]![frmSelection Criteria Form]![Manager]
On the OnClick event is the following:
Private Sub Command6_Click()
On Error GoTo Err_command6_Click
Dim stDocName As String
st...Excel, how do I change the column headings from letters to number
I have a spreadsheet that has numbered columns as opposed to the standard
letters. How can I change this back to letters?
Go to the Tools menu, choose Options, then the General tab.
There, uncheck the R1C1 reference style setting.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"lazybee" <firstname.lastname@example.org> wrote in message
>I have a spreadsheet that has numbered columns as opposed to the
> letters. How can I change this ...parsing a date and time field #2
I am having trouble parsing the date and time in a field. I download
data from a data base and the date and time come together in one
field. I want to seperate the two. The date and time comes across as
the following: "2/1/2009 14:37" in the cell. When I parse it, it
seperates into three columns as follows: "2/1/2009", 2:37 AM", and
"PM" I can see what is going on but I would like to get two columns
with one as the date and the other as the correct time. are they any
ideas on how to address this?
Try using the TimeValue and DateValue functions.
First format ...Get drive letter for old slave hard drive while keeping data
My master hard disk has failed and I have successfully replaced it with a
new one and reinstalled windows XP etc. Before the crash I had a second slave
drive with some data I would like to keep on it. When I connect this drive,
it shows up in disk management, but does not get assigned a drive letter. How
can I get windows to assign a drive letter to the drive without formatting it
and losing all of my data?
Both drives are IDE drives, the master is jumpered to cable select and is on
the master cable, the slave seems to have lost its jumper, or never had one,
but sh...Hiding empty rows and columns
Does anyone know the code for hiding all blank rows and columns
in a worksheet.
Message posted from http://www.ExcelForum.com
try the following (adapted from:
Public Sub HideBlankRows()
Dim R As Long
Dim C As Range
Dim Rng As Range
On Error GoTo EndMacro
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
If Selection.Rows.Count > 1 Then
Set Rng = Selection
Set Rng = ActiveSheet.UsedRange.Rows
For R = Rng.Rows.Count To 1 Step -1
If Application.WorksheetFuncti...Excel moving horizontal columns to vertical
I am trying to find a simple way of moving data in horizontal columns
(referencing the key in column 1) to vertical colums (still referenceing the
same key). This would mean automatically repeating the values in column one
for every entry in the moved columns.
I can do this through the pivot table, but this is a long drawn out process.
I'm not sure if this will work for you, but you can try this:
- Highlight & copy on the horizontal value you want to make vertical
- Now highlight the vertical area you want these value to got
- Right Click when highlighted & choose...Select all of a certain column across multiple worksheets
Is there an easy way to simultaneously select (or do a find-and-replace) on
column H on every worksheet of an entire multi-sheet workbook, without
having to select that column on each individual worksheet by hand?
Right-click on first sheet tab and "Select all sheets"
In activesheet select the column............will be selected on all sheets.
Gord Dibben MS Excel MVP
On Mon, 24 Aug 2009 16:43:02 -0700, "Charles Belov"
>Is there an easy way to simultaneously se...Insert,Update Data in sage (MS Access Linked tables) using Vb.net form
I am developing application using vb.net which requires integration with SAGE
LINE 50 (Accounting software ) V11... The data which SAGE is using is MC
ACCESS 2003 database... with linked tables in it... Now I Have developed the
Sage connection using ODBC which works fine when reading the record but
cannot Add or Update record into the Linked tables.... When i debug the
program the error is at the line where it has...
Can anybody Help ?????
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/acce...Transformation of data into columns
I have the data from a flattened spreadsheet in a table in the
f1 f2 f3
period to: Scheme1 Scheme2
31/01/2005 Net Gross
28/02/2005 Net Gross
31/03/2005 Net Gross
30/04/2005 Net Gross
31/05/2005 Net Gross
30/06/2005 Net Gross
31/0...Filling Web Form
Dear freinds Hello,
I have written code in vc++ using MFC to fill the Webform using HTTP post
method and I'm able to fill the form but I'm facing a problem that I'm
unable to fill login name and password. So any one amongst you have any Idea
or help then please help me
...Sumproduct with multiple date criteria
Having a tough time with this one.
Column A = Start Date, Column B = End Date, Column C = Quantity.
Row A = Start Date, Row B = End Date.
I would like Row C to sum quantity from sheet 1 where ever the two date
The date ranges on sheet 2 represent the beginning and ending of a week
Column A Column B Column C
01JAN2010 24JAN2010 1,000
Row A 04JAN2010 11JAN2010 18JAN2010 25JAN2010
Row B 10JAN2010 17JAN2010 24JAN2010 31JAN2010
Row c 1,000 1,000 1,000 0
Do the Sheet 2 Star...Add new record through Form view
I have a table which is linked to a form, i would like to have a command
button which will add a new record to my table.
On the click of command button it should view the last empty row of my table
in a form.
On Sat, 26 Dec 2009 11:11:01 -0800, Ranjith Kurian
>I have a table which is linked to a form, i would like to have a command
>button which will add a new record to my table.
>On the click of command button it should view the last empty row of my table
>in a form.
The Click event should show [Event Proced...Outlook...screen saver keeps kicking on during active sessions
My screen saver keeps turning on when using Outlook. I can be in the middle
of typing a email and it will constantly go to the screen saver picture. I
have the screen saver set to activate after 15 minutes of inactivity. Why
does this do this??? Are there other places to adjust??
...Converting date from an external source
I am having an issued with converting a date from external data source. the
data has the timestamp in the general date form mm/dd/yyyy 00:00:00. I want
to convert the date to mm/dd/yyyy format so when i run a query for a single
day it will return the data for that date, I can currently return the data
but i have to set the parameter in the mm/dd/yyyy 00:00:00 format, i want to
simply return the data by setting the parameter in the mm/dd/yyyy format
Don't confuse how data is stored with how it is presented. As long as you
import the date into a field defined as a Date data type, you...Is there a way to sort a column without invoking a macro?
I am trying to get a feel for some probabilistic properties. For
example, I am trying to look at the statistics of the intervals between
randomly occurring pulses. I have no problem getting a column of
uniformly distributed pulse times, but they are unsorted, Every time I
recalculate with cmd-=, I get a new unsorted set of pulse times because
of the use of the RAND function.
Is there a way of taking this unsorted column and pasting it into
another colun that would be sorted without invoking a macro?
To simplify and be more specific consider the following.
1. In A1:A100 I have a set...MS Access 2007, Forms
When using the "Forms Wizard", I need to use the "Style: Ricepaper", but it
isn't available in the 2007 version and I have not been successful trying to
find it in Office Online or on the web.
Does anyone know where I can get it?
Access 2007 has 25 AutoFormats, but as you noticed, they are virtually all new ones. It's actually
nice to see that these were updated.
To get the older Ricepaper style you could probably create a form in an earlier version of Access
and then import it into your current database. If you're using the ACCDB file format, you would...Where can I get a good holiday booking form for my golf business?
I need a quality Booking Form for my Golf Holiday business on the Costa Del
One which includes sections for accommodation, dates, numbers, flight
enquiries and car hire enquiries. Any help would be much appreciated on a
Wrong forum. Try templates or doing it yourself. :-)
Please hit "Yes" if this post was helpful.
> I need a quality Booking Form for my Golf Holiday business on the Costa Del
> One which includes sections for accommodation, dates, numbe...unique with 2 columns
I have 2 columns with duplicates in the first column and no duplicates in the
second. I neeed to only see one value for each in the left and only one of
the accounts from the right.
ie: abc 1234
I would like to see either of the abc with the 1234 or 12345
I would like to see the bcd since it's individual with the 251
I would like to see either of the eft with the 600 or the 607
Use a totals query and one of the aggregate functions (First, Last, Min, or
Max) on the...Column and Line Chart
I am making a Custon Chart using the First -Column and Line Chart. When I
setup the chart it makes the last column a point instead of a column. When I
go in to change the type of Chart it makes the bar much bigger than the
others. I know you can go into Format and decrease/increase width- but I
can't believe there is a not a way to tell excel to make this a column on
setup so they are all uniformly spaced. How does Excel decide whether it is
a point on a line or a bar?
Hi Nikki -
Excel simply splits the number of series between the lines and columns. If you wa...Macro help with saving a spreadsheet with date and time in it
Can someone help me with some code that would save a file name as
Alan, how about something like this
ActiveWorkbook.SaveAs Filename:="Schedule " & Format(Now,
"mm-dd-yyyy-hh-mm") & ".xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="",
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Fee...Date/Time Show When Changes Made
When changes are made in a table or form, I want the date and time to appear
showing me when changes were made in any of the fields.
How can it work?
It's not possible if you're working directly with tables.
Using foms, you have to put code into the form's BeforeUpdate event to
update the row's LastChanged field (which, of course, you have to add to the
You might find what Allen Browne has at
http://www.allenbrowne.com/AppAudit.html to be useful.
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"Beame...Clusted stacked column chart
I'm posting this (after banging my head against a brick wall for
several hours) in case anyone else should run into the following, and
I would be very interested to know if anyone knows of potential
reasons for the problem.
I made use of Jon Peltier's technique for creating a clustered-stacked
column chart (http://peltiertech.com/WordPress/clustered-stacked-
column-charts/). This worked fine the first time I used it. However,
thereafter at the step:
"The month names are not centered correctly under the clustered
columns. Format the scale of the secondary category axis (B throug...how2 create identity column on contact form
how to use identity contact_id column on sql contactbase table,
because i want to, auto increment id field with contactid
The ContactId field is defined as a uniqueidetifier (ie. GUID). When you
create records via the SDK calls, this value will be assigned for you
automatically. I would not recommend going directly against the tables to
"tashtan" <email@example.com> wrote in message
how to use identity contact_id column on sql contactbase table,
because i want to, auto increment id field with contactid
...Way to Retrieving data with date parameter
I hope that someone can help me with the following problem.
I would like to have an access report with a date parameter that
allows me to retrieve data from an access table. I've tried to add the
following date parameter in a query "Between [type beginning date] And
[Type Ending Date]" My problem is that whatever dates I put into the
date parameter, I always have the same data. It seems that the
parameter doesn't recognize the data that must be retrieved from my
Can somebody help me please.
Thanking you all,
Thank you Gerry, this have s...