Search results

Place an IF condition after the For I = 0 To UBound(FieldArray) e.g. For I = 0 To UBound(FieldArray) IF FieldArray(I) > 0 then If FieldArray(I) < currentVal Then currentVal = FieldArray(I) End If END IF Next I You will need to do the same for the Maximum value

You will need to create a query and link the IDent Number and Solution in each table then concatenate the TRN of each table. I have attached an example, open the query qry_result.

You could use this Private Sub Sales_Click() If InputBox("Enter Password Please") <> "somevalue" Then MsgBox "Password Invalid.", vbOKOnly Me!sales=false else Me!sales=true End If End Sub

I am using a 2003 database and 2010 Runtime 64 bit. The problem that I am having is when I execute the following code from a form :- Private Sub Preview_Click() On Error GoTo Err_Preview_Click Dim strDocName As String Select Case display_order Case 1 ' by date strDocName =...

I am glad this solved your problem. All the best

Looking at your screen shot it appears your data is a string and not numeric. Use the formula that you posted and assuming the data is a string the the result is correct. For a string all data starting with the digit 1 are grouped together followed by digit 2 etc. The two rows that are correct...

Use this code The Open event triggers when the form opens and assigns a value of 0 to the text box, then the sub procedure check_late_fees is called and enables the button depending on the value of the text box as 0 is the value then the button is enabled. If 12 is entered in the text box...

You want to populate the first names to array then use the first names to build a sql query. What will be the purpose of the names in the sql query? You could use a list box on a form to do the same thing if you require the names to be the criteria in the sql query.

Remove the Me. as Me refers to the control that is used for data. for buttons etc use the name without the Me. Assuming your text field is called txtLateFeesToBeCharged then you will need code similar to this sub txtLateFeesToBeCharged_Afterupdate() If Me.txtLateFeesToBeCharged=0 then...

Just a suggestion have you considered using ARRAYS to do your data manipulation?

Hello Andrew Have you considered using arrays? Here is a very short overview of how I use arrays for a work project that is used to record details for each employee. The number of employees vary depending on the criteria selected. The attached jpg is a possible layout of your input field...

Rick Thank you, it saved a lot of coding.

I have a number of fields on a form to display and capture data. The fields in each column has the following format fieldname_number e.g. period_1, to period_10, name_1 to name_10 etc. Is there a way that I can use a counter to make these fields invisible or visible as required? As an...

Yes, I am aware of this method. I would like to produce this data into a table so that I can add additional fields The current database has about 15 tables, in excess of 100 objects tables,queries, forms, reports and modules etc. with No documentation showing how the objects interact with each...

John I know how to display the system tables. But I want to know how I can use these tables to produce my requirements.

Using the System Tables in 2003, is it possible to list for each object 1. Other objects that depend on the object 2. Objects that the object depends on?

I agree. In my example database after working out the access levels and menu items I then created my login screen then created the forms etc. As stated in previous posts leaving the login and access levels until the database is finished means that you will have to change forms names etc.

Attached is a sample database that I placed on another forum. It has three access levels. Open the form frm_main, the user ids and passwords are displayed for each level. There is no restrictions in the number of times that an user can attempt to login. Module mod_display_menu has the code...

Your welcome, Yes, it was a challenge. I forgot to mention that when I was consolidating the data trasnactions table I also had field in the append code to flag the day of the week e.g. mon, tue etc. This flag was used to produce totals for the crosstab for each day of the week. In your...

Please find a version that may provide a solution to your problem. In the attached I have added a new table tbl_temp_monthly_data, this table will hold the monthly data. The field Item Code in the table t_CombinedVelocityTotals was set as the Primary Key. Run the module mod_run_monthly_data...