Search results

Dummy report Hi Lee83... I just implemented something really simple. See if it works for you. Add a field Dummy which is a Yes/No field in the underlying table. You know the underlying query of the report. Save it as a new query called qryDumyReport. In the old as well as new query add the new...

Dummy check Hi fedupwithaccess... I just implemented something really simple. See if it works for you. Add a field Dummy which is a Yes/No field in the underlying table. You know the underlying query of the report. Save it as a new query called qryDumyReport. In the old as well as new query...

Hi Hi Ashik, Could you elaborate a little more. I have searched a lot but don't find anything helpful. Thanks, Sudhir Hinduja

Hi Hi llkhoutx, I'm relatively new to VBA. I know I have to use recordsets and the lockedits property from what you suggested and what I've read on Access help and a couple of others. I just dont know how to go about it. I am thinking on a couple of lines 1. I set the recordset to the form...

Hi Hi Ashik, I'll explain the problem properly. Maybe I need to use recordsets and the lockedits property. I just dont know how to do that in VBA since I have not done too much of coding. I have implemented an editable multi-user database which has no additions/deletions to it. It has a form...

Thanks Hey Ashik, Thanks for that input. But I have not used recordsets to date. I have a table of 40000 records. I made a query to select certain records and a form based on that query for editing. Now multiple users are opening that form, so many of them goto the same record. I want to go...

Hi, I have implemented an editable multi-user database which has no additions/deletions to it. It has a form based off a query.That form has a button NextToDo. On clicking this button, a macro starts which runs a requery as the first step and gotoRecord Next as the second step. Problem is many...

Record locking Hi, Could you explain this with code. I'm trying to implement something similar. I have the query off which a form opens. But when I click the Next To Do button it should goto the next unlocked record since I am only locking the current record. Thanks, Sudhir

Hello, I have 2 tables. 1) Table A, which is a table of all 100,000 users 2) Table B, which is a table of all other users I have a query qryA, which looks for everyone in table A with a certain type of job title. I want to exclude anyone who works for a company that occurs in the table B...

Hello, The general layout is, premCust contains a customer's information, which is tied to premInvoice, which lists all the invoices, which ties to premInvoiceLines, which is all the items in the invoice that the customer ordered. In premInvoiceLines is a field called ExpDate, which indicates...

Hello, I am trying to do a compact and repair on my database but when I do that I find that my database which is on the server is not recognized by the 9 other client machines. My shortcut which uses a workgroup file is on each machine and was working fine until yesterday. Once I perform a...

StrConv() works! Well once again thanks to all those posts.... I got my job done wothout starting a new thread! Thanks,

Hi all, I have created an ExecutiveList table with 2 years of data 2003 and 2004. But about 50% of them are duplicates. So I created 2 Find duplicate queries: 1) SELECT ExecutiveList.Name, ExecutiveList.ExecID, ExecutiveList.Title, ExecutiveList.Company, ExecutiveList.Address1...

Well Pat, I think that I shall not need to fix the auto-numbering problem as they are now planning to carry forward the previous numbers. Thanks for all your advice.

Thanks Thank you, I shall try it out. Pat, I also considered your opinion. I shall get back on the issue. Thanks once again.

Hi all, I have deleted some records to clean up data, so the auto-number has got messed up. Can anyone suggest ways to straighten the issue so that the auto-numbering gets continous again? The field CompID which was autonumbered was the primary key of the table and foreign key of the other...

Deborah, If I do that how do I link each Executive to the new table? Won't the relationship get affected? Colin, I plan to have another field EIN number as the primary key since that is unique. However, I need to merge the two years of data so I shall have to merge one more column of...

Hi guys, I have 2 tables, Companies and Executives. 1 Company has many Executives (Relationship 1 - many) CompID is PK in Company and FK in Executives. ExecID is PK in Executives. I have 2 years of data 2003 and 2004. I need to merge the two years. I want to get rid of auto-numbered...

Hello, I have generated the duplicate Executives from a query using the following code: SELECT [Companies and Executives with Proxy Date Query].[Name], [Companies and Executives with Proxy Date Query].[ExecID], [Companies and Executives with Proxy Date Query].[Title], [Companies and...

Thanks Pat n Newman, Pat I did the same thing.... but it gave an error saying that cannot delete from specified table. I checked with the person who made the tables and he says there's no password protection, so I'm ruling out a permission problem. What's the next step to take? Please...