Recent content by jallen919

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?

thanks so much -- I thought I just copied and pasted last time but apparantly I didn't. You saved me days worth of manual work -- thank you.

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...

OK -- here is what I did... I added a new module and just called the module Functions and inserted the code you wrote. When I run the query I get a message saying RunTime Error 5 -- invalid procedure call or argument and it stops and highlights the line: MyVar = Split(StrIn) Thanks very much...

Where do I place the code that you so kindly wrote for me?

Not to be dense but I'm not sure how to put this code in my DB and run it on the table I am working with... can you help with that too please :)

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...

Well I want it to be run as part of a macro because I have some append and update queries run, then I need the module to run. If I run is separate from the macro it works just fine but if I call it from within the macro it doesn't seem to work... should I be running all commands from behind a...

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...

Not sure exactly how I fixed it but changed my code so my first recordset opened all records in the table for update and then my second record set was opened as a select statement and as a static set of data -- then it seemed to work. I posted my new code below. Thanks to both of you for your...