I went thru and did a saveas on every form, query and macro. Then I rebuilt the forms, queries and macros with the new names. To my utter suprise it now works. I still don't know what the problem was but it seems like it must be mis-spelling of something like that. I appreciate you help....
When the Results Form is called with the Query as the Data Source, Access puts up a Enter Parameter Value message box with the criteria statement shown.
I am having a problem getting my Query to use the SubForm value as search criteria.
I have:
Access version 2003
Mainform - Location Master Browse - Location Number
Subform - Location Account Browse SubForm - LocMast - Location Number
Query - Bank Master Browse Query - LocMast - Location Number...
No such luck.... am using ADO.NET (XML)... I just thought of another way to tell if I am not at the highest level. Is there a way to tell if your have indented the value because that is what the hierarchical sorting is doing.
I am using CR 10 and have grouped by data hierarchically to produce a Table Of Contents. The TOC is perfect as far as the data being correct but I need to format the various levels of the TOC different based on what level it is.
My question is how do I determine what level I am at so I can...
AirCon,
You must have missed the messages that went out today. The problem has been found and corrected. Read the posts and let us know if you have any questions.
I finally found some Microsoft documentation that actually explains why you need the path.... Wish I had found it sooner...
Adding pictures
Pictures are added to the Shapes collection with the AddPicture method. The syntax is as follows:
oSheet.Shapes.AddPicture(cFileName, lLinkToFile...
I just ran a test where I put the JPG signature into a newly created Excel workbook and e-mailed it to myself. The e-mail attachment is just fine. The Excel file is OK. Don't really know what that proves but it does work.
It doesn't bomb... It just doesn't place anything into the cell. Here is the code being used...
* Update Sheet 14 (Declaration)
SELECT .aPagePrintOptions[tcFileId, PPO_RESULT_CURSOR]
GO TOP
toWorkbook.Sheets("Declaration").Select
toSheet = toWorkbook.ActiveSheet...
Yes, I just did that with this JPG file and it worked perfectly but when I execute the code in FoxPro it bombs. It sure is so strange doings...
Got any ideas??
I haven't had a chance to really test this logic yet but had planned on doing so this afternoon. What this JPG file contains is a signature that needs to be placed in a certain location on the worksheet. This worksheet is a duplicate of a printed report which has the signature graphic printed...
I have a JPG file that I am try to put into a Excel cell. I am having no luck with this. Anyone ever done this before? It sounds easy enough but doesn't work for me.
This is the code I am using.
toSheet.Range("C28").Value = TempSig.JPG
Any help would be greatly appreciated.
I didn't find that of much help but have gotten the code to work up to a point. I can now create a JPG file from the FoxPro General field. The problem now is getting Excel to accept the JPG file.
Here is the code that I have written with sigfile the General Field in table UserInfo1. This is...
I am trying to develop a excel spreadsheet that mirrors a set of reports. In a couple of the reports a JPG file stored in a General field in printed on the report. I need to know the method to allow me to copy the JPG file to a cell in the excel spreadsheet.
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.