Search results

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...

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

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

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...

That's It!!! Thanks, Doc:D

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...

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:)

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.

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...

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.:)

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...

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

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...

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

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...

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

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.

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.

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?

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...