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 wOOdy-Soft 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 nqobile

  1. nqobile

    Error Message on closing database file

    Ladies and Gentlemen, May I extend my sincerest apologies to all for being such an ill-mannered and selfish person. Judging by the comments, no explanation may be good enough (apart from me being remorseful of my actions),but may I say a few things. I accept that I have overlooked finding out...
  2. nqobile

    Error Message on closing database file

    Ladies and Gentlemen, May I extend my sincerest apologies to all for being such an ill-mannered and selfish person. Judging by the comments, no explanation may be good enough (apart from me being remorseful of my actions),but may I say a few things. I accept that I have overlooked finding out...
  3. nqobile

    Error Message on closing database file

    Upon closing my database, the following message pops up -Table 'TempMSysAccessObjects' already exists. Can anyone help.
  4. nqobile

    cannot print a report

    When clicking on a switchboard command button, a message "there was an error executing command" comes up. After some investigation another message comes up "there was a problem retrieving printer information for this object.The object may have been sent to a printer that is...
  5. nqobile

    Removing user- level security

    I applied userlevel security and have had to remove it because of problems I was encountering with other applications that were linked to / or using data from the database. The problem is that the applications (intranet and arcexplorer)do not have read, view and run permissions on objects in the...
  6. nqobile

    Number of fields in a table or query

    My table is to have 212 fields but my access 2000 keeps saying I have define too many fields once I reach the 124th field. I ended up splitting the table into two,with the hope of creating a make table query that will bring them together. It still wont work. NB: tables and queries take a maximum...
  7. nqobile

    Defining an customised autonumber

    How can I make a number field automatically increment in a table withouth using autonumber. I dont want to use autonumber because it has limitations.
  8. nqobile

    record locking information

    Record locking information is appearing for a database that is closed. How do I unlock these records? How would the database be affected if I delete the .ldb file?
  9. nqobile

    Outputting report to Word

    How can I output a report to MS Word without losing the formatting (lines and pictures) on the report?
  10. nqobile

    please help with a select query

    I have a numeric field with eight digits and I would like to select records where the first five digits are specified and the other three can be any i.e 13201###. When criteria is '13201#' and '13201###' it gives an error message saying 'data type mismatch in criteria expression'. Please help.
  11. nqobile

    Problems with replication

    when replicating there's an error message that says "microsoft access can't open the database. Could not lock file"
  12. nqobile

    how can I link database with arcview or arcexplorer

    There's a feature for using arc explorer on the control toolbox. Unfortunately I cant find it now and I would like to explore it to link to our database. Can anyone help on where I find it and use it???
  13. nqobile

    How to link dbf file to an access database

    I've been able to link between access and dbf files , but I cannot seem to concude how I update or add new records through the database forms (to automatically update the dbf's). The dbf files are from Arcview shape files, so we want to update shapes through accesss. Can anyone help????????
  14. nqobile

    how can i remove replication

    My replica got corrupt and would hang when I tried to synchronise, I then deleted it. I want to remove the replication from the master and redo it without losing any information? What do i do???
  15. nqobile

    Bound Column property does not work for lookups with more fields

    Thanks for the response Littlesmudge. May I elaborate on my problem. For example, my rowsource looks like this 'SELECT LUEntity.EntityID, LUEntity.Entity, LUEntity.Description FROM LUEntity;' The field that should be edited by this is a text field bound to LUEntity.Entity. I also want the other...

Part and Inventory Search

Back
Top