Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Quixxx
-
Type Mismatch after save?
That worked Thanks a million!!!- Quixxx
- Post #5
- Forum: Microsoft: Access Forms
-
Type Mismatch after save?
I made the changes... I guess I was lazy with the rstSet. I still receive the error though... it breaks at the last line when I am trying to close the form. Private Sub cmdSaveDOCS_Click() Dim recIND As Integer Dim strSQL As String Dim i As Integer Dim rstSet As DAO.Recordset recIND = txtRVA...- Quixxx
- Post #3
- Forum: Microsoft: Access Forms
-
Type Mismatch after save?
Hello all, I can't figure out why I am getting a type mismatch error after my save. Here is my code Private Sub cmdSaveDOCS_Click() Dim recIND As Integer Dim strSQL As String Dim i As Integer recIND = txtRVA strSQL = "Select * from tblPhysicians" Set rstSet =...- Quixxx
- Thread
- Replies: 4
- Forum: Microsoft: Access Forms
-
Saving data
I thought about doing something like that but in this case... the users using the form are just typing it in without any kind of verification. I wanted to make sure that the correct data was being entered without an input mask on all of the form fields. I guess I could have started all the... -
Saving data
Thanks for your answer... I figured it out already. I had added extra fields to the table and when I modified my code I forgot to put the quotes. If IsNull(txtGroupPATIENTS) Or txtGroupPATIENTS = "" Then Else .Fields(grpRosterNUM) = Me.txtGroupPATIENTS.Value End If should... -
Help Saving Records 3256 error
Never mind... I'm an idiot!!! I didn't put the quotes around the field names!!! WOW and it's not even Monday!- Quixxx
- Post #3
- Forum: Microsoft: Access Forms
-
Help Saving Records 3256 error
I just realized that it is doing this only on new fields that i have entered into the table after it's initial creation. would that have anything to do with it?- Quixxx
- Post #2
- Forum: Microsoft: Access Forms
-
Help Saving Records 3256 error
I have been loosing my mind trying to figure this out. I have been trying to save a record from a form but I keep getting this Runtime error 3265 - Item not found in this data collection. I know that the field names are correct. as a matter of fact, I have changed them thinking that maybe I had...- Quixxx
- Thread
- Replies: 2
- Forum: Microsoft: Access Forms
-
Saving data
Hello All, I have been loosing my mind trying to figure this out. I have been trying to save a record from a form but I keep getting this Runtime error 3265 - Item not found in this data collection. I know that the field names are correct. as a matter of fact, I have changed them thinking that...
