Search results

Hi I would like to find an efficient and effective way of retrieving text from webpages using VBA in Access, basically a web query. I know this can be done in Excel and have experimented with the code below to do this in Access. I really just need to get the raw data into a file so I can...

Hi I am trying to find a way to build custom scrollbars into Access forms that are linked to say a textbox, and moving the scrollbar or slider, (where a min and max value could be set), updates the value in the textbox. Excel has useful form controls such as scrollbars, spinners etc. that...

Please could someone tell me how to perform autoexec in vba? Is there a function name or startup property that needs to be used? I need to run this without using an autoexec macro or running code off the back off a form at startup. I have searched the net and tried the obvious things...

I have set up databases that use append queries to update data into linked Excel tables/ranges using Access. This functionality was removed in one of the 2002 service packs, because from what I understand someone owned some code that enabled it to work and microsoft wouldn't pay them for it...

Hi I have a database that is used to log details of phone conversations, (ie. call centre). It has come to light that the end parts of some records are missing. There seem to be various strange goings on including chopping off characters after 255 when it writes to a table - which I can...

Hi I have a query that shows part numbers with a total qty ordered for a specified time period. This first part of the query is fine and is made into a table. I am then trying to use this table to create a running sum with the list sorted in descending order, and ultimately break the list...

Query will not filter I have searched other threads and cannot find one that helps solve my problem. So, I hope someone can help. I have a query which runs ok until it is filtered. I have tried using criteria to filter the info I need but this returns an 'Enter Parameter Value' message...

Hi, I have a query with a 'many to one' join from a table of selected part numbers I want to look at which includes new part numbers with no current order numbers, to a master order table with all order numbers raised against all part numbers. The query returns null values for the new part...