Search results for query: *

Cajun - I tried that, in code, not a query, and I got an error message saying "Too few Parameters. Expected 2". So, Access has NO idea what's in the text controls. Baffling. I've seen this work before in other situations, I can't understand it. accessguy52

Cajun - here it is, nothing special. UPDATE tblRisk_Severity_Levels SET tblRisk_Severity_Levels.Project_Name = [frmProject2].[Title], tblRisk_Severity_Levels.Project_Number = [frmProject2].[FP_ID]; This executes when I close the form and go to the Severity levels form. What I'm trying to do is...

Hi! This is driving me crazy. I want to get 2 values from Form1 into the tables that populate Form2. I do this by an Update query, BUT, I keep getting a Parameter input box for my values from Form1. My query will NOT let me put the "Like Form1!text1.text" - does not accept "Like". I tried it an...

Does anyone know how to convert TextBox1.Value = Val(".25"), say, and have it come up on the textbox as actually .25? Access seems to respond to that string value by converting to 0 ? I'd be very grateful! Thanks! accessguy52

aahh - that's right. Thanks, Randy! accessguy52

Duh - why didn't I think of that? Thanks, that worked. BTW, do you recall how to turn off the "You are about to append.." dialog box so I can put up my own? I remember seeing it somewhere in a book and now I don't have that book. Thanks again! accessguy52

Hi! Does anyone know of a workaround to appending a recordset that has some records with null values in them? Access will let me append the ones with non-nulls but complains when I run the append query. In code, it's even worse, just stops and syntax editor complains. Anyone have a workaround...

Does anyone know if I can make my option buttons exclusive? - that is, click on only ONE button? Sure, I know you can do this with unbound and option groups, but, it seems that radio buttons that are bound to a field can be ALL be picked, when I only want ONE to be pick from a group. Anyone have...

Daniel - cool! that worked beautifully! I'll have to save that one for future use. Now I have ANOTHER question: I've changed the check boxes to radio buttons, per my clients. These buttons still bound to their respective record flds, but, how can I keep them exclusive? That is, as unbound...

Does anyone know how I can disable the checkboxes on a continous formsheet for one record? I have a "questionnaire" type of form where I have a N/A checkbox which should, when checked, disable ONLY the other checkboxes on that particular record. Instead, it naturally disables the checkboxes on...

Thanks, Golom - I decided to use a query for my form which will give me all my records from the Severity table and keep it cleaner, also I would not have the Append msg showing up every time. So I think I have enough to start on now. Much thanks for all your work! accessguy52

Golom - I put your code in and made sure I had a dummy record which the logic caught, as it should. But, still, no update took place - let me mention that the Severity table has 85 existing records which I update with the 1st update. The Risk table only has (now) 1 record. Would that make a...

Golom - I ran it again and the Update error box read "0-". What would that indicate? Thanks accessguy52

The msgbox (which was pretty cool, by the way) said 86 records for Severity, 0 records for Risk. accessguy52

Golom - I tried your code and the Severity table got updated fine, but the Risk table still did not get updated. You mentioned recordset locking. I purposefully didn't put in commands to open the recordsets, but maybe it's still getting locked. Any way I can test for that? Thanks. accessguy52

Sorry - the Severity table was updated successfully, but the Risk table was not. Golom, are you telling me that I DON'T need to open the recordsets for updating? If I don't open the recordsets, then how do they get affected? Or do I need to open them at all? I'll try your code up there. Back...

Can anyone tell me why one of my tables gets it's flds updated but the other one doesn't? This is a real mystery! I can't see why something that worked for one table won't work for the other. Same commands, different table. Here's the code. If you can figure THIS one out, you have my utmost...

Thanks - your statement suggestion was close but, it only returned the variable name. Here's what I did, which worked: strSQL = "UPDATE myTable SET myField = " & "'" & myStringVariable & "'" & ";" By changing one of the double quotes to single quotes, it worked. Now why doesn't Microsoft tell...

Hi everyone - didn't see my earlier question posted so thanks to the folks who replied with their INSERT INTO suggestions. Turns out that I really needed an UPDATE statement. But, that only seems to work on numeric flds. Any way to get UPDATE to work with text flds? Thanks in advance. accessguy52

Hi all - I'm trying to insert 3 flds from a form into another table when a Save Record button is clicked. However, I need to fill up the ENTIRE recordset with those 3 flds. Access keeps giving me a "INSERT INTO syntax error" message when I run this code. A debug step shows that the program drops...