Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 44
Search took 0.21 seconds.
Search: Posts Made By: iworkonline
Forum: Forms 02-18-2011, 04:52 PM
Replies: 3
Views: 1,322
Posted By iworkonline
Re: combobox reading values

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
Forum: Forms 02-18-2011, 04:20 PM
Replies: 3
Views: 1,322
Posted By iworkonline
combobox reading values

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...
Forum: General 10-28-2010, 08:49 AM
Replies: 1
Views: 725
Posted By iworkonline
Entering filename in the Save As DialogBox

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...
Forum: General 09-29-2010, 02:39 PM
Replies: 4
Views: 11,080
Posted By iworkonline
hiding navigation and top menu from access 2007

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. ...
Forum: Queries 09-13-2010, 03:45 PM
Replies: 1
Views: 748
Posted By iworkonline
Query Crashing In Access 2007

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...
Forum: Modules & VBA 09-09-2010, 02:13 PM
Replies: 0
Views: 508
Posted By iworkonline
report header is not included in the emialed report

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,...
Forum: Modules & VBA 08-30-2010, 09:31 AM
Replies: 4
Views: 1,177
Posted By iworkonline
Forum: Modules & VBA 08-30-2010, 09:22 AM
Replies: 4
Views: 1,177
Posted By iworkonline
Re: Proper use of Sendkeys

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.
Forum: Modules & VBA 08-30-2010, 08:59 AM
Replies: 4
Views: 1,177
Posted By iworkonline
Proper use of Sendkeys

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...
Forum: Modules & VBA 08-30-2010, 08:47 AM
Replies: 5
Views: 1,759
Posted By iworkonline
Re: Sending email using VBA code

Hi

Have you seen the code here (http://www.access-programmers.co.uk/forums/www.everythingaccess.com/tutorials.asp?ID=Outlook%2DSend%2DE%2Dmail%2DWithout%2DSecurity%2DWarning)? I hope that helps...
Forum: Code Repository 08-26-2010, 02:34 PM
Replies: 2
Views: 14,131
Posted By iworkonline
Re: VBA Program to get a IE HTML DOM Tree

Set a reference to Microsoft HTML Object Library
Forum: Code Repository 08-26-2010, 01:06 PM
Replies: 2
Views: 14,131
Posted By iworkonline
Re: VBA Program to get a IE HTML DOM Tree

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.
Forum: General 08-11-2010, 09:51 AM
Replies: 16
Views: 12,660
Posted By iworkonline
Re: Screen scraping in MS Access

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...
Forum: General 08-11-2010, 09:01 AM
Replies: 16
Views: 12,660
Posted By iworkonline
Forum: Access FAQs 08-11-2010, 09:00 AM
Replies: 4
Views: 197,355
Posted By iworkonline
Re: Navigate Internet Explorer using VBA

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...
Forum: General 08-11-2010, 08:35 AM
Replies: 16
Views: 12,660
Posted By iworkonline
Re: Screen scraping in MS Access

I have asked a question which is realted to the linked post. Please answer it if you can. Thanks.
Forum: General 08-11-2010, 07:23 AM
Replies: 16
Views: 12,660
Posted By iworkonline
Re: Screen scraping in MS Access

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...
Forum: General 08-10-2010, 02:37 PM
Replies: 16
Views: 12,660
Posted By iworkonline
Re: Screen scraping in MS Access

Oh well I will try some other forum.
Forum: General 08-09-2010, 02:40 PM
Replies: 16
Views: 12,660
Posted By iworkonline
Screen scraping in MS Access

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...
Forum: Modules & VBA 07-16-2010, 01:51 PM
Replies: 4
Views: 929
Posted By iworkonline
Re: Unable To Read From Recordset Into Arrays

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 =...
Forum: Modules & VBA 07-16-2010, 01:50 PM
Replies: 4
Views: 929
Posted By iworkonline
Re: Unable To Read From Recordset Into Arrays

Set qdf = db.QueryDefs("Get_Distinct_Shippers")
qdf.Parameters(0) = [Forms]![Form1]![Text3]
Set ds = qdf.OpenRecordset

ds.MoveLast
myarray = ds.GetRows(ds.RecordCount)
Forum: Modules & VBA 07-16-2010, 01:32 PM
Replies: 4
Views: 929
Posted By iworkonline
Unable To Read From Recordset Into Arrays

Hi Guys

I need to read the stuff from the recordet into array. I have tried using GetRows method but it only reads one record. Here is how I am doing

Dim myarray As Variant
Dim ds As...
Forum: Modules & VBA 07-08-2010, 02:10 PM
Replies: 5
Views: 1,299
Posted By iworkonline
Re: group box/option box has no value

Hey Bob

Thanks for the illustration and that's how I created the option box using the wizard. But I did not know how to use the frame control. Initialy the frame Default Value, I set that to -1,...
Forum: Modules & VBA 07-08-2010, 01:45 PM
Replies: 5
Views: 1,299
Posted By iworkonline
Re: group box/option box has no value

Hello Bob

I am using 2 option buttons. and I don't see an index property for option button.
When I was creating the option box I remeber setting the index but I don't know how to access that...
Forum: Modules & VBA 07-08-2010, 01:02 PM
Replies: 5
Views: 1,299
Posted By iworkonline
group box/option box has no value

Hello Fellowes

I have created an option group box with 2 options and in the VBA code I have an if statement if one of the option box is sekected or not like so


If Me.optSoft.Value = True...
Showing results 1 to 25 of 44

 
Forum Jump



All times are GMT -8. The time now is 01:29 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World