Replies

Julie, we were all new to Access at one time. This forum is a great place to learn stuff.

If all you want to do is transfer information from Access to Excel, you can do this with a macro.

Click on the Macro tab on the database window. Click on the New button. In the Action column, click the dropdown arrow. It shows you the list of Actions. The first Action I usually run is a make table query. Select OpenQuery from the list of actions and enter the name of your query. If you don’t need to query for information, you can skip this step.

The next Action is the TransferSpreadsheet action. In the Action Arguments section of the macro design window, there are six arguments that you have to fill in. They are self-explanatory. The Transfer Type is Export. Be sure to type in full path to the File Name in Excel, such as c:MyDocumentsAccessMyData.xls.

Add the RunApp action as the next, and last, action you need in this macro. It has one argument, Command Line. Here is a typical command line:

c:Program FilesMicrosoft OfficeOfficeexcel.exe c:MyDocumentsAccessMyData.xls

Be sure an place a space between excel.exe and c:.

Save it, name it, and run it. If you do it right, this will work well for you.

HTH.

Thanks for the response. I looked at Cindy Meister’s article. From what I read and understood, she is only talking about getting data from Access into a Word merge document. I am looking for the opposite.

I will try the CSV method tomorrow.

Again, thanks.

Hi. You can do this by a macro.

In the action column of the macro,

SetWarnings: to No (the SetWarnings to No will stop those pesky warning windows from popping open.)
OpenQuery: to your makeTable query
Close: your query
OpenReport: to your report. Set the View to PrintPreview

Pay special attention to the Action Arguments in the lower part of the macro design window for each of the four actions.

This works well.

Hi Peter,

First, we need to know the version of Access you have and the version of dbase you are importing from.

You can also do what Charlotte recommends, but in Row Source, put this SQL:

SELECT DISTINCTROW tblCustomer.strCustomerID, tblCustomer.strCompanyName FROM tblYourTable ORDER BY tblCustomer.strCompanyName;

The dropdown list will let you type in the first few letters and will go to the first Company Name that matches the letters in the list. Then just click on the Customer Name you need and it will open that record.

Ian,

This forum has a lot of good discussions about templates and normal.dot. You should do a search for the threads.

From what I have garnered from these threads is that your colleague should have created a template that contains the styles, etc., and named it something other than normal.dot. You wouldn’t be getting this annoyance.

But, the best thing for you to do is read some of the threads here.

HTH (hope this helps)

Hi Vikas,

The tabbed data entry form is a good method for entering data, but doesn’t seem to work for a report. So, you either have to change the data forms to match the report you need or create a report that matches you survey form.

Suggestion:

Why can’t you create 13 reports that match each of the 13 pages in your tabbed form? You would need 13 parameter queries to collect the data for each page. A macro would contain the 13 reports. The reports would be created by the queries.

The main problem with this is that the 13 parameter queries would ask for the ID number 13 times. Somebody on the forum may know how to code SQL to store the ID value that the queries would need so that you would only have to enter the ID once.

Or, the queries could be written completely in SQL with an input box for the ID number. The SQL would read the input box value for each query and then run the reports.

Is this something you might think is useful?

Joyce,

You may not need to use VBA code. You could set up your queries as Make Table queries, put all the queries in a macro, turn the Make Table warnings off, then in the macro, run a report that reads totals from the new tables. Making the macro, the Make Table queries, and the report would require you to read the online help, but it would be worth your while to take the time. Access can do a lot of things without having to write code. In the long run, though, if you plan to stick with Access, learning some VBA will really make you a good application developer.

HTH

Gail, memo fields are two part fields. Part of the field shows in the table view (or query view). The other part is stored in another area (don’t ask me where). Online help talks a little about memo fields.

The query result you get is limited to displaying about 50 or so characters in table or query view. When you open a report or form, you can see all or most of the memo field, depending on how large your fields are set on your report or form. That is why you see the whole field in the report, but not the table.

You are not doing anything wrong.

I havn’t been able to open any of these .mdb attachments. I have Office 97 SR-2 on Windows 95. I get the “Unrecognized database format.” error.

Also, Word 97.

Just tried this on a 7 line, six sentence, paragraph.

If the first line is italic, changing styles from Normal to Body Text didn’t change the first line.

When the first two lines (not sentences) are italic, changing from Normal to Body Text did change both lines.

When I didn’t include the first sentence in italic, changing from Normal to Body Text didn’t change any of the paragraph.

When I included the last two words in the first sentence with the rest of the paragraph, it didn’t change.

When I included the last three words in the first sentence with the rest of the paragraph, changing from Normal to Body Text did change the whole paragraph.

Very strange.

Thanks, BAM. That is why I said it “appears” to turn track changes off. I didn’t know for sure.

Hi, all. In Word 97. if you click on Tools|Track Changes|Highlight Changes|Options, you open a dialog box that appears to allow you to turn Track Changes completely off.

John, I haven’t used Office 2000. Here is a problem I found when I tried to import a Paradox 8 table into Access 97. Access 97 is older than Paradox 8 so Office 97 didn’t have a converter for Paradox 8. What I did was save the Paradox table to DB V and then imported. That was all I could figure out. You may have the same kind of issue, QuattroPro 9 may be newer than Office 2000.

Ken, in Access 97, if I open the form, resize it while it is open to the size I want, and then save it while it is still open, it keeps that size when it opens again. This is the only way I have been able to get forms to stay the size I want.