Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    18
    Views
    1,511

    If FORMNAME is a text field you need to use...

    If FORMNAME is a text field you need to use
    "[FORNAME] = " & chr(34) & Me!FORENAME & chr(34)))
  2. It seems to me you have 3 ways of tackling this...

    It seems to me you have 3 ways of tackling this
    (1) Use Geek's suggestion to use a query with a join on the common PK and have 100 or conditions a.Field(n)<> b.Field(n) to locate records with...
  3. Replies
    3
    Views
    1,032

    I haven't tried it but how about setting the...

    I haven't tried it but how about setting the height of a hidden rectangle.
  4. Replies
    2
    Views
    645

    Why don't you use the same query for the Word...

    Why don't you use the same query for the Word mail merge as is used to print from Access? If there was a filter being applied to the Access report, set up the same criteria in your Word Mail Merge...
  5. Replies
    1
    Views
    487

    One way might be to position the data...

    One way might be to position the data sequentially. For example, if you had say up to 21 data items to display, put 21 unbound text boxes in the report called txt01 to txt21, in say 3 columns, 7...
  6. Thread: Store input

    by Cronk
    Replies
    7
    Views
    851

    Is the form bound to the table where the data...

    Is the form bound to the table where the data being printed is sourced from? If so then the easiest is to add the field where you want to store your input value and then add to your code after the...
  7. I'm sure it will work. datMaximum =...

    I'm sure it will work.
    datMaximum = DMax("ExDay","qryA")
    After executing this, datMax will contain the maximum value in the field ExDay in the data table or query qryA. Doesn't matter if there is...
  8. Replies
    2
    Views
    2,834

    I can think of a few situations where your...

    I can think of a few situations where your database is opened read only
    1. Your default setting is such.
    2. The database is in a folder which is read only (or a CD) or the folder cannot create the...
  9. Replies
    4
    Views
    785

    Use Date() in the criteria of the recordsource...

    Use Date() in the criteria of the recordsource for the report. Then you don't need to worry about macros or BA.

    As to running the report in the mornings, if you open the database every morning,...
  10. Replies
    12
    Views
    1,140

    Seasons greetings Geek Your intended solution...

    Seasons greetings Geek

    Your intended solution is better because it aims to pick up not only the "X" situation, but any other where there is a Null value.

    I think the issue is in the first part...
  11. There is a problem though catering for leap years...

    There is a problem though catering for leap years with 366 days.

    Your a better man than me with complex IIf statements, but the first part would be
    IIf(DateSerial(Year(pDOB) + 1, Month(pDOB),...
  12. Replies
    5
    Views
    620

    Is the programming that difficult? I would have...

    Is the programming that difficult? I would have thought two loops, one to iterate through each unit of data eg Scott, and one for each day since 1980, each seeking whether data .

    Maybe a huge...
  13. CStr(CLng(Rnd * (2 ^ 31))) is generating a...

    CStr(CLng(Rnd * (2 ^ 31))) is generating a random, and hopefully unique, number which is used as the Key value to the particular instance of the specific report object that you are creating in the...
  14. Thread: Error Handling

    by Cronk
    Replies
    3
    Views
    630

    What defines an "invalid" receipt number? One...

    What defines an "invalid" receipt number? One that does not exist? You could check the existence first (check out DLookup) and if it does not exist, advise the user accordingly.
  15. Replies
    3
    Views
    2,224

    Thanks for the steer. I'll try it and let you...

    Thanks for the steer. I'll try it and let you know the outcome. But it won't be for a couple of weeks because I've just arrived in Surfers Paradise to thaw out.
  16. Replies
    1
    Views
    479

    Look up Access help on DAvg and use the criteria...

    Look up Access help on DAvg and use the criteria "FieldName Not Is Null"
  17. Replies
    22
    Views
    4,759

    I think the original post indicated there was...

    I think the original post indicated there was only one table.

    What the user wants to do is disply one record but not including a memo field in one form on the left hand screen, and the memo field...
  18. Replies
    3
    Views
    2,224

    Problem displaying images in Access 2007

    Iím hoping someone can help throw some light on a problem I have displaying images in an Access 2007 form.

    The images (jpg files) are not stored in the database, only the full file name.

    The...
  19. And don't use padding. Use vbCrLf to start the...

    And don't use padding. Use vbCrLf to start the next comment on a new line. Or two of them to have a separator line.
  20. Thread: Last Working Day

    by Cronk
    Replies
    1
    Views
    538

    What is supposed to happen on Tuesday if the day...

    What is supposed to happen on Tuesday if the day before was a public holiday? If you want to cater for non work weekdays, you will need a lookup table of public holidays and the exercise is not a...
  21. Replies
    12
    Views
    3,042

    Can you delete a record manually to check there...

    Can you delete a record manually to check there is no locking in place?
  22. Replies
    6
    Views
    4,421

    Alternatively Dim db as database Set db...

    Alternatively

    Dim db as database
    Set db = DBEngine(0).OpenDatabase("C:\Path\YourBackend.mdb")
    Debug.Print db.TableDefs("tblYourTable").DateCreated
  23. Replies
    5
    Views
    1,305

    Why not use a query with criteria Between...

    Why not use a query with criteria
    Between Date()+1 AND DateSerial(Year(Date()), Month(Date())+2,0)
  24. Replies
    0
    Views
    534

    Report margins - cannot change

    I have encountered weird behaviour with several reports I created where I cannot save changes in the bottom and right margins from 171 and 208 mm.

    The reports were using Access 2003 in a...
  25. Replies
    10
    Views
    5,266

    The Split function will generate a string array,...

    The Split function will generate a string array, and in this case with email addresses, the first item will be the user name and the second the "domain" name.

    Looking at the comment next to the...
Results 1 to 25 of 43
Page 1 of 2 1 2