Search results

My insert query works The insert query works just fine. I can add as much data as I want. All this data is housed on a SQL server so space is not an issue. This database houses projects and what is going on with them. The user need to be able to talk to what is going on with the project...

This code works This code works if I dont put too many char's in the text box. When I start writing a novel then it gives me that error. What I am trying to do is "Update Values". The insert code works and I can put as many chars' as I want. I need to know how to modify it to update

That did not work This code does BUT!!! This code works fine. The problem is when I try to update anything over 1024 charachers access give me this Run-time Error '2246 Access cant runt he query, the parameter values are too large The total length of all the values entered for the parameters...

The Add query works perfect. I would like to duplicate this query and change it to an Update query but I can not get it to work. Can anyone please HELP!!! I have an update query that works fine but access will not allow me to update any characters over 1024. Private Sub cmdAdd_Click()...

The pounds signs do not belong If I put a date in txtProjectName it works so I know that is the problem.

I cannot figure out what is wrong with the code below. The first text box txtProjectName is NOT a date. I know the # sign does not belong there but I borrowed this code from a working form and modified the field names hoping it would work. Any Suggestions. HELP!!!!!!!!!!!!!! DoCmd.RunSQL...

Does anyone know how to get a list box to word wrap or a way to make the Column widths more that 22' to accomidate a lengthy entry.

I have a form that I want to pull data from 2 tables when a value is selected from the cboProjectName drop down box. Both tables have the field ProjectName in them and I want all the boxes on the form to display the data that correlates to the valule in the Combo box. The code is listed below...

Thank you Thank you for that code. It worked like a charm. I can now stop pulling out my hair

I need help. I have a simple form with 1 combo box and 2 text boxes. The combo box is populating from tbl_Projects. I want to select a value from this box and insert a record into a new table with data I populate in the 2 text files (Im using the combo so users cant type in values wrong and...