Search results

No problem .... :) .... You are welcome. RDH

You really don't need the hidden txtbox. Have a look at the Choose() function in Access Help files. You can use it in the criteria section of your query to convert the numeric value to the desired text. HTH RDH

The "Allow Additions" property must be set to Yes for the Data Entry in the form. If this form is specifically for entering "new data" only ... then also set the "Data Entry" property to Yes. If you don't want to allow more than one record to be entered at a time then set the "Cycle" property...

This is usually caused by a problem in the query that the report is bound to. Check the results being returned from the query and you may find the problem. HTH RDH

Int(UnRoundedValue * 10 ^ 3 + 0.5) / 10 ^ 3 HTH RDH

It would be much simpler to troubleshoot your problem if you posted the procedure you are using. RDH

Open the BackEnd Database "Exclusive", then set the Password. Now ..... you will have to delete all the table links in the FrontEnd and re-link the tables so that Access can register the Password. If you do not do this ... you will be prompted for the password every time the FrontEnd db is...

=DateSerial(Year(Date()), Month(Date()) + 1, 0) HTH RDH

Try using the Int() function in a "Field Expression" in the RowSource query the combo is based on. ExpName:Int([FieldNameFromTable]) Change "ExpName" to whatever you want (other than a field name already used in the table). Change "FieldNameFromTable" to the actual name of the field of...

Great ....... You are very welcome. RDH

Using the ">" in the format property will only change the way the data is viewed (at table level in this case) .... not the way it is stored. If you want to convert existing data to Upper Case then you will need to create a temporary Update Query to convert the existing data to Upper Case. You...

If this for a data entry form ......... Use the After Update event of the combobox: Private Sub YourComboBoxName_AfterUpdate() If Me.YourComboBoxName = "pending" Then Me.Reason.Visible = True Else Me.Reason.Visible = False End If End Sub In the code above I assume the name of the control...

You say "Textbox" .... I assume you mean the "Caption" on the top of the form .... Place the following code in the Form's "On Timer" event: Private Sub Form_Timer() If Me.Caption <> " " Then Me.Caption = " " Else Me.Caption = "Place Your Form Caption Here" End If End Sub Change "Place...

You have placed the calculation in the control source of the control that displays the "Total". This is the reason you can not change the value (it's bound to the expression). You need to populate the "Total" by running the calculation when you type in the "number of items" information using the...

Try this: field_ytd_01: Format(Nz([field_ytd_01],0),"#,##0") HTH RDH

Dave I'm sorry you have had a problem finding the information. I have contacted Candace Tripp and she informed me that the URL had changed. Here is a link to what you need. Candace Tripp's MS Downloads RDH [This message has been edited by R. Hicks (edited 03-25-2002).]

The form "frm_Fish_ID" must be open at the time the code is executed. RDH

Oppss ..... Sorry .... :-) Go to Candace Tripp's site to retrieve the file you need. It is in MS Access Downloads on the left side on the page and the name of the file you need is named "Animated GIF's". Here is a link to the site: Candace Tripp's Site HTH RDH [This message has been edited...

Go to A3's FTP site and you will find what you need. Read and follow all instructions carefully. ftp://216.122.167.138/pub/candace/access_downloads_html.htm HTH RDH

If you want your app to fit .... most developers currently design their apps to fit 800x600. I develope in a higher resolution so I can move tool bars ... ect out of the way, but I make sure the app will fit a 800x600 resolution on a 17" monitor. HTH RDH