Search results for query: *

I have a table with some duplicate records and I would like to convert it into a table with unique records. The table stores employee history in the company. There is one record for each position that an employee held in the company. The records aren't technically duplicate. The office address...

Is there a way to programmatically change a table name in all the stored procedures without having to change it one-by-one? We have a few dozen stored procedures and would like to change reference to particular table. Say table1 to be changed to table2 everywhere. Any ideas? Thanks,

Here is a search query I would like to optimize. The database is de-normalized to store 6 StaffIDs in the Applications table. We need to lookup applicaitons by employee names. Currently it takes a loooong time. SELECT * FROM Applications a LEFT OUTER JOIN Employee e ON m.StaffID = e.StaffID...

I have an update trigger on one of my SQL tables. In the adp client there is a form that is bound to the table. Now since adding the trigger, the form gives me a "Write Conflict" error whenever I try to update any information on the form. If I remove the trigger all works fine. The trigger makes...

I have an access textbox displaying a sql server field (varchar, 8000). My problem is that the form would only show 4000 characters and truncate the rest. It saves all the comments but displays only 4000. Any ideas? Thanks,

I have an access textbox displaying a sql server field (varchar, 8000). My problem is that the form would only show 4000 characters and truncate the rest. It saves all the comments but displays only 4000. Any ideas? Thanks,

I am facing this weired problem which I belive wasn't there before. I am developing an Access Project DB. When I try to add a new record to a form based on multiple tables, I get a "Write Conflict" error: "This record has been changed by another user since you started editing...

I have a calculated field on a Continous Form that I want to do a running sum on. I cannot use DSum because that field is a caluculated one and not a part of any Table in the database. The field calculation is complicated enough to eliminate the use of a SQL query. Any ideas???? Thanks!

I have tried this in many different ways (Thanks to the responses I got from this board)but I keep hitting dead ends. Here is what I want now...... I got three tables: Application, ApplicationDetails and Employees Application Table has ApplicationID & EmployeeID as a composite primary key...

I am developing a database solution using Access Project. My backend DB is in SQL Server. I have questions about securing the DB. I would like to hide all the tables when the user open the DB using Access Project, so that they donot make any design changes. So in the object explorer window I...

I am developing a database solution using Access Project. My backend DB is in SQL Server. I have questions about securing the DB. I would like to hide all the tables when the user open the DB using Access Project, so that they donot make any design changes. So in the object explorer window I...

I am looking for some suggestions to optimize the query below. Currently it takes till eternity to display the output and the users won't like it. The reason is quite obvious: I have used subqueries in loop. There are three tables involved Max, Employee and Departments. Max table has fields...

I am not sure if this is possible: I have one table with LogID as primary key and another table with LogID & EmployeeID as composite primary key. One-to-Many relationship. Table 1 Table 2 LogID LogID ----- ----- EmployeeID ---------- Can I create a...

I have posted this problem before but no one replied. I have already spent many hours figuring this out with no luck. May be I could not explain it to you guys. I will try again: I have to create a mail merge from an Access form. That form is a combination main form/Subform. Main form has a...

Is there any way to Mail Merge subform data? When I export the filtered data on my form/subform only the data from the main form is exported. Any ideas??

When I try to apply a filter to my main form that contains a subform I get this message: "Column prefix 'nameofthesubform' doesnot match with a table name or alias name used in the query" Any ideas on what it means???

Can you use a stored procedure to perform a mail merge in Access Project? I am able to chooose a query as a data source for mail merge in .mdb files but when I use .adp, word only shows the tables but no stored procedures. I donot want to create a temp table evrytime I have to do a mail merge...

I am in the process of converting an Old FileMaker Pro database to Access Poject (Using SQL Server as back end). In Filmaker Pro, to create a mail merge you can do a multiple search for a group of fields on a form or a group of values for the same field on the form. The result can then be...

I am using a filter in one of my forms. The filter criteria comes from a listbox. In the form footer I want the sum of the filtered records to be displayed. Using '=SUM([ColumnName])' results in the SUM of ALL the records and not just the filtered ones which is what I want. And when I switch...

I am creating an application on Access Project (connecting Access interface to a SQL DB). I am trying to pass a report parameter using a form but it doesnt' seem to be working right. Conventional means of passing a query parameter using a form (Forms!FormName!ControlName) doesn't work on...