Search results

RichO It works. I used this suggestion: [Forms]![FrmReportmenu]![txtCaseNumber] Placed it in the criteria field on the Query, and It works like a charm. Thank You very much for your time. Oren Haydel

I checked the properties of that form, and it displays the filter just like we set up: [Case Number] = (the case number I entered in the form) Still blank record in print preview. I have no arguments or filters set on the query that I am aware of. When I open the report directly from Access...

Sorry, I should have mentioned, that I already added the space to make it execute correctly. It just pulls up a blank report. When I open the report from Access directly, all of the data is there, but when I use the button, it is blank. I am putting in a valid case number for the search...

Open report Ok, I added the necessary information like you described. The button opens the selected report in print preview mode. However no data is displayed. How does this method get the information from the query? And where is it calling for the field "Case Number" My field in the...

I have 7 different reports that pull information from a single query. The names are as follows: RptChecklist RptRightsform RptCitation RptAdminhearing RptArrestaffd RptPropertyRecord RptMarshalsheet In the main query, I have a primary ID field of Case Number, which is unique to each record in...

Holding down shift while opening the database worked like a charm! Thanks a million, I appreciate your speedy suggestion. Oren H

I created my database, forms, tables, etc. I cleaned everything up, and made it to where when the startup screen opens, all of the design toolbars etc, are not there. I cannot figure out how to get my design toolbar back, etc. Now I cannot edit any of my forms etc. Ive attached a screenshot...

This database I am trying to create is only for my personal use. I think Im making progress. I set up my tables, and linked them all together by Case Number. Now whenever I pull up one of my "Sub Forms" it displays the records. All I have to do is use the Last Record navagational button to...

The reason I cannot use one form and one table, is because I have more than 255 fields. I have many checkboxes and fillable fields, therefore I need more than one table. The example above does not reflect what I am trying to do. Each arrest is basically one record.

Ok, to make this simple for me to explain, this is what I'm trying to do: Im a police officer, and I am trying to make a database to hold all my arrest information. This is what I have set up: FORMS frmInitial frmSuspect frmVehicle frmArrestAfd frmQuestionaire frmSFST TABLES tblInitial...

I was able to open it. Thanks I will give this a try. Oren Haydel

Hi, I appreciate your response, however I cannot open the database you sent me. It says the database is read only. Ive checked the properties and it does not show that. Im running Access 2002. Any Ideas?

Hello all, First off, I have no expierence in programming, and very limited knowledge of MS Access. I have sucessfully set up a database that I use at work to keep track of my arrests. I think my question (problem) is a simple one, but I cannot figure it out. Here goes.. I have a main form...