Search results for query: *

Hi everybody, i have two comboboxes. One pulls out a list with company names, and the second pulls out a product name list. Many of these companies have the same products but with different names. I would like to have the second combobox list first to show the product names of the company...

Hi, I have behind butons code to "find" certain recordsets, the code is almost the same for find, findfirst, findnext, findlast. To make things easier to explain, I copy the 'findlast' code and describe (one of) the problem(s): Private Sub btn_LastRec_Click() 'Purpose: Find the last matching...

Hi, I have a form with several comboboxes which should only accept values from the list. I have set the NotInList event, but in addition I added these two modules, which should fire on entering the combobox and on Keypress: Private Sub ucbo_Starter_Enter() sOldValue = ucbo_Starter If...

Hi, I wonder if this is possible from Access: I open a specific webpage (yes,followhyperlink) http://appft1.uspto.gov/netahtml/PTO/search-adv.html This is the US patent database webpage. 1. Step Now I want to run specific queries which are stored as strings in my database which have to be...

Hello, how do I get the new value just entered into a combobox control ('ucbo_System', linked to a table field) show up after the control has been updated but without record change in the dropdown list? I tried the requery method in the controls after_update event, but it doesn't work, neither...

Hi, if I recall correctly, I have seen people saying in various unrelated threads that light weight forms (i.e. put everything into the property box) work better than those with VBA code behind, but others say the opposite, such as Bill P. I really wonder which is better, or if one or the other...

..unfortunately not in the good sense. When I move to the next record, parts of the form shake like struck by an earthquake, keeps quiet and flickers again - all in less than one (to two) seconds, but very disturbing. What do I have: approx. 5 subforms, 5 tabs, 100 labels, 30 comboboxes, 70...

Hi, I would like to show as the defaultvalue the entry which has been selected most so far. How can I achieve this? I tried several ways, but it did not work... I guess, due to a mixture of logic and syntax problems. Thanks, georgp

Hi, I have a combobox with the following - working - VBA code, which restricts the dropbox selection to the items related to combobox cbo_Fld0: cbo_Lot0.RowSource = "SELECT Distinct LotName from tbl_ProdLot Where [ProdNo] = " & cbo_Fld0.Column(2) However, if I try to put the code...

Hi, I am using MS Sans Serif font for my tables and forms. Is there any way to make the user type real single greek characters, like 'alpha', 'beta', 'gamma', 'delta' (i.e. Symbol font) as prefixes, such as in 'g(amma)'-gluboline? Thanks for tips. georgp

but obviously I did not. I want to refer from one subform control to another subform control (different subform). The main form can also change. Any help? Happy New Year!..... georgp

Hi, in a module, I want to refer to a control (rectangle) which name is identified in the tag of another control (combobox): Public Sub bss_PolySynth(rfrm As Form, Ctl As Control) .... .... Forms!(rfrm.Name).Controls!(Ctl.Tag).BackColor = Ctl.BackColor (and many other trials) .... .... End Sub...

Not sure, if this is the right place to post... I have a database with 5 fields and the form with 5 textbox controls: [topic1], [topic2], [topic3], [topic4], [topic5] as well as other text controls. Two questions: 1. The user can enter 1-5 topics in whatever order in a new record and I want...

Hi, I have a listbox with the RowSource: utbx_list.RowSource = "qry_PSynth". The stored query behind is as follows: SELECT tbl_PSynth.ID, tbl_PSynth.Name1 & IIf(IsNull(tbl_PSynth.Name2),"","/" & tbl_PSynth.Name2) AS [Poly Comp] FROM tbl_PSynth; This works...

Hi, I've been running into problems with a form, which is quite complex, but I think I can demonstrate the problem by analogy. Basically, I want to set recordsource (selection) criteria through a sub-sub form value. Three tables are the basis: 1. tbl_Top with field 'Top_ID' (linked to...

Hi, before printing my reports I would like to be able to select the printer using the Access standard dialog box, popping up especially if the defaultprinter is not available. How can I open the standard dialog box and how can I test, if the defaultprinter is available? (I want to hide the...

Hi, I use the 'Application.RunCommand acCmdRecordsGoToNext' a.o. to move to the next record. The code is in a standard module. This works fine, as long as the form is the main form. For certain reasons, I have to use the form as a subform, and now the code fails, probably because the mainform...

Help wanted! Today is obviously not my day.... I'd like to set the recordsource of the subform frm_CustOpporSub3 in the VBA code of the mainform frm_CustOppor: Forms!frm_CustOppor!frm_CustOppor3.Recordsource = frm_CustOppor.Recordsource I also tried other variations. Always error messages -...

Hi, looks like I am posting many questions recently. In the property sheet for a subform are the two items "Link child fields" and "Link master fields" in order to get the subform synchronized with the main form. I want to change the links programmatically in VBA. I do not...

Hi, in order to browse through the data in my form, I have included my own navigation buttons (command buttons: first, last, next, previous) working on VBA code. The problem I have is that upon activation of the command button only the next or previous record will appear and I have to click...