Hi All,
We use for reporting a web page with a lot of fields, I have no control on the web. Somebody have to type in the information submit it and do it again. I get all this info in a database. Is there a way from my database to make some VBA code to populate the fields of a webpage?
Thanks...
Hi all,
I have an asp web page (intranet) with a list of document that the users could download. It works well for desktop but not for laptop. On desktop a window open asking to open or save or cancel and for laptop the browser is working endlessly, no window popup. I could not find the...
If windows explorer is open and I run VBA codes in Access that have Scripting.FileSystemObject in them. Windows explorer stops responding and funny icon appear instead of the yellow folders picture, I could not see the contain of other folders, I must close and reopen it to be able to access...
Hi to all,
Here is my problem:
I had an access 97 database on windows XP machine. It was open with a timer on a form. It works find for a long time. We migrate to Office XP. I import every thing from the 97 database to a new XP Access. It work find for a day then it seem that the timer when...
Hi,
I have an hyperlink to an Excel document. When user click the link, it open in IE but I would like them to see the “Open save as” window instead. How could I force that?
Thanks,
Jean-Paul
Montreal
To send me E-Mail, remove “USELESSCODE”.
jp@USELESSCODEsolutionsvba.com
Good morning all,
In my AS400 source I have tables with date fields, if I import a table with a package to a text file, there are dates like “0001-01-01”. Before I import directly my AS400 tables into Access without problems because Access read those date as “1901-0-01”. Now we have to move to...
Hi,
I have ASP page connected to an Access database, every thing work find. Now I need a page with date input, could be done easily, that will generate a PDF file from a query to be downloaded. How could I dynamically generate PDF reports.
Thanks.
Jean-Paul
Montreal
To send me E-Mail, remove...
Hi,
I use Access to send information with Lotus note, it must be sent automatically. I print a report and e-mail it, it work find until for formatting raison we need to print the report with Acrobat.
I set Acrobat as the default printer on the computer where the e-mails are send.
Use the...
Hi,
I run a very long query. I would like to show a progressbar on the form that I use to start the query., not the status bar. How could I do that.
Thanks,
Jean-Paul
Montreal
To send me E-Mail, remove “USELESSCODE”.
jp@USELESSCODEsolutionsvba.com
Hi,
I have a table with date and trips like the following:
Trip Leg Departure End
123 1 11/2/03 11/2/03
123 2 11/5/03 11/05/03
123 …
123 5 11/16/03 11/16/03
I need to create a report with the duration of the trip like:
Trip Duration
123 14 days
How could I do that?
Thanks,
Jean-Paul...
Hi,
I use Access to send information with Lotus note, it must be sent automatically. I print a report and e-mail it, it work find until for formatting raison we need to print the report with Acrobat.
I set Acrobat as the default printer on the computer where the e-mails are send.
Use the...
Hi,
I use Lotus Note in Access to send e-mails. When Lotus is on the c: drive, it works find but when it is a roaming profile on a network drive, it give me an error message: “ ActiveX component can’t create object” error # 429.
It stops on the line:
Set...
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.