Search results

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

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

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

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

Hello, Our company uses a access database (using forms) to store client details. One of the fields is web_id, We enter our clients web identification number into this field. I would like to place a button on my access form that does several things in a single click: 1. opens our web...

What us wrong with this please? I get error "Object Required" Private Sub Form_Open(Cancel As Integer) If Date_Diarised.Value Is Null Then Add_Date.Enabled = False Else Add_Date.Enabled = True End If End Sub Date_Diarised is field on my form and starts empty, Add_Date is a button that will...

Hello, I have made a form based on a query. The Field in question is called FTP_account. The form is tabular showing a list of all FTP accounts. I would like the data shown in the text box FTP_account to be shown in lower case only. At the moment it displays a mixture of lower or upper...

:confused: Hello, I have the following tables: Companies: ----------- Company_ID (PK) Company_name etc etc Product CD: ---------- Company_account (FK) Module A Module B Module C Product Web: ---------- Company_account (FK) Module A Module B Module C Product Book: -------------...

Hello, Im not sure if this should go in forms or queries. but i guess its a bit of both. I have two tables: TABLE: COMPANIES ID Account_no Company 1Address Type 1Address1 1Address2 1Address3 1Town 1County 1Postcode Company_Notes TABLE: CANCELLATIONS Cancellation_ID DX_NO Company_Name...

Hello, I am just exploring the world of access (completely new never done it before EVER!), vb, forms and queries and i am totally in over my head. What i want to do is actually pretty simple in my head I just cant figure out how to do it in access, i hope some1 can help. I have two tables...