Search results

Are you trying to filter and show the form.

Hi RpbertS Even I build this string for inserting data into a tables. The string will look like this 2001,1,1,1,2,3,4,5,6,7 and so on. Ex: Insert into accounting_calendar (year,qtr,week,month,txt1,txt2,txt3,txt4 and so on ) values (2001,1,1,1,1,2,3,4 and so on) Any idea how to build the...

I am trying to build a Accounting Calendar for my company. This calendar will look something like this : Jan - 4 Weeks, Feb - 4 Weeks, Mar - 5 Weeks Apr - 4 Weeks, May - 4 Weeks, Jun - 5 Weeks and so on. I have the above data in row form. Ex: Columns in the table are Year, qtr, week,month...

KevinM, Thanks for the solution, it works.

Is it possible to assign values to variables dynamically. Ex: Dim txt1 as Variant, txt2 as Variant For i = 1 to 2 "txt" & i = i (****) next (****) I get the following error in this line "Expected: Line number or label or statement or end of statement" Can somebody give me a solution. Thanks

I have report which is not connected to any table or query. The data's must be populated dynamically from a table. For example, on the load or open event a script will be executed to populate the report fields. Is it possible, I try but I get an error. If not, how to populate the report fields...

I have a form with one button. When user hits the button, I am populating a table with some data's. I want to display a message at the bottom of the form about the status of the processing. The processing is happening in "For...Loop" For ex: On opening the form the message will be "Ready..."...

The combo box must have all the fields which you want to populate in forms fields. Display the value you want to show in combo box and hide the other fields. Then in the AfterUpdate event of the combo box write the below script for each field. formfield1 = form.comboboxcontrol.column(column...

Can somebody help me with a solution. I have tabular form (Continous Form) with more than 10 columns, in that one of the column is a check box. I have command button below the check box. Whenever user clicks the check box the command button must be enabled and disabled. In my case when I click...

Thanks for the solution. I will try it out.

To use the value for some other calculations. Thanks

Can somebody help me with this. I have a combo box in a form and it has 2 columns (cust_id and customer_name). The combo box will display only the customer name. The 2 columns are not bound to any column in the form. When user selects a value from the combo box, I need to populated a temporary...