Search results

Try using a field called Customer ID in your Customer Addresses table which I hope you did. Now on the after update event of your Address Combo write the below code "Select tblCustomers.FName from tblCustomers where Addresscombo.CustomerID=tblcustomers.CustomerID"; If you can upload your DB...

Hi, Please find attached a sample databse ...See if this is something you were looking for...Or atleast the logic

Greetings and welcome to AWF. Could you please upload a sample of those three combo boxes along with the tables so one of us can look into it. As every problem is independent I might be prejudice in providing you with an example.

Hello All I have a table called Activity with columns ActivityID, PolicyID (Lookup from tblPolicy), CustomerID (Lookup from tblCustomer) and further ... I have an activity form with details from tblactivity..further I got a Dashboard where all the records are displayed including ActivityID...

I Seriously need some help friends, From the below mentioned scenario...I basically have a table called Activity with columns ActivityID, PolicyID (Lookup from tblPolicy), CustomerID (Lookup from tblCustomer) and further ... I have an activity form with details from tblactivity..further I...

Hello All, I am looking for a way to create a popup in Internet Explorer using VBA. I was just wondering if there is a method in ie.document to create a pop-up. However Where can I find all the properties and methods of an ie object. Any help would be highly appreciated. Many Thanks

Additions: I've managed to close the current tab once the pdf is opened in a new tab by using Start = 0 StopTime = 5000000 While Start < StopTime Start = Start + 1 Wend ie.Quit The pdf file pops up with a file download dialogue box with three buttons Open,Save & Cancel. How can...

Hello All, Once again I am struck. I've got a form in access which (When submit button is clicked) submits the form's data to a website which inturn generates a pdf file (Which gets opened in a separate tab (of IE)). I want to save this pdf file somewhere on the drive. I've looked for at...

Hello All, I've got a table named tblEmployee with a field called attSignature of attachment datatype which inturn holds jpeg files of employees signatures. My query is when I create a letter in word I'd like to replace <Sign> with this signature. I've tried this but its replacing the word...

Hello All, I have a combo box and a 3 checkboxes in a data sheet view form. I'd like to enable or disable one or more checkboxes depending upon the value of the combo box for that particular record. Unfortunately Conditional formatting cannot be applied to a checkbox (atleast not that I...

Using recordsets All I need is to check if the button was clicked or not.

I've got a Web Browser which displays a form with a submit button. All I am doin' is saving the information filled into the fields of the web browser into a recordset object. I want to first save them to the table when the user clicks the submit button. and then navigate t the next page.. HTH

Hello Again, I am struck again with this web browser...I am unable to capture the button click event on this web page...the source code looks like <divclass="submitBtn clear right"> <inputtype="submit" id="policy-details_Save and Calculate" name="method:calculate" value="Save and...

Are u sure its not rst.FindFirst ("[Institution] = " & Organization.Value) Also you are not checkin' if you've found the record or not... If you've found it then you dont have to add a new record... Anyways I can give u a hint and you work around... If found then the recordset should be opened...

The following code in the above scenario clicks the button ie.Document.all("method:calculate").Click Hope this might help one of you to see how can i capture the state of the button... I mean to check if the button is clicked or not...

Besides Beetle's suggestions, When you open a record set in write mode you got to change the RS to write mode explicitly like... rst.AddNew rst.Organization= Institution.Value rst.Address= Address.Value rst.City= City.Value rst.State= State.Value rst.ZIP=Postal Code.Value rst.Country=...

Hello Again, I am struck again with this web browser...I am unable to capture the button click event on this web page...the source code looks like Let me make it clear... I dont want to click the submit button rather want to save the data entered into the fields to a recordset...

Hi Missingling! I think you were right. Though I wasn't clickin' the button rapidly but when I delayed the click for about 10 secs it works.. Probably coz When I click the button it actually opens a web browser and the page takes a while to load... I Hope the While busy...do events.. should...

When you reply you've got a little paper clip Icon on the format bar ...Use it to upload...however its a good Idea to zip it before uploading...

Could you upload your DB to quickly have a look..