Search results for query: *

Hello all, I am really new to vb and do not know where to start for this. What I am trying to do is have a user set a default path for an exe one time, and save the path to be used when a user clicks on a command button to launch the exe. Is there a control I can user to open a file path...

...MPMmessage.AttachmentName = File1.List(ii) Next ii If (ii) = File1.ListCount And (ii) <> 0 Then '*************Get Email Address from Access**************** 'Call GetEmail(CurrDir1, elist, email, Company) strAppDir = CurrDir1 strDBName = strAppDir &...

That was it!! JR - I needed to update data between the tabs without going back to the combo box. Private Sub Form_AfterUpdate() Forms![frmedit]![frmTooling].Form.Requery Thanks to both for the quick responses. Thanks again

I should have been more clear. I have one tab called tooldata(main) and another called partusage. The tooldata main tab has a form called frmtooling & the partusage tab has a form called frmpartusage. Both forms are based on queries. I pull the desired record using a drop down. All tabs are...

I have a tab control with several tabs. What I am trying to acomplish is this. When a user changes a usage field in one tab, I need to update another tab that has a form based on a query. I have tried the recalc and requery, it does not seem to work. The only thing that will update the tab is if...

I have a cdonts program working on my machine using vb. I also have personal web server running. It is using my c:\inetpub\mailroot\queue. It works great. The question I have is how can I compile this and put it on another machine? I have attempted to install and I get an active x error...

...CurrDir1 = Mid(Currdir, 1, 29) Else Dir1.Path = Currdir End If For i = 0 To Dir1.ListCount 'Create Email Object fields************ Set objNewMail = CreateObject(&quot;CDONTS.NewMail&quot;) If Dir1.List(i) <> &quot;&quot; Then DoEvents Call...

I am having an issue with a vb app that uses CDONTS to send attachments. The app first goes and gets the directory name, grabs the files in the directory using objNewMail.AttachFile nochange, File1.List(ii), I then open a access database to associate an email address to the folder name...

Is it possible to use a macro in excel to e-mail specific sheets of a workbook? I am using the outlook 9.0 object library and here is what I have so far ActiveWorkbook.SendMail Recipients:=&quot;test@test.com&quot; Because the worksheets are sensitive and are tailored to each e-mail account, I...

Sorry, I was thinking you were trying to use Access, Data Access Pages. For the life of me I can not remember what I did to fix this. I think it was something in the IIS security accessing the FPDB directory on IIS. If I can remember I will e-mail you.

I gave up using data access and went to ASP

That is correct a new page authenticates them. After authentication I want to go back to the index page and update the left frame with options after authentication. Initially, the left frame of the index page is blank, after authentication, the left frame shows different options of data entry...

I have an asp page with 3 frames called index.asp. In consists of a top frame, body frame, and left frame. When click a link on the top frame it updates the left frame. What I am trying to do is when they click on a particular link on the top frame a new authentication page comes up that...

That did the trick thanks guys!!

I have vb app that is using an access database. I have coverted the db to 2000 and am getting unrecognized database format when opening the vb app. I am running mdac2.6. Dim rs As Recordset Dim db as Database strAppDir = App.Path strDBName = strAppDir & &quot;\VenRate.mdb&quot; Set db =...

That did it. Thanks a bunch

I am pulling data and need to parse out the first name part of a employee name field to be used in a mail merge. Example : Scott Smith. I need to pull the Scott. Any help would be greatly appreciated. Thanks

I tried both ways, I am still getting invalid character for Case 061. In Sql I have the field defined as nvarchar. I tried to use a different field(Cell) and changed the 061 to &quot;Small Cell&quot; to select data and received the same error. Any ideas suggestions

I take that back, I am still getting an invalid character for case 66

Never Mind, I had a syntax error with the rs - rsOP. Thanks for all of your help!!!!