Search results for query: *

rossco, Look at thread702-953231. It may help you. thehorse

AceMan, I want to complement you on this post. Obviously from this and all your other posts, you have great command of ACCESS and SQL programming. Also, you take the time to develop codes to help people solve their problems. You, among the many other professionals on this forum, make this...

PH: Thanks, Works well. Can you briefly explain two things? 1. Why the single quotes and the second ampersand? 2. Me. and Me!

Search is disabled, so I'm posting this question: I want to display data in a text field on a form based on a selection in a combo box. I get it to work with a list box, but not with a text box. Here's what I have: Form name: frm_OfficeReport ComboBox: cbo_Office; TextBox: txt_officevalue...

The Import Wizard should work with the txt file. If not, you could always use Excel to import the txt file, save as xls file, then import the Excel file into Access. It's a workaround.

Got it. I simply modified [Subform] to: link master = PicState;PicLoc, child = State;Location Works like a charm. Thanks.

First, thanks to all the experts on this site for your time and help. I've learned more in the last month reading the threads than I could from any book. Now to my current issue: I'm working on a form/subform. The form has 2 cascading comboboxes, [PicState] and [PicLoc]. PicLoc uses the...

One similar problem I'm having is requery on a subform. I have a form/subform. The form has two cascading comboboxes. I select [state] first, then [city], the source of [city] changes based on the [state] selected. I want the subform then to list pricing for each city. I've tried (but get a...

yourcombo1.rowsource = "" will clear the items in your subsequent comboboxes. If this is what you're after, then it works. If you want the subsequent comboboxes to clear the current entry, but to keep the corresponding source, then use: yourcombo1 = "" yourcombo1.requery etc.

Ah-Ha! I figured it was something rather simple. Let me see if I understand. By having [OFFICE] in the Control Source of the combobox, the combobox is bound to the data in [OFFICE] which makes it an editable field. This also is causing Andy's record to change based on the edit in the...

I created a basic form with a combobox looking up [OFFICE] with a subform that filters based on [OFFICE] to display editable fields of employees in each office. The form/subform works, but autoedits the first record. What do I mean? When I open the form, it defaults to the first record in the...

How can I create an Ad Hoc Query on a form? I have a form with a subform designed as a Datasheet. The subform contains approximately 10 headers and is sourced from a query. The top form currently contains a combo box that sorts the datasheet based on the first header. What I would like to do...

I got part of it now. I previously tried to add the Me.Requery to the AfterUpdate of the Combobox as you suggest, but it already contained the following code: Private Sub Combo0_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone...

How can I get my subform to update based on my form selection? That's my question, now let me give details: I created a form with a single combobox called "LastName". I pulled this from a query called "CompileInfo" that contains 8 different data fields. There are 5 "LastName"s. I "Group...