Recent content by GeoMetry

Is there a way to copy an entire record from one recordset to another? I currently loop thru all the fields and it seems inefficient. I would like to do something like: rs.fields = rt.fields instead of: while intCounter < rs.fields.count rs.fields(intCounter) = rt.fields(intCounter)...

I just wish I could figure out a way to have the basic error handling code inserted each time I create a function or a sub. Access fills in the end sub for me why not the error routine I want?

I am having trouble picturing what you are doing. It seems like you would have two list boxes, one for the product and one for the attributes. After you have made your selections in each listbox then click a button and the code would loop thru all the possible combinations and add records to the...

I generally use an unbound listbox. I set the row source type to value list then I dynamicly create the rowsource for the listbox from a recordset. You could just put a counter on the loop that creates the rowsource and have it stop after 25 rows. If all the data doesn't fit well I show only the...

My users create/edit records with several types of related data for example Points of Contact (POC) so the edit screen has a button that calls a dialog box that allows them to add one or more POCs to the record. What I would like to do is when they click the close button in the dialog box it...

Cells... is this in Access or Excel?

I have a hard enough time getting people to enter the required data. I hate to make them enter stuff that already exists in Outlook (and then keep it up to data in two places) I experimented with a link to the Outlook Global Address List but it seems slow and I guess I would need to code a form...

Use instr() to find the location of the @ or . or - then use mid() to extract the part you want. Use Ucase and Lcase to modify the case as required.

I think I could solve my problem if I could figure out how to share a recordset between two forms (access and manipulate one recordset from two forms) but I will explain what I am trying to do because it is entirely possible that there is a better solution. I have a table (funding) with 16...