Search results

On my form I have several filters that work independently; however, in order to maintain a display of data that I want, these filters need to be combined. Can someone help me build a complete form filter by using these individual filters? Form DeclarationsOption Compare Database Option...

Thanks, That looks like the solution. I'll give it a try. PC

I'm familiar with creating a table using VBA; however, I need to create a table with an index field (aka key field). Just using some simple code, could someone show me what I need to do to include an index field when I create a new table? Thanks, PC

It appears that Google provides stock quotes. How to get a real-time stock quote using Google API http://yken.org/2009/01/05/how-to-get-a-real-time-stock-quote-using-google-api/ Google Finance APIs and Tools http://code.google.com/apis/finance/docs/2.0/reference.html#Feeds Historical Quotes...

This seems to work. Try this. Let me know if you have any questions. Option Compare Database Option Explicit Private Function RequestWebData(ByVal pstrURL As String) As String 'http://www.emoreau.com/Entries/Articles/2004/03/Using-The-WebRequest-object-to-retrieve-Yahoo-stock-quotes.aspx...

I'm having trouble with the ADO connection and I was wondering if someone can help? Public Function DownloadData(Symbol As String, StartDate As String, EndDate As String) Dim DownloadURL, stockSymbol As String Dim StartMonth, StartDay, StartYear As String Dim EndMonth, EndDay...

Do you download data into a database table through your connection? How do you insert the data into the table after its downloaded?

I'm wondering if I should use DAO or ADO in my code. Its not clear what the Excel code is doing with the "Connection" command. In ADO this command is used to connect with an internal network and its possible that now its being used to connect to an external network. Does anyone have ideas on...

I see that this forum has a sample database that possibly can be used to chart stock data A Line Charting VBA Syntax Demo. If I could get the Excel code to work in MS Access, I might be able to utilize the code in this demo. Does anyone know how to translate code for Excel into code for...

There's code for an Excel spreadsheet that I would like to use in an Access database. It downloads stock quotes from Yahoo! Its from this website: Creating an Automated Stock Trading System using Microsoft® Excel® I need advice on how to get this go work in MS Access.Sub GetStock(ByVal...

I had the same problem, solved it and posted a sample here on this forum. Search for "Counting Checkboxes On A Continuous Subform". Sample1 Also you can find it at Sample2 Good Luck, PC

Ok, for those who are interested I've finally solved the problem and I am sharing it for you. I've made a public function that I call to do the bookmarking. ===================== Public Function SubformSync() On Error GoTo Whoops Dim db As DAO.Database Dim rst As DAO.Recordset...

Great!! Sounds like you found your answer. I hope the samples that I reference for you were helpful. They are in the postings that I mentioned. Do you have a small demo of your project that you'd like to share with us? Thanks, PC

I asked a similar question and I have some examples in the post, if you would like some additional information. See this posting.

Syncronize Generic Subforms I have been making use of the concept of subform swapping from the Subform Swapping Demo; however, now I've come across a problem of syncronizing the subforms. I've been able to use a filter combobox on the main form and control the results in the subforms by...

I have a form with a subform control that can change subforms. I have a filter on the main form and I've managed to find a way to change the record sources for any active subform. However, I need to syncronize them whether or not they are filtered. I've tried to use the LinkChildFields and...

I have a database with a number of option fields that I want to include in a word merge document. I have no trouble with regular fields or checkboxes, but I need some advice on transfering option values to the same type of formated form as on my database. Thanks, PC

I've further developed the code, but it's still not working. Can anyone help?Option Compare Database Option Explicit Dim db As DAO.Database ' For main table Dim qdf As DAO.QueryDef Dim tdf As DAO.TableDef Dim idx As DAO.Index Dim fld As DAO.Field Dim strPKName As...

This is my first attempt to adapt Allen Brown's concept to the generic function and I'm getting this error: on this line of the code: Set tdf2 = db("SELECT * FROM strSubTable WHERE " & "idx.Indexes = " & varPKVal) This is the code:Function fCopyRecord(strMainTable As String, strSubTable As...

FYI, I see that Allen Brown has an approach that works. I'll have to see if I can adapt it to the generic function that I have shown. This is Allen's dupication function: Duplicate the record in form and subform ~~PC