Search:

Hello, I searched around and I don't see what I'm trying to find. I see a lot of Chart threads but none seem to be asking what I'm asking.

I'm looking for some samples or a tutorial on how to set...

Remove the me.close (not sure thats the correct syntax anyway), just run the application.quit.

you cannot query a workbook, no, there is now way to run a query off of data in a sheet. Anything you wanted to do in SQL could be easily coded to work in excel..

Is the form open? Is that the name of your form?

Where are you getting this error?

Try this in the meantime



Dim cCont As Control

With Forms!frmMain
For Each cCont In Forms!frmMain.Controls

Dim cCont As Control

With Forms!frmMain
For Each cCont In Forms!frmMain.Controls
If TypeName(cCont) = "textbox" Then
If cCont.Value = "" Then
...

I already have them linked but I hadn't saved my password...that stopped the prompts thanks.

I have a query that I'm currently running that joins between two different db's. However, I want to move it to VBA. I was wondering if there was a way I could put the connection strings for both of...

Thank you it does...

That worked awesome, thank you...however....

I really don't understand how it worked. If you get any time, an explenation would be greatly appreciated. I really wan't to understand, so I don't...

I know very little about HTML, I mostly do a lot of VB stuff. So bear with me please.

I'm building a web page at work to link to all my different reporting, problem is, new reports will be created...

yeah I still can't get it to loop right...IDK what I'm doing wrong?

That works but for some reason (I had gotten to this point before) it ends the For Next Loop.

There will normally be multiple values on a sheet, so it has to loop through the column looking for a...

I have this code that I use to delete rows based off of a variable in the columns. It loops through and finds every row with that value and deletes the row.

I'm trying to do everything the same...

I've never done anything like this, so I don't know what my next step is, I've tried pulling back all the tables by using a sp but all the info is blank? I would just like to have it show up in the...

I'm trying to link sql server to a DB2, so I can show our IT dept how much better it is than using the as400 interface. I currently connect through VB using this con string.

...

A client is asking for me to make an app I built print out (main form basically), well what I built them prints like a screen print, I couldn't get the list view to print otherwise, they didn't like...

Thank you. I'll see if this works.


I was actually just putting a listbox on the form and selecting the checkbox value in properties of the listbox.


EDIT: Did you mean to rem this line out?...

No I was using a listbox with a checkbox in it. Should I change it to a checkbox?

But I need to get the actual value of the item that is checked.

e.g. if the item checked says "hello world", I...

I am very new to vb.net. I have been using vb6 for a while and I am making the leap.

I have a list box that receives entries from another text box, there will be multiple entries, and only some...

I noticed the changes but I dont think I could explain what its really doing besides possibly finding each slide...

^ You are a god, it worked the first time.

Ok so I noticed that I wasn't telling it what object, so I got past that, now though it fails on the first line saying the object doesnt support this property or method.



Dim oSld As...

^Yes sir....MS PPT 11.0 Obj Lib

Could I be missing anything else?

This code should work.

I was building something to run an update in PPT to refresh the links. I am now having to update some related things in access along with some pivot tables in Excel. So I decided to just build it in...

I figured a way around it, create the ps file, then shell call the distiller.

So I cant bypass the save dialogue box alltogether?

I am trying to print a powerpoint presentation to PDF, I have everything up to the Save Dialogue box complete. I need to figure out how to set the save criteria for that box or bypass it...

I like to kill off each workbook in the code, rather than killing the object....just me but it works for me.

Why display the dialogue box at all?

Once that event is triggered that normally opens the dialogue box, call the function from there and remove the dialogue box from the code?

Am I missing...

^Thanks, that was what I should have done.

I was wondering if there is a way I can have a word doc always open as read only. I have users opening it, and I know someone is going to save over the original. I have removed the File menu, but its...

If this is a "meantime" solution I would probably just link the SQL tables to the Access db and reconfigure your fields to work appropriately, this will keep your app running with minimal work until...

I currently import outlook folders into ms access tables manually, daily. I do this so I can manage the mailbox volume.

I know there has to be some way of automating this, however I have no idea...

Just writing this out, should work though




Public Declare Function GetAsyncKeyState Lib "user32" (ByVal vkey As Long) As Integer

Public Sub DoKeys2()
If GetAsyncKeyState(vbKeyF) And...

I use DAO. With DAO, you have to add a reference to the DAO 3.6 Object Library to talk to Access 2003. I use this everyday...




Dim db As DAO.Database
Dim MyQry As DAO.QueryDef
Dim rsMyRS As...

You dont.

I use this in access, its the first thing that I have ever seen work. You have to put a module in Outlook and Access...if you're using VBS you can probably modify it to work....been...

Always remove parens from SQL code when using it in VB. It makes life so much easier.

Those parens around your variables are uneeded. That is most likely the error.

Something like this, I did...

Got it to work thanks, Code Doc, your code worked great.

Code Doc, that works awesome, but how can I change it a bit to have it fire at say 7am?