Recent content by accessguy52

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