Recent content by grmman

I forgot one more thing: The form I am using is created on the fly after the data in imported fromn excel. SO i guess i cant do the compare on the form b/c the from is recreated each time the data changes.

I need to write a module to compare fields in a table. For example I have acct_num and acct_nummi, I need to check to see if the value in acct_num = acct_nummi and if not i need to update an other field with the with and Y for yes or N for no. The problem is I need this function to be...

I have a report with a lot of text boxes. I need to check to see if the value of the text box is < 0 (- number)and if so print that line, if the value is >= 0 skip it and dont print it. Thank for any help.

thank you.

I have a table with 120 fields. I am running this small function just to print out the name of each field. When it gets to the 57 one it stops and give me an error "run time error 3021" no current record" when I restart the function at 58 it goes to record 114. Its only doing 57 records at a...

thanks for all the help I had to do this to get it to work Select Case rst.Fields!Type Case "dbtext" Set thisfield = newtable.CreateField(fieldname, dbText) Case "dbDouble" Set thisfield = newtable.CreateField(fieldname, dbDouble) Case "dbdate" Set thisfield...

the field type is a string format. I think thats my problem. the ftype is defined as a num. How do I get around this one.

Is this how I should do it. Dim ftype As DataTypeEnum fieldname = rst.Fields!Question ftype = rst.Fields!Type Set thisfield = newtable.CreateField(fieldname, ftype, 15) thanks for the help

can you replace dbtext with Variable. Set thisfield = newtable.CreateField(fields(x), dbText, 15) I have a table that has all the data I need to create a new table from my table has 2 col(fieldname and fieldtype) for exmaple of the data: account_number dbdouble is there a way I can use the...

thank you so much. it worked perfect.

I am importing excel spreadsheets into my db. I was wonder if there is a way to reorder the fields in the table to be asc order. I don't need the data in asc order just the fields(columns) in this order so it will display nice for the use on a datasheet form. I am createing the form on the...

NO need for help I got this to work.

How do you save the form after the wizzard created it? Thanks

I have a weird problem. I am importing in data from excel spreadsheets. and I want to be able to display the data to the use in a datasheet view form, my problem is the struct of that data changes from one spreadsheet to another. So is there a way to create a form on the fly and the currect...

How do you turn on a custom toolbar from code. thanks