I'm a developer and have a non-profit customer looking for an easy to use PO system. They are not looking for anything too fancy - enter a requisition, have one or two levels of approval based on dollar amount and print a PO for the vendor. Their budget is $2,000. It would be installed on a...
Does anyone has any suggestions on how to improve performance on a processing intensive Access application. There is a small frontend that is about 9 MB. There are 2 backend databases. One with static data that is almost 1 GB. The main table is 3 million rows of stock option quotes. The...
Can you create stock and/or candlestick charts in Access? If yes, then what version did they first become available in?
Also, is it possible to add technical indicators, such as a moving average, to a stock chart?
Thanks,
Brooks
I'm an experienced Access/VBA developer and am having trouble with importing some html data files into Access.
I've tried:
1. Toolbar wizard, External Data, html Document - gives 2 errors, first says it can't file the html file, second says the file may be in the wrong format.
2...
This occurs when trying to print from IE10 or OL2003.
Says line 2378 - the remote server machine does not exist or is unavailable.
Is this something wrong the in Java configuration/setup?
I've looked at the Java (32 bit) settings in CP and don't see anything wrong.
Any help appreciated.
I get a "Script Error" window when I try.
Error: The remote server machine does not exist or is unavailable
URL: res://ieframe.dll/preview.js
I get the exact same error from Outlook or IE.
The OS is Win7 Home Premium, 64 bit.
Things I have tried:
1. Downloaded and installed the latest Win7...
Microsoft says: “Only members of the sysadmin fixed server role can run a package that contains a Bulk Insert task.”
http://msdn.microsoft.com/en-us/library/ms141239.aspx
I got an error trying to run a Bulk task that a co-worker could run with no problem.
So in my Login Properties, Server...
I'm an Access developer with 10+ years of experience that would like to start doing database applications on websites.
Are there any web languages close to VBA?
Is mySQL the best solution for backend databases or are there others I should consider?
Where do I find a web-based report writer as...
I’m working in a network environment.
If I do:
strFile = Dir("\\(some user’s machine)\C$\Documents and Settings\All Users\Desktop\*.*")
to test the connection to a user’s machine and their machine is turned off or in sleep mode, I will get an error 52 (“bad file name or number”).
This is ok...
Hey guys,
I'm a developer here (VB/VBA MCP/MCT) but have an end user question/problem.
I upgraded my Msft Office from 2000 to 2003 two months ago and Outlook 2003 is driving me nuts. It crashes while getting mail and I have no idea why. When I restart it, it checks the PST file saying it...
When you connect a hand-held device running Windows Mobile to a laptop via a USB port, is it assigned a drive letter so you can read from it? If not, how do you use files on a hand-held from a language like VBA?
Thanks!
I'm an experienced MS Access developer and need advice and/or code samples on reading text and JPG files from a Motorola hand-held which is running Windows Mobile.
Thanks,
Brooks
I'm an experienced Access developer and haven't seen this before.
I have code behind a button on the form and it won't run. No error or anything. I tried recreating the button with the code and it still won't run.
I put a STOP statement as the first line of code and it doesn't reach it...
Is there anything built into A2003 for saving reports as PDF files?
I need to be able to do this from code.
If not, is PDFCreator (public domain) a good choice?
Other ideas?
Thanks!
Trying to find a reliable method to do this.
1. SendObject will not work with external files and supposedly is not reliable after A97.
2. Have been trying CDO samples without luck. Got error:
"the SendUsing configuration is invalid"
then tried a sample which included...
Looking for an open source/free/low cost database or list of words as in an English dictionary for searching from VBA code. Word meanings would be nice but I will settle for the words. They can even be ASCII format and I will create my own database.
Any help appreciated.
Brooks
Hi,
I'm trying to duplicate in VB5 code from Excel 2000 for working with a stock chart.
In Excel VBA, to set a chart type it is:
ActiveChart.ChartType = xlStockOHLC
In VB5, I added the Excel Chart using the OLE object tool. The object is: OLE1, so I tried:
OLE1.ChartType = xlStockOHLC
but...
Hello,
Can anyone tell me which version of Microsoft Charts first supported candlestick (stock) charts and which version of Office Pro it was in?
Thanks!
Brooks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.