Search:
Type: Posts; User: SeanK
Search:
Search took 0.15 seconds.
-
I have never, in my life, lived in an apartment complex that had an armed guard.
I think if I were being shown around to available apartments and passed armed security I would not, under any...
-
Lets say I have an Access 2007 database table with two fields called MyNumber and MyText.
There are seven records as follows:
1 A
1 B
1 C
2 D
2 E
2 F
-
See the posts by Code_Doc
http://www.vbforums.com/showthread.php?t=456226
-
Too late for that I think....Happy Birthday anyway.
-
Use a small MS Access database and load the file names into a table field.
Have you code loop through that field and play the files one at a time.
-
Why any kind of textbox? I'd use a ListView for this.
-
I have an Access 2007 database application that I’m taking over. In one of the tables there are 13 fields, and I need to run a query to see if any of those fields contains a zero. The typical...
-
It is an easy printer question...you need to change the selected printer to be the default printer otherwise, nothing will print there.
As a procedural matter add language in your help file or...
-
I know how to do it but I can't tell you because this is my source i got the solution by my self so i can't give the source i'm sorry again
-
Thanks to all for the code and the responses. :)
-
How would I determine what the dates are for all Mondays for any given month, for any given year?
For example: If I put 6/2011 in a textbox, what would I need to do in order for my program to...
-
I probably should have posted this in Office Development because I am use VBA, but, regardless, it works great.
Thanks.
-
If I have the letter W mapped as a network drive to \\ServerName01\FolderName02 how do I get drive W's UNC.
In other words, I have a drop down combo with 10 letters in it.
I click on "W" - I...
-
I tried
ListView1.Font = New Font(ListView1.Font.Name,
If(ListView1.Font.Size = 8, 12, 8), FontStyle.Regular) and got three errors. Two said “Expression Expected” and one said “End Of...
-
I have a listview and I’ve been asked if I could set it so that the font size got bigger when a selection was made. So, I have thisPrivate intToggleFontSize As Integer = 0
Private Sub...
-
The )) after .ToUpper generates and "End Of Statement Expected" error. Removing them takes care of the error.
"Function" is underlined and generates a "Expression Expected" Error. Perhaps n...
-
That is where I was going wrong...I was still using a 1-based loop. :rolleyes: Thanks.I know I can do it that way, but I don't, and I won't.
I find it far more clear to use variable = variable...
-
I did add the Text property to it originally, but that gave me an error.
-
I found this from a Google search and I need the VB.NET equivalent to Martin Liss' code
Dim lngIndex As Long
Dim lngTot As Long
For lngIndex = 1 To lv.ListItems.Count
lngTot...
-
It is a locked textbox that is populated from a datetime picker selection. I never, ever allow users to actually type in a date.As I indicated, I did try the pound signs, but I encapsulated them...
-
I am using Access 2003. I haven't worked with Access as a backend since Access 2.0. Even back then I used Text as the data type for date fields because they are such a pain to work with. Now,...
-
Thanks westconn1. When I check Tools/EMail Accounts I get this for a server name:
ServerName.ent.corp.blah.com
So, I'll use that as my SMTP server name and see what happens.
-
I've decided to give SMTP a shot as it seems you can specify a from address using this protocol.
It requires I give my SMTP Server, and there in lies my current problem.
In the Outlook...
-
Ok, I figured out what is causing the type mismatch.
GetDefaultFolder is looking for a MAPI Folder name, not a mailbox name. When I add olFolderInbox, it works. However, it is reading my...
-
This works just fine if I want to do stuff with the unread messages in my own mailbox. But, I have a generic mailbox that I'm supposed to write some code against that will detect unread messages,...
-
Brilliant...it blew up on: Set testCON = CreateObject("ADODB.Connection"), and I got the exact same error message.
So, if I'm reading you correctly, I need to put in a request to get MDAC...
-
I gave myself an idea from my last post.
I can put an Excel spreadsheet on other machines, so I created one that connects to my SQL Server. My suspicions were/are correct. The error occurs...
-
InstallShield is used as the installation and setup package. It is created by our deployment department. We (the developers) are not permitted to install anything on anyones machine.
In order...
-
I have an VB6 application, which connects to a SQL Server 2000 database, running on about 75 machines.
All machines are running XP with Server Pack 3 installed.
One machine, and only one...
-
Same error message, but now it highlightes .End
With objSheet.Range("A7:G" & lngRowCount)
.AutoFilter
.AutoFilter Field:=1, Criteria1:="="
'~~> Get the...
-
This produced a "Error 9 Subscript Out Of Range" error on the highlighted line at the very end (it did go through all lines. There were 170 and at the time of the error, i = 167) and because of...
-
Well, I tried it in VB6, and it errors on the highlighted line with "Wrong Number Of Arguments Or Invalide Property Assignment"
With objSheet.Range("A5:G" & lngRowCount)
.AutoFilter
...
-
I’m doing this from VB6, so I guess that makes a difference.
I got this from recording the macro
Range("A7:G170").Select
Selection.AutoFilter
Selection.AutoFilter Field:=1,...
-
I put an autofilter on row 5
Each cell in the row received a dropdown menu with:
Sort Ascending
Sort Descending
All
Top 10...
Custom...
-
I have a spreadsheet in which I need to delete blank lines when they occur after a load of records has been dumped to it.
The number of records will be completely dependent on the query run, so...
-
Works great. Thank you anhn!
-
anhn: I'll need to do some pretty extensive testing and get back to you, but #2 looks like it will work for me (Yay!!)
-
It does print what I select, however, the page numbering is off.
As I indicated, I need all tabs selected to have their pages numbered consecutively.
Each sheet/tab will have multiple pages. ...
-
Attached is an example.
The path to Book1.xls is hardcoded in the "Open" button on the userform so you will want to change that.
The userform is on the PrintSheetExample.xls
Thanks...
-
No, that wasn't what I was doing, but I tried it, and got the same error. This time my sheet array string was
Sheets(Array(""Sheet1", "Sheet3", "Sheet4"")).SelectTwo double quotes at the very...
|
Click Here to Expand Forum to Full Width
|