Combo boxes #12
I have a combo box in a form that lists all of the countries. I am
trying to set it up so that if the user presses the first letter, it
goes to the name of the first country with that letter and then if they
press the same letter again, it goes to the next country that begins
with that letter. I have the first part working, but the second part
is not working. I press a letter once and it goes to the first country
beginning with that letter, but when I press it again, it doesn't go to
the next one. Is there a property to set in the form for that combo
box to make it do this?
...mail.comcast.net box to enter username and password pops up every 15 seconds
I have a remote user/co-worker that has Comcast email. Every 15 seconds
(we literally timed it) a box asking for a username and password pops
up. I had him call Comcast for help, and they said it's a VPN issue,
and they can't help.
Any ideas on how to get this annoyance to go away? I'm terrible at
remote help, and he's very computer illiterate :). Any suggestions
would be greatly appreciated.
Jilly <Jilly4@gmail.com> wrote:
> I have a remote user/co-worker that has Comcast email. Every 15
> seconds (we literally timed it) a box asking for a username and
&g...Highlight Data Points that change in Graph
Is it possible to highlight data points that change slope in Excel 2003 and if so how.
...Display Text in the Data Area of a Pivot Table
I would like to simply display text in the data area of a pivot table without
summarizing it. For example, take the following database:
Date Time Instructor
8/9 8am Jones
8/9 9am Smith
8/10 8am Anderson
8/10 9am Doe
and display it in a pivot table like so:
| 8/9 | 8/10
8am | Jones | Anderson
9am | Smith | Doe
...stretch text box very very little
In publisher on a calendar I use text box in the date square. Some I can
stretch a very very little others stretch too much. How do I make them all
so I can stretch them very very little. That way I can get them very close
to the date box line and not go pass it.
> In publisher on a calendar I use text box in the date square. Some I can
> stretch a very very little others stretch too much. How do I make them all
> so I can stretch them very very little. That way I can get them very close
> to the date box line and not go pass it.
I'm entirely ...alter the content of the from box in a message
in outlook my "from" box automatically defaults to the email from me and that
is the email address issued to me by my ISP that I entered at inception.
I want my default email to read a different email which corresponds not to
my ISP but to my web site and email service by my web hosters?
for example my outlook says that my emails are from email@example.com
in my signature block i type my small company details and include my company
website and my email which is firstname.lastname@example.org etc how do i get this
email to appear as a default in the "from" box?
Enter i...Comparing data
There are 2 column in this query:-
Column 1 Column 2
I want this 2 column to compare. If both A, display A, if different compare
next 1...However, the result of the third column will give me all A,C,D
without B and E included at the last row?
Any idea to make them show all A,C,D,B,E?
Message posted via http://www.accessmonster.com
On Mon, 21 May 2007 02:19:56 GMT, "EMILYTAN via AccessMonster.com"
>There are 2 column in this query:-
>...restoring exchange 2000 SBS stores to a differnt exchange box...
We are looking at dumping our SBS 2000 box and would like to set up a
different win2K box with just the std version of exchange 2000 until such
time as we can afford to upgrade to the newest version of exchange.
I need to get this up and running asap.Can I setup my new win2k server,
running the regular version of exchange 2000 and then once setup restore my
sbs exchange 2000 information stores to this new box running the regular
version of exchange 2000?? Are the information stores in the sbs 2000
version of exchange the same as the std version of exchange 2000 or will I
run ...Vlookup from Combo Box
I am trying to use the Vlookup function from a Combo Box.
The combo box will contain currencies (USD, JPY, EUR). Once a user selects
a currency, the lookup will use that currency to find the exchange rate from
Something like this
Any help would be much appreciated.
If it's a Combo Box from the Control Toolbox toolbar, you
can set the "LinkedCell" property (right-click on the
combo box and go into "Properties") to a worksheet cell.
When the user makes a select...Data Entry to a Cell Range
Can I set up a data entry form, so if every time I enter a value in a cell,
it updates the next empty cell in a range? Thanks
Lets assume that the form is used to update cell A1. We require that
everytime A1 is updated the new value will be recorded in column B. Put the
following event macro in the worksheet code area:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim A1 As Range, t As Range
Set A1 = Range("A1")
Set t = Target
If Intersect(A1, t) Is Nothing Then Exit Sub
Application.EnableEvents = False
n = Cells(Rows.Count, "B").End(xlUp).Row...Error in Data Migration Framework (DMF)
I am trying to upload 14,000 Account records using the Data Migration
Framework, along with 6,000 Contact records. It was easier to use the DMF
rather than the bulk import especially with the relationships between the
I first trialled the DMF migration of these records on the May VPC image
supplied by MS and it all worked fine.
However now that it is being run in a pre-production environment on full
sized servers I am having problems. Approximately half of the account
records, and all the contact records have been uploaded successfully. Half
of the account recor...Increase data type size in GP table?
I don't know whether this is supported or not, but we're planning to roll out
the HR module on GP9, and one of the fields that is missing for job
applicants is an email address. We'd like to use an extra field to hold this
data, but the field length is too short to adequately contain that
I'm wondering if I can change the length defined in the SQL table structure
for that particular column, or, if doing so will likely mess up something
else (stored procedures, mappings, etc.).
Thanks in advance!
Technically, yes. However, if you do that, you...how can we transfer data from child dialog box to parent Dialog Box. #2
hi guys, i have created modalless child dialog box by parent dialogbox
using UI Thread . now i want to do 2 things first i want to transfer
CPoint variable from child to parent and second i want to call
OnLButtonDown() function of parent DialogBox. i have hint but not
proper please help me to complete this one.
SendMessage(m_pParent, WM_LBUTTONDOWN, x,y); // from child side
void CHRS_MoleDlg::OnLButtonDown(UINT nFlags, CPoint point) //on
parent dialog box
first of all tell me is it possible if yes then what will be "x" and
"y" so that they can convert into CPoint v...Data format in pivot table
I am running a Pivot table on some swim data. Even though the data is
formatted the same way "mm:ss.00", the fraction of the second is not
showing up or is not part of the numbers in the Pivot table.
Pivot table data
Back 25 Breast 25 Fly 25
00:23.00 00:25.00 00:24.00
Data the Pivot table is based on
7 CMSA-SE 00:21.87 00:21.49
6 BMAC-SE 00:22.95 00:21.91
7 BMAC-SE 00:23.13 00:22.16
6 BMAC-SE 00:27.97 00:22.63
8 BMAC-SE 00:21.07 00:22.70
7 UN-SE 00:00.00 00:22.94
6 CMSA-SE 00:26.36 00...Data type on import wizard not active
Hopefully, someone can help me with this.
I'm using the importing an excel 2003 into access 2003.
Using the import wizard to import the excel 2003 spreadsheet. everything is
fine until i get to the field options: dialog box. The Data type drop down
What can i do to make this drop down option active.
Thanks for your help
This is a known issue for ACCESS 2002 SP3. This issue is described in
There is a Hotfix available for ACCESS 2002 from Microsoft Technical Support
for this problem. Descr...Message-Data file not properly closed???
Upon boot of Outlook, EVERYTIME, I get this message--Data file did not close
properly the last time it was used and is being checked for problems.
Performance might be affected by the check in progress.
When I leave Outlook, I have made sure to close all files and exit properly.
Is there some reason this happens? I even go back to my main screen now.
Is there something more I should be doing.
Did the file checking finish before you closed Outlook?
If not, it will continue/restart the next time you start Outlook.
If it still does this after the checking has completed, the...Can you enter a formula in a chart data series?
I am referencing a column of data into a chart. How do I perform an
operation on the data before it is entered into the chart? For example, I
want the row of data to be divided by 1000, and then charted.
HELP! This is driving me crazy!
The simplest way is to use a helper column and formula to alter your
data and then chart that. You can not directly apply formula to the data
series within the chart.
> I am referencing a column of data into a chart. How do I perform an
> operation on the data before it is entered into the chart? For...Subreport Data Listing Twice for Each Report Record
On a report & subreport pair, the subreport data is listing
out twice, and I can't seem to sort out why.
Any suggestions appreciated.
>On a report & subreport pair, the subreport data is listing
>out twice, and I can't seem to sort out why.
Does the subreport diplay two records? If so, the problem
is that your main report's record source query has a Join to
the subreport's data source.
MVP [MS Access]
in article email@example.com, Marshall Barton at
firstname.lastname@example.org wrote on 7/5/07 1:18 PM...Using Drop Down box that can be edited
I have created a form in Word 2007, but would like to have the drop down box
I created to also be overwritten by the user if the items in the drop box
doesn't include their choice. Thanks
One possibility would be to replace one of the items in the list with a user
input item. You could do this with a macro run on exit from the dropdown
Assuming the dropdown field Dropdown1, put an item at the end of the
dropdown list "Enter your own value" then run the following macro on exit
from that field
Dim sChoice As String
Dim fDD As FormFie...How can I get data from an entity via java script
How can I get data from an entity via java
I have a new entity with alle zipcodes and cities/countries.
I want it to be so that if a person enters data in the zip code on account
or contact that city and state automatically is filled with corresponding
data from the new zip code entity.
How can I do this, java script ?`
Any ideas appriciated !
Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
Den har indtil videre sparet mig for at f� 13991 spam-mails
Betalende brugere f�r ikke de...Mapping one custom attribute to another and filling the data
I have created two new attributes (Net Commission) one under leads and one
under oppurtunity. I did not realilze that although I created the two same
attributes I did not create a relationship between the two. Now there is data
in one that is not in the other.
Basically the oppurtunities section contains all the data because that is
the form that lets the user input this info. The leads attribute for net
commission is basically blank. I would like to be able to create a
relationship between the two attributes and copy over any of the data that
has been entered into the oppurtunities se...Drawing a selection box using CRectTracker
I have an MFC SDI CView application and I want to draw an selection box
when the user left clicks and move the mouse. I have found the CRectTracker
class but I can't get it to work
I have this code:
void CSCMLaserView2::OnLButtonDown(UINT nFlags, CPoint point)
m_startPt = point;
void CSCMLaserView2::OnLButtonUp(UINT nFlags, CPoint point)
//Release the capture on the mouse
CSCMLaserDoc* pDoc = GetDocument();
ASSERT(pDoc != NULL);
// Co...Grouping & Moving Data
I have a spreadsheet with data in the following format on sheet1:
Col A col B
etc etc - possibly upto 1000+ rows
Each group of 3 are results of different tests on the same sample.
(In reality there are currently12 different results for each sample)
I need to convert this on to sheet 2 to read as follows:
A B C D etc
1 pos pos pos
2 neg pos neg
3 pos neg pos
Any ideas how to do this ?
Message posted from http://www.Ex...form: data input locking up
I have a form which was working fine until a few hours ago. The form has
several sub forms. However, those are working fine. I am unable to
edit/add/delete records on the main form. This is a front end database, with
the main data storage on a network. I moved the data starage DB onto my
local drive, reset the links and experienced the same problem. The form is
not based on a query and writes directly into a data table. The form is
normally called up (filtered) through code. however, I experience the same
problem when I open it up directly (without filtering the re...SQL Query to transform/group data by Date
I have a large Access table with data organised as follows:
There are seveal different codes and therefore duplicate dates. I'd like to
run a query to bring back each code grouped by date and so put the codes
along the top as feilds. For example the query below brings back the
following data for two codes.
SELECT field2, field1, field3
WHERE field1 In ('LLOY','RSA');
21/01/05, LLOY, 12454
22/01/05, LLOY, 31541
21/01/05, RSA, 21241
22/01/05, RSA, 12414
Instead I want the data to look like this: