Search results for query: *

I have a form to search for customers based on last name. The user types the name in the text box and clicks on the search button. There is a data grid attached to an adodc. I want to know how to assign the value typed in the text box to a variable that is inserted into the where clause of a...

I have a form that includes a datagrid displaying all customers in customer table. On the form is a NEW button which creates a new record in the customer table. When the user returns from the NEW window, I would like to have the datagrid refreshed to show the new customer entry but want to...

I have a separate form with a datagrid on it. If the user selects a specific row in the datagrid then clicks on OK, I would like the record that was selected in the datagrid to populate several text boxes on another form. Any thoughts on how to do this?

I got some help from another tek-tip user on using the string function. I have a column in my DB that sometimes has two strings in a record. If the record has two strings in the specific column, I need to delete the first string and leave the second. If there is only one string, that string...

I have one table with columns for lastname, homephone and e-mail and another table with just lastname and homephone. I've added the e-mail column to the second table and want to update it with e-mail addresses based on the criteria where lastname=lastname and hmphone=hmphone. I've tried both...

I have a column that sometimes contains two string values. I actually only need it to contain one string value. If there are two string values in the field, I will always need to delete the first string value and leave the second one. In addition, the first string value always starts with two...

I would like to print a report that pulls records just based on the amount of records. For example if I have a table with 2000 records but I just want 200 records to print not based on any other criteria other than I just want 200. This may be simple and it may be in the knowledge base but...

I have two tables (one linked from another db). I want the second table to lookup the AccountExec from the first table. I have set the AccountExec column as lookup type ListBox, Row Source Type is Table/Query, Row Source is the name of the table (which has two columns). I want one column to...

I have created a module that I can get to run when running it from VBA but when I reference the module in a macro using either the OpenModule AssignBrokers or RunCode AssignBrokers() -- the module doesn't work correctly. Any clues? Below is the module code that is being run. Public Sub...

I'm new to Access VBA so bare with me :) I bought a book on Access Development and there is some code (working with Recordsets) that I want to put into my Access database. To add this code I click on Modules from the main window, start typing: Public sub myfunctionname() Dim rsLeads as Then...

I have one table containing sales records (with a column for AccountExec). One table containing list of Account Executives (with yes/no column to designate active status). Need to loop through the sales table and assign one active Account Exec to each record. Want it to loop through list of...

I have a form that allows a new code to be created (in the Codes table) or look for an existing code (in the Codes table). I have a table of imported records and for each record there is a blank in the "Code" column. I want to insert a code into every record (the same code for each...

I have a combo box that is listing all my Account Executives (being pulled for AcctExec table) but it is populating the entry in a Sales table. In the sales table I only reference the Account Executive by their code number (PK in the AcctExec table and FK in the Sales table). I would like for...

I will be importing approx. 20,000 rows per month (info tracked is basic indinvidual info (name, address, phone#). For every 20,000 rows only approx. 5% of those records will be used on a semi-regular basis. In addition, more info will be tracked (business phone, occupation, etc.). From...

I have a table that will contain imported sales records. I want to evenly divide and assign the sales records to the different active salespeople (salespeople stored in different table). The table storing the imported records does not have a column to hold which sales person but can if...

I have a cross tab query setup but I need to only include certain records in the query based on a date range. I know how to setup the date range parameters but when I include my date column (not to show) with the criteria &quot;>=[Enter beginning date] And <=[Enter ending date]&quot; in my...

I have four columns on information: Name, Sales Item, #of Items Sold Per Day, Date of Sale. I want to create a report (which I assume I should base on this query) that shows Sales Items, # of Sales Items Sold (based on date range) for specific Name. I have created a query that prompts for the...