Search results

thanks plog this worked perfectly, very much appreciate your help

Hello, Please see the attached image. there are 3 tables (simplified below for those that cant see image). Company (id{PK}, name, address, etc) Web (company_account{fK},module1, module2, module3) CD (company_account{fK},module1, module2, module3) I need a query that displays the following...

Hello, I dont actually want to manipulate the files, I simply want to list the contents of the FTP, so that the files are available to download for the user. They just choose the one they want. Does anyone have a way to list the FTP contents....the easiest way would just be to open a browser...

Hello people, I have the following script and it works on my PC. It will open IE and go to FTP directory. Im using IE8. My colleague who also uses IE8 only gets a blank screen. This is on a button that takes values from two fields (FTP_Username & FTP_password) Private Sub...

Hello David, I Now get the following output. I played around with the code for ages but I can not see why. Something seems wrong with the first part of the segment. alseCancellation Date:30/03/2010 Product:Finstat Specific:CUR1 Daily Cancellation ID:96 ======================== End Of Report...

excellent its working now. I get the mail come through. I have 1 problem however I comes through pretty much very ugly. Like...

I am Getting an error Run-Time Error '94' - Invalid use of Null, could you check what is wrong please? Private Sub Send_Email_Click() Dim TmpString As String TmpString = QueryToText() Call NotesMailSend("me@myemail.com", "New Cancellation Reminder", TmpString) End Sub Public Function...

the query returns the following fields. cancellation_id (PK), company_name (FK), cancellation_date, product, these fields are what will be sent in the e-mail I do not want to make it too complicated by sending attachments - even though it might be better (if there is an easy way - can you...

OK, but how do i actually code this?? Im not really good at this(VBA/Access), i just usually get some code and fudge it together..usually it works.lol I would appreciate any way to do it. I just need to get the information out from the query into a string via some kind of for/while loop. It...

please someone im still stuck on this! It cant be that hard ! can it? :eek:

please someone im still stuck on this! It cant be that hard ! can it? :eek:

I have 3 elements to this question. I have a table (called cancellations) a form (called cancellations_form) and I have made a query called (e-mail_query). I would like to display the results of my query in a text field on my form, Each row returned from the query should be displayed in a new...

:p anyone able to help

Yes the database was not originally designed by me!

Hello I need some help with a combobox. This may fall under forms/queries and vba. One of my forms (called cancellations) contains a field company_account number. When the company account number is entered the company_name will automatically appear on a field called....company_name. I also...

Private Sub MyBtn_Click() Dim browser As WebBrowser Dim SearchValue As String Set browser = CreateObject("InternetExplorer.Application") browser.Visible = True browser.Navigate ("www.mywebsite.com") 'Wait for the page to load Do While browser.Busy Or browser.ReadyState <> READYSTATE_COMPLETE...

Can you show me the steps? If I do Insert > ActiveX Control I do not see it on the list (see image) I have also tried(in access) doing Tools > ActiveX Controls > Register > shdocvw.dll But I get the error: C:\Windows\System32\shdocvw.dll was unable to add/remove itself from your system...

Im trying to have my form do various internet related functions and have googled around to find that I need microsoft internet controls to do what I want. A Similar to this: http://p2p.wrox.com/vb-how/9811-fill-out-web-form.html I cant see microsoft internet controls on my toolbox, how can...

Anyone with an idea?

I dont actually need the webpage to open in access...I just need a command button with vb code behind it that will open a browser and then all i need to do is fill in a username and password fields. And then go to the company page e.g http://www.blablabla.com/blabla?search?id=[web_id] I...