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 Mike Lewis 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. jiminy

    concatenate

    In Excel 2007, I have the hardest time with CONCATENATE. I have 2 columns of text that I want to concatenate together (row by row). If in cell C2 I enter =CONCATENATE(A2,B2) the result is just THAT-- As if I had put quotes around the whole thing.
  2. jiminy

    Link or import

    I have an Access DB of personnel-type info. The info originates online in different Excel files that are updated on different schedules. Each is renamed according to the date it was last updated. I cannot link the online files to the DB, so I have to save them to my computer and link or import...
  3. jiminy

    combining field contents

    Is there a way to combine 2 text fields in a table to make a third in the same table? Example for one record: Field1 = 1 Field2 = a Field3 = 1a
  4. jiminy

    corrupted table.

    ps. It is pdox ver 9.00.368
  5. jiminy

    corrupted table.

    I have a pdox table of some 3000+ records. I was trying to change the driver language and wound up with a corrupted table. I ran the table repair and wound up with only 378 records. Did this a couple times. Each time the 'copy of' table shows the correct size, but is mostly unreadable. The...
  6. jiminy

    putting a database on an existing website

    Is there a way to put a database such as Access or Paradox on an existing website so that guests can query it for data, but not edit it?
  7. jiminy

    What do I do to setup a database-based website???

    Is there a way to put a database such as Access or Paradox on the web for user query access, but not edit access? We would like to post searchable, cross referenced data.
  8. jiminy

    spreadsheets within combo boxes

    I would like to put a combo box onto my form. The associated table has one field that has different spreadsheets as objects for some of the records. I would like the user to be able to choose a record from the first column (name of a publication), and see the spreadsheet of data in the 2nd...
  9. jiminy

    indexes and keys

    Definitions please: What is the difference between a composite index, composite key, vs primary + secondary index. Is creating a composite key as simple as defining 2 fields as keys? I haven't seen any good how-to references on this.
  10. jiminy

    adding a field

    How can I add a field to an existing form without starting from scratch?
  11. jiminy

    Word Standard menu

    I've r-clicked up as far as the name of the doc. Rebooted, Pressed esc. No change.
  12. jiminy

    Word Standard menu

    Alt-v doesn't show anything.
  13. jiminy

    Word Standard menu

    To clarify: I have NO bars. Neither tool or menu. When I right click on top, I get the size/move etc list.
  14. jiminy

    Word Standard menu

    I don't see any tools. ps This is Word 2000. Forgot to mention that.
  15. jiminy

    Word Standard menu

    I must have done something to hide the standard menu bar in Word. Control-V does nothing, right clicking only shows the short cut, paste, etc menu. I've tried right clicking all over the document and edges with no luck. Any other ideas? I looked in the MS office tools folder & it doesn't...
  16. jiminy

    Problem with absolute reference in excel vba

    I have always been frustrated when excel moves the cursor. I have gone into Tools/Options/Edit, and then unchecked the 'move selection after enter' box. However that will stop it from moving for everything you do. (I suppose with programs also?)
  17. jiminy

    change table name in a query

    I would like to write a program to change the table name in a query, and then run the query. The table structure will not change, nor will the checked fields. Reason: I always forget the fields (predetermined) I'm looking for.
  18. jiminy

    Token?

    What, in SQL lingo is a Token? I get references to it in some error messages.
  19. jiminy

    running saved 2-table query

    I created a 2 table query using a data model. It ran at the time I created it. Then I saved it for future editing and use, but when I try to call it up, I get the msg "Expecting consistent number of columns in all rows of table" The related Help, says it may have an incorrect # of...
  20. jiminy

    Problem with a Changeto query

    I am trying to use the changeto command in a query to change a numerical (N type) field with a calculation. This would affect all the records in the table. I get an error msg saying I am trying to link 2 tables (WRONG) and the fields are not the same type (number fields should have no...

Part and Inventory Search

Back
Top