Search:

Type: Posts; User: Kreszch68; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    3
    Views
    1,687

    Re: Using ListObjects and ADODB

    Hi Rory, thanks for the reply. I thought the memory leak issue was resolved from Excel 2007 and beyond. Anyhow, it doesn't seem to be a problem at all as I can query limitless without having the...
  2. Replies
    3
    Views
    1,687

    Using ListObjects and ADODB

    Hi there,
    Iím working on a project, and although my advice was to use a database instead, the management insisted it has to be build in Excel (please donít let me explain why :rolleyes:).
    So, I...
  3. Thread: not exist

    by Kreszch68
    Replies
    2
    Views
    631

    Re: not exist

    SELECT Table1.id_A
    FROM Table1 LEFT JOIN Table2 ON Table1.id_A = Table2.id_B
    WHERE Table2.id_B Is Null
  4. Re: Creating a sequential inquiry number (not Autonumber)

    This is how I would do this.
    Basics, having a table (tInquiry) with fields InquiryID (long) and InquiryNumb (string).

    Field InquiryID is just for doing the math, so it could be a hidden field on...
  5. Re: Is there a way to carry balances forward in access

    What exactly do you mean by the months being grouped together? What you should have, is the months being set as a group, with a group footer for the totals of each month. If you do this, I'm quitte...
  6. Re: Run a query with values taken from a form

    I made an example database instead of trying to explain by typing a lot of text. Goto this link and then select the TableReplicator file.

    The code behind all this


    Option Compare Database...
  7. Replies
    12
    Views
    438

    Re: Change cell coulor with a single click

    Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    Const vGreen As Variant = 43
    Const vOrange As Variant = 44
    Const vRed As Variant = 3

    Select Case...
  8. Replies
    12
    Views
    438

    Re: Change cell coulor with a single click

    To avoid users ending up with a complete green sheet, better use the before double click event, and make it reversible.


    Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As...
  9. Re: Is there a way to carry balances forward in access

    Sometimes things aren't that complicated as they seem to be. What you need is a running total, which is a standard feature in de Access reporting tool. The only thing you need to do is set the...
  10. Re: Importing text file into access with condition

    Depending on if the txt file is well structured, but assuming it is, you can link the file to your database. Then use the linked file in an append query, with the right conditions, to transfer data...
  11. Re: How to use data from Excel file for criteria in an Access selection query?

    First link the Excel file to your database, then in a query join the vendor ID to the corresponding field in the Access table.
  12. Replies
    6
    Views
    714

    Re: Query with lookup from second table

    And there is option 3.

    Select Field1, Field2, (Select Description From TableB Where ID = Mid(TableA.Field1,2,3) & TableA.Field2) As Description from TableA
  13. Replies
    3
    Views
    723

    Re: Changing a subforms record source

    Are you sure the event is triggered correctly? Normally you place option buttons within a frame, and use the after update event of the frame to do something with the choosen option value.
    Try to...
  14. Re: Update form fields from a table with a command button

    I worked out an example for you.
    Created a form with two text boxes, GPSLongitude and GPSLatitude and a commandbutton 'cmd_GetNearestLocations'. On the form I placed a subform, frmNearestLocations...
  15. Re: Update form fields from a table with a command button

    You can approach this in two ways, find the nearest location by selecting the records that have the smallest absolute difference between current lat/lon and lat/lon from the reference table, or...
  16. Re: I nid to create a username for user and admin that have different previledges

    Actually I created a database doing just what you're asking for. You can download it from my livedrive portal.
    To implent it into your database, import ALL tables, forms, queries and modules...
  17. Replies
    4
    Views
    958

    Re: Query with IIF and Null values

    Supposing you have the EmpID on your form, and having set Q_AssetPossession as the recordsource for your form, you better use the next approach.
    To make it work you'll have to strip all criteria...
  18. Replies
    5
    Views
    766

    Re: Is null or other values

    Just another thought. To avoid endless if not/or/and/else constructions in the expression of the criteria, just go a step further and dynamically built up the SQL statement you use for the form (or...
  19. Replies
    8
    Views
    2,111

    Re: Access Query Two-to-One field match

    I couldn't resist, this is another approach:


    SELECT CompanyName, ContactName, 'Yes' As Primary FROM Company INNER JOIN Contact ON Company.PrimaryContactID = Contact.ContactID
    UNION
    SELECT...
  20. Replies
    8
    Views
    2,111

    Re: Access Query Two-to-One field match

    You're partially right. There is actually no inner query (as in: correlated or synchronized) in the SQL, only a join from the left table on the two aliases of the right table. However, in the SQL...
  21. Replies
    8
    Views
    2,111

    Re: Access Query Two-to-One field match

    I agree the company table is not set up in the most efficient way, but I don't think it's that hard to query this one.

    The easy way is: Go to the query designer, drag the company table into the...
  22. Re: Access VBA : Display output Data below button in Access form

    I don't think anyone in the world understands what you're asking for. Could you please describe what you're after?</SPAN></SPAN>
  23. Re: Show the three newest records in a multiple records form

    As I don't have any information regarding your database, I can only give you a general description.

    For the example we use a fictive table, named StockItems having the fields (ID, StockNumber,...
  24. Re: Show the three newest records in a multiple records form

    You can if you have something to identify the newest records. This could be either the unique ID if it's a counter, or a creation date field.

    Say you have a table X having a counter field named...
  25. Replies
    5
    Views
    985

    Re: Export Reports to pdf

    Ok, you could also use, Select DISTINCT qryInvoice.CustomerID FROM qryInvoice.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4