Recent content by StevePupel

Its hard to tell, but I think the general technique could be better. There's nothing wrong with passing a form reference, I do that all the time. If you create the function like below, you could call the function out of an update query and update all or any subset or records in a table. In...

Put your data in a table with a column for Client ID and column for Call Date and Time, define the key as Client ID + Call Date and Time, then add an auto number field (AutoNumber), and also add a Long Integer called "Next Autonumber". Create an update query and update Next Autonumber to the...

Yes, you can do this in VBA. I'd probably use a Do While loop and build up a new string which will contain everything in the original string with VbCrLf every n characters. Use the mid function. The second argument is the start location, this will vary, with each iteration through the loop...

You can't really append and excel file, do you mean you're importing the excel file and creating a table? It's easy to create a Make Table query and then in the window where you specify the table name you can specify that you want to make it into another database. Then you can view the SQL so...

Yes, easy. Import the data, or even link to it. Then create a query over the table and click on the summary button to make it a summary query. Specify the Column which holds the fruit name as the group by column. Make sure no other columns have group by specified. You can simply remove the...

You can create a text box on the parent form and set the visibility property to false. Then you can store your info in the text box. The VB code within the subform will be able to access the value. There's a number of ways you could reference the control which is storing the value you need...

I wrote a couple functions many years back to solve this exact problem. The basic technique is that there is a first function which breaks up a string into separate words and stores each word as an array element. Then a the code loops through each array element and converts the first letter of...

I'm trying to run some VB code (in an Access module). The code executes for 10 seconds or so, and then Windows XP robs it of any CPU. I've tried (many times) using task manager to set the priority to high or real time, but still MSAccess shows as using only 2 or 3% of cpu. I've got in intel...