Search results

I have a form, which opens showing an attachment object, which when double-clicked, prompts me with a Dialog Box, listing ALL the attached files, for that record, ( not just the oen I have just seelecetd ) whereupon, I have to agin selct the file I wish to open, make changes, and then am...

Does anyone know how to 'bypass' the built-in dialog box, that opens when double-clicking an Attachment control. It lists all of the attached files, and you confrim you wish to open the one highlighted. I would like to use the 'Double_Click' event, to open my files immediately :confused: ??

I don't know what a 'split' Db is. Do you mean by deleting the linked table, making a copy of it, and deleting the existing one. Then use the new one ?

I've set the Control Source of an Attachment Control correctly, for a field in a table which holds 5 attachments ( files 4 x .doc and 1 x .pdf ). However when the form loads, it shows no icon, and when I click on the 'paperclip' with control, to view files there are none shown. Also of course...

Thank you for your clear and logical explanation. I will be trying to implement it now.:)

Does anyone know of a succinct and efficient way, of positioning controls on a form, ( screen/window ) actually, which 'adapts' to the 'ratio'. I know in Webpage design, one can group controls, and then position them relatively, based on coordinates 'read' at loading time, of that particular...

I did have, and do have, a Form/Subform linked in this way. In my case, unique client records on Main Form and their referrals ( one or more ) on subform linked by Master/Child Client_ID ( unique P.K. number ) I initially used a cross-table query for the main form, which was read-only ( it took...

I follow your idea, but was only aware of two Z-Order positions i.e 1 and 2. As is known, these cannot be set dynamically, only using Send To back and Bring To Front- at design time. If I can, I'd like to use your solution, but how ? Thank you again.

Don't worry. Here's the issue ( solved now ). If you select data from MORE THAN ONE table ( in a query, SQL ) for a form, you cannot edit/update that data, either directly through the form's controls, or in VBA dynamically. I had about 12 fields on a subform showing in datasheet view, ALL of...

I tried that ( with an = sign in front ) but didn't work.

I didn't realise you could put 'unamended' SQL into this property. I'll try it now. Thanks jdraw.

I've now overcome it. I took the useful concept of your's ChrisO, of effectively 'reintroducing' the same object in the same place, which should restore it's original Z_Order position. ( I just 'read' the current Left and Top positions of the object in question, and then using the same...

I'm not familiar with the syntax for the Expression Builder for a control's Source ( other than very basic). I want an output, based on another field's value on teh same subform ( Like a SELECT .. WHERE Clause in SQL. In fact, here's the equivalent SQL "SELECT tblStaff.CalcStaff_Name FROM...

Every time I click on a 'Text Box' ( I use it as background colour for several other controls 'in it' ), which is set under Conditional Formatting, to change colour, ( dependent on a value in one of these other Text Boxes/Controls ) It covers all of the other controls i.e changes it's Z-Order I...

So far it's working well again. Will monitor, and bear in mind your advice. Thanks.

Thanks for reply. No I haven't. I have checked all Filter properties in forms ( I did try setting one in the past ), but it caused the same difficulty, when I tried to overwrite it dynamically - so took it, and all Property-set filters, out. The only other 'filter' on this ( or any other form )...

Has this happened to anyone else ? Main and subform working normally - the latter having a linked field to the mainform, and changing it's recordset accordingly on moving through the recordset. Then, what appears to be only one or no records showing on subfrom. On checking the SQL/Design Grid of...

Re: Using combobox ( .FindFirst filter ) on main form. Found the issue ! Subsituted .Text property for .Value. This appears to trigger the correct events, to complete the operation. Now looking at how I change the underlying data, linked to these Combos. Thanks all, wishing you smooth...

Hello fellow VBA programmers. Here's the issue. Any ideas ? ------------------------------------------------------------- 1. For .... Next loop in On_Current event ( 0 to 2 ) on Main Form. 2. This is for 3 combo box outputs, ( outside the recordset fields - of main form's recordsource ) 3. Using...

thank you again boblarson. It's now working. An alternative, round it, also seems to be, referencing the still open ( and at the required record importantly ) recordset, on the calling form. i.e. With Forms!frmClients.Recordset .Fields("Diability_Type_IDS") = whatever value here End With...