Search results

I posted a message and subsequently researched this forum and received a lot of great information which I am now researching. Someone named Anauz posted a response and then Emailed a sample database to several members. I am looking for this sample shrinker-stretcher database or Anauz. Thanks

So that I can view the records before and after the update query is run.

I have a test database with an open table. I want to run an update query and then see the results in the open table. What code or method do I use to refresh the table. I can use the menu item “Records & Refresh” but I can’t figure out how to run that in code. I may need to set focus to the form...

I have a form that looks fine on my screen but when opened on a smaller screen in a lower resolution is way to big for the screen. What is the general approach when designing forms for general use?

When designing a report you can use a “Sorting and Grouping” pop-up to sort and group records. Does anyone know how to use code to determine what sorting and grouping was used on a report? I want to put the sorting and grouping information in a text box on the report so report readers will...

When designing a report you can use a “Sorting and Grouping” pop-up to sort and group records. Does anyone know how to use code to determine what sorting and grouping was used on a report? I want to put the sorting and grouping information in a text box on the report so report readers will...

OK, here you go, it's a little more complicated than my initial explanation, I actually have several related tables. SELECT tblMasterNeeds.KeyNum, tblMasterNeeds.TempProjNum, tblMasterNeeds.ProjName, tblMasterNeeds.ProjDes, tblMasterNeeds.Purpose, tblMasterNeeds.History...

I have a query that has a main table and a related table, one to many. I am using the following code to open a report and to pass a query name and record selection criteria. DoCmd.OpenReport "rptAllDataFields1", acPreview, "qryAllDataFields3a", "[County] = 'Deschutes'" DoCmd.OpenReport...

I have a query that has a main table and a related table, one to many. I am using the following code to open a report and to pass a query name and record selection criteria. DoCmd.OpenReport "rptAllDataFields1", acPreview, "qryAllDataFields3a", "[County] = 'Deschutes'" DoCmd.OpenReport...

I have a query that has a main table and a related table, one to many. I am using the following code to open a report and to pass a query name and record selection criteria. DoCmd.OpenReport "rptAllDataFields1", acPreview, "qryAllDataFields3a", "[County] = 'Deschutes'" DoCmd.OpenReport...

Thank you for the help. Actually the query name goes in the "filtername" argument of the method not the "wherecondition".

I am attempting to use the “OpenReport Method” to open a report based on a query that I name in the method. The method syntax is “DoCmd.OpenReport reportname[, view][, filtername][, wherecondition]”. My code is as follows “DoCmd.OpenReport "rptAllDataFields1", acPreview, "qryAllDataFields2"”...

Open your report in design view. Make sure the Formatting tool bar is on. Click the Sourting and Grouping button. You will see a popup that will help you with this.

I think it should go "Like Forms![MainFormName]![SubformName]![ControlName]"

Thanks, that looks like it.

Thank you for the reply. This worked with one exception, the controls can now have the focus and I don't want them to. Any ideas how to accomplish this without allowing focus?

I have some text boxes on a form set to Enabled = No so that they can't get focus and they can't be changed but it makes the data to gray. Do you know of any way to get the black font back?

Yes, I started with a query but due to the number of fields, datatypes, and the fact that any number of the criteria fields may be blank it wouldn’t return the records correctly. So now I am using a form that has combo and list boxes on it which supply the where criteria of a Select Statement...

I am attempting to populate a list box by creating a function and placing the function name in the RowSourceType Property of the List Box. The list that I want in the List Box is a Recordset created with a Select Statement. I am using function format from a help example. The help reference is...

Conceptual help needed. I want to select a group of records by using various query criteria which will be supplied by a form. Then I want to look at the records and randomly select non contiguous records and have them print in report form. I accomplished the first part and have the records...