Screen Scraper - Help Finding Example Or Tutorial Please.

Jun 10, 2007

New member here. I've searched this forum and the internet but came up dry and sure could use some guidance.

There are plenty of references to being able to use Access 2003 VBA to open a separate program (in this case it will be Internet Explorer 6.0) and scrape data from the window, importing it into a table. But all of the references only mention that it can be done, not how to do it. Apparently, it is such a common thing that pretty much everyone except me already knows how to do it.

Can anyone please point me toward a tutorial that walks step-by-step through the process of using VBA to open IE and extract data? If there isn't an online tutorial, maybe someone has an example I could use to figure it out.

Any and all help is appareciated.

Thanks,

DiverGuy

View Replies

Finding Location Of Listbox On SCREEN And Not On Form

Jun 11, 2014

I have code that finds the current position of the mouse on the screen in X,Y coordinates.

I am curious if there is something similar that can let me know the X coordinate (basically the .left function but for the screen) of a listbox?

View 3 Replies View Related

A Simple Login Screen / Also Access In Full Screen

Jul 27, 2006

I have tried to make a login screen, I have also searched for information and tried some of the examples but, I just can't get one to work.
Is there someone or somewhere where I can get information on how to build one step by step in simple easy instructions....(access 2003).

Also, how do you get access to open all the windows, tables, queries etc in full screen mode.
I have expaneded them and shut it down and then reopened it but they still want to open out of full screen mode.

Thanks, everyone has been a great help in creating my first Access program.

View 3 Replies View Related

SQL Tutorial

Oct 20, 2006

Hi,

I am trying to learn how to use SQL. Can ayone please tell me where to download/view a comprehensive and easy to use tutorial?

Thank you very much.

Gareth

View 1 Replies View Related

VBA For Access Tutorial

Jun 4, 2005

Does anyone knows a good VBA for Access tutorial or documentation i can download so i learn how to write the Event Procedures in MS Access?

Thank you for your help.

View 1 Replies View Related

Need A Good Tutorial

Jan 26, 2006

I have been selected to do a project by my department head. It involves programming an Access database to do various things. It has to have forms and all that good stuff. I'm trying to get the higher powers to get a web server for me to do this as a web application, but I may need to fall back on the Access idea. So I need a good tutorial on programming in an Access environment. I know it uses VB and I am pretty decent when it comes to programming with that language. What I need help with is how to do certain things like close a form using an onclick event or to print a report. There's a lot I need to be able to relearn so if anyone can point me in the right direction I would appreciate it much. I'm doing this for a Commander in the US Navy...(several ranks above me )...so I need to be able to pull this off!!

Thanks much,

JMH

View 1 Replies View Related

Access Tutorial With Exercises

Sep 21, 2005

Hi All

I have just spent 30-40 minutes reading through this forum. So many solutions. Excellent. http://www.access-programmers.co.uk/forums/images/icons/icon7.gif
Smile I am just starting Access and I want to find a course where there are exercises which will take me to a reasonably proficient level.

If anyone has done come across a book CD or online that they would recommend then I�d be most appreciative.

All the Best
Jacky Kenna

View 1 Replies View Related

Customer Database Tutorial

Jul 5, 2006

Hi

I am new to Access and would like to learn by taking on small projects.

Does any body know any good tutorials for beginners that could show how to start a database for a list of customers or something similar?

I have looked at the ones that can be created with the Wizards but obviously this doesn't help you understand the mechanics.

I would like to learn the 'nuts and bolts' so that I can expand the database and create new ones the more advanced I become.

Any good suggestions would be appreciated.

Thanks

View 2 Replies View Related

Looking For A Chart Creating Tutorial...

Apr 17, 2007

Anyone know a good site w/ help creating charts in Access 2k? I have a few queries id like to display as charts but just playing w/ the chart feature is getting more confusing by the minute. Any tutorial would be great. TIA!

View 1 Replies View Related

Access Tutorial Videos

Nov 11, 2007

Sorry, couldn't let the world go without these instructional videos. It's not much, but it's a good place for beginners to start:

Access Instructional Videos

This might be a good sticky

View 11 Replies View Related

Expression Builder Tutorial Or FAQ?

Oct 13, 2006

Now I have been working for a few months with ACCESS but one thing that keeps giving me trouble and that is the "Expression Builder". I look at the Microsoft Help and it is not good in explaining this part of ACCESS. I have Access books and they are not good with explaining this aspect of Acess. Is there anyone with a good source to point me in the direction to learning the Expression Builder better then I know now?

View 1 Replies View Related

A Thorough Tutorial That Helps One Make A Mean Database

Oct 24, 2006

Hello all!

I have been searching online for the past couple of days for a thorough tutorial that aids the user to make his/her own detailed database based on example data (that does not necessarily have to be adhered to) supplied as the tutorial progresses.

As a student participating in an advanced computing class, I feel that this would benefit me as I can do as the steps ask and see how certain things are done. I am not a complete Access mug... I have a basic knowledge of the fundamentals, but stumbling accross an in-depth tutorial that details all of the standard features (tables, queries, forms etc) along with possibly some example modules would be excellent and beneficial.

All I have found so far is various snippets - "SQL basics" and "Macros: what they do and how to implement them" for example - these miss the bigger picture I am looking for. Surely a step-by-step tutorial on "Designing and working a fully-featured database from the gound up" is not that rare!

Thanks in advance for any help. :)

View 5 Replies View Related

Recommend A Tutorial To Print Records Please?

Mar 8, 2007

Hi,
I'm using Access 2000.
I currently use a form to enter my customer details. As soon as the info is entered I need to send out a "thank you for joining" letter, but I can't figure out how to print out a single field, it prints them all.

Ideally I'd like to have a button on the form so I can print it out on a template.

Can anyone recommend a good tutorial on how to do this, or offer any advice please?

Any help would be greatly appreciated!

Many thanks

View 7 Replies View Related

Online Tutorial For Form Design?

Jun 4, 2005

I am new to Access and not a sophisticated user of computers. I've been given the task of redesigning some forms on an existing data base. I understand how to put the new fields I'm adding into the table associated with the forms I'm working on, but I've having a hard time actually moving stuff around the screen and getting it lined up.

Is there an online tutorial or reference I can go to that will teach me the layout basics?

View 1 Replies View Related

QBF (Query By Form) Advice/tutorial/example Appreciated!

Jul 7, 2006

Hi,

I have some basic VBA and ADO recordset exposure, and would like to create a form, that:

- allows a user to search 4-5 fields (client & business name based information)
- return options of records to view that match that data
- allow user to make a selection, which then provides another form with full details of that client's record(about 20 fields)

Can anyone provide an example or perhaps guidance on a good tutorial, that will take me through this process gently (and help me understand the process)!

Regards and thanks

Mack

View 1 Replies View Related

Looking For Good Tutorial On Feeding A Site With A Database.

Oct 25, 2004

I am very new to ASP and Access. I need to learn how to create a database full of images and text to feed dozens of webpages for a new site I am doing. I have googled many times and can't really find what I am looking for. I've come across ADO several times. Is this similar to what I am looking for? Thanks.

View 5 Replies View Related

Beginner-Tutorial For Retail/inventory Table(s) Set Up

May 5, 2007

Access Guru's:

I am a beginner at best with Access. (I'm using Access 2003) I have a small in home business as a second job making silk flower arrangements. I am now to the point that I need to track my inventory, quantity used, COGS, etc. Most of my arrangements are in gift shops on consignment.

In lieu of buying Quickbooks Manufacturing ($$$), I want to start tracking everything with Access so I can at least get some nice reports at tax time.

The problem I am having is I cannot translate the tutorials that Microsoft supplies to this application, they only cover setting up basic tables. (ie: in a retail/inventory application - do I set up 1 table, 1 table & subtable, 2 tables????)

I set up a table so far with 4 basic inventory fields:
Item description (record includes: flower, vase, foam, etc) / Color / Qty on Hand / Cost. Then (on the same table) finished goods fields of: Qty Used / Arrangement # / Qty Left / Sold for. While trying to figure out how I am going to track how much each arrangement cost, I'm not sure this set up will work.

I probably went into too much detail for my question, but I wanted to give some kind of background. Is there a CD/Book/Tutorial that specifically guides one through setting up a retail/inventory table?

Sorry so wordy.

Catherine

View 1 Replies View Related

Password Protecting A Form - Microsoft Tutorial Error

Jul 22, 2005

I was using this form tutorial to password protect my administrative tools. When I went to run it I received this:

"User defined type not defined" and the line Dim rs As DAO.Recordset was highlighted.

I have little experience with VB and I was wondering if someone here had any idea if it was their code that was wrong, or if it was something I did...

View 7 Replies View Related

Create A Tutorial That Tracks Progress For A Specialized Access Database

Apr 13, 2007

We are working on an access2000 database that will incorporate various "tutorial" or "training" elements in the db on how to use the db (mostly links to outside PDF files, etc.); the training elements guide users on how to do various data entry tasks, report generation, etc.

Is there a way, in Access, to track which "step" of the procedure a user is on? For instance, if they make it through Exercises 1-5, is there a way we can add some sort of indicator that lets them know, when they come back to it a week later, that they left off on Exercise 6? I have seen this done in various software tutorial packages, but I'm not sure how it is accomplished?

Any suggestions?

View 1 Replies View Related

"Do Not Show This Screen Again" : Splash Screen

Aug 1, 2006

Hello all,

I have this splash screen, which welcomes all the users. It has an OK command button that exits the screen, and a checkbox that says "Do not show this screen again". I still do not have the code behind the checkbox. Thus I was wondering if there is a way where I could entirelly close or "get rid" of the splash screen until the user loggs in again. Because right now there is no code behind it, so everybody that checks it and click OK, leaves the screen. But they can still open it, if they select the "splash form".

View 11 Replies View Related

Splash Screen

May 25, 2005

i have spash screen that runs for about 10 seconds, would like to reduce to about 4 seconds any ideas

seee script below.

Option Compare Database
Option Explicit

Private Sub Form_Close()
DoCmd.OpenForm "Switchboard"
End Sub

Private Sub Form_Timer()
On Error GoTo Err_Form_Timer

DoCmd.Close

Exit_Form_Timer:
Exit Sub

Err_Form_Timer:
MsgBox Err.Description, , "ASSETSonTRACK"
Resume Exit_Form_Timer

End Sub
Private Sub Command21_Click()
On Error GoTo Err_Command21_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Switchboard"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Command21_Click:
Exit Sub

Err_Command21_Click:
MsgBox Err.Description
Resume Exit_Command21_Click

End Sub
Private Sub Command23_Click()
On Error GoTo Err_Command23_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Switchboard"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Command23_Click:
Exit Sub

Err_Command23_Click:
MsgBox Err.Description
Resume Exit_Command23_Click

End Sub

View 1 Replies View Related

Splash Screen Help

Oct 14, 2005

Hi all,
I was wondering if it is possible to use a splash screen in the middle of your program? Ex. Can I have a splash screeen to display at the beginning of my database and then have another splash screen open during my program. If i click on a command button to display a form, cause I have a splash screen appear before that form load?
Is till possible while using Data Access Pages as well?
thanks in advance

View 3 Replies View Related

Full Screen

Aug 29, 2006

Hi,

I searched in this form and on the internet on how to display a form in Full screen; however, I could not find an answer that worked.

Does anyone knows how to display forms full screen please?

Thank you,
B

View 5 Replies View Related

Flickering Screen

Nov 7, 2006

Hi,

I used a tab control in a form. However, when I move the mouse over the form, the form flickers.

Has anyone ever experienced the same problem?

Thank you,
B

View 4 Replies View Related

Logon Screen

Nov 28, 2006

Hi, i want to add security into my database, but i dont want to use the built-in workgroup security.

Is it possible to create a login screen that will allow different access rights depending on the username? If so can sum1 please help me with the code?

Cheers Guys :)

View 1 Replies View Related

Navigation Screen

Jun 4, 2007

hey

i build a navigation screen

the problem : i want to activate this in the tools-operation , but i can't (i dont see the name of the navigation screen there ...

View 2 Replies View Related