Search results

What if you don't have the Linked Table Manager installed? The IS Dept. did not give me the complete installation with all the wizards etc.

GumbyD, I tried your suggestion. Thanks!

How can I print arrows on my report? I need several arrows pointing from labels to text boxes. Thanks for your help.

It Worked! Thanks Rich.

Thanks Rich, this looks like exactly what I am looking for. I will have to study it.

I have: tblToEnterDates: with IDNbr (PK), RptDate tblToEnterLines: PK is IDNbr & LineNbr, has some other fields tblToEnterSamples: PK is IDNbr & LineNbr & SampleNbr, also field Charts. Each table has a one-to-many relationship to the next. On the report I show the date from tblToEnterDates in...

OK, it looks like my explanation was not clear. First of all, my original question was as follows: whether it is undesirable (due to normalization or other issues) to have fields in a table such that they would be empty in many records. Or is it better to have them in a separate table. However...

No, Approved, Denied, and Referred are not choices. They are 3 different fields which have numeric values. (Unfortunately the formatting of my example did not come out.) The choices are in the StatusCode field. Whether you enter or skip all 3 fields depends on the choice of StatusCode.

OK, Gambit, that did not really answer my question, which was whether it was OK to put the ADR fields in the same table with the status code. I did try it and tried your code, but it did not work. I was able to go into those fields regardless of the value of the status code.

The situation is as follows (simplified): The user selects a status code, enters other info which is in the same table. Depending on the status code, may have to enter Approved, Denied, Referred values. There are only 2 values of the status code out of ~20 choices for which the user needs to...

Oh well, I posted a little too soon. I fixed it by removing the record source of the main report. There were 3 records in the table that was the record source, so the report was printing 3 times. There was one field displayed in the header of the main report that was in that table, but I got it...

I had this problem before with a different set of reports, but forgot what I did to fix it. I have a report with 5 subreports. The report is printing 3 times i.e. I have 39 pages when I should have 13. The report prints through 3 times. I hope you can help!

I found an easy way from another post. I made a group header in each subreport and put the headings of the subreports there. Also, you need to set Repeat Section on in the group header properties.

Thanks Pat, I read the Action entry and you were right. I changed the path to just the directory, and the source to the filename, and it worked. Thanks for your help!

I tried TransferDatabase: DoCmd.TransferDatabase acImport, "dBase IV", "\\Aimscluster\Aims\Aims\URTracking\SURLOG.DBF", acTable, "SURLOG", "tblSURLog", False but it said: "\\Aimscluster\Aims\Aims\URTracking\SURLOG.DBF" is not a valid path. \\Aimscluster\Aims\Aims is mapped to the I: network...

How is this implemented? How do you determine when each subreport is being printed? Which property does it go in? Is this going in the subreports or the main report?

I am not sure what Excel version it is. Maybe I can try doing the TransferSpreadsheet with a different version. When I looked at Access help for TransferSpreadsheet, it did not list .DBF/Dbase files under spreadsheet types. It only lists different versions of Excel and Lotus. Can I use some...

I am exporting an Excel file into a new table in Access using the TransferSpreadsheet method. The data starts out in a UNIX/Pick system. I had been exporting the data first to a .DBF (Dbase IV) file, then saving the file as Excel, then using TransferSpreadsheet to transfer the Excel file to the...

I finally got the query to do what I wanted, so I did not need the code after all. Thanks anyway Fizzio.

Hello Newman! Thanks, that did it. I should have seen that myself.