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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by djgolds

  1. djgolds

    Compare billing statements

    Is there a way to do an Unmatched Query and use multiple fields for the comparison? What I'm trying to accomplish is to compare a line-by-line billing from a vendor with my own billing spreadsheet and I need to match on address, service date, equipment, and dollar amount to determine any...
  2. djgolds

    Can't access open data source in mail merge

    I've created a brochure that includes a text box for adddresses. My addresses are created in Access. For some reason, Publisher is not allowing me to get to the open data source (it's grayed out). Any suggestions?
  3. djgolds

    Text Boxes created in Word 2000 can't be viewed in Word 97

    I've created text boxes using Word 2000, but when I email the document to my client and she opens it up, the text boxes are blank. She's using Word 97. Does anyone know of a solution? Thanks in advance for your help!
  4. djgolds

    Can't get Excel column width to be fixed

    I've created a PivotTable and below that I've entered formulas for percentages based on the calculations in the PivotTable. Every time I change my selection in the Pivot table, it reduces the column widths so that it's not wide enough for the calculations I've entered in below. Any suggestions...
  5. djgolds

    Need help calculating in Access

    I've created a table in Access based on a survey that consists of 80 questions and a combo box for responses to the survey questions (yes, no or partial) and which region they belong to (total of 5 regions). Table Example: Question 1 Response Region Now I want to be...
  6. djgolds

    How to Order by Records by two or more fileds displayed

    I'm having the same problem. I have a table that consists of only 4 fields (Date, Payable To, Category & Amount). Payable To and Category are based on lookups that I have added within the same table. I've created a form for data entry, and I absolutely cannot get these to sort in ascending...
  7. djgolds

    Does PageMaker work as well as Adobe Acrobat for PDF's?

    I need to purchase software to create pdf's and was going to buy Adobe Acrobat, but I have the opportunity to purchase PageMaker at a great price. I currently use Microsoft Publisher for making newsletters, brochures, etc., but I'm assuming PageMaker would be a better choice. I guess I really...
  8. djgolds

    How do you convert a date to year only?

    I have a column in my table that is in date format example 01/25/2001. I'd like to convert this date to year only to do various queries. Even though I put my format as yyyy in the query, when it does the filtering, it returns numerous instances for the same year becase it still recognizes the...
  9. djgolds

    Help with Limit to List and Column Widths property

    Thank you all for your help on this, but I'm still going to need more (sorry, I'm slow!). John, I'm not sure what you meant by opening it up in dialog mode, and also, from your last email, no, I'm not familiar with using DoCmd.RunSQL. Sorry, but I'm one of those that needs step-by-step...
  10. djgolds

    Help with Limit to List and Column Widths property

    I have a database set up for all of my customers. One table lists customer names and addresses. Another table lists types of businesses. It has 2 fields, one is the primary key auto number and the second field is the type(insurance, attorney, etc.). I have created a form for my customers and...
  11. djgolds

    Need help converting text field to date field

    The BirthDate field actually started out as a number field. The preceding 0's before month and date were entered, but because it was a number field, it didn't leave the 0 in place for the month. I then changed it to a text field hoping to do the conversion from text to date. I tested it out as...
  12. djgolds

    Need help converting text field to date field

    I'm going to make 1 last effort to see if there's a way to do this. Thanks to those that have helped so far! I have a table tblTest2 where the BirthDate field is entered as a text field and I want to convert it to a date field. What I've tried so far is creating a query from tblTest2 with the...
  13. djgolds

    How do you convert number field to date field?

    Don't faint - but it worked . . . for at least the first line. In my test2 table I'm only using 6 entries and it converted the first entry, but the rest were blank. If you want to give up on me at this point - I understand!!! In case you don't, I copied and pasted the SQL in the "update...
  14. djgolds

    How do you convert number field to date field?

    This is the last time - I promise! If I don't get it on this one, we'll just forget it. I'm a bit confused by the SQL as in one message it included datevalue, and the new message didn't. I should have done this from the start, but my table name is Test2. This table includes a BirthDate field...
  15. djgolds

    How do you convert number field to date field?

    You're right - it was eliminating the first 0. I tried 3 times exactly as you had it and I get dialog box that says can't update due to violations. If I go ahead and click yes, it deletes the BirthDate column and my newDOB is blank. Sorry, you must be wanting to beat your head against the...
See more

Part and Inventory Search

Back
Top