Search results for query: *

Is there any way that an automatic insert can be aborted from the Before Insert Event. I have a situation where records are being inserted into a status table automatically. As part of the before insert I am checking to make sure the effective date of the transaction falls within a prescribed...

Hi folks. I honestly wasn't sure which forum to put this question in. Has anyone else run into this problem. Two days ago, while adding a couple of new fields to a form, my application started exhibiting real performance issues. These fields were basically a check box and a text field that...

I have an Access application that accesses a SQL Server backend. The application is adding a record to the Customer table. Customer table has a Primary Key of CustID which is also an Identity (auto number) field. When a new record is added to the table Customer I need to be able to identify the...

Here is a strange one. I have an Access 2000 database that is linked to tables in a SQL Server backend via ODBC connections. There are about 35 links to SQL Server tables. One of these tables is a Customer table. I can add new records to the Customer table but if I try to update any fields on...

I have run across a situation in DTS that is extremely frustrating. The package should be a simple one but there is an error which is holding me up. I have an Excel file that I need to import into a SQL Server table. The Excel file is located on my C:\ drive. The database "123" is on server...

Is there a function available to determine the last day of a given month? I've been searching and come up with nothing. TIA Greenfella

I was hoping to generate Random numbers within Access VBA but was unsure of how to go about this. The RND() function does not do the trick. Nor did the RANDOMBETWEEN function. Any light that can be shed would be greatly appreciated. Thanks Greenfella

Is there any way that I can capture a data model showing the relationships between all the tables in SQL Server? Or would I have to create the data model manually? TIA

Hi. Really hope someone here can help. I have been struggling with a problem whereby I can delete any number of .txt files from a folder once those files are beyond a certain number of days old. The code that I have tried using so far is this: Dim I As Integer Dim oFSO As...

Howdy. I have a situation where information being entered into a database via an Access form needs to be copied any number of times. The customer information resides in three seperate tables. A user selected number will dictate the number of copies that are required. The customer table is the...

Hi I am attempting to disable certain menubar items depending upon the security level of a user. However, I am having problems referencing the menubar item to disable them. I have been able to do this to the main menubar but have not been able to do so to sub menu bar items. Not to sure if I...

Howdy. I am trying to write an application that uses as custom menu bar. What I need to be able to do is write code that will allow a particular multi use form to know which of two options was selected from the custom menu to bring it there. This form can also be arrived at from one of two...

Howdy. Is there anyway to execute a popular Zip program (WinZip or PKZip) from within Access 97 and then intiate an FTP session to send the zipped file to a specific FTP site. TIA Greenfella

I am attempting to automate copying a shortcut onto a person's desktop when they sign on to a Windows NT workstation and run a batch file. However, since I do not have Admin authority I cannot copy the shortcut to the Winnt\Profiles\All Users\Desktop folder. I need to copy it to the...

I am having a real mental cramp today. How do you pad a numeric value in a Text field with leading zeros? I know I'm going to kick myself when someone tells me the answer. Thanks in advance. Greenfella

Is there any way using VBA to check to see if the data on the current record of a form has been edited? I want to be able to invoke an edit checking routine for a current record only if it is a newly added record, or if any of the data on the record has been added. Otherwise, I want to skip...

Is there anyway to turn the default Menu Bar off in an Access application? More screen real estate is required for an app and I would like to be able to free some up by turning off the Menu Bar. TIA. GreenFella.

I am currently working with a delete query and two joined tables. I wish to delete all records that fit criteria made up of one field from each table. I only want to delete the records from one table. This is the SQL which I am using to do this... DELETE Claim.* FROM Claim INNER JOIN...

I am currently working with a delete query and two joined tables. I wish to delete all records that fit criteria made up of one field from each table. I only want to delete the records from one table. This is the SQL which I am using to do this... DELETE Claim.* FROM Claim INNER JOIN...

I am having a locking problem with an Access application that is acting as a front end to a SQL database. I want to compact the application since it has grown to arount 750MB and should really be around 16MB. However, the application is showing as being locked. About 15 - 20 users share this...