Also I think there is a problem with Run-time error '-214721900(8004e14)'
Syntax error(missing operator) in query expression '* [Technicia_Name]'.
It highlights Set Rs = Cn.Execute(StrSQL)
But this is when I put the Set Rs right after StrSQL = "SELECT...
Thanks for the reply sparks80.
Sorry I didn't specify where the error was coming from. I totaly spaced
on that. I've made the changes you suggested. I'm getting a new error now. Not sure how the code is to be written where the errors are. I'm a rookie with SQL and barely 7 months experience...
I need help please. I can't figure out how to UPDATE a record in
Access 2010 using an Excel 2010 userform.
Run-time error '3709':
The connection cannot be used to perform this operation.
It is either closed or invalid in this context.
Dim Cn As ADODB.Connection, _
Rs As New ADODB.Recordset...
I've copied and pasted a couple of examples from on of my vba codes.
I don't have one specifically for "Numbers" but hopefully this will lead you in the right direction of how to format a text box.
Me.TxtWorkFinished1.Text = Format("0" & Me.TxtWorkFinished1.Text, "hh:mm")...
I forgot to mention that my form worked fine with all those change events when filling out the form it was when I used that same form to recall a record where all the feilds were filled in at once that I ran into the problem. I'm assuming that is what your form does based on what you are saying...
I had this exact problem with one of my userforms. Mine had to do with a change event with a combo box and a few textboxes. The way I had my code structured for all the different change events caused it.
Here is what I have now for my code on my change events. I had to break things down...
I'm new to this forum and a rookie so please bare with me.
Current Errors:
1.)Syntax error(Missing operator)In query expression '[Technician_Name]ID-'38'.
2.)Operation is not allowed when the object is closed.
3.)Object variable or with block variable not set.
I'm using Access 2010 and a...
Hi. My name is Chris. I'm new to Access programming. I live in US, California. I'm a market refrigeration technician. Why am I here? I joined because our office currently uses a paper system for our service department so I took the initiative of trying to build a database. I'm in over my head to...