Search:

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

Search: Search took 0.00 seconds.

  1. Personally, I can't think of one. It depends on...

    Personally, I can't think of one. It depends on why you need to change the default, but you may have to go with a custom Import/Export form where you can set the directory you want. It will probably...
  2. Replies
    2
    Views
    710

    Just an idea: Instead of opening a new query...

    Just an idea: Instead of opening a new query instance, why not just work with the form's recordset via the RecordsetClone?
    Regards,
    Kirk
  3. I use a product called Speed Ferret. Couldn't...

    I use a product called Speed Ferret. Couldn't reverse engineer (efficiently) without it. However, the publisher stopped updating it at Access 2003, and I haven't tried it with later Access versions....
  4. Replies
    5
    Views
    5,310

    Joop, I use the following statement to update...

    Joop, I use the following statement to update combo boxes and lists:
    <controlName>.Rowsource = <controlName>.Rowsource
    With the various versions of Access I work with, this is the only reliable...
  5. Replies
    4
    Views
    3,049

    Hi! It sounds like the source data is actually in...

    Hi! It sounds like the source data is actually in a character format rather than number. You could do a conversion from character to number and store the result in the target field. That way, the...
  6. Replies
    19
    Views
    2,733

    Using a query for determining age of listing

    Hi, Jack. Once you have things normalized, it would be relatively simple to keep track of the age of a listing by using a query with a calculated field (let's call it Age) that is the CurrentDate -...
  7. Replies
    19
    Views
    2,733

    Normalization

    Hi, I took a quick look at the mdb you posted and noticed that the data needs to be normalized. You can get some good information by searching for Data Normalization on the Inet. As an example, I am...
  8. Replies
    4
    Views
    2,666

    SQL uses % instead of *

    Hi, Scott. This typically happens when you are querying an SQL table, but you seem to be accessing an MDB. In any case, you might want to try using % for a wildcard.
    Regards,
    Kirk
Results 1 to 8 of 8