Search results for query: *

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

I am try to trap to make sure the user filled in all the fields that are req. So I did an check on the next button to do a query on the table to check to see if there is any null values. It looks like it works the frist time but then after it dosent Can someone look at my code and see if I...

I have a form Ineed to open with a filter. I can get it to work as long as the filter value is not null. When the filter val is null i get all the records. I should only get the records where the status is null. I know I am doing somethingn dumb here. here is my code on opening the form...

I have a text box on a form its control source is a memo field from my table. I need the user to add info into the text box, but I don't want them to be able to delete any of the data that is there already. Thanks for the help. G

I go it to work now this is how I had to do it Me.subfrmdata.Visible = True Me.subfrmdata.Form.RecordSource = "EXEC dbo.procgetinvno" & "'" & [Forms]![frmsearch]![txt_search].Value & "'" thanks for the help

They all have the same permissions set. the first proc works but the other 2 DO NOT.