Recent content by ebbo

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...