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. Stangleboy

    True Count of Records in Subform

    Perfect, I didn't think about doing the work on the subform and then displaying it on the main form!!! Thank you!
  2. Stangleboy

    True Count of Records in Subform

    I have been through several posts on the site searching for a code to count the number of records in a SubForm and display in a field on the main form. There are several posts but they are parts and pieces of bigger code. I wrote a simple piece of code on the display field on "Got Focus", but...
  3. Stangleboy

    Using the TransferText Command

    So in the direction above using the SpecificationName; I would have to change my query to a "Make Table" to make a temporary table then run the "Export" wizard from the temp table and save the wizard. Then use the code above pointing to the name I gave the wizard and add more code to delete the...
  4. Stangleboy

    Using the TransferText Command

    I am not familiar where to use that, is that in the original code or a new line in the code? thank you!
  5. Stangleboy

    Using the TransferText Command

    I have been searching posts and FAQ but have not found any solution to an issue I have using the TransferText command in VBA. My code works but the resulting text file I produce has qoutes ("") at the beginning and end of each record. Can I strip or delete the quotes in VBA code prior to it...
  6. Stangleboy

    Grouping from Field Data

    I decided to go with an If statement, thank you both for your time and help, I couldn't get the last character of the employee right without your feedback and answers!!! Code Used: Private Sub EmpNumber_LostFocus() If Right((EmpNumber), 1) = 0 Then EmpGroup = "3" ElseIf Right((EmpNumber)...
  7. Stangleboy

    Grouping from Field Data

    Oops, missed the cross thread traingamer; I used to use Select Case when I needed to group but it is not working. What am I missing here? Private Sub EmpNumber_LostFocus() Select Case EmpNumber Case Right((EmpNumber), 1) = 0 EmpGroup = "3" Case Right((EmpNumber), 1) = 7 To 9...
  8. Stangleboy

    Grouping from Field Data

    Thank you for your fast replies: Traingamer- when I add the code into a query it places quotes around the field name and I get an error, I switched it to brackets around the field name and get no results. Also where would a '0' fit in group 3? Also every time a new employee gets added do I...
  9. Stangleboy

    Grouping from Field Data

    I have been out of the VBA scene for a long time and this seems easy but I have been searching the FAQ and other posts since 8:00 am and have not found code that can help me. Any help would be appreciated. I want to populate a field in a table from the data entered into another field in the...
  10. Stangleboy

    Code to Remove Duplicates with a Button Control

    These are great answers I will try them all to see which ones works with the flow, thank you all for your time.
  11. Stangleboy

    Code to Remove Duplicates with a Button Control

    Great suggestion, and I tired that but then the job fails and if they were adding a group of 50 employees through InfoPath or Access control, and there was only one duplicate, then none of the employees get added.
  12. Stangleboy

    Code to Remove Duplicates with a Button Control

    Alright this is going to be a little difficult and I do not know where to start and what forums to use (VBA, Access Forms or SQL) but I believe the answer lies in VBA coding so I am posting on this forum. I have an Access database with a SQL back-end for training function. I had the system...
  13. Stangleboy

    Run Different Months

    Will do, give me a few I will let you know the results, thank you.
  14. Stangleboy

    Run Different Months

    I belive this will still require me to run three separate times for each month when I want it to run one time and give me the results for each month. Maybe a temporary table for each month inside the main query?
  15. Stangleboy

    Run Different Months

    I am trying to get the same data retrieved for different months, but not sure how to code it. It works fine for 1 month (May in this case) but I need to know if the person made a payment in full for each month for April and June also in one query. Thank you for your time and patience: SELECT...
  16. Stangleboy

    Copy Selected Records from Another Server/Database Error

    It looks like it connects using the link server Stored procedure, I get: Command(s) completed successfully. Then I ran this code from my machine with the 'DataRep' code from a different query tab: DECLARE @myname varchar(200) IF @@SERVERNAME = 'BURMA' BEGIN USE DataRep...
  17. Stangleboy

    Copy Selected Records from Another Server/Database Error

    OLE DB provider "SQLNCLI10" for linked server "Burma" returned message "Invalid authorization specification". Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "SQLNCLI10" for linked server "Burma" reported an error. Authentication failed. Msg 7303, Level 16, State 1, Line 1 Cannot...
  18. Stangleboy

    Copy Selected Records from Another Server/Database Error

    On my box (DataRep)- error: Msg 102, Level 15, State 1, Procedure sp_addlinkedserver, Line 70 Incorrect syntax near '%'. On the host server (Burma- AH1PD01)- error: Msg 208, Level 16, State 6, Procedure sp_addlinkedserver, Line 53 Invalid object name 'sys.sp_addlinkedserver'.
  19. Stangleboy

    Copy Selected Records from Another Server/Database Error

    Yes, but the data I need to retrieve is not in that database (DataRep) it is in Burma (AH1PD01). Can I run the query from the database I want the data to populate (DataRep) and have the query portion point to the host(Burma)?
  20. Stangleboy

    Copy Selected Records from Another Server/Database Error

    Burma

Part and Inventory Search

Back
Top