Remote data access
As a new .net developer, I would like to know how a
VB.net Windows application can access a SQL Server
database residing on a web server.
In other words, using the Visual Studio IDE, is there a
way to develop a Visual Basic, Windows application that
can access a SQL Server database over the internet.
Thanks for suggestions,
John C. wrote:
> As a new .net developer, I would like to know how a
> VB.net Windows application can access a SQL Server
> database residing on a web server.
> In other words, using the Visual Studio IDE, is there a
> way to develop...calculated field 12-30-09
i have a query with the following fields:
year, month, customer, debit euro, credit euro and balance (debit-credit).
the query returns multible entries for each customer. e.g. customer X in
November 2009 has a balance of 500 euro and December 2009 has a balance of
i want to build a field that returns 500 euro for November and 400 euro for
December. can i achieve that in a query?
i also want to create another field that returns a date. in the above
mentioned example: if year is 2009 and month is 11 i want to add thrre
months, that is the filed should return the d...How can I insert a cell reference in a footer (eg for variable foo #2
Any ideas on how to do this?
I'm trying to create a template with the doc reference number in the footer
However, I'm trying to avoid users having to edit the footer (because this
just wont get done).
Private Sub Workbook_BeforePrint(Cancel As Boolean)
.PageSetup.LeftFooter = .Range("A1").Text
This code should go in the ThisWorkbook code module.
(remove nothere from the email address if mailing direct)
"wngg001" <email@example.com> wrote in message
news:8A0F9D9E-269F-45CF-A6E3...Test Mail...Please Ignore #2
Testing NNTP Client,
Please ignore message
...Data Validation #12
I have data validations in sheet1 as named range lists from sheet2.
When I have deleted sheet2 and copy sheet2 from identical other workbook -
my validations does is not work...
I see Name ranges in copied worksheet, but when I use they in validation - I
have error: "The Source currently evaluates an error. Do you wish
Only after deleting of Named ranges in Sheet2 and recreating its, my
It is possible after replacing of worksheet with named ranges for
validations (named ranges names are identical) use copied worksheet without
recreating ...Data Entry Form 03-20-08
I created a form to use for viewing currently records and entering new data.
This time, the form doesn't allow me to enter new data. In fact, all text
boxes didn't let me to enter new information.
Several things to check:
In form properties:
Allow Additions = Yes
Allow Edits = Yes
If the form's record source is a query, be sure the query is updatable.
Dave Hargis, Microsoft Access MVP
> I created a form to use for viewing currently records and entering new data.
> This time, the ...Cannot syncronize accounts in different currencies on my pocket
I often need to manage accounts in different base currencies but it seems
that accounts different from base currency, do no appear on pocket pc 2005. I
am using money 2005 on my desktop and recently downloaded pocket money 2005
to my ipaq.
This seems to be a serious limitation. any suggestions?
It is a (one of the) limitation of the pocket pc client.
Glyn Simpson, Microsoft MVP - Money
for UK tips and fixes for MS Money. To send Microsoft your wishes or
suggestions, use http://regi...Sorting lots of data
We are trying to sort through a csv file that we converted to an excel
spreadsheet. the spreadsheet has over 40,000 entries which include mailing
addresses that are in some cases duplicated. is there anyway to sort/filter
the info to locate the duplicates and then remove them?? any help would be
greatly appreciated. thank you for your responses.
use 'Data - Advanced Filters' and check 'unique entries' or use the
following addin for this:
miss lynar wrote:
> We are trying to sort thr...Stacking Data??
if I have data like this
A B C D...
1 Type\Date 01/10/04 02/10/04 03/10/04...
2 T-X 100 50 100
3 T-Y 50 70 0
4 T-Z 400 0 400
...Sort one coloumn according to another coloumn on another worksheet
i am a newbie. i went through all the posts but couldnt inderstand.
I want to sort coloumn A on worksheet 2 according to coloumn A on worksheet2.
Coloumn A ( Worksheet1) B | Column A (Worksheet 2
harry H david
david D craig
craig C harry
smith S smith
The contents of coloumn A will not be the same order every day. Could
someone help me sort c...Drop down menu #2
Is is possible when you have a drop down menu, to have excel short list the
menu as you type in more charcaters of the text. For example a have a list
of several hundred customers. I start inputting the first few letters of the
customers name, I would like that list of several hundred to be shortened to
only include thaise customers that begin with the letters I have typed in.
Think this previous post by Debra Dalgleish would be of help:
"Although data validation doesn't support autocomplete, there's a sample
file here that provides a combobox from which you can se...Associated external Account #2
Just got some of our exch2k users migrated to another org exch2k3. Found
that associated external account rights which never seen before in 2k. Wish
to know the purpose of this account and when is the best time to use it.
Please help and thousand thanks.
Granting Access to External Accounts
"Elton Seng Yan Thung" <firstname.lastname@example.org> wrote in message
news:enFBAvpwFHA...virus scanning #2
I really get prompted for "requesting virus scan", and I don't know ho
to disable it; the warning is located beside ready, in Excel bar
Gerbatin's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1523
View this thread: http://www.excelforum.com/showthread.php?threadid=27651
What antivirus software do you use?
I think/hope the solution will involve a setting that you can toggle in that
program. (maybe you missed an option???)
The antivirus program doesn't have t...2 questions about Exchange Server 2000
1. How, or where, do I find out where Service Pack level I have installed? I
see that I downloaded SP3, but I can't tell if it was ever installed.
2. Clients have Outlook 2000. Inbox is open. Last message is selected. No
new mail. Then, if you click on a different message, you get the "new mail
has arrived..." message. It seems to only deliver new mail when you change
1. In Exchange System Manager, highlight the Servers container. It should
show you all servers in the right pane along with their service pack level.
2. Sounds like something is b...Turn data #2
Is there a way to turn the data in an Excel spreadsheet so that what is on
the top is now on the side and what is on the side is now on top?
I need to export my spreadsheet into Access but, I can't get it to format
correctly in its current orientation.
~Make a backup copy of your data to work from (just in case, so you
don't lose data)
~Highlight the entire range of data; click >Edit >Copy
~Choose a new location, on a different sheet perhaps; click >Edit
>Paste Special and select the Transpose box; click OK
Does that do it for you?
thank you so much. You are a genius...Only 1 taskbar button when i open 2 excel documents
Hi all. When i open 2 excel documents i have only 1 taskbar button on the
taskbar even though i did not choose the option to group similar taskbar
buttons under taskbar properties. Hence when i want to switch between the 2
documents i need to go to window and select them. Hence how do i solve this
so that i can have 2 taskbar buttons of the excel documents on the taskbar?
Thks in advance.
Tools>Options>View, check Windows In taskbar
"inenewbl" <email@example.com> wrote in message
news:6F715432-2EB2-47AC-B737-56D63F37537A@mi...Pivot Table fields #2
Is there a way to format multiple pivot table fields at
one time and have them refresh that way, rather than
having to select each column and choose the format
I think the solution for you is to open the Pivot Table
Toolbar and select the Field Settings icon. This sets the
format for all results for that particular field.
One limitation that I haven't found a way around is
getting a preferred column size to "stick" and not reset
after a table refresh.
>Is there a way to format multiple pivot table fields at ...Business Cards #2
I am trying to create business cards using Microsoft Publisher 2002 on XP. Where would I find the template for Avery 8397, or for any of the Avery business card products.
In page setup, select business cards, click Change copies per sheet and adjust the
margins to fit your template.
Avery has blank templates for downloading, choose Cards, there will be a list to
select from. Your number was not among them but generally business cards are pretty
Mary Sauer MS MVP
http://office.mi...Data in columns not rows
I have file that is names, addresses and phone numbers.
When I copy it into excel it comes out like this.
I need it to be like this
COLUMNA COLUMNB COLUMNC COLUMND
NAME ADDRESS ADDRESS2 PHONE
Is there a way to change this without copying and pasting?
Is the data consistently 4 rows? Or do you have varying sets?
How far down Column A do the sets extend?
If 4 rows per set try this.....
In B1 enter =INDEX($A$1:$A$3000,(ROW()-1)*4+COLUMN()-1,1)
Drag/copy across to E1 then select B1:E1 and drag/copy down u...order data by a rank
i need to create a form order by the militaty rank.This form is based in a
query "qrystaff" with three fields: MemberID FullName and Rank.I´d like that
the data were ordered firstly by MilitaryRank and secondly by FullName in
alphabetical order.There is an easy way to do this?
Message posted via AccessMonster.com
When you create queries, you're given the option to specify the sort order
under each field.
If the fields aren't in the order from left-to-right in the query grid, you
can add ...Can not create Matrix Item please Help RMS 2.0
Can not create Matrix Item please Help
When trying to create any new items I receive error message
This is the message
(-2147217864) Row Cannot be located for updating. Some values may have been
change since it was last read.
Manger still creates standard items but still receives message with out this
number in message -2147217864
...Populating combox with worksheet names
I'm using the following to populate a combobox on a worksheet with the names
of all the worksheets in the workbook:-
Dim ws As Integer
For ws = 1 To Sheets.Count
My question is I have one worksheet that is veryhidden and I dont want it to
show in the combobox. How do I do this?
Use the .Visible property which list out xlSheetHidden, xlSheetVeryHidden and
Private Sub CommandButton1_Click()
Dim ws As Worksheet
For Each ws In Wor...Macro Recorder #2
I have a very basic question( I think). When you are recording a Macro how
do you stop and then restart where you left off? For example I have a
repetitive task that moves columns from one spreadsheet to another. The
problem is that there are about 40 columns I am required to move.
As I record the macro can it be stopped and then restarted if I have to
close Excel and return later?
I can't find the answer to my question documented anywhere.
You can stop it, but when you start again it will create a new subprocedure,
you can go in and copy/paste the second after the firs...2 mirror files with :1 and :2
Not sure how, but have 1 excel file, lets call it FILEA.xls and when I open
it, it opens a FILEA:1 and a FILEA:2 workbook. Any change made to FILEA:1
gets repeated in FILEA:2 and vice versa. Looks like some sort of mirroring,
or changes being tracked, but track changes is turned off. Any help is
you've opened two windows of the same workbook (from the window /new window
menu) - just close one and then save - this should solve the problem
"DJR" <DJR@discussions.microsoft.com> wrote in message
news:F0F6BDF5-9DC2-486E-947C-ABBB6C4544...Date Range #2
Can someone please assist me with the following issue:
I am currently using the formula noted below to direct
another application ( Bloomberg ) to select prices from
the previous 6th business day.
My question is> Is there any way to revise the formula to
exclude US holidays for successive years (i.e. for 2005,
2006...) without having to manually change the date
entries each year, in the formula?
I'd recommend listing...