I checked both ofb these and they are fine. I am wondering if it is a setting on my actual computer? All other macros in other documents work fine..
Thanks for the help Daniel. I appreciate the quick response. Any other suggestions?...
elecooley
Last Activity: Jan 31 '08, 10:24 PM
Joined: Mar 7 '07
Location:
-
ODBC error in Excel macro, on one particular PC
Baically, myself and the person I sit next to use a shortcut to an Excel file. The Excel file has multiple macros. When office mate opens it, it works fine (ie all macros run, excel file gets data,). When i click on the shortcut, I get an error pop up: Run time error 1004' General ODBC error.
When i click on Debug, VB opens and it shows:
Object = General
Procedure = Get_program_dat es
and highlighted in... -
NeoPa --
Ok, sorry about posting the long set of code. I am trying to learn all the ins and outs of this, and it is going slow.
Post #15: I have done this, and it works. So, when I am on the current form and click the checkbox, it "locks down" the data (grays it out). That is what I want. But again, when I exit that form and go back to the main switchboard, then go back into the previous form, the checkbox...Leave a comment:
-
I think there is a "conflict" with this (see the BOLD code I highlighted) but I do not know how to resolve it.
----------------------------------------------------------------
I guess I need the checkbox code to "trump" the above code when the form is reopened. Hopefully that makes sense. The above code is only for when a NEW document is opened, then after all the new information...Leave a comment:
-
1) I do have the filed in my table to store the value.
--Under "FieldName" I have named it "Done".
--Under "DataType" I have "Yes/No"
--Under "Descriptio n" I have a general description of what it does
2) The checkbox is bound to the field "Done"
3) i do not have a Form_Current that I can see under my forms. I do have this code under my...Leave a comment:
-
Honestly, I am not sure which one is better. I am not familiar with "adding a value to the registry". Is this in the database itself?
Again, thanks for the wonderful help....Leave a comment:
-
No, It was not impatience. I am still getting familiar with the postings and how they work, that is all. Thanks for calling me on it....Leave a comment:
-
I reposted another question....Leave a comment:
-
That worked great, but when I close out of the document, then get back in it the data is able to be changed, even with the checkbox checked. If i uncheck the checkbox, then RE check it the data gets greyed out like I wanted, but I need it to ALLWays be greyed out when the check box is allways checked (even when the database is closed out then reopened).
Hopefully that makes sense?! :)
Thanks for all the help.Leave a comment:
-
Thanks. This was an awesome help. It works just like I wanted.Leave a comment:
-
When a user puts in the data and then checks the box, i would like the boxes where they put in data to "grey out" and not be able to put any more data in it. The only way a user could put more data in would be to uncheck the check box and then they could put more data in. Is this possible?...Leave a comment:
-
----
This does not seem to work. This is what the code looks like in the form after I input the above code:
Private Sub Done_Click()
'Must Save the Record first
SendKeys "+{ENTER}", True 'Save Record
Me.AllowEdits = False
End Sub
I am rather new to working on the "background " of databases, so there may be something else that I may have to do that...Leave a comment:
-
Checkboxes: to lock down user input data in Access 2003
I have a checkbox on the form that says "When all data has been entered, check this box". Right now it does nothing, but I want it to lock down that particular set of data so the data cannot be changed from the data input form. I would still like to be able to run queries on the data, but would basically like to lock down the data so other users cannont change it.
Thanks for the help
No activity results to display
Leave a comment: