Search results

Hi; Hoping that someone can suggest a solution for the following: I have a form “frmAdd_Client”, on which, in the form header there is an initial (field(0)) cbo “cboSelect_Client”. Into this control is entered Surname,Prename;Date of birth. If the new data is ‘not in list’, then the detail...

Hi; Wondering if anyone can solve this problem, which worked fine in Ac2 and Ac2k, but does not seem to function properly in Ac2003. I’m using the following elements to print different captions in [lblCopy] in a report/ subreport of which I’m printing two copies. Report ‘Declarations: Dim...

from what I remember, all you have to do is set 'can shrink' property of report text box to 'true' and text box will not appear on report. Report section should allso be set to Can shrink=true. Hope this helps richard

Hi; Does anyone out there have a sample Db for something like a loan- payment invoice; ie, to show monthly payment due, interest (or service charge), and balance remaining? I've looked at the "accounts ledger Db" from MS, but that's not quite what I'm looking for. (In fact, I can't imagine what...

Hi; hope someone can help with the following problem in Ac 2003. I have a report/subreport, used as an invoice. The subreport contains itemized bill lines, which include [charge] for each line. I’m trying to show the sum of the charges on the subreport in a control on the main report, which I’ve...

Steve Lebans code works great. I'm actuating an auto effect by setting focus on a transparent command button (on double-click of item selected in lb), and using SendKeys "~" to effect the code on the command button. Two questions for the audience: 1)anyone have any suggestions as to how I can...

RURALGUY; Info looks like it might help. I'm not sure, however, if there will be any advantage to a command btn in place of scrolling the lb itself. Hope I can figure out some way to auto-actuate. Richard

Skea; "I search for something, then the listbox scrolls it in visibility. Is that what you meant?" >>>>>> No. I have a listbox which is filled by a 'filltree' fn. There are many branches in my tree. When I 'select' an item in the tree to open up the branches for that selection, I'd like my...

Glad that GARYCA responded to my msg so as to get the string going! Note that I posted the Q back in June. Now all I have to do is see if I can figure out what the respondents mean. Thanks. Richard

I'm having a problem appending some records from one table to another, and hope that someone can get me on the right track. I'm trying to append a small group of records-perhaps five at a time, from tbltemp to tblservices. Each line in tblServices must have an entry 'LineNumber', which is...

Scrolling SelectedItem in LB in code Hi: Anyone know if there is any way to make a selecteditem in a listbox move so that it is 'scrolled' to the top of the visible listbox. I'd like to add such a feature to a filltree type of listbox outline. TIA, Richard

I'd like to set a value for control 'units' on 'form2' ans am having difficulty with the following macro. Macro action is: SetValue Item: [Forms]![Form2]![Units] Expression: ElapsedDays([Units]) Macro is run on 'afterupdate' event of contol on form named 'Date_To'. Function "ElapsedDays" is...

Just discovered an amusing solution to my own problem! Microsoft, in it's infinite wisdom, decided to replace the 'unreliable' SendKeys action with such things as 'Dropdown'. My app was converted from Ac2, where it worked fine with SendKeys "{F4}". Converting my sendkeys statements must have...

RE: Try using OnEnter event. Already tried and failed. RE: 'Hackup DB" yes, it works for me also if there are sequential controls on the form. The problem I have is ONLY when I seem to setfocus on the cbo from a field that is not in the tab order. Thus my fields go: eg---ctr1, ctr2, cbo1, in...

Crilen007: Nope----even with a new DB, the cbo won't open unless it is entered directly in the tab order of controls on the form. This was never a problem in Access2.0 with 'sendkeys {F4}', and it formerly was not a problem in my Ac2k setup. (no, I don't have any viruses in my system) Any...

Oddly enough, I have a duplicate Db already loaded on my PC, and it has exactly the same problem. I'll try setting up another one just to see, but I don't expect any miracles. Richard

Multiple users use this? No What did you change recently? Nothing Does it happen on just your system or other computers as well? The App only exists on my PC, so I don't know about other pc's. Did you do any windows updates that would change this? No. Richard

I've recently acquired a bug in my app in Ac2k where, if I enter a cbo by a 'setfocus' command on exit from another control on the same form, my cbo doesn't dropdown (as it's coded to do in the 'ongotfocus' event). This problem used to not be present, but it has recently started to occur on...

Aleb: Sounds good; I'll give it a try. I'm still confused that the old system worked fine in AC2, but fails here. It was so neat, without extra buttons, etc. Richard

Pat: My filter is for the detail section of my form, in which the subform is placed (but not exclusively). The filter is not for the subform itself. I don't understand how I can change the recordsource of the subform to accomplish what you suggest, as the recordsource would always be...