Search results for query: *

I have an insert trigger that is working fine. I have a need to export the primary key value that was inserted into the table to a text file. My attempts thus far have resulted in an error. Here is the code: BEGIN DECLARE @MySql varchar(1000) SELECT @MySql = 'osql -Q "SELECT...

I'm sure this will be easy for some of you, but I am pretty new to the trigger/stored procedure world. I have a date field in two tables, and an employee id field in two tables. The dates are associated with a primary key of employee id. I would like to create a trigger (or stored procedure)...

Ok vbscript gurus, this is probably a simple question. This is my first attempt at vbscript. I am querying a database with input from the user, and when the records are returned to the message box, I have a retry button there. If the information that is returned is not what the user is...

The following powershell script works fine.... foreach ($svr in get-content "C:\AllServers.txt") { [System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.SMO') | out-null $serverinstance = new-object ('Microsoft.SqlServer.Management.Smo.Server') $svr foreach ($db in...

Hey gang! I know there is someone here that can help me. I have 10,000+ MS Word Docs. They are all formatted the same - another program creates them. See below: "Commencing at NGS monument "Any High 2" having XXXX Grid Coordinates (NAD 83-2001) X=XXX.XX and X=XXXX; thence from said point...

Hey gang! I know there is someone here that can help me. I have 10,000+ MS Word Docs. They are all formatted the same - another program creates them. See below: "Commencing at NGS monument "Any High 2" having XXXX Grid Coordinates (NAD 83-2001) X=XXX.XX and X=XXXX; thence from said point...

I am way out of my league here, so I am hoping someone can help. I have a Linksys BEFSR41 Router that is connected to the internet and working fine. It is not wireless. I have a Linksys WRT54G v8.2 that I would like to use as an access point for my wireless laptops. I have found a lot of...

Hi all, I am trying to use an ADODB recordset as a rowsource for a combo box. I can loop through the recordset and write the values to a table just fine, but that is not what I need to do. Here is the code: Set cn = New ADODB.Connection Set rs = New ADODB.Recordset cn.Open...

I have a rather large excel spreadsheet that is the schema of a database, no data. There are several tables and hundreds of fields etc. It has the table name, field name, field description, type and null information in different columns. Isn't there a way that I can use this information to...

Can someone explain to me why the following code will only return the user name in the domain? Function ListUsers() Dim MyDomain As Object Dim user As IADsUser Set MyDomain = GetObject("WinNT://" & Environ("USERDOMAIN")) MyDomain.Filter = Array("user") For Each user In MyDomain MsgBox...

ACC 2K using 8i Oracle Client ODBC I am trying to create a form that allows a user to input 2 variables into an access form, click a button and that makes a table. I have not tackled that yet as I cannot get my parameters to work (this is actually the first time that I have had to do this so I...

Gang, I need to be able to extract 2 tables from a secured Access database everynight. I know how to pass a username and password programmatically to launch a secured database, but this is a shade different. First, I have to join a different workgroup, pass username and password, then import...

Hey gang, Is there anyway to loop through the events of a form and determine if an object is in use? For instance, I just inherited a rather large and complicated database that I am trying to clean up. There are a number of macros in the database that I want to get rid of for various reasons...

I am using Access 97 with a secured database. I am using the command line switch /user to clear out the last person that was logged into the database. When a person starts the db, I would like for the cursor to be placed in the username field instead of the password field. Is this possible...

Gang, I have several databases with only one .mdw file. What I would like to do is to log into a 'master' database just once, then be able to open any database from within that master without having to log in to each and every one. Does anyone have any ideas, suggestions or know of any...

Hi, When you are referencing an Access object (form, report) etc. in a code module outside the object you are referencing, I understand that you have to reference it explicitly - reports!rptMyReport etc. What I am wondering is this, can you pass a report name as a variable to this explicit...

Hi, I am using DoCmd.TransferText to create a text file. Instead of posting that file somewhere on a drive, I would like to be able to post it programmatically to an ftp site. Is this possible? Thanks in advance for any assistance. Lee

Hi, I need help bad!! I have the need to be able to print a different number of different labels. Example, Label1 - 2 copies, Label2 - 4 copies, Label3 - 1 copy etc. etc. The attached code loops through the recordset and does just that. It allows the user to start printing labels anywhere on...

Hi gang, I have a button that runs a macro, that in turn runs a function. I assigned permissions to the macro. When a user without permission clicks the button, that UGLY access permission error message pops up - which is good - permission is working. But I want to intercept that message...

Hi gang, Can someone PLEASE point me in the direction of trapping for the "You don't have permission to run the ......" message? Those messages, like others, are not very informative to an end-user and I would love to replace them with custom messages. Any ideas? Thanks in advance...