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 Chriss Miller 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. llkhoutx

    Win98 CD-RW won't read on WinXP?

    I burned (in multiple sessions) a 650MB, 74 Min CD-RW CD which was and is readable on other Win 98/ME/2000 PCs. I add new folders and files to it from time to time. My burner is an external "HP cd-writer 8200." The CD in question is a Sony 1X2X4 rewritable CD. I've tried to read...
  2. llkhoutx

    Export MS Access charts (Graphs) to MS Word

    My Problem: I need to export graphs generated charts in MS Access to MS Word, but can't find anything about how to do it. Of course "cut & paste" to MS Paint works, but is not satisfactory for my application. My questions to the forum are: 1. Is anyone familir with how to do it? 2. Is...
  3. llkhoutx

    How do I create a Cross Tab Look alike, which I can update ?

    Use a Crosstab query result as the recordsource for another query.
  4. llkhoutx

    Exporting A Query

    checkout TransferText in the Help menu
  5. llkhoutx

    Decimal number in a table

    Use the format and decimal places properties for your table field.
  6. llkhoutx

    Database engine can't lock table??

    You may have multiple copies of the database open. Maybe it is linked to another mdb which is open.
  7. llkhoutx

    How do I code a login form???

    Buy Litwin's Access 97 Developer's Handbook (by Sybex). Use the wizard to build various types of objects, then emulate them.
  8. llkhoutx

    Keep label and text field on same report page

    Even with grouping, if your group fills up a page and runs over, you still have no header on successor pages. Can you build your field header into the page header? I commonly do this, even with multiple line headers.
  9. llkhoutx

    make table query

    A make table query deletes the old table before the (new) table is created. Worry about formating at display or use time, not when the data is stored. When displayed or used it can be formatted if and as necessary.
  10. llkhoutx

    Updating Fields?

    I've seen a post that say use [FieldName]+1 to get to the next record, if this is true, I suppose that [FieldName]-1 would get you the previous record. Personally, I would use a recordset of the table, loop through it with DAO code, always keeping the previous value of a particular field...
  11. llkhoutx

    I need to parse a number from a string

    Try instr(), left(), right() - see Help menu for these functions.
  12. llkhoutx

    Deploy New Front End Over Network

    Your mdb should be stored on a Server(file or folder) that Users are only generally aware of and only have read access (no pun intended) to. That mdb is then copied to each Users harddrive from which it's ececuted, alternatively, each user has a batch file with does the copying at StartUp and...
  13. llkhoutx

    Can I Create An Append Query That Overwrites

    An overwrite is an Update not an Append. Link the table you want to overwrite to your acctive database and build an Update query.
  14. llkhoutx

    Installed programs

    Litwin's Access 97 Developer's Handbook at page 1136 has a solution.
  15. llkhoutx

    VBA controlled margins

    Once you set the margins for a report in Access, they are set, regardless of the margins in other reports. If you think that you need to set the margin every time you open a report, use Sendkeys (see the Help menu)
  16. llkhoutx

    Exporting A Query

    Check TransferText in the Access Help menu, that's what you want.
  17. llkhoutx

    Rowsource of combobox on toolbar

    Build a query with the correct field, then use that query as the recordsource for your combo box. Youn can have any number of fields displayed in the combo box drop list.
  18. llkhoutx

    Date comparison in SQL query problem

    Trap your strSQL when it's finally built utilizing a breakpoint and put in the QBE SQL frame to see if it will execute. Alternatively, build your query in the QBE frame, test until it executes properly, and then look at the SQL gerenated for that query. compare it to your original code and make...
  19. llkhoutx

    Query from de 3º caracter of the field

    First put a field in your query to select the first 2 characters of the field: Expr1:left(Article,2) with a criteria of "tx" then add another field in Expr2: right(Article,len(Article)-2) - this allows for the right most portion of Article to be other that a fixed length.
  20. llkhoutx

    Exporting A Query

    Look at "TransferText" in the Access help menu.

Part and Inventory Search

Back
Top