Search results for query: *

Thanks. Let me have a try. Regards, Charley

WayneRyan, Well i don't have any problem in converting text to number. When i use the Between And operator for the converted field (ie number field), am getting the same results as i get for the text field which is confusing me. Regards, charley

I have an access table with a field "period" of Text data type. I have to retrieve records from the table between 2 periods using a select query. For retrieving records between periods 1 and 3, When i use "Between AND Operator" in query, then it returns all record which have...

Am very new to Autocad. The request came from autocad users and i did the retreiving of record from Access database. But as i said, don't know how to load the drawing with new data. A gap is there between autocad users who don't know much about vb and myself who don't know about autocad...

O.K I will tell you what i understand and know. Refreshing the drawing means loading the same drawing with new data or values from an Access database. The drawing itself don't change, instead there are some values/data displayed in the drawing (as number figures) and these changes. The sheet...

Am very new to Autocad. I need help on how to refresh or reload an Autocad Drawing. The Autocad drawing displays or gets data from an Access database. I run a Macro once the drawing is opened whcih asks for a sheet number using a form. When the sheet number is provided the corresponding values...

Thanks. The suggestion by CCLINT solves the problem. Now its working fine. Thanks to everyone for their help Charley

Am not completely sure about this. Usually in the table for the date field i give something like below which prevents the user from entering invalid dates. Format dd/mm/yyyy Input Mask 99/99/0000;0; Make a copy of the database and try changing the date field to the above mentioned format and...

Sorry. Still without a solution and getting the same error message too few parameters expected2 even after trying CALL before the function name and enclosing the parameters within (). I tried call ThisDrawing.Input_mas_tag (strMas_tag, strMas_tag1)

Great. It solves the problem. Regards, Charley

How can i specify that the first 2 characters of a Date field in dd/mm/yyyy should be 01? Am not sure how to do it either using Validation rule or by input Mask? Please help. Regards, Charley

Thanks. Let me fiddle around a little bit. Thank you sparing your valuable time. Regards, Charley

Hi again, I tried your code, but still getting the same error. ThisDrawing.Input_mas_tag txtMas_tag.text,txtMas_tag1.text I could see the values in debug mode when i place the cursor above the parameters.

You are right. Am getting error on the following line. ThisDrawing.Input_mas_tag txtMas_tag.Value,txtMas_tag1.Value Regards, Charley

Sorry to trouble you again. Now Am getting the following error Run time error 3061: too few parameters expected2. Here is a sample of the code. I don't understand why the values are not getting passed into the function. Public Sub Input_mas_tag(tmas_tag As String, tmas_tag1 As String) Dim...

Thanks. That solves the problem.

I have the following code attached to a button on a form. Am getting a syntax error. Can anyone help me? Am very new to VB. Private Sub cmdExit_Click() ThisDrawing.Input_mas_tag (txtMas_tag.Value,txtMas_tag1.Value ) End Sub Regards, Charley

Hi, How to subtract 21 days from Today's date? I tried something like DateDiff("d",Date(),21), but getting unexpected numbers. Regards, Charley

I have a report in the following format. Discipline Header Category Discipline footer TOTAL eg. A11 CIVIL AND STRUCTURAL ......................... ENGINEERING 10 ......................... .....DRAFTING 10 A11 CIVIL AND STRUCTURAL TOTAL 20 A11 CIVIL AND STRUCTURAL is the Discipline Header...

Thanks a lot. I will give it a try and let you know