Search results

I changed it to the Table name - and it is a module - I went to the run function and it gave me an error. - this is what I have - it give me the error on the If - (i) line - oh and I had way more columns then I thought I did Public Function ChangeToYes() Dim i As Integer, rst As...

Okay I put in the code - now do I have to run the code in a macro or something - sorry for all the questions I am completely clueless when it comes to code.

Well neither of them worked - I but in the code - and it didn't give me a public option but a General Option - do I then have to run the code - again lost when it comes to code. In Excel - I tried to put in the formula and it told me it was a circular referance - there has to be a simpler way...

Well I may not have exactly 70 fields but there are allot all the fields are listing when I download them from the excel file (the info from the website is downloaded into an excel file) - I need to use Access because I need the data to be in a database so I can query different info different...

Ya - the form I am using restates the same info 4 times for 4 different peoples information - I know it should just have the same info once and the info should be submitted 4 times - but it is a form for a school with users that area not very computer savy and I want all the info on one...

I need an update query because I already have the data in a table that has the 1 - in it - I could make up 70 separate update queries but I wanted an easier way

Hello - I am not a newbee - but I really do not like code - and I need an easy query to update about 70 fields - from 1's to Yes. I have an online form that used check boxes - I need to download this info into my database into Yes/No fields. I know I have figured this out before - so I know it...