Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. newtech2

    Word to Acrobat hyperlinks

    I have converted a word document, which has several hyperlinks, to pdf using Acrobat Reader Standard 6.0. As long as I created the pdf within Word, the hyperlinks came along with them. But, the hyperlinks with bookmarks toward the bottom of the pages, do not jump to that bookmark, only the top...
  2. newtech2

    Spreadsheet Linked to DB

    I have a spreadsheet linked to an Access 2000 DB. This spreadsheet updates upon opening. I have a user that receives the following message when attempting to open the spreadsheet: "The Microsoft Jet Database engine cannot open the file {file location path} It is already opened exclusively...
  3. newtech2

    Multiple Users and New Records

    MichaelRed: Thanks! I am new to programming in Access. Where would I need to place this code and where do I need to tweak it? Thanks in advance!
  4. newtech2

    Multiple Users and New Records

    I have split a database with the app local and data on network. I had a problem with my form receiving a duplicate value error on the autonumber field when 2 users made a new record. I have since changed the data type of the autonumber field to number and added the following code to my form...
  5. newtech2

    Form Filter then Parameter Window on Print Report on Lookup Field

    I am quite new to Access programming. . .please forgive some of my names, etc. I have tried many different things to get my filtered form to print on my report, but no go. Here is the background. I have a form, Main Job Form, with a print button that prints out the records on a report...
  6. newtech2

    I am quite new to Access programmin

    I am quite new to Access programming. . .please forgive some of my names, etc. I have tried many different things to get my filtered form to print on my report, but no go. Here is the background. I have a form, Main Job Form, with a print button that prints out the records on a report...
  7. newtech2

    Lookup Problems

    Thanks so much for responding. Regarding double negative and spaces in field names: it has been a learning experience.
  8. newtech2

    Lookup Problems

    Background: Main Contact Table [Contact ID] [Contact First Name] [Contact Last Name] [Discipline ID] is a look up to the Discipline Table Discipline Table [Discipline ID] [Discipline Name] [Disc Deactive] yes/no qryDiscipline: is a query with all fields from Discipline table Main Contact...
  9. newtech2

    Combo Box Independent from Field

    I was under the impression that if I limited the combo box list to only "active", I would no longer see the names in the records prior to being marked inactive. It worked just fine! Thanks!
  10. newtech2

    Combo Box Independent from Field

    How to I make a list for a combo box “independent” from the field? I have a form with a record source of “Job Query.” I have combo box with a record source of table “SAM”. This list for the combo box has become quite large and some of the names in the list have become inactive and won’t be...
  11. newtech2

    Why doesn't the top of my Tabbed form show without scrolling?

    Try clicking in the gray area on top, to the right of the last Tab. You should see only 1 set of sizing handles. Now click and drag the tabs down lower.
  12. newtech2

    "Neat" Filter Criteria in Report

    I have a button on a form which takes the records from a filter and prints them on a report. I have added this code to the report to reflect the filter criteria: Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As Integer) Let Me.txtFilter = Forms("[My Report...
  13. newtech2

    Report changes orientation!!!

    See http://support.microsoft.com/default.aspx?scid=kb;en-us;Q240826 Lost Printer Settings When Name AutoCorrect Is Enabled (Q240826)
  14. newtech2

    How do I set a OLEGraph's Row Source on Report Open??

    -Click once on the chart of your report in design -Right click chart -Properties -Select your query on the drop down for row source.
  15. newtech2

    I was having trouble with a chart r

    I was having trouble with a chart report coming up with a blank page. The tip I received is the following which worked great! Note: The mentioned [Forms]![frmChartReports]![EndDate] and [Forms]![frmChartReports]![StartDate] is 2 unbound fields ([StartDate] and [EndDate]) on a form...
  16. newtech2

    Try Refresh, Requery, Other? Thanks!

    I received some help from Microsoft on this. This is what they had to say. . .seemed to work like a charm!. . . Based on my research, the graph does not match the data of the query result, but it is referencing data from the original result in the report. This behavior seems to be on Windows...
  17. newtech2

    Try Refresh, Requery, Other? Thanks!

    I think you are on about the report not closing. After playing with it more, I noticed when the chart report comes up in print preview, and I click close, I moment later I can hear my computer “cooking” for a second. FrmChartReport was, of course, still open when I clicked close on print preview...
  18. newtech2

    Try Refresh, Requery, Other? Thanks!

    I have a form, frmChartReports, with 2 unbound controls: StartDate and EndDate. frmChartReports also has 5 command buttons that run its own report which is a chart. Each of the chart reports are based on parameter queries, which use the unbound StartDate and EndDate on frmChartReports. When...

Part and Inventory Search

Back
Top