I have had the same problem using version 4. The code posted here works beautifully, but when you upgrade to 7.0 it fails. They have indeed changed the registry configuration and making any of the above changes does not work. I had to scrap and return to 4.0. I was hoping that someone with more...
Hi everyone: I successfully utilized the code that changes the default printer to Acrobat to print reports out of Access, which works well in a Windows 2000 environment, but have this machine upgraded to Win XP using Office 2003. Its no longer working. I referenced FAQ 703-2533 and duplicated...
I found the problem. Has to do with the query. I had some fields that were stored in the Master Table strictly to take up a column on the worksheet. See Reconmaster.Blank1 above. These were coming across as nulls, throwing the Error 13. But thats not all of it. I Tag on the Department Name, Bank...
That was an oversight. I had ripped out all the formatting code and must have forgot to put back in the piece where the strDept gets loaded. Good Point on the worksheet save as. I meant to rename the worksheet to the department name. Sorry. I hadn't gotten down that far in trapping the errors.
I've written a Database that imports raw data from a mainframe general ledger system which includes account number, cost center, office, product, etc. and the balance from the previous end of month. The purpose of this system is to create a workbook for each department in the organization based...
Thank you all for comments and I will start a new thread in the Access forum and post the code to see if you guys can help. I have crossed the bridge on the earlier error using the parameters. I believe it has something to do with the criteria I use. Its an auto-number ID field from the...
I don't have a choice about the exporting to Excel. These workbooks are sent out to different departments as a tool for them to reconcile their general ledger accounts that fall under their departments responsibility. I'm sure the formatting of the workbooks for each department cause the time...
I will relate my experience in what I think you are referring to. I built some SQL Server 2000 tables from Mainframe data that was imported to Sql Server via the DTS system. The intent being, what I think you are doing, so as to allow users to access this warehouse via Excel or using MS Query...
I've been reading many peoples questions regarding design on the forum and would like to ask your opinions on a project/system that I have written. I wrote a General Ledger Reconciliation system that gets its data from a as400 mainframe system via a set of queries that extract multiple financial...
I have a selection criteria forms that selects a group of records based on parameters and displays the records individually on a different form. The user would like me to add a Print button to print the form as it looks on the screen but in a report format. I have seen some code that allows you...
I have a Rich Text Box on an Access form that the user would like the ability to copy a paragraph from a Word document and be able to paste it into the RTF box on the form. The only events that I see exist on the RTF is the Click event. When I put the code in there to GetData from the clipboard...
I have a request to build an Audit package that has a form that allows memo data from an Audit opinion to be entered. The user would like the memo box to have formatting such as is offered by Word within the form. Is there a way to replace the memo table item with an embedded word document so...
I also have the same problem that you described. I have a form that has two data controls (Parent/Child) I have a dataclass that handles the logistics of both sets of data. I too have a bunch of fields that need to be combo boxes, because the user needs to see what is currently displayed in the...
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.