Search results

Hi Guus, Thank you very much for this info! Sup

Hi Guus, Actually it can't really be opened in Excel. If you open it in Excel (or in any text editor), all you see is weird random characters with a customer name here and a item description there and other bits of random field data scattered throughout the file which is mostly gibberish. In...

I'm trying to extract invoice and payment transaction data from a very old version of quickbooks. This very old version allows for the export of customer and item lists to .iif format which I can view in Excel. However, there is no method of exporting transactions. All of my searches for how to...

I have 2 separate Access 2013 Web Apps on a Sharepoint 365 server. Web App 1 was created by uploading related tables to the Sharepoint Azure SQL. I am hoping to use that app strictly for housing the tables which are currently linked to a desktop application which is working very well. I'm...

Update: DSN-less connection error Sharepoint 365 With fresh eyes this morning and a little more research I found my problems. In the interest of saving others the wasted time and frustration that I experienced, here is what I did to make my DSN-less connections work: 1) In order to...

I have uploaded my back end database to an Access App on Sharepoint 365. I have set the permissions to allow access from any location and to allow read-write. When I create a ODBC data source in the ODBC Data Source Administrator, the connection works fine. My front end includes code to make a...

Update: Access App (not web app) on Sharepoint I think I have determined that "Publishing" an A2010 accdb to Office 365 Sharepoint does nothing but save some of the objects to a sub site. It seems that Office 365 Sharepoint requires A2013 to open or edit the uploaded objects, which need to be...

I am trying to run an Access front end with a Sql Server backend from an Office 365 Sharepoint site. I published the (A2010) accdb to Access Services using my Sharepoint url. It uploaded a the local tables, but ignored the linked SQL server tables. It also uploaded a few of the forms, but most...

Smig, I just downloaded Inno-Setup. Thanks for the tip! Sup

Thanks Dave, From all of my research , I think you're right. I n order to do what I wanted I needed to create my own custom print dialog form with a printers list. I grab the current default printer name, then change the default to the selected printer from my list. Then I get thenew default...

This for an app being used in Access 2003. I'm trying to (sort of) automate naming a PDF report. After the user selects a printer from the print dialog, if the printer name is like "*PDF*" then I want to put the PDF file name in the clipboard so it can be quickly pasted in the file name of the...

Having Order By on both sides of the Union, along with an end char(;) separating the 1st query from the 2nd did the trick! Thanks so much for your help! Sup

I'm trying to filter a combo based on the selection in another combo. The twist is that I need the row source of both combos to include an "*", "(All)" selection, as I am using these combos to filter a listbox. When I add the Union query with "*", "(All)", the row source in the 2nd combo is...

Yes, I tested the report and it had the same issue. I guess it is the vm causing the problem. Thanks for the help! Sup

Here's a sample A2003 db with the same issue in the report in A2010. Thanks for looking at it! Sup

Yes, text alignment is set to general. I tried left as well with no luck. I just rebuilt one of the reports in A2010 by copying and pasting all of the controls and code module. The rebuilt report works perfectly. I am developing in A2003 and the app will be used in both 2003 and 2010, against...

I have a report in an app that I built in A2003. When I open the app in A2010, everything seems to work well, except report preview, in which the text is spread out with huge spaces between the letters. In the page layout view, everything looks right including the sample text. Printing the...

I discovered that the linked sql server table "sys_objects" includes a field for table type. I no longer need to write code to find that info. Thanks, Sup

I need to update data in a bunch of tables of a sql server database. The database has 300 tables which I have linked via odbc. I'm hoping there is a simple way, using vba, to loop through my linked sql server tables and determine which of them are views as opposed to tables. Any help would be...

The acImage and .picture references were guesses that happened to be correct. I guess I should have relied on intellisense to confrim that. The hardest part for me was setting the sizemode correctly, as it changed when importing the new image. I did get it to work with the following code...