Recent content by TommyTea

A few years ago, I found a small application containing Access tips. It showed a form with a grid view of tip categories. You could click the record selector (on the left of each record) and a form would open with the information about that subject. Does anyone out there know how this works...

How can I enter use the on click event in order to stamp the contents of a textbox into a field on a subform? The subform is displayed as a continuous form.

This looks great. I'll try it Monday.

Actually, I got this, what I can't seem to figure out is how to take the value of cmd(3) and pass its value to a variable or to change the procedure to a function and apply cmd(3) so that the function returns it. Thanks for the NOCOUNT ON tip.

I am on my first adp. I have a working stored procedure as follows: CREATE procedure "ud_verify_record" ( @employee_id int, @project_id float, @week_id datetime, @records int output ) As select @records = (select count(t.employee_id) from Tracking t where t.employee_id = @employee_id...

My first adp project. I have the following proc: Public Sub TestIt() Dim cnn As New ADODB.Connection Dim cmd As New ADODB.Command Dim p1 As Parameter, p2 As Parameter, p3 As Parameter, p4 As Parameter Set cnn = CurrentProject.Connection Set cmd.ActiveConnection = cnn...

I am writing my first adp and I am trying to figure out the best way to execute a SQL Server stored procedure where the parameters are supplied from combo boxes.

I am considering converting a current access solution using SQL Server as the data server that just uses ODBC attached tables to an Access Project as opposed to converting my table activity to stored procedures and leaving to rest in Access XP. I have heard little about Access Project and...

Does anyone have some code that will read through all of the filenames within a given directory or subdirectory? I need to process (unzip) a large number of files and I need to get the filenames so that I can feed them to winzip. Thanks.

Does anyone have some code handy to compact & repair from vba? I have an app that offers a major import function and I need to be able to offer the non-technical user a Compact & Repair option.

Does anyone out there have any knowledge of reading mp3 tags from within vba code?

Can anyone help with some code examples for running a set of dos commands from within Access (XP). Is this the shell() function? I come up totally blank on Microsoft help.

Does anyone remember the DOS command to send screen output to a file. I thought it was like: c:\ reglog.cmd /switch > log.txt I guess I am getting very old.

Does anyone have code that will read mp3 tags?

Does anyone have any experience in reading the tags on mp3 files? I need to be able to capture the mp3 tags into an access table.