Search results

  1. JPFred

    "Id is not an index in the table"

    I was doing some coding and was going to save and close the db when the problem happened. I was trying to get to the compact/repair tool but the error message was modal and I could do nothing. I actually had to use task bar to kill the session since when I clicked on OK I ended up right in...
  2. JPFred

    "Id is not an index in the table"

    Has anyone ever received this error and if so how did you recover from it.:eek:
  3. JPFred

    Thanks

    I would to thank all of the brain trust that assisted me in my creation of a card catalog for my grand sons school. I still have a good bit to go but it is in placed and being used. Again, Thanks Doc
  4. JPFred

    Reading single record

    I am writing some code and need to do the following: Call up a form by clicking on the proper button from a menu I need to add this to Form_Load 1. Prompt user for search data 2. Use the entered data to find the record using the search data 3. Once found I will insert the record to a...
  5. JPFred

    Column headings in SQL

    That's It!!! Thanks, Doc:D
  6. JPFred

    Column headings in SQL

    I have written an sql query (below) and need to have a user friendly column heading displayed with each field. I a retired senior programmer analyst and have been retired for 10 years. I know there is something I have forgot to accomplish my issue. Any help will be appreciated. SELECT...
  7. JPFred

    Compare database date field to todays date

    I am trying to compare a field (datecheckedin) to today's date in an sql query. The field is defined as a short date. I thought I could use curdate() but it is not the proper way to get today's date. I know the brain trust has the answer:)
  8. JPFred

    Multi user run of a db application

    Thanks for the input. I was thinking about doing the download option and still may go there. The non read-only users would only be allowed after hours. That being said I could go either way. Thanks for the input and solution options.
  9. JPFred

    Multi user run of a db application

    I have written an access application and would like to have accessibility to the database on a network server in a read only mode. I know how to auto-run a form but would like the main access options inhibited and allow multiple users to access the database application from laptops having...
  10. JPFred

    Bar Code input

    Thanks for the reply in doing so you answered my question. I was unsure where to post the message so I took a shot by placing it in the code section.:)
  11. JPFred

    Bar Code input

    I am currently creating a card catalog system for a private school library and would like to add a feature to scan a bar code on a book adding the necessary data to the database. This data will be used to retrieve information from the database when the book is scanned in. It must also have the...
  12. JPFred

    OpenForm (filter name)

    I am fairly new to the macro creation utility in access and was wondering if anyone can give me a few examples with the use of "filter name". From what I can tell you can place a form or query name here to restrict record retrieval:). Thanks, Doc
  13. JPFred

    Excel macro language

    I agree. It is a tough to try to work within her parameters. The access to access issue comes down to funds. This is a private school that works on a very fixed budget. That is why my grandson's grandfather is writing a workable card catalog system and get them off of the paper cards. What...
  14. JPFred

    Excel macro language

    Unfortunately I only understand English and it seems that the link is in German?
  15. JPFred

    Excel macro language

    Hi gang. I have returned after a recent illness. Even though this question is not directly access related it does tie into a project I am working on. Due to limited available of the access db program I am in the process of using access to create and maintain a card catalog database. The...
  16. JPFred

    Locked forms

    Hi Gang, I am back again after a bout with pneumonia. In that time I must have made some global change that will not allow any entry from any form. Direct entry is allowed if entered directly to the database without using a form. Pretty weird huh! Doc
  17. JPFred

    DoCmd.RunSQL (what am I missing?)

    I am using the code: strQueryPart2 = ("*" & txtsearch.Value & "*") to build an sql statement that will look like *datavaulehere*. By dueing this I was able to build my sql that will find datavaluehere anywhere within a db field.
  18. JPFred

    DoCmd.RunSQL (what am I missing?)

    Yes I did supply 2 sets of code in an attempt to show the two solutions I have tried. I still am confused about how to execute my query/sql passing the value of txtsearch to the query/sql.
  19. JPFred

    Auto load a form upon access load

    Is there a way that I can have a for automatically load when access is opened? i.e. Library.accdb (form name) sort cut from desktop?
  20. JPFred

    DoCmd.RunSQL (what am I missing?)

    I am attempting to run an SQL statement from code when a check box is clicked on. I build the statement (seen below) and try to execute it using the DoCmd.RunSQL function. When I execute the code I a 2342 run time error. If I use the the DoCmd.OpenQuery function passing the name of a query...
Back
Top Bottom