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.

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.

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

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

I am trying to insert a record into a sql server table with an identity field as it's key. I am using an ms access pass-through. My table looks like: review_id int 4 0 <-- identity reviewer int 4 0 reviewed int 4 0 role_id int 4 0 project_id int 4 0 Reviewer_id nvarchar24 1 my...

I need to create a view in my database that uses a table in another database and on a different server.

I have a form (set as continuous) with a query as the recordsource. The query brings up about 20 questions as records and allows the user to input the answers. Some answers are numeric and I have a numeric field in the underlying table that is displayed on the form as check boxes in a frame...

I have a form with a query as the recordsource. The query brings up about 20 questions as records and allows the user to input the answers. Some answers are numeric and I have a numeric field in the underlying table that is displayed on the form as check boxes in a frame. Some questions have...

Hello. I need to sort data displayed on a sub-form by running code from a command button on the main form. I tried forms(&quot;frmMain.form.frmSubForm&quot;).OrderBy = fieldname and every permutation that I could think of. Any wisdom out there? Thanks.