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 strongm 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. 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...
  16. 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...
  17. nqobile

    Bound Column property does not work for lookups with more fields

    Bound Column property does not work for lookups with more than one fields unless the others have column widths of 0cm. What other property does one have to set to force the lookup to bind to any other stated field?
  18. nqobile

    Error message when opening database file

    When opening my database the following message come up 'Microsoft Jet database engine could not find the object MSysDb. Make sure the object exists and that you spell its name and path name correctly'. What could be the problem and the resolution? The only thing I usually do is restore the...
  19. nqobile

    Increasing the default number of fields in a table/query

    Is there a way by which more that 255 fields can be defined in a table or query in access 2000.
  20. nqobile

    round up when capturing numbers to 2 decimals

    Each time i enter a number with 2 decimal places it is rounded up and I would not like this to happen. any suggestions on how I can keep the number as is???

Part and Inventory Search

Back
Top