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.

...thanks Function check_results() Dim rst As Recordset Dim db As Database Set db = CurrentDb Dim x As Double Set rst = db.OpenRecordset("select * from tblresults") rst.MoveLast rst.MoveFirst x = 0 MsgBox rst.Fields.Count Do While x < rst.Fields.Count Debug.Print rst.Fields(x).Name...

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

...Database Dim rst As Recordset Dim strsql As String strloanid = Me.LoanID.Value strreg = Me.ModName.Value Set dbs = CurrentDb() strsql = "select * from tblresults where LoanID = " & " '" & strloanid & "'" & " And ModName = " & " '" & strreg & "'" & " and answer IS NULL" ' MsgBox strsql...

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.