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!

Register Log in
  • Congratulations derfloh 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: *

  • Users: jdd3110
  • Content: Threads
  • Order by date
  1. jdd3110

    Printing a diagram in '97

    Hi: I have a very small database in Access 97 with just 3 tables, all related. All I need to do is print a relationship diagram to show my boss, but I cannot get a print preview screen or the design mode of my relationship window. Any ideas would bew greatly appreciated. Thanks JD
  2. jdd3110

    Count Function for an Expression

    Hi: I am making a report where one of my fields comes from an "if" expression in my query. It simply prints out "yes" or "no" in the report detail for each entry. What I would like to do if have a count total of yes's and no's in my report footer, but I am not sure how to do so. Any help...
  3. jdd3110

    File Transfer Problem

    Hi, I am helping a small business owner set up a very small network, 2 computers, both running XP pro. I have just set them up with a small 4 port router. My problem is that when I copy files from one PC to the other, many of them large media files, the folder sizes more than double on the...
  4. jdd3110

    Calendar Set and Close

    This should be easy...I have a calendar form to input a date into a particular field on a form. I want the form to automatically close when a date is clicked, but the way it is now, my entire main form closes rather than the calendar. Here is a portion on my code for the calendar. Any...
  5. jdd3110

    Update Query for Multiple Formats

    I am trying to update an Access field for pricing for a quote log. Some of the records have the price quote and some have NQ for "No Quote" I would like to make the records that are a numeric value appear as currency and leave the "NQ"s as text. Is this possible?????
  6. jdd3110

    Too few parameters. Expected 1. - OpenRecordset() Help

    I'm trying to run a DAO recordset when a value gets updated on a form in MS Access 97. Dim rstTemp As DAO.Recordset strSQL = "SELECT [WORK ORDER HISTORY].[INCIDENT NO], [WORK ORDER HISTORY].machine, [WORK ORDER HISTORY].DESCRIPTION, [WORK ORDER HISTORY].dept, EMPLOYEES.EMPLOYEE, [WORK...
  7. jdd3110

    Switchboard Problem

    I am trying to create a switchboard to navigate through 8 forms that I have already created. I used the switchboard manager as I always do, but on this particular project My switchboard will not run. I am getting an error code the reads "User-defined type not defined" in the code...
  8. jdd3110

    Capturing "NOW" in a field

    I am creating a form for a database at work and I would like to autopopulate the "date" field with the date and time that the record was saved. Is there any way to capture the now function? Thank you very much

Part and Inventory Search

Back
Top