Search results

Thanks! I knew it was something simple like that. :)

Does anybody see anything wrong with this Update query please? mySQL2="UPDATE Interp rates SET Interp Rates.Next Rate=nextrate WHERE (((F1)='ZAR')and (isnull(F5)=True))" (The table is [Interp Rates], the field I want to update is [Next Rate], and the set is any record where [F5] is Null and...

Thanks alot you two!

ejstefl - Thanks alot for that, I think you have the right idea. It's still not working though, now it says "No value given for one or more required parameters." When I debug, and hold the mouse over mySQL, it does show the string as ...WHERE [F1]=ATS ORDER [F4]. ATS is the value of ccy(1), so...

OK I think this should be working, and I can't figure out why it isn't, maybe someone can see what I am missing here please? What I am trying to do is isolate chunks of a table, and use each chunk as a recordset and do some rs.movelast, next, etc manipulations. I have a string array variable set...

Hi Folks, I have a problem I've been mulling over, and I thought I'd just post it here and see if maybe someone has already gone through this and might be able to tell me what I am missing. I have an access database that contains a table of currency rates by forward date. So for example, there...

Bob - You are the man! Thanks so much for your help.

Hey Bob, thanks alot for your help with this! I figured it out...the reason I couldn't update the table under that query is because there were two linked tables under that query. When I set it to copy the information I needed from the second table to the first table prior to the function where I...

You're right, the entire recordsource is non-updatable. I went into the underlying query and tried to uncheck a checkbox and it won't update. I just have to figure out how to make it updatable!

the field type was Integer, I just updated it to Long Integer but the same thing happens. I scrapped the option control group and tried a drop-down combo box. The same thing is happening. Every time I bind it to that field, it won't allow me to change the value from what it already is in the...

Do you think it's because I've linked the control to a query that is then linked to the table? The subform is linked to a query containing the target field, maybe I have to link it directly to the table?

Quick update: I tried changing some of the checks around this so I could have it default to a value of 3. I was thinking that maybe the problem was because the default value of 0 was not one of the option choices. It's now stuck on three and won't change if you click on either of the other two...

Thanks Bob. I actually had it bound originally, and had to change it, because when I bind it to the table that I want it to update, it doesn't allow me to make any changes. The value is by default 0 in the field, and the choices in the control group are 1, 2, and 3. So when the form runs, all...

Hello all, I'm new to the site, hoping someone familiar with both continuous subforms and option groups could give me a hand please? I have a "dialog window"-type form with a subform in it. The subforms are in continuous mode, and I have a scrolling window in my main form that contains one...