Recent content by rjohnstone1

The only thing that i could come up with is DoCmd.hourglass in your subroutines or use some sort of timer to wait until your queries stop. Ryan Johnstone

I have a button on my form to open a report with some criteria (combo box, dates) I am trying to build a sql statement so the report will be filtered between two dates and having criteria of my combo box. I know the dates work but the Cost Centre Name does not. Here is what i have. Any help...

Use an event sub miles_field_after_update () if [miles] < 100 Then [cost] = miles * rate for under 100 else [cost] = miles * rate for over 100 end if end sub You could also use the iif statement if it is query based. Create a calculated field in the query...

I am having a little trouble updating records on a form. When a field on my form has a certain criteria, i want to change values on other records. I am using code to open a recordset (the same recordset i am using in my form) and change records. Everything is fine until i leave the form or...

In design mode of the form, click on the field. Click format from the menu and then conditional formatting. You can enter an expression for that field and the background color when the expression evaluates to true. I think that is what your looking for. Ryan J

Click on the field on your form. Click Format -> conditional formatting and enter an expression and set the formatting of the cell for the condition. It is a good tool to use

You should use a filter when the report opens or a parameter query to base you report on. If you wanted the certain records that met the condition to stand out, you could use conditional formatting DesignView->Format->Conditional Formatting

It depends on how you have your report set up if you have 1 record on each page, you could use the record count command and then the doCmd.printout value of recordcount when the report opens. If this does not help, please provide more info.

I have a field on a form that i use to store a string which contains values from a list box. I then reference this field from a query to get multiple parameters ( instr([form]![field Name], [Query Field Name]). It works fine, but when my field on the form contains a string over 120 characters...

go into the properties for the field and select can grow option to no.

I have a form with a subform. My subform contains many instances of the same field (many parts and information). I was wondering if their is a way to reference all instances of a field in a subform without making a query. Any Help would be greatly appreciated. Thanks

I have tried both of those sites. One is too expensive or shareware and the other doesnt work that great. If you like i have an easy fix. Email me for the code mailto:Rjohnstone1@home.com

Does anyone have any code or modules to resize forms a networked database so forms can shrink/grow for different users. I am stuck on this one Thanks very much Ryan J

have the user input info into the two fields. Then use dlookup in your vba code to find the records. You could also apply a filter after the info is input which would also find any records with that information

I have a combo box that is giving me errors. I would like to change data in the combo box when a user deletes the info in it or when a user backspaces deleting info in the combo box. I have tried using event procedures but it didnt help. The reason for doing this is because i am getting jet...