Recent content by zunan

Here's another suggestion: Save your macro as a Module. Copy it into the module of the form. Place it in the "Click" event of the button that kicks off the report instead of the code that kicks off the macro. This way, you can put "Me.cboName = null" at the end and the report will get the...

rhay I'm sorry I don't know more details right now but I do know that there is a way of preceeding the calculation with an indicator that determines wether to round the answer up or down. I will do some searching and get back to you.

What I have done, in A2K, and I know works, is programmatically set the RecordSource of the form with an SQL statement in the "Open" event. Populate the cbo with a distinct list of a particular field. In the "AfterUpdate" event of the cbo re-set the RecordSource of the form to the original SQL...

the general convention for refering to a field on a subform is: Forms![FormName]![SubFormName].Form![FieldName] Replace what's in the brackets with your own info but "Forms!" and ".Form!" are literal.

Remove the SQL statement that populates each combo box from the Row Source line on the property sheet, Data tab. Instead, place it into a few lines of code the "On Enter" event. Code would look something like this: Dim strSQL as String strSQL = "SELECT DISTINCT [TableName].[FieldName] FROM...

Hello everyone, I know I've posted this problem before but maybe I didn't quite word it right. I have a form that displays bound images in as icons to avoid loading time (unless deliberately requested). How do I get these images to load and print in the report? Thanks to anyone who might have...

I've tested this work-aound in runtime and it works.

It sounds like your form is displaying several or all of the fields from the table. It also sounds like you have changed the field containing the Key (Company Name) to a combo box. If this is so then what you have effectively done is allowed yourself to view one record and change the information...

I have communicated with Susan about this and I believe I've found a work around. My form is a continuous form of all the records in a table. At the top of each column I've put a combo box that used the "DoCmd.ApplyFilter" in the "AfterUpdate" event of each combo box. I believe this filter bug...

It's called "Conditional Formatting" and it workd great for your purposes.

Just an added thought that might be helpful: An option group is designed to deposit one piece of data into one field (whichever of the options you choose). Separte individual check boxes will enable your user to select multiple choices but each check box will require it's own field.

After "Case Else" you need to indicate the visibility status you want for each control when nothing is selected. You may also think about putting your code into the forms "OnCurrent"(record) event.

I have recently submitted a question that I would greatly appreciate you taking a look at. The topic is "Access 2000 Runtime Search Problem" under my name "zunan". This problem is specifically "Filter" related. Thanks much, in advance. Just once, I'd like to find out that the problem is...

Thanks fro the tip. I went there and read up on the software and it sounds like just what I need . . . but . . .my employer doesn't want to spend the money. He'd rather I came up with a solution . . .so I'm still stuck.

Thanks Keith for your patience with me. I just tried Me.Requery and that yields a bank screen in the full version of A2k. I'm afraid to find out what will happen when I package it up. What puzzles me the most is that when I open the dbase in the runtime environment (using the switch) the filters...