Search results for query: *

On my search form, my search results are in the detail of a continuous form. I want a text box to show the currentRecord beside each record. I tried to make a text box called txtCounter that would show this results. I put this in as the control source: =[Me].[CurrentRecord] This did not work...

On my search form, my search results are in the detail of a continuous form. I want a text box to show the currentRecord beside each record. I tried to make a text box called txtCounter that would show this results. I put this in as the control source: =[Me].[CurrentRecord] This did not work...

I have a search form that matches control's values with an underlying query. The unbound search comboBoxes are in the form header, and there are continuous results in the 'detail' section. Some people at work have complained that they get confused about what record they are at when they scroll...

I have a search form that matches control's values with an underlying query. The unbound search comboBoxes are in the form header, and there are continuous results in the 'detail' section. Some people at work have complained that they get confused about what record they are at when they scroll...

I have a search form that displays the results of a cross-reference catalog search. The results are displayed on a continuous form such that many results are seen at once. I have among other things, a text box that shows a company's web-site in hyperlink form. This works about 50% of the time...

In my main data entry form (frmCatalogDataEntry) I have several controls that are mainly for viewing purposes (auto-fill) that don't really need to have focus on them within the tab order. I also have three command buttons that I would rather not get the focus unless clicked. Like my 'delete...

In my main data entry form (frmCatalogDataEntry) I have several controls that are mainly for viewing purposes (auto-fill) that don't really need to have focus on them within the tab order. I also have three command buttons that I would rather not get the focus unless clicked. Like my 'delete...

I have a "Cross-Reference Search Form" which has several combo boxes to choose from. I finally got this thing to work but there is one minor problem that is a major annoyance. I based a form on a query, and put in SQL criteria for the query which pretty much said ie. ....WHERE...

I hate string ID's. My first database, and now, I realize that I have shot myself in the foot for not using autonumber. I have changed one relationship already, now I want the change the last one. However, I want to do so without deleting info because if I did, I'd probably be fired. Ok, I have...

I have two tables that deal with product categories and sub-categories. Foolishly (because I learned from some terrible "for dummies" book) I made both the category, and sub-category ID's 2 & 3 letter strings (auto-filled on a form). I had also used this technique for the supplier ID...

This is kinda visiting a thread that I posted earlier today, but I feel I should elaborate on what I was trying to say. I have created two successful search forms based on queries that incorporate different tables. One form prompts a user with a combo box in which they select products. The...

I am trying to use the code from DougP's FAQ702-1177. I was wondering if there was any way to get fields on the sub-form from a different table. Could the Dlookup funtion be used to get values from different tables of a record? Or would that somehow violate the code? Dan Eaton...

I have a data entry form. It has many fields describing a catalog and how it is filed. Many of the catalogs we receive are in different formats. There are catalogs, cd's and what we call "datasheets". Datasheets (as the name suggests) are simply single, or groups of sheets with...

I have a data entry form. It has many fields describing a catalog and how it is filed. Many of the catalogs we receive are in different formats. There are catalogs, cd's and what we call "datasheets". Datasheets (as the name suggests) are simply single, or groups of sheets with...

My database has a main data entry form called frmCatalogDataEntry. On that form are many different command buttons. Two such command buttons are to update info if it is not already in the combo boxes. For example, the user enters the catalogs date, and catalog#, only to find out that the...

My database has a main data entry form called frmCatalogDataEntry. On that form are many different command buttons. Two such command buttons are to update info if it is not already in the combo boxes. For example, the user enters the catalogs date, and catalog#, only to find out that the...

Is there anybody out there who knows if it is possible to change to an autonumber field late? What I mean is I'm trying to change an ID tag from >LLL to autonumber. The reason: I underestimated how much repitition there would be for my field, and the program has gotten repetitious. There are...

I am currently creating a catalog database, and filing all of the catalogs. I have a report that creates labels for each catalog as it is entered. The labels have two different characteristics: catalog date, filed under. Catalog Date is a field on tblCatalog that is not required to be entered. I...

I have set up a search form that is based on a query. It prompts the user for a product to search and displays all of the catalogs that contain at least that product (as there can be many). There is a button on this form called cmdModifyCatalog. This button, when clicked, activates the visible...

I have set up a search form that is based on a query. It prompts the user for a product to search and displays all of the catalogs that contain at least that product (as there can be many). There is a button on this form called cmdModifyCatalog. This button, when clicked, activates the visible...