Search results for query: *

I would like to be able to connect to a URL in access and store the response in a variable to display on a report. I use this code in Excel: With ActiveSheet.QueryTables.Add(Connection:= _ "URL;http://finance.yahoo.com/d/quotes.csv?f=l1&s=" & [A3], _ Destination:=Range("p32"))...

Hi All... Is there any way to tell which form just lost the focus? I have a field on a form that I would like to populate with a value from the form that preceeded it, but that form could be one of a few different forms. Any ideas? Thanks in advance! Griz

Hello All, I just got a freshly formatted computer, and for some reason this install of Access is not recognizing built in functions such as Date(), InStr(), etc? Any ideas as to why this might be happening? Any help would be appreciated. Thank you! Griz

Hello All I have a subform, and the AllowEdits property is currently set to False. The user needs to be able to create new records and fill in all the fields, but not change them after the record is saved. Ideally, I would want AllowEdits to be false for every field on the subform except one...

Hello All, I am trying to insert embedded "signature" images that are in an access table into a Word document based on what uniqueID is selected. I am familiar with how to insert text into a document based on some criteria using bookmarks, but I am having trouble w/ the images...

Hello All, I am trying to insert embedded "signature" images that are in an access table into a Word document based on what uniqueID is selected. I am familiar with how to insert text into a document based on some criteria using bookmarks, but I am having trouble w/ the images...

Hello All, I am trying to insert embedded "signature" images that are in an access table into a Word document based on what uniqueID is selected. I am firmiliar with how to insert text into a document based on some criteria using bookmarks, but I am having trouble w/ the...

Ok....I'm stumped. I have a table with a bunch of signatures embedded into it as OLE objects (bitmap images). What I would like to do is insert the correct signature into a Word document that is automatically generated. This would be based on a UniqueID that the user inputs. I can drive all...

Hello all, I have a form that uses a parameter query to build the recordset for the form. After the parameter is entered, I would like to be able to test to see if the query returns any records. If so...load form, if not...close form. How can this be accomplished? Any advice would be...

Does anyone know of a good reference for the Lotus Notes COM model for automation from VBA? I am trying to use access to generate tasks that are added to the "To Do" lists of specified users. Thanks for any assistance. Griz

Is there a quick and easy VB method to reset all of the controls on an unbound form to their default values? I sure hope so... Thanks in advance. Griz

Ok, I have a quick question.. I have a continuous Notes subform which displays all notes for a given policy. Currently the notes subform sorts the records from Newest to Oldest descending. This is great, but what I really want is for a New Note Record to be the first note on the continuous...

Hi All, First time post on this forum. Thank you in advance for any assitance. Here is my problem. I have a form which opens in data sheet view called "Claims". Each claim number is a hyperlink which pulls up a form called "Claim Notes" at the "On Click&quot...

Hi all.. This is a first time post. Here is my problem. I have a bunch of preexisting records with a field called "ID" The data in the field has varying lengths such as: 1 12 123 1234 etc. I would like to write a function that looks at this field and then transforms it...