Search results

look ups are in different table which contails the ID and VALUES data type in the table which is being saved to is integer because I only want to save ID

Here is the problem I am trying to solve, I have not encounter this before. Let me describe the scenario table1 ID--VALUES 01-games 02-video 03-other I have combo box that needs to display VALUES from the above data. and the user should be able to select the values and I am storing the ID...

Hi Guys Here's what i am trying to do. My client wants to automate some tasks and one of them is to save a datafile from a webpage. I have a written a program that clicks the Download button and then the Open/Save Dialog box appears, I want to programmatically choose Save then enter the new...

Hi I have ACCESS 2007 application in which I do not want to show the All Access Objects on the left and stuff on the top. When somebody runs the app they should only see the start up form. How can I only show the start form in my app, if the individual running the app have ACCESS2007...

I am running the following search query on a table [Par_Client] containing 77195 records SELECT [Par-Client].Parent_Name, [Par-Client].CLast, [Par-Client].CFrst FROM [Par-Client] WHERE ((([Par-Client].Parent_Name) Like [Forms]![frmSearchParent]![txtName] & "*")); The application is crashing...

Hello Friends I am having problems dispalying my report correctly when sending it through mail DoCmd.SendObject acReport, stDocName My format option is excel. When I open the exported file, the data in report header does not display the headings/labels/fields names just the data, and which is...

you are right

I had TRUE instead of 0.3 as I was jut expermineting by specifying the wait time. That's bad I didn't get a compile error.

HI Guys I am trying to send some tab keys to an IE browser but it is not working. Here is my code. Dim IE As Object Dim IEpage As Object Dim dummy As String Dim i As Integer Set IE = CreateObject("internetexplorer.application") IE.Visible = True With IE...

Hi Have you seen the code here? I hope that helps for you. I have not tried it in the access2007

Set a reference to Microsoft HTML Object Library

Dim mainDoc As HTMLDocument Compile Error: User-Defined Type not definded This is the error I got when I tried to use your code. Can you please tell me how to define HTMLDocument. Thanks.

The website is a password protected website. The user first logs in the site and then use the web based application by entering the shipper number and then it generates some results. At this point the user wants to click a button on the Access form that will extract the data from the...

I just did

The website is a password protected website. So the user first logs in the site and then use the web based application by entering the shipper number and then it generates some results. At this point I want the user to click a button on the Access form that will extract the data from the webpage...

I have asked a question which is realted to the linked post. Please answer it if you can. Thanks.

Hey Darbid After looking at the post this, I can get started. What I am doing is this, I have to look for specific text and then copy the values next to it. I really don't have words on how to offer my thanks. You guys saved my job.

Oh well I will try some other forum.

Hi Guys I have been asked to write a VBA code that will get data from Internet Explorer and store it in Access tables. Internet Explorer is already open and the page that I am extracting data from is already displayed. Is it possible to do it in Access 2003? Thanks.

Set qdf = db.QueryDefs("Get_Distinct_Shippers") qdf.Parameters(0) = [Forms]![Form1]![Text3] Set ds = qdf.OpenRecordset 'I added the following line and works ok now ds.MoveLast myarray = ds.GetRows(ds.RecordCount) Thanks for the help.