-
Hello,
I have a form which has several cascading dropdownlists. I used to have them set up on secondary data sources and they would retreive data whenever the form was opened.
However, I had to switch them to the primary data source and now they don't contain anything, and I can't seem to figure out how to populate them.
How can I populate a ...
-
I am not very fond of excels workbook protection (possibly because i dont know all of the ins and outs).
Another thing is that I can keep a running tab with my database, instead of making a new excel file each month the database will be easier for me to manage. I just wish i had the time to really learn access and make the data access pages and ...
-
This is probably a question with a simple answer but I can't seem to find info on it.
Background:
I have created an InfoPath form with an Access DB as the primary data connection in order to query AND submit data to the DB. I have created it on my PC in location A (my work office) and it works fine. Tomorrow I need to move/copy and publish it ...
-
Try this:
Dim myComment As String
myComment = Range(''A1'').Text
Range(''A1'').AddComment
Range(''A1'').Comment.Text Text:=myComment
End Sub
-
yeah i think i have insert permissions, but wouldnt i get some sort of error message if i didnt?
-
Why not use the built in security features in Excel to prevent your users from accessing the features that you don't want them to break? You should be able to lock down the workbook in a few minutes after you have read the Excel Help file for all of the details.
-
Nobody knows this?
Thanks for your reply
-
The range property needs to be assigned to an Object (e.g. the worksheet needs to be defined)
-
do you have insert permissions on the DB?
-
Mike do you realy need to copy the data into another form, or could you get by with another View in the same form. If this would work for you, take a look at www.wssdemo.com:8080/Pages/infopath_lookup_of_list_data.aspx for an example showing how to use Rules to populate other fields from a dropdown.