Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. chtullu

    Report Crashes Access 97

    I've also encountered the same problem when using Access 97. I researched it and could find no answer. As the old parrish priest said when asked questions to which there were no clear answers "It's a Mystery
  2. chtullu

    Very Slow Query

    Hello, It does what you say it does. I agree but I need only to extract the unique values of group id. For example if group Id 5 appears twice I need to see the 5 once. At any rate, I fiqured out a solution using a temp table that hold only unique occurances of group ids that are displayed in...
  3. chtullu

    Very Slow Query

    Hello again, Basically I need to extract the groups ids of dataset tthat have duplicates in them. The problem is that the query execution is running very slow. Now what is the exact purpose of the following section of code ORDER BY 1,2,3,4,5,6,7,8,9,10 Is it used to set the order of columns...
  4. chtullu

    Very Slow Query

    Hi thanks, But your solution isn't what I was looking for. Thanks anyway. Juan
  5. chtullu

    Very Slow Query

    Unfortunately, the users are using Access 97
  6. chtullu

    Very Slow Query

    Hello, I tried it but I'm getting a syntax error in the second select clause,
  7. chtullu

    Very Slow Query

    ...As Tmp GROUP BY [Location],[Drawer #],[Date],[Type of Payment],[Stated],[Verified],[Over/Short],[Deposit Number],[Unique Identifier] HAVING Count(*)>1 And [Drawer #] = [tblCurrentOptical].[Drawer #] And [Date] = [tblCurrentOptical].[Date] And [Type of Payment] = [tblCurrentOptical].[Type of...
  8. chtullu

    How to identify last duplicate row in a set

    Hi, I've already tried that however, it looks like I found the solution For intRowCount = 1 To intTotalRows If (Cells(intRowCount, 10).Value = "Duplicate") Then If Cells(intRowCount + 1, 10).Value = "Ok" Then x = x + 1 Cells(intRowCount + 1...
  9. chtullu

    How to identify last duplicate row in a set

    Hello everyone, I need to identify the last row of each duplicate set that exists in a spreadsheet. The other duplicates of the set will be sent to a worksheet called Duplicate while the last duplicate of the set is retained. However, the use wants to be able to identify which rows in the...
  10. chtullu

    Need Help deleting duplicate records

    Hello, I had the some problem and I executed the following make table query SELECT DISTINCT * INTO temTable FROM tblImportedBrinks tblImportedBrinks is the table with duplicate rows and I populated the temp table with only unique rows. I then deleted all the records from tblImportedBrinks...
  11. chtullu

    Linked Subforms

    Hello, Thanks for the info. It worked perfectly. In fact, I did try to use the same approach earlier but was unsuccesful. As I implemented your solution I noted that the subforms were not properly named and had taken their name from the underlying table or query. I should have caught that...
  12. chtullu

    Linked Subforms

    ...current event I've entered hichRecord = Me.Database_ID 'MsgBox "The following record has been selected " & WhichRecord MYRECORDSOURCE = "Select * From tblUnMatchedBrinks Where [Database Id]= " & WhichRecord & ";" 'Forms.frmMMRecon.subfrmUnmatchedBrinks1.Form.RecordSource = MYRECORDSOURCE...
  13. chtullu

    Multiple Excel Data Forms

    Thanks to everyone for their help.
  14. chtullu

    Multiple Excel Data Forms

    You know I was just thinking. Why not keep it in Access. I could create two subform for each of the unmatched table and have each one display in datasheet view. Now the fields will all be visible at the same time - I could create a view details function that would display a subform form in...
  15. chtullu

    Multiple Excel Data Forms

    Thanks for your response. Actually, I should have gone into more detail. These excel sheets are popuplated by an access application that I created. This application compares two tables - tblCadence, tblBrinks. Each table has several fields that correspond to fields in the other table, though...
  16. chtullu

    Multiple Excel Data Forms

    Hello everyone, Here's the setup. Users in my department have to reconcile the currency amounts in two different worksheets. In order to do this, they start Excel, then open both Excel files. They then arrange each worksheet, one above the other via Windows -> Arrange -> Horizontal. They...
  17. chtullu

    Export Access Backend table to other database

    Hello, I'm currently using Access 97, which I should have mentioned. The table needs to be exported to another database where it will be scanned. Linking doesn't work because the source databases are secured and part of workgroups. When the linked table is exported, the permission structure...
  18. chtullu

    Export Access Backend table to other database

    Hello, I'm currently using a split database and I want to be able to permit a user to export a table from the backend to another database via a command button on the front end. When I execute the following code from the front end only the link to the table is exported. I want to be able to...
  19. chtullu

    Calculated value is Twice Expected value

    Thanks dhookom, Your suggestion worked fine. Thank you also RoyVidar. I do have a question about the code solution although I decided to go with the former suggestion. I put the code into the location footer and then put Me.Total_Amount = dblDailyTotal in the date footer I kept getting the...
  20. chtullu

    Calculated value is Twice Expected value

    Hello, I need to create a report where in addition to daily grandtotals, I have to output daily grand totals for all locations that are "Health Connect". When running the report, I find that while my daily grandtotals for the entire day are correct, my daily Health Connect grandtotals are...

Part and Inventory Search

Back
Top