Hello Everybody, I would like to see a webpage in an Access file with Refresh feature to see latest data. The URL of webpage is given below. Please let me know...
Hello Everybody, I would like to see a webpage in an Access file with Refresh feature to see latest data. The URL of webpage is given below. Please let me know...
Hi Darrell (Reginald?), Additionally, you may want to consider times where the value CAN be changed -- such as an error was made. In these cases, I have a...
Hi Peter, from this statement: Me.TTOYYMM = Format(DATE, "YYMM") & "\" it appears that you may have a fieldname or controlname that is called DATE do...
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the MS_Access_Professionals group. File :...
MS_Access_Professiona...
Nov 1, 2008 6:56 pm
66994
Hi Dinesh, I have uploaded a sample database for you to download. You can find it in Files > 1_Samples ...
Hello Patrick, I just caught this message. How would I add multiple URL's? Bernie Penkin ODOT Region 1 TMOC 503-731-4652 Motivation: If a pretty poster and a...
I need to prepare a series of reports every month that present visitor activity on our website. I have a report which selects records from a criteria query. ...
Hi Bernie, If you mean store URL's you can add your URLs to a Table and use your preferred method to load the URL into the URL textbox. You can also save your...
Hi Bernie, I should have added in my last post. This is the code which opens a URL: WebBrowser.Navigate (your URL string here) I used a command button and...
Hi Robin, the easiest way is to set this to be the ControlSource of a textbox: =[Filter] What I often do is make a "friendly" criteria string when I make...
Hey Patrick, I have MS Access 2000 and when I try to open your sample db, I get the dreaded "You have to upgrade" error. Is there a way you could save that...
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the MS_Access_Professionals group. File :...
MS_Access_Professiona...
Nov 2, 2008 6:09 am
67003
Hi Tim, I converted my DB to 2000 format and named it WebBrowser2000.zip. If you still can not open it, I also uploaded instructions on how to do it yourself...
Hi John Viescus, From the first time I saw your code I had a feeling that it must have at least 75% solution even if it was not functioning once I changed...
Hi Crystal, Thank you for your message. Date is not a field - it is today's date I wanted to use. I'll try your suggestion. Thanks a lot. Cheers Peter ........
Hi Shan Roy, I am glad you were able to get the results you wanted. Good for you! Best Regards, Pat ... have at least 75% solution even if it was not...
you're welcome, Peter ;) Warm Regards, Crystal Microsoft MVP remote programming and training Access Basics by Crystal (Bill Mosca's site) http://thatlldoit.com...
All, quick question: is there a way to add any formatting to text in a data collection field of a data collection email? InfoPath is not an option. Example: we...
I am using A2007 and need to get number of records in Queries in a separate database file. I tried DCOUNT but it resulted in 1 record for queries with joins....
Hi JT, here is some code you can modify '~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Sub GetNumberOfQueryRecordsInAnotherDatabase() 'returns number of records in query ...
JT, Sample function named Fn_GetRecordCountInExternalQuery() as given below, should get you the count of records in a table or query located in an external db....
Hi guys I have an Access 2007 front end & SQL server datafiles linked to front end by linked tables. I have a combobox in a bound form with a simple query as...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
