Search results

Yes, more then one person can work on a form at one time. You may have to worry about the database being set to Open Exclusive (usually if the security is set up right, then only the Admin will have that ability). You may also have to worry about the refresh interval. I would go to...

Okay...I don't know why this doesn't work and my presentation is first thing tomorrow morning. I have an option group that allows the client to select a division for which they would like to narrow the reports down to. So, they select a division and when the report opens and their is...

As long as the <Properties><record source> of the form is being pulled from the quey you should be able to use the arrows at the bottom of your form page to navigate through your records. You can always write code, run marcos, or use command buttons to allow users to Navigate to the "Next" or...

Okay, This is as simple as I can get it to keep it small. My table is made up of four fields, two of them create the multi-indexed key! When you search for [ID] (which is indexed with [Page]), you are able to view all of the [ID] fields, regardless of the Page numbers. I think those...

Could you be a little more specific? Do you want to be able to search through multiple table? Do you want to be able to search in any field or only certina fields? Have you looked thought the Search Options here....I remember some really great post about creating search engines!

Have you considered running the report off of a query? Provide your users with a query driven report the prompts for the KeyField Like [Enter the Number Field you would like to add or edit: ] Then when the users enter the form they will see all of the record that share the One KeyField that...

If you're planning to make changes using 2000...I would not convert back to 97. It's amazing how touchy Access is about converting between versions. I'm not saying don't do it. I'm just saying that if you made changes be ready to loose them or prepare to recreate actions. I've been jumping...

Are you going to use the total to calculate something later? Is that why you need the record total in the query? If you you are having problems with the TOTALS (sum, count,etc.) function, then please be alittle more specific. If you just want to count the total number of records so that you...

skate, It is possible. You could create a button or a SelectAll checkbox and then use: If (Forms![My Form]![MySelectAll]=-1) Then MsgBox "To unselect a single field you must also unselect this field" Forms![My Form]![My Other Fields] = -1 Forms![My Form]![My Other Fields]= -1 etc. EndIf...

There is a zero length property for the field that the combo box sources back too. So if someone tyes 20 numbers into a 10 value text field....you're combo box should not accept the selection because it shouldnot be accepted by the table. Sort of like making the source field mandatory...it's...

I think this might help you: Old posting on Printing Multiple Reports if not...I've got a macro that is almost working in your database....it might take me another minute or two!

Pascal, I have a question first....have you tried using a macro that generates reports using an OPTION group. So that the users are able to make the artist selection via a list and then print or preview the report from their selection?

I'm assuming that you've set your fields so that they will not accept a ZERO Length? I've actually added NONE or " " selection options to my combo boxes and then set them as the default values. That way I can still query for them and I know that I will have some sort of data for every field!

Okay.....this is what I think you're asking to do When the user makes a selection from [lstordinance] you would like for the value selected to appear in the unbound [txtordinfo] box. All I would do is set the control source for [txtordinfo] to =[lstordinance] That way when the user selects...

Insert the excel reports into the report, using INSERT --> OBJECT --> From File This will place your reports directly into our report. Do make sure that you select "Linked" if you plan for the data to change from time to time. That way you only have to update the report in excel and not in...

ON the Language bar, click the microphone icon OFF. For as long as the microphone is on...it will slow your computer and continue to try to process any and all sounds that it is able to pick up. So if you do not want to use it..just shut it off and Access will work fine without it. if you...

Hmm...I'm hoping this is as simple as it sounds!! I would make a query of all of the fields that you need to present in your report. Hopefully you have a Date field already. In the criteria of the [date] field type this: Between [Enter a Beginning Date: ] And [Enter and Ending Date: ] That...

Stephen, If you embedded or linked the graphic into the Page Properties then the picture is a true watermark..it will not effect your data at all. The picture is truly in the bakgroud...it has nothing to do with the text or data that ar in the report. You will obviously have to watch the...

John, Don't fret...with a little extra information, you should be on your way. I would like to know what you are trying to do exactly. Are you trying to use Excel in a Form....or Report? Are you trying to display an existing chart or worksheet? Do you want to have the ability to...

DW, This forum is for all sorts of office questions. It was not created for just one purpose. So, I have to admit that I've never found the need to use the addin control wizard...not everyone uses it. It doesn't say anything about the knowledge or quality of one's work. If you are...