Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.53 seconds.

  1. Thread: Date Difference

    by xenou
    Replies
    8
    Views
    484

    Re: Date Difference

    Example:

    Expr1: Date()-Int([DateField])

    Also:

    Expr2: DateDiff("d",[DateField],Date())
  2. Replies
    3
    Views
    299

    Re: How to Link your Access DB to Sharepoint?

    Not that I know of. It sounds like a bad idea since Access is not for use over http networks.
  3. Replies
    7
    Views
    452

    Re: Access Macro to Show All in Query in Form

    Master and Child are for finding related records only. It cannot be used as part of a generalized search.

    The simplest way to search is to right click in a bound field and use the in-built access...
  4. Replies
    7
    Views
    452

    Re: Access Macro to Show All in Query in Form

    What is the purpose of the combo box? How many names would you expect to be in the combo box when you search for names in the combobox (10 names, 100 names, 100,000 names?)
  5. Replies
    7
    Views
    452

    Re: Access Macro to Show All in Query in Form

    I apologize too but it's not clear what your problem is - I'm guessing English is not your first language. I think you should give an example with some sample values.
  6. Replies
    7
    Views
    452

    Re: Access Macro to Show All in Query in Form

    The combo box record source should not be the same as the bound item (the record that it is bound to).

    For instance, the bound item is one single product for an actual order line, while the...
  7. Replies
    16
    Views
    677

    Re: Updating Linked Tables to Back End Problem

    I think there are two basic reasons for splitting the DB (there are probably more than two!)


    To protect the DATA from corruption (i.e., if forms or reports cause a problem the data tables are...
  8. Re: Access: Design view problem - only showing SQL

    it makes sense since the query designer needs information about the tables to provide field names and data types for the designer.
  9. Replies
    16
    Views
    677

    Re: Updating Linked Tables to Back End Problem

    Have you looked at the links? Are there differences in mapped drives (E:\MyDb.accdb or F:\MyAccdb or \\mynetwork\MyDb.accdb and so on). Is everyone on the same local network?
  10. Replies
    2
    Views
    418

    Re: disable design view in Access

    I've always thought that simplest is to re-save the db as an executable:
    http://www.databasedev.co.uk/convert_to_accde_format.html...
  11. Replies
    3
    Views
    430

    Re: Access: VBA to identify User and rights

    Also I guess you could just change your open event code (not sure why you found this hard):


    Private Sub Form_Open(Cancel As Integer)
    On Error GoTo Error_Handler

    If...
  12. Replies
    3
    Views
    430

    Re: Access: VBA to identify User and rights

    You could just put the formula in the unbound text field and wrap it with IIF:


    =IIF(
    Nz(DLookup("UserName", "tbl_Users", "[Object_Name]='" & Me.Name & "' AND [UserName]='" & CurrentUser() &...
  13. Thread: Date Filters

    by xenou
    Replies
    2
    Views
    514

    Re: Date Filters

    It is generally possible to re-write such a query so that it takes a range you can set at runtime (simplest case: user enters a range such as "startDate" and "endDate"). Generally that would be...
  14. Replies
    3
    Views
    572

    Re: What are Class Modules

    Class modules generally fit into an object oriented paradigm. You might create a class to represent an object that has many different attributes (perhaps something like a "Product" with attributes...
  15. Re: Walkthrough on How to Create a Combo Box with a subform query

    My honest opinion is that the easiest is to use inbuilt filtering features on a bound query. You just right click in the first field and filter on the values you want to filter down to. Now that you...
  16. Re: Setup a List Box to Work with a Subform in Access

    This looks like the same question (or similar enough) so I'll close this one to keep it in one place.

    Related Question:...
  17. Replies
    4
    Views
    1,037

    Re: Access Track Changes to Data

    That is a database with an example of an audit trail (tracking changes). See above the suggestion is that you can "rollback" changes by writing queries to work with the audit table to reverse changes...
  18. Replies
    15
    Views
    1,409

    Re: VBA write data from Excel to Access

    The point about addins vs libraries was just that whether you use late binding or early binding you still have dependencies, so avoiding dependencies isn't a reason to prefer one over the other (with...
  19. Replies
    15
    Views
    1,409

    Re: VBA write data from Excel to Access

    Mr Ice, when you say you are pushing data or writing data to Access like this, how much data are you writing? Is "Data Range" a cell, a few rows, or a few hundred rows, or tens of thousands of rows?
  20. Replies
    15
    Views
    1,409

    Re: VBA write data from Excel to Access

    Just FYI Those are not addins. They are the same libraries that are used with late binding. The only difference is whether the binding is early or late.
  21. Replies
    6
    Views
    790

    Re: Cross Tab Query How to Get Distinct Values

    using my second two step solution described above, first you preprocess the data to get something that works for the crosstab:


    select
    T.[Service Location Name],
    T.[Date Fulfilled...
  22. Replies
    6
    Views
    790

    Re: Cross Tab Query How to Get Distinct Values

    The grouping looks like it won't work that way but it is hard to say because I don't see what is being grouped. However, since you are grouping on fields that aren't in the output it is almost...
  23. Replies
    6
    Views
    790

    Re: Cross Tab Query How to Get Distinct Values

    Sounds like it's not working but it's not entirely clear what your sql is doing. You probably should post the query text (and some sample data if possible).
  24. Re: Append table with another table and user input

    to use a variable to filter results add a where clause:

    Parameters [Enter CustomerID] Long, [Enter Name] Text ( 255 ), [Enter Month] Text ( 255 );
    insert into Table2 (ID, CustomerID, Amount,...
  25. Re: Append table with another table and user input

    The raw sql you need is this:


    insert into Table2 (ID, CustomerID, Amount, [Name])
    select
    Table1.ID,
    123456 as CustomerID,
    Table1.Total as Amount,
    'John' as Name
    from Table1
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4