Morning, Has anyone had any issues installing 2002 runtime on systems with existing full 97 or 2000 installations? I've trawled through the KB and are familiar...
What's up with this Error 3159, Not a Valid Bookmark? I've searched & searched the web, but am not finding a solution. The DB I have was working just fine. No...
How do you get the Header to span the whole page. If I extend the report to 7 inches in width - the whole first column is 7 inches, not just the header...
My friend Shri.Jayasheelan has written a macro which could be called on to a text box in a report to convert figure to words. Detailed Instructions are given...
In what format the data is being recd?. If you receive the attachment is excel format the same could saved oon to the hard disk with particular name. In access...
Thanks for your reply. I have not seen his DB or file structure yet as we have only been in discussion at this time. I believe he receives the emails in...
Carlos, I have seen the paypal format before... What you may have to do is create a rule in outlook to call a outlook macro to call some VB code agian in ...
Todd, Thanks for your reply. I am going to play with outlook and see if I can do what you are talking about. I have never created a form or used VB in it....
I haven't seen anyone answer this....is there a way I can change the following code so I can upload pictures as described below? Help, Help??? Lynn Bryant ...
Hello All, Sometimes my clients want to be able to add new reports to their database. So I build in a custom report generator, nothing new lots of people do...
Thanks, Guy. I am using Access 2002. I, too, thought it might be the reference, but I went in and checked off the two that started with mso... Still doesn't...
I don't use the mso dialog box. I use the following code in a module and call it with strFileName=LocateFile: Option Compare Database Option Explicit Type...
Lynn, FileDialog object is available only from Access 2002 onwards. You need to set reference to "Microsoft Office 10.0 Object Library" Best wishes, A.D.Tejpal...
Took over another person's Access 2000 database and did a bunch of work on it to discover that no matter where I print from printing using a docmd.openreport...
Robin, You might like to consider maintaining a master db containing all the latest reports as well as linked tables, queries etc. This master db, though...
Hello A.D.Tejpal, That sounds like a whole lot more work than adding a single table to the back end and a form to the front end. Maybe if you explain it a ...
I have a question on restricting data using a query. Perhaps I am approaching it the wrong way. I have a table for a city with zip codes in areas of town I...
I have a text list that I would like Access to create for me but I am having some difficulty with it. I capture text data from a VMS mainframe system and...
Robin, The alternative suggested in my post, would be relevant only if all the reports are designed and maintained in a central db. All front-ends can avail of...
Hello, Thanks for that. Yes I can see what you mean now, however, as you have realised, you can create a new report in any front end in the system. The method...
Hi Everybody – After a couple of brain-wracking weeks, I have begun designing my first DB. I am struggling, but determined to make this work. Would any of...
Ok, I checked and the reference was already set to MO 10.0 Object Library. Same error message? Any other advise. I have Access 2002 and copied this code...
Well, this must be waaaaay over my head because I tried replacing the current code from Northwind with this, but I'm getting all kinds of errors I have no idea...
I'm using office 2k, on an XP Pro OS. The help extras [javascript items] are now not working. I have Sun Java on the machine. Is there a way to enable those ...
Lynn- The Object Browser tells me that msoFileDialogFilePicker is defined in the Office 10 library. Setting a reference to that library should solve the ...
Hi John: As directed, I did a search for the msoFileDialogfilePicker and it is not in <All Libraries> in the Object Browser. It says "No Items Found". I also...