Search results

Must say I've never seen this happen before, but : I've a combo box set up with a Value List ('Row Soiurce Type : 'Value List') on a Form, and until today it was working well; no problems. Today, for some unknown reason, the 'Row Source' ellipsis has disappeared. ('Data' tab > 'Row Source')...

Thanks, Gasman, bob fitz, and NauticalGent. On my return to this following a few days away from it, I still can't see where the problem is in the Before_Update Event. I'd really like to get this method working. I've attached the database. If anyone has the time to take a look and try to...

I've a simple form, with two fields : one is an unbound combo (named unbClaimDecision) with a Value List of Yes, No, and To be decided. The other is a bound combo (named InvalidClaim_Reason). Attached to the Before_Update event of the form, I have the VBA code below. It seems to be working up...

MajP, thank you for this and for your earlier response. I'm making progress again now.

I've posted this in 'Modules & VBA' as essentially I think the solution is in the VBA code.. I have the very beginnings of a compensation claims database. Please see the attached. I want to be able to : Go to Form A, and click on the right-arrow buttons at the right-hand side. On clicking, I'd...

I just tried it (didn't know about Shift bypass before now), and it worked ! Thank you ! Would like to know why the icon caused this problem, though..

I've added an Application Icon to my database, and now I can't open the database, even in Safe Mode. Is there a way to force the database to open....long ehough for me to remove the icon. By the way, I'm not sure why the icon would cause this problem. It is a 200px x 200px jpeg. Thanks

Thanks, Gasman

I'm starting to try out some VBA that I haven't used before, for processing some records. But I'm getting a Run-time error '91' (Object variable or With block variable not set) error message. I've tried to resolve the problem by searching around on the www and by altering the code in various...

Apologies for the delay in replying. Thanks for your advice. I seem to be making progress now, using a joining Table.

Open frmContract. Go to 'Production company / companies' tab. In the subform, the field that's furthest left has a header 'Choose' (and Control Source intProductionCompanyID and Name cboProductionCompanyID). Is there some way of linking companies to contracts using that combo, d'you think (and...

I've been - and am - trying to link contracts to production companies via the 'Contract' form (frmContract, accessible via frmContracts). If there's a better way to do that, I'm eager to know.

In the subform , you mean? Well, I see now that I included intContractID in the combo....though not sure that I needed to do that.. Are you able to get this working, or am I attempting something that isn't achievable?

Please see attached : 1) my database (work-in-progress); <----{I've moved on to a different database to the one I initially described} 2) the only example of a similar scenario I've been able to find so far (addition of parent names to the subform embedded in frmActivities). On the subform on...

Thanks for you guidance. However, I'm struggling to understand exactly what needs to be done to be able to enter a record, or multiple records, in the subform. Could you provide an example database, d'you think? (Sorry)

Yes, intSpecsID is in the first column in the combo. I was intending to set 'Enabled' and 'Locked' to 'No' and 'Yes' respectively, for the copied-across values, so that they cannot be edited.

Thanks. Yes, I'm trying something along those lines. However, besides the material / colour / etc details, how do / should I assign the intSpecsID too in the subform, so that the intSpecsID is linked to the Order ? In trying to do so using me.field1=me.comboname.column(0), a whole new intSpecsID...

Apologies for the probably newbie question, but : I'm trying to work out how to populate the lines in a continous subform based on my selection from a combo box within the subform. I have a number of scenarios in which I'd like to use this method, but to pick one out : I've a continuous main...

Thanks, CJ_London and arnelgp ! I've achieved what I wanted now.

I have a continuous form, with some text fields, some date fields, some combo boxes, and some numeric fields. I'd like to be able to filter the records, with the option to base the filtering on a number of the fields or just one or two (depending on requirements), but not via criteria set in...