Search results for query: *

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.

I am using Office XP Professional. I am looking for the Packaging Wizard to deploy an app. I am looking at Add-ins, Add-In Manager in a code module and see no reference to the wizard. where can I get it?

Does anyone know of a way to copy the results of a query to clipboard using code? The results I am working with are about 25 rows with 12 columns. I would like to allow the user to choose where he/she would like to paste it (using ctrl V).

Thanks to younguser! I was able to get the rest of the function to work. It's really great to have a tek-tips to come to when you have a problem, even if it's self inflicted.

I am trying to Open a DAO recordset on an attached SQL Server table with an identity field. My code is: Public Function VerifynewRecord() Dim db As DAO.Database Dim rs As DAO.Recordset Dim strSQL As String Set db = CurrentDb() strSQL = "Select review_id from Review_Instance where...

It works! Thank you all so much. What happened? I created this database by importing tables from another database. I checked everything to make sure that everything was the same. Everything except the identity setting on the review_id field. I'm sorry for the bother but am delighted with...