Search results for query: *

Hopefully, this message is in the correct forums. I have pondered over this for 2 days now and cannot find a resolution. I have a oracle stored procedure which I am pulling into a ADODB recordset. I then create a pivot table based on the recordset. This all works fine. If however, I apply a...

Can someone tell me if I can accomplish the following? I have a Access 2000 database which has very tight network permissions on it. I want to create a replica of it where everyone has full read/write access. The problem is I don't know much about replication. I want to be able to do...

I have a ASP form that writes to a Access database. On another machine, I have the database open at a form in datasheet view. By setting a timer to do a requery on the form, I can see when new records are enetered. However, I want to do a sequence of events when this happens but I can't which...

Is there anyway I can trigger an event whenever a record is added to a Access table?. All I want is a msgbox that says a new record has been entered.

Does anyone know how I can open a table view and prevent users from entering information in a column. I did initially place the tables on a SQL server and do a column lock but although, in pricipal, it works. It's not user friendly. What I want is some people to be able to edit the entire table...

Hope you can help here people. We have recently upgraded all out workstations from Access 97 to Access 2000. The problem we are now experiencing, on most of the databases is that the find function doesn't work. In some cases, we click on find and the dialog box appears but the "Look in"...

I have a really annoying problem here. I have a form which is bound to a query. All works fine when navigating through the records but I also have a button on the form which opens another form and does a lookup. The problem I have is when the second form is closed down, the original form goes...

I have a variable assigned in a global function. The purpose of this is for when a user selects a company from a drop down list, it then runs a query and filters on the company selected. The reason I am using a variable is that I have also added the option of listing "All companies". However...

Can anyone tell me how I display the number of records retrieved from a query on a form. I am trying to display "Record 1 of xxx ". I know I can use the currentrecord property to display the current record, but is there a property for the number of records. I have the navigation buttons turned...

When I try to do a disaster recovery on a completely clean machine, the above error is what I get. I have tried all the technotes on running IDR but I can't find anything relating to this error. Does anyone have any suggestions. I am running BE version 9.0 and yes, I do have the DS.NLM that it...

I have created a directory on a NT workstation which if for temperature logging. I want the hardware that is attached to the machine to be able to write files to this directory with the current user logged but I don't want the user to be able to delete them. I have set up the file permissions to...

I have a lot of linked tables in Access which all hold the same data types. The problem I have is that in one of the fields, instead of seeing what I see in SQl Server, I see "#S_C_H#". If I open the a form that is linked to the table, I see the actual information without any problem...

I have a SQL database that uses over 50 tables. In a majority of these tables, the fields are identical. Only the information in the tables is different (these are required for different sites) Anyway, can someone tell me how to do 2 things. 1). I need to copy a copy and paste a table into the...

Can soemone tell me why this is happening? I have a module in MS Access which makes a connection to a SQL server. I am using ADO for this and I am prompting the user to enter a username and password. This works fine as I can then query the tables on the server. The problem arises when I try to...

I have a series of linked tables in MS Access 97. I am using a local DSN to connect to the SQL Server. The problem is that although I have about 40 tables, I want to restrict access in the front end (MS Access) How can I prompt a user for thier SQL Server credentials everytime they open the...

Can someone tell me how I can achieve the following. I have approx 40 SQL server tables linked into an access database which open automatically. What I want is when the access database is opened, it prompts the user to enter a username / password to authenticate to the SQL Server so that I can...

I have a VB front end which takes a username and password and use it to shell to the Access MDB file which had the security MDW file in the shell statement. However, I have now migrated all the tables to SQL Server and I want to be able to shell MS Access and open the database passing the SQl...

Can someone tell me why when I use the find records function from a form, if I tell it find something in a particular field, the find function will not find records that have the particular field disabled. How can I overcome this. I do not want to enable the field as they are set that way...

I have just created a database with over 2000 records imported from a text file. Now, the problem I have is that one of the fields is a web address (therefore, I want it to be a hyperlink). I have set the format for the field to Hyperlink and yes..it gives me the lovley underlined blue colour...

Can someone tell why I have quite a large chunk of code which does mostly what I want except that I want to set the warnings (DoCmd.SetWarnings=False) to false before a line of code runs and I get the error "Argument not optional". If however, I create a macro that says...