Search results

A SELECT query will not affect the data in the table it will merely show the data. An APPEND, UPDATE or DELETE query will affect the data, which meets the query criteria. It sounds as if you have run a DELETE query and as far as I am aware there is no way to get that data back unless you have a...

Hello. I need help understanding how to create a calculated field in a querie. I am a totally newbie at Access and the only reason they have me working on creating a database is because I am the only one in the office with expierence using the program. HEHE. Onto the question. I have...

Quick update I shrunk the file to make it smaller and I forgot I use Access for XP. :confused:

Hello. This might sound silly but I am totally lost and confused. I have been given an assignment to create a Project Mahours database. This is a place where the project managers can go in pull up information about an employee from a list box or combo box it then pops open a subform that has...

Thanks everyone for your help. Since I am still new at access, and I was having a tough time finding where the problem was, I did notice that in the query, books id was listed. So I deleted that query, made a new one without the books id and it now works. YAHOO!!!! But I still have the...

Thanks. I have not made any changes to my queries recently. I have been working on creating the Switchboard. I ran the query and it runs fine. It just asks me for the first letter of the author and when I click ok it pulls up the list. I went to design view in the report and did not see...

Hello. I am having a problem with reports/queries. Here is the problem. I am trying to create a report from a query, just like I have done with all the other reports I have. For some reason this particular one is giving me a problem. I have the query designed to look through my books table...

Thank you so much. I have been racking my brains trying to figure this one out. I am learning how to build websites but not web applications. I wouldn't think it would be too hard, since I have gotten this far with Access without much training. I in the process of designing 2 website with...

Hello. This is my first post. I have been looking at the posts and getting a lot of great advice, so first off Thanks. Now on to my questions. Over the past year I have been creating a library database in Access XP. It's working great. The database is to be used by everyone in our office...