Search results

Okay, thanks darbid. I'll take a look and try to get a solution.

Okay, thanks for your reply. There is no advantage to downloading to an Excel file, not for what I'm trying to do and I would rather not have it in this format at all. This was the last format I experimented with to see how it came out. Sorry if this was misleading.. The format I am really...

darbid, I have been researching this for a couple of days and the code I posted is the best I have managed to get together. You may notice from the 'PageAddress' in the code I posted that I have already tried to find an answer in this forum and many others across the net. I don't have a...

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

Great. Thanks David.

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

OK, thanks for all the replies. Thought it was worth exploring..

Thanks for the responses. Yes the form could be hidden, and I was thinking I could use a startup form as part of a splash etc. sure... The question is a general one and not for a specific db. I'm just looking for a better method. It may be better if I give an example of a situation. A db...

I'm trying to move away from using macros, and am finding an increasing need to use VB, mde files and make my systems more secure. As macros can't be locked I want to be able to run the entire code in VBA. At the moment I set a form to open at startup and run code on it's open event to...

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

Thanks Bob. Problem solved... I follow the code and will apply it to my db, but if you could explain why it actually is that the query/macro version didn't work and why it wasn't a problem with the textbox I would be grateful to understand the problem as well as well as having the solution...

I have added a new file which also includes about 13500 characters ready to paste into the textbox, to save people doing it themselves. 13500 will be ample. cheers... :)

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 Seb Could you just have a form where you enter one set of times and set the query to run when another form opens which fills in the other set of times? Set the query as an action in a macro and then set the macro as the 'On Open' property of the form you want to use to list all the times...

Maybe Seb needs to have it stored in a table and doesn't want to bother entering the same info twice. Seb - look at the attached. Run the 2 queries. If you put In times into table In1 and run the TimeIn query it makes a new table and adds a column with Out times. The other table and query...

Running Sum Thanks. I'll have a look at it on a copy of 2000. I don't really see where it doesn't work though. I'm assuming you noticed the change in the grouping code? I just put it in to demo subgrouping. If the the grouping code and order qtys are the same, and even if all values are...

Running Sum Thanks for all the replies and suggestions, sorry I have only just picked them up. I have tried adapting all the ideas to my query and the SQL below fits best to what I need. Maybe others will find it useful?: SELECT a.Part_Number, a.Qty_Ordered, a.Grouping_Code, a.Index, (Select...

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

Parameter Issue resolved Thankyou Bob for offering to help with this. However, I think the problem is now solved. It seems the Text to Number fields were what causing the issues with the parameters. By creating a new query with the fields from the original query and setting the criteria in...