Hmmm that's a bummer... Maybe this should be a new thread?
My brother is a pretty darn good programmer (he set up Bhutan (the country) on a solar powered wireless network that he designed and built and he works for companies that he can't even tell me about...)and he says "life's too short for MS" he seems to think that MS Access has a lot of faults, but, i have to say, for me it's worked well because I am not a programmer...
CharT
Last Activity: Mar 24 '12, 05:49 PM
Joined: Sep 30 '11
Location:
-
hmmm... would using an incorrect way of linking controls cause that? Maybe I did something wrong? I do have a backup that is only 1 day old, so not too much trouble, but I sure would like to know what causes this so i can try to avoid it again!Leave a comment:
-
Hello, thanks for the quick update- after I made the change to my form, saved and closed the db for a bit, and went to reopen and it keeps crashing... any suggestions of what would cause this? The error is: Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience.
It just keeps going in circles backing up and crashing... :(Leave a comment:
-
CharT started a topic Use a control on a Form as the Record Source for a control on a Different Form?in AccessUse a control on a Form as the Record Source for a control on a Different Form?
Hello, Using Access 2010...
I can't get this to work and it seems as if it should be :)
I have a text box on a form, which is a subform on a main form. The main form is Child Info, the subform is called AdultList, and the subform control is called AdultSFCont
I would like the value of the control Adult ID on the subform AdultList to magically appear in a control on a different form.
I have set the... -
Although I did not use the code provided, I was able to use the tips about linking child and master fields to finally get a solution. I left out one thing I did, I put the adult id control in the form header of the continuous form, so that when an adult name (in the detail section) was selected, the adult id was selected as well. I used that adult id as the source for the text box on the main form and then linked that to the detail subform. I am...Leave a comment:
-
Hello all- WOW I finally got this to work... I was able to create a text box on the main form and make its source the adult id in the continuous form, then, link that text box to the detail subform adult id. I am not sure why it took so much trial and error, but it is working. There is a bit of a lag for the detail subform to populate, but it's working. Thanks so much for the continued support :)Leave a comment:
-
Hello Nic, I have been trying to get this to work for several hours. I must be doing something wrong, or, I may not have described my goal clearly enough to begin with...
I would like to use a continuous form with an on click event to generate the correct record in an adjacent form.
The subform that generates the list is a continuous form, named "AdultList" who's record source is a query that selects adults that...Leave a comment:
-
Okay- i figured out what the problem was... this may not apply to anyone else... but I have a field in the table that is the source of my form, that stores file paths that refer to images... when I copied an updated back end from my client to my local drive and linked to it, the image file path was trying to find their network drive and not my local drive and that apparently was the source of the error message. Once i changed the file path for the...Leave a comment:
-
I wish I could answer your question! I haven't changed the properties of the list box, I have changed a few design features of the main form... i did however just figure out that it is only 1 record that produces the error, so I might just try recreating that record to see if that solves the issue.Leave a comment:
-
2101 The setting you entered isn't valid for this property
Hello- I have an access 2010 db that i have been developing for almost a year. I have a list box, based on a query, that filters a form... for no explainable reason i now get the error message "2101 the setting you entered isn't valid for this property".
I have not changed any of the properties of my list box, or my form. The weird thing is, the folks that i am creating the db for have the exact same front end and back end,... -
I will work on this as soon as possible and let you know how it goes. Thank you!!Leave a comment:
-
sorry- stuck again... maybe what I am after isn't possible...
My application is for a child welfare setting...
I have a table with 300+ kids. Every kid can have multiple adults with various relationships to the child (bio mom, care giver, foster mom, etc)
I have a form "child census". There is a page (tab) for adults that are related to that kid.
I have a relationships table that joins the child to...Leave a comment:
-
Thanks- I'll give that a shot. :)Leave a comment:
-
Help with the "BrowseTo" command
I could use some help with the BrowseTo feature in access 2010. I have searched for and read everything I can find on the web... which wasn't much.
Can browseto be used on a form other than a navigation form, if so, how do you set the file path? I have tried to follow the examples given here: http://blogs.office.co m/b/microsoft-access/archive/2010/02/23/access-2010-browseto-docmd-and-macro-action.aspx and I can't get it to work. ... -
Yes, thank you that answers my question. I will implement your suggestions.Leave a comment:
-
i'm sorry, they are form objects. not control objects on forms.Leave a comment:
-
Thank you again for sticking with me on this! To answer your question, i have named my sub forms imagesa and imagesc. imagesa is on the main adults form, and imagesc is on the main children form.
So- two answer that question, yes, they have different names- but when i look at me list of modules, i have only 1, the module that i created when i made the first subform, imagesc.
when i copied imagesc and saved as imagesa so...Leave a comment:
-
I'm so sorry... i completely agree, its difficult to clear up confusion if you don't know where it is! I feel like a blind man trying to describe what i am seeing :)
i think my use of the subforms fits your first scenario. (i think)... okay here i go again:
I have a main form called "adult info" this main form has in the detail section the fields from the underlying table as well as the image subform that displays...Leave a comment:
-
Oh- i think i understand. would it help if i pasted the code? the subforms, called "imageA" and "imageC" (a is used in the adult main form and c is used in the child main form) are exactly the same, except for that the record source for a is the adult table and the record source for c is the child table.
I had found some code that i used from the internet that looks up the file path in a text field of a table and...Leave a comment:
-
Can two image subforms use the same module?
I decided to try to add the picture feature to another form. So, I have two image subforms now, one for the kids pics and one for the adult pics. The kids one refers to the kids table, the adult to the adult table, etc.
But ever since i tried to create the one for the adults form, my db crashes. it seems to have suffered some serious corruption, and I had to spend some time piecing it back together... i don't know if it is a coincidence...Last edited by Niheel; Oct 1 '11, 06:37 PM. Reason: Spaced sentences to make readable. Moved: one question per thread.
No activity results to display
Leave a comment: