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 Rhinorhino 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. zandsc1

    On returning to form move to specific row in its subform

    Well that's not a particularly good sign that different versions of Access are behaving differently. Usually a good indicator that the problem may be harder to sleuth than you would like. Is there any sort of timer event or 'On Got Focus' event for the subform or the main form that houses...
  2. zandsc1

    Connect two queries

    ...AS EMP_ID, dbo_TIME_T.TIME_F_DIV_NUM AS DIVISION, Sum(dbo_TIME_T.TIME_F_AMOUNT) AS EARNED, Sum(dbo_TIME_T.TIME_F_AMOUNT)*0.04 AS VACPAY FROM dbo_TIME_T WHERE Year(TIME_F_PAY_PERIOD)=[ENTER YEAR:] AND dbo_TIME_T.TIME_F_DIV_NUM = 2 AND dbo_TIME_T.TIME_F_PAY_CODE < 499 AND...
  3. zandsc1

    Connect two queries

    ...AS EMP_ID, dbo_TIME_T.TIME_F_DIV_NUM AS DIVISION, Sum(dbo_TIME_T.TIME_F_AMOUNT) AS EARNED, Sum(dbo_TIME_T.TIME_F_AMOUNT)*0.04 AS VACPAY FROM dbo_TIME_T WHERE Left(TIME_F_PAY_PERIOD,4)=[ENTER YEAR:] AND dbo_TIME_T.TIME_F_DIV_NUM = 2 AND dbo_TIME_T.TIME_F_PAY_CODE < 499...
  4. zandsc1

    Connect two queries

    Hmmm I know that Access is a bit more limited than SQL databases in terms of join capabilities but it should be able to do a simple left join like this. Your two tables have proprietary data in them so I won't ask you to post them, but can you give the SQL definitions or screen captures of them...
  5. zandsc1

    Connect two queries

    ...= m.TIME_F_EMP_NUM, (SELECT dbo_TIME_T.TIME_F_EMP_NUM AS EMP_ID, Sum(dbo_TIME_T.TIME_F_AMOUNT) AS EARNED, Sum(dbo_TIME_T.TIME_F_AMOUNT)*0.04 AS VACPAY, FROM dbo_TIME_T WHERE Left(TIME_F_PAY_PERIOD,4)=[ENTER YEAR:] AND dbo_TIME_T.TIME_F_DIV_NUM = 2 AND...
  6. zandsc1

    Incremental Load (No primary key)

    Is there a really good reason why you don't have a primary key on either the source or the destination? Seems like a longshot but if you can't have a key in the source or the destination for some reason, it might be helpful to add them with SQL (temporarily), load up the destination, and then...
  7. zandsc1

    Need File Code and Search Code Updated.

    Chr(13) is to use ASCII to reference the carriage return character. I think if you define CR as a string you'll resolve that issue. Opening and searching through excel is not as easy a fix, unfortunately. Excel has it's own class now with it's own set of commands which is a nice improvement...
  8. zandsc1

    how to make field value start with area code

    you should be able to do this very easily in the query builder. Right click on the phone number field and click 'Build...' and in the box that comes up put in '716-' & [phonenumber] where [phonenumber] is replaced by the name of your field containing the customer's phone number...
  9. zandsc1

    Can't create ODBC link to SQL 2016

    I've got a similar setup but I'm using ODBC to connect to Postgres. We had to go through and configure the System DSN on each workstation when we started using ODBC so I suspect that will yield results for you if you are installing drivers and confirming the connection. I had played a bit...
  10. zandsc1

    Need File Code and Search Code Updated.

    Well that's a good sized module to wade through looking for errors... So is this the actual line that's throwing the error: Call dmerge(WordDoc, MergeQuery, SaveFolder) Or is it somewhere within the dmerge function that you posted? If it's the actual 'Call dmerge...' line that's giving an...
  11. zandsc1

    Combo Finder does not find record after Not In List procedure

    Are you requerying the recordset driving the combo box and form after you add the new customer to the table? If your combo box "Limit to List" field is set to false (which it usually is by default) the it will let you put whatever you want in there even if it isn't necessarily in the dataset...
  12. zandsc1

    On returning to form move to specific row in its subform

    Are you closing the orders by customer form when you launch the order details form? Try tracking the orders by customer subform and seeing what event is causing it to revert back to the top row (i.e. when you launch the order details form, when you close it, when it gets focus, etc).
  13. zandsc1

    ListView - Refilling and Selecting

    I found a solution and I wanted to follow up and post it. First, I'm confirming that there is something selected in the listview and then storing that information: Dim mySelection as integer If Me.lsxPriorityList.SelectedItem Is Nothing Then mySelection = 0 Else mySelection =...
  14. zandsc1

    Need File Code and Search Code Updated.

    First, let's clean up the code a little and make it readable: With Application.FileSearch .NewSearch .LookIn = pubPermitDocFolder 'a constant in GenMods module .SearchSubFolders = False .FileName = finddoc .MatchTextExactly = True .FileType = msoFileTypeWordDocuments If .Execute() > 0...
  15. zandsc1

    ListView - Refilling and Selecting

    I've read through the FAQ guides here and I'm trying to figure out a solution to what seems like it should be a simple problem. The users are looking at a priority list of jobs stored in a listview. I'm using a listview instead of a listbox because I want to be able to format each row based on...
  16. zandsc1

    Make primary key values depend on external variable

    Have you considered making a sequence and using it as the key for both tables? CREATE SEQUENCE sequence_name(... sequence parameters ...) CREATE TABLE table1name(table1_id PRIMARY KEY DEFAULT nextval("sequence_name"), ...) CREATE TABLE table2name(table2_id PRIMARY KEY DEFAULT...
  17. zandsc1

    Unique Constraint on Pair of Fields (with boolean)

    philhege - thanks for the suggestion. I think you may be right. Off to do some research on triggers. Thargy - this would hold true given your assumption, but I'm afraid the assumption doesn't work in our case. There are instances where a new revision of a part is created, but not released...
  18. zandsc1

    Database Schema for Document Revision

    Ah very interesting denimined. That does solve some issues. I may be able to simplify further and just reference the CRID in the CL table, since that CRID has a FK pointing to the CID, and the CRID for a given lot should never change (once the lot number is created for a specific rev of a...
  19. zandsc1

    Unique Constraint on Pair of Fields (with boolean)

    Looking for something that's similar to a unique constraint. The scenario is that I have a table with part numbers and revisions in it. In order to maintain change history, the old revision of the part number stays in the table when the new revision is released. Now say I wanted to create a...
  20. zandsc1

    Database Schema for Document Revision

    I have a schema that I'm trying to normalize: Component(component_id, component_number, component_revision,...) Component_lot(component_lot_id, component_lot_number, component_number, component_revision,...) Component_supplier(component_supplier_id, component_supplier_name, component_number)...

Part and Inventory Search

Back
Top