Search results for query: *

Anyone know how to scroll a listbox control to the row index of the 'first' selected value?? For example, a listbox with 200 items, displays 8 items at any one time (scrollbar down side): Selected items at (say) row# 99, 140, 150, and 155. I do not want to display row index# 0 thru 7, but...

I have a form with a tab control (each tab reprsenting a country) and two lists: Size and Colour. When the user selects size and colour combinations, the selected size and colour list ids are populated to their respective temp tables. The temp values are later recalled when the user clicks a...

I have a problem with the behaviour of the OnClick event in a tab control. I'm not familiar with tab controls at all - this is the first one I've used. The main problem I encounter is that I can't get the OnClick event to function on the visible "tab" portion of the control? Am i...

Does anyone know how to make Access think it needs to perform an OnCurrent event, without any user intervention? L.

I wondered if there was a shortcut to this problem. I started writing a function to do this but I've lost my way a bit... I believe there must be an easier way!! I have three text fields: IntSTD - max length 3 AreaSTD - max length 4 Number - max length 8 Together they would form an...

I have a kind of general question on recordcounts. The situation is my main form: Company has a subform: Contacts. In a global variable I am passing the company ID, so that the mainform will load with the company details as well as any associated contacts in the subform. In the Form Open event...

I have a continuous form (actually a sub form, but you get the idea). On each record row I want to put an Edit button that kicks the user to another form. What I want to do is pass the record ID of the row whose Edit button is clicked. Is there an easy way to tie the each Edit button to its...

I have a form which is essentially a collection of buttons, navigating users to other forms. Here's what I want to happen: 1. User clicks button for desired form 2. The current form senses the button click event & closes itself 2. The desired form opens. I already have 'open form' macro...

I'm really unsure about this one. I want to populate a combo box with a default value if the user does not put one in. Problem is the bound column is record ID [column(0)], and this has no meaning given that the record ID is an autonumber. I want to default to a value in column(1)...

I have read extensively on this topic, including here, and I'm close to a solution, but no cigar... yet! I have multiple combo boxes cboCurrencyType which I want to filter from another combo box cboCurrencyPeriod. The idea is that the CurrencyType boxes let the user select the type of currency...

Has anyone ever created a linefeed inside the result of a SQL statement? I'm trying to return the results from several address fields, as a combined result with linefeeds: ie. BuildingName, BuildingFloor Address1, Address2, City, State Zipcode Country Im trying to concatenate all these...

If I want a form control to flash several times based on the setting of TimerInterval in the Form_Load events, do I have to put the procedure in the Form_OnTimer event?? L.

Ive never used list boxes before, but they look suited to my purpose. However given my limited knowledge I'd appreciate some feedback. Is it possible to use a list box in combination with the keyboard <ctrl> key, in order to make multiple selections?? If multiple selections are posiible how do...

I have a form to display the records from its underlying table, tblCategory. In order to edit existing records from the underlying table I transfer (user clicks 'EDIT' button) the displayed record to unbound fields on the same form. In the unbound fields the user can make any changes & then...

I have a procedure to add a new record. At the end of the procedure, I refresh the form using: Me.Requery I thought this action would refresh the combo box to include the newly added record, but it doesn't. Do I have to use a statement that specifically identifies the combo box to get its...

I have a multi-functional form that adds, updates & reviews existing records. I am trying to work out if this approach is going to work given the complexity of the underlying tables. tblCategory: CatCode (PK) CatName tblFeature: CatCode (FK) FeCode FeID FeName In tblFeature...

I'm having a general problem with a msgbox - not a big one - just a procedural one i think. On a form (fmProducts) there are two combo boxes: cboCategory and cboFeature. When the user selects a Category code (cboCategory), this selection filters the list result in cboFeature. However when there...

Hi, Im setting up a Registration form. Two of the fields are CompanyName and UserName. I want both of these fields to have data in them of a certain type and format before the user can move on to complete other fields. I've set up validations in the AfterUpdate and LostFocus events for these...

I have an unbound text field on my Call Log form that records text into a Memo field in tbl_Call. Trouble is when the INSERT INTO SQL string is built up in VBA code I get errors running this statement, if the Memo field contains any quotation marks, doubles(&quot;&quot;) or singles(''). How do...

I have a number of forms with dual purpose: - search/display functions - edit/update functions Edit functions are activated on the click of the &quot;Edit&quot; button. The thing is I want to limit the edit or update functions to &quot;Admin&quot; users or members of the &quot;Admins&quot...