Search results

Is there VBA code that will let the user choose a section of the screen and capture that screen portion as an image directly into an Access table?

Stock quote data downloaded from Yahoo Finance arrives in csv format. I'm using some stock analysis programs that require the data be imported in the MetaStock format. I've been searching the internet for code to do the file translation in VBA; however, so far I've only come across code to do it...

I cannot get any data to download from this code. There are no errors and the best that I can tell the syntex is correct. So, why doesn't it work. Can anyone see why it doesn't download data? ' Retrieve the file from the specified URL Set XMLHTTP = CreateObject("MSXML2.ServerXMLHTTP")...

I'm trying to update a table using DAO recordsets. The recordset update works partially, but when the process has completed the data has not changed. There must be something wrong with the recordset code. Also by looking at the Debug.Print results, it looks as though it didn't process all the...

I need help to increment a scrollbox when I scroll up or scroll down. The scrollbox has currency values; so I would like to increment by the penny.

I'm trying to sort by clicking on the label in the header of a continuous subform list, but I'm getting an error saying that the recordsource is locked. I haven't encountered this type of error before. Usually I can change the recordsource while the form or subform is open. Does anyone have...

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...

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

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 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 have a functional function that can duplicate a record so that I can edit a specific field and not have to enter all the data for all the fields in a new record. However, now I have a table that is in a one-to-many relationship with another table and this function will only duplicate the...

I'm getting an error in my code on the first EDIT command and I'd like to request someone's help. The error is: Public Function wmConvert_Containers(intContainer As Integer, intInventoryID As Integer) Dim strContainer As String 'Convert option value to checkbox value 'Insert data into...

I'm having trouble with my loop indexing. I can't seem to get the counter "j" to number the array correctly. The numbering should be sequential. Can someone help? Public Function InsertLabels() Dim intCount As Integer Dim intRecCount1 As Integer, intRecCount2 As Integer Dim...

I have two tables: tblChemicalProperties and tblHazardousComponents. I've been trying to give rank values to the hazardous components using the percent weight field. Each chemical should have its components ranked by percent weight. I've attached a prototype database to show you my situation...

I have two tables that are linked by a key field that I need to export for uploading onto a website database: Chemical Properties Chemical Components key field: ChemicalID I need help in developing a query or an output report to export the chemicals with their properties and the components from...

I've have used the usual code format for creating a column of row numbers for my query, but it doesn't seem to work. Sequence: DCount("InventoryID","Chemical Location","InventoryID <=" & [InventoryID]) I got this error So I tried this: Sequence...

I used to have Snapshot Viewer Control on a form to use as a report viewer, but that's no longer available in Access 2007. So I was wondering if anyone has had used other viewers on a form such as: 1. Adobe Acrobat 8.0 Browser 2. Microsoft Office Document Imaging Viewer Control I've...

I'm using an agency form in the background to make my report. Its a MS Word OLEUnbound on which I placed the data fields to fill in the agency's form. The form has a table where a list of chemicals needs to fit into. There are twelve rows to this list and when the list exceeds 12 I have the...

I found this code somewhere, but I keep getting errors on it. Try it and see what I mean. Is anyone familiar with the Scripting Library and can you help me on this? =================================== Private Sub btnCopyRow_Click() Dim dict As New Scripting.Dictionary Dim ctl As...