Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.06 seconds.

  1. The Before Update event is part of the form...

    The Before Update event is part of the form itself, and should operate whether the form is opened directly or as a subform. There are no events on a subform control (other than Enter/Exit).
  2. Replies
    3
    Views
    150

    The first problem you have is with "WHERE Field1...

    The first problem you have is with "WHERE Field1 = null"; this needs to be "WHERE Field1 Is Null. Any expression such as Field1 = Null equates to Null and not True/False; it doesn't matter what...
  3. I'd keep that "Life Membership" field. I think...

    I'd keep that "Life Membership" field. I think it is an important piece of information. I dislike using artificial entries (like 2525).
  4. Replies
    9
    Views
    258

    Exactly where did you put this Validation Rule?...

    Exactly where did you put this Validation Rule? You could put it in the [meter] field in the table. In a form, you'd put code in the Form's BeforeUpdate event to check for this.
  5. Do you know about conditional formatting? This...

    Do you know about conditional formatting? This can handle your situation without any code.
  6. Replies
    7
    Views
    232

    In addition to what Wendell mentioned, make sure...

    In addition to what Wendell mentioned, make sure you haven't tried to format the field. Also, make sure the detail section "Can Grow" property is True.
  7. Replies
    1
    Views
    131

    Basically you first need a query that returns a...

    Basically you first need a query that returns a single record for each Client and Date, then that is the source for your final query. Something like this:

    SELECT ClientID, Count(EventDate) AS...
  8. Replies
    4
    Views
    430

    I've notice that also, but it is not consistent. ...

    I've notice that also, but it is not consistent. I'm thinking it may having something to do with which mode it was in the last time it was saved.
  9. Your original post said this: (1) Make a query...

    Your original post said this:

    (1) Make a query to generate a list that has one row for each attribute within each memo field, like this.

    Item1, Back, Red
    Item1, Front, Green
    Item2, Back,...
  10. I just looked back at the original post, and...

    I just looked back at the original post, and there was apparently a leading space before each color. So yes, my WHERE clause would have to be adjusted accordingly. All of which assumes, of course,...
  11. David, Thanks for the compliment, and you made a...

    David,
    Thanks for the compliment, and you made a valid point about a skill also being a substring of another skill. However, I think that can be handled. Here is my original SQL and a revised...
  12. I think query #1 can be done with this (you could...

    I think query #1 can be done with this (you could even modify it to append the records to a table for further manipulation):

    SELECT Item, "Back" AS Position, Colour FROM tblItems, tblColours WHERE...
  13. There is a trigger, it is called the Current...

    There is a trigger, it is called the Current event.
  14. Replies
    10
    Views
    659

    I also have no idea why its there! Don't know...

    I also have no idea why its there! Don't know when or where I got the code from, I just copy it from project to project. It works so I don't question it!:)

    Glad it solved your problem.
  15. Replies
    10
    Views
    659

    I used this instead of the .To, and it works just...

    I used this instead of the .To, and it works just fine:
    Set objOutlook = CreateObject("Outlook.Application")

    Set objOutlookMsg = objOutlook.CreateItem(0)
    With...
  16. Check your references. You are likely to find...

    Check your references. You are likely to find one "Missing".
  17. Replies
    13
    Views
    710

    Here's how I do it. I keep a table with the SQL...

    Here's how I do it. I keep a table with the SQL for each query. In the Where clause of each SQL, I stick something like "AND 0=0". For example, your query would have this:

    WHERE...
  18. Replies
    2
    Views
    175

    Or, there is this. Let's suppose your fieldname...

    Or, there is this. Let's suppose your fieldname is "MonthName". You could sort by this expression:

    Month( [MonthName] & " 1")
  19. I don't know what you mean by a "Windows Database...

    I don't know what you mean by a "Windows Database Server" either. I'm guessing they don't understand how Access works. There are 2 separate issues here, where you put the Access backend database,...
  20. Personally, I would have the database on a...

    Personally, I would have the database on a server, and then use Remote DeskTop from each of the remote users to log into that server. This way they would be "local" to the database. Each user would...
  21. Replies
    2
    Views
    313

    Basically the cursor has to be sitting in a text...

    Basically the cursor has to be sitting in a text field that can accept the datastream from the card reader. You'd then then have to the format of the string to do anything with it.
  22. If you populated 1RGC with just the codes you...

    If you populated 1RGC with just the codes you wanted, you don't need a LEFT JOIN, you could have used an INNER JOIN. My suggested use of the LEFT JOIN assume you already had a table with ALL the...
  23. Replies
    1
    Views
    304

    I don't really understand what you are asking. ...

    I don't really understand what you are asking. You might want to include the SQL for your query and give an example of what it is (or is not) doing.
  24. If you don't have one, you need a separate table...

    If you don't have one, you need a separate table that just contains all the codes. You need to create a new query that uses a Left Join to connect this table to your previous query, something like...
  25. Replies
    7
    Views
    400

    I don't know about anyone else, but when you...

    I don't know about anyone else, but when you present a convoluted situation like this (one query is a source for another query which in return is a source for yet another query), it would help me if...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4