Search results

More info: Data will arrive as delimited text file, 800,000 records with 450 fields per record. First few fields are sales person identifiers, next fields come in sets of 12 with each field in the set representing a different attribute and containing the quantity sold. The header will...

I understand normalization to mean setting up tables so that duplication of data is reduced as much as possible. Also, that searched fields are indexed. I know it's hard to describe in words here, but given my examples of Product Groups, Subgroups and Attributes, can someone please explain a...

Thanks loads, Doc. Think of the app this way. Product groups are vehicle brand names (e.g., Ford, GM, Kia, etc.), subgroups as type of vehicle (e.g., sedan, SUV, truck, etc.), attributes as colors (up to 12 of them). Budget plays a big role so we're trying to fit this into Access. A fast...

Hello again. Looking for great advice that I always get on this forum. I'm working on a new application that tracks sales. Let's say the application has these characteristics: There are 800,000 salespersons each with unique ID (I). The number of product groups being sold...

Would something like this be sufficient and effective: With CurrentProject.ImportExportSpecifications("spec name") startpos = InStr(.XML, "Path = ") + Len("Path = ") + 1 endpos = InStr(.XML, "xmlns") - 2 varSavedPathName = Mid(.XML, startpos, endpos -...

Ran into a problem and need some help. I know it can be done but am having trouble finding VBA code that changes the path to an input file for a Saved Import Spec. I'm not familiar with XML but I believe there's a way to modify it with VBA. Many thanks for any help.

Thanks to everyone. I found a Youtube video that seems to address what I want. For those interested, here's url:

Thanks islados. I went ahead and put a button on the form. The button modifies the query sql, changing the sort order. It does a rerun of the query that loads the ListBox but it works fine and doesn't take much time.

On a Form, there is a Listbox that is populated with records that result from a DoCmd.OpenQuery "SearchQ" when an event occurs. One of the fields in the ListBox is 'City'. Is it possible, without re-executing the 'SearchQ' query and re-populating the ListBox, to sort the ListBox records on...

I want to give the user the option to either type in the two character state id into the Forms 'State' control field, or click on a down arrow on the control to select one or more states from a pop up dialogue.

Sorry for the naming errors. I'm new to forms. On my form, I have several fields that the user uses to enter search criteria. In the Form's Name Control, they enter a name. In the State Control, they enter a tow character state id. Then the Search button is clicked and the query that's built...

Hello again. Need some help with a search form that I've created. The form has several controls like name, state, city, etc. which the user fills in to search a table. As it is, only one name, state, and city, etc. can be searched at a time. Is it possible to bring up a listbox, on the state...

Thanks to everyone who contributed.

Sounds like continuous forms is what I need. Too bad I'm just getting my feet wet in Access & Forms. Are there any good examples of continuous form usage?

By 15 controls, I meant the fields in the form that are populated by a query. The query retrieves a student name record set from a table and populates the form fields with those names. I might be use wrong nomenclature for the form parts. So, those form fields are unbound. After the data...

Think of this as a course/student/grade update form. When the form opens, the user enters a course number. The form is then loaded with course information coming from the course table and then it is loaded with all of the students enrolled in that course. The student list comes from a table...

I have form that has, among other things, 15 controls that are preloaded with data that represent keys to a table. Associated with each of these controls is a data entry control. As the user enters this data and clicks an 'update' button, the associated key is used to find the corresponding...

Thanks again isladogs. Got it.

The only answer I can find to this question says that I have to click 'Macro' in the 'Other' group on the 'Create' tab. I don't see an 'Other' group in the 'Create' tab. I only see a 'Macros & Code' group. When I select 'Create/Macro', the 'Design' tab, 'Show/Hide' group, I do not see 'Macro...

I've tried several approaches but cannot get this to work. I have an FE that has an Autoexec macro. In the macro, I check user name against a table. If the user name is invalid, I want to display a message and quit the application. However, when Access opens, it defaults to a Form. How...