Recent content by sedixon

I'm not.... (yes I know, not the best security). I only needed a password to protect the raw data. I figured out a way using Dlookup to verify the password. Thanks!

Is it possible to store a select statement as a variable? I have a table (UsysPassword) with a single row (Password). I would like to be able to select this row and store it as a variable to compare with another text box. As you can probably guess, I want to make sure what the user enters as...

It sounds like you and I are doing the same thing. Here is what I did to create a clear form button. I was lazy and used the code already built into Access for this button. 1. Create a command button. 2. In the options for this button (in the wizard) choose Record Navigation 3. Then choose...

Hello everyone, I have an interesting problem. This code worked at home on my Win2000 box running Access XP. Now I get to work on a Win2000 box running Access 2000 and I get a run time error '2455' stating that I have an invalid reference to the property recordsource. I've listed the code...

Well I can run a report off the original query. The problem is they only want selected results from that query. I don't know how to give them the option to choose which results they want. I need a check box of some sort, but I can't put that on the query.

I have a literature database that a user can search using a simple search query. The user now wants to be able to select certain records from that query and output them to a report. I've got the query done, and I've got the report. I just don't know how to select certain records from a query to...

Jim, Thanks so much! The way you suggested sounds like a much more logical approach than what I had originally thought I wanted to do! I had completely forgotten about sub-reports. Thanks for jogging the memory! Sarah

Doing that way would mean I would have a different report for each media type, right? Could I combine all the reports into one large report? If so then all the "books" would be in one section and all the "videos" in another. That might work provided I can combine all the...

I have a database that contains literature references. The references can be anything from magazine articles, to books, to videos or conference proceedings. I have a form the user can use to search the database for the area of research they want. The report is built off the query that used to...

I'm having the same problem as was first mentioned. I changed the Detail Can Shrink property to yes and all the fields that can shrink have been changed accordingly, but I still get the blank lines where the fields used to be. Any other suggestions? Thanks! Sarah

I have a form that searches through my database based on user input. The results from this search are displayed in a subform. Is there a way I can select certain results from the subform and print them to a report? For example, a user would use the form to search for "pollution...

Hello, My project is to re-write a database that stores bibliographic information about articles for the office in Access 2000. When someone wants to print out a reference list they would need to utilize this tool, but they don't necessarily need to print out every reference that is found -...