Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    2
    Views
    429

    Re: Combo Box troubles (Access 2003)

    You don't have to point your combobox at a table/query to collect the options. The wizard allows you so simply type in the options you want & for you this would seem ideal!

    Best of Luck

    Ian
  2. Replies
    3
    Views
    304

    Re: Filter On (Access 2000)

    I suppose a criteria of

    nz([Size],0)<1

    (assuming size is integer) would catch both null & 0
  3. Re: DatePart('m',[dtDateChanged]) (Access 2003)

    Good question! The expression looks right so it must be the data in [dtDateChanged]. Try it on another date field.
  4. Replies
    10
    Views
    480

    Re: Method of programing (2000/2002)

    No answer is 'wrong' you just have to decide how you want to run your inventory.

    You already said you wanted a FIFO system so that gives you your answers.

    If I understand correctly that you...
  5. Replies
    2
    Views
    309

    Re: Renaming (2003)

    An old much mentioned favorite is the Find & Replace utilty @ http://www.rickworld.com/

    It's saved me many hours & much heartache
  6. Replies
    6
    Views
    425

    Re: Extract Text (2003)

    A general solution to this sort of problem are the following 2 functions which return the first part of a string up to a defined character or characters & the part after the character or characters....
  7. Re: Normalize Stree Name? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    Try the following functions. GetFirstWord takes your input string & a delimiter string & returns your input string up to the first occurrence of your delimiter string. GetLastWord is similar but...
  8. Replies
    3
    Views
    312

    Re: Now() (Win XP Access 2003)

    If you mean that when you create a new record you want to put todays date in, say, a field called [CreationDate] then you can set the default value for that field =Now() if you want date & time or...
  9. Replies
    5
    Views
    366

    Re: Number Format (2002)

    Glad to help!
  10. Replies
    5
    Views
    366

    Re: Number Format (2002)

    If you define your fields as Fixed instead of General Number it works as you want
  11. Replies
    6
    Views
    408

    Re: Address Expression (Access 11)

    You Americans are such sticklers for etiquette! Well I asked the Queen at dinner last night & she said you were technically correct but what I wanted to do was fine! PS the Duke of Edinburgh agreed...
  12. Replies
    6
    Views
    408

    Re: Address Expression (Access 11)

    I fully accept all your comments. I understand the faults in the way I have structured the data but I was young then...... It reminds me of the old Irish joke along the lines of 'How do I get to...
  13. Replies
    6
    Views
    408

    Address Expression (Access 11)

    I have 3 fields Title, Forename(s) & Surname from which I use an expression to address a letter. It works fine of most instances. I use a function to extract initials from the Forename(s) field.
    ...
  14. Replies
    8
    Views
    440

    Re: Names list with tabs (2003)

    I have used Francois solution which he helped me with some time ago & have been very happy & impressed with it!
  15. Replies
    5
    Views
    372

    Re: sort Data fields (Access2002)

    Changing the data type is the best solution.

    If you really want to keep it as text you could parse out the year in a query with Right(YourData, 4) & then sort on the result. This would order on...
  16. Replies
    4
    Views
    346

    Re: 0 instead of blank (2000)

    It depends on exactly what you've got & what you want.

    If by blank you mean null & the field is numeric the function Nz([YourField]) will replace null with zero as will...
  17. Re: Updating some fields, but not others (2000)

    The thing that often trips me up when appending is trying to append to a table on the 'many' side of a relationship before appending to the 'one' side. In other word the append fails 'cos the linked...
  18. Replies
    3
    Views
    356

    Re: Processor speed for Access (XP/2K)

    ...also it is said that the Centrino processor running @ 1.6Ghz is equivalent in 'ompfh' to a Pentium 4 running at lot faster.
  19. Replies
    3
    Views
    356

    Re: no decimals (2003)

    What do you really want to do? If you want 9.87 to show as 9 then set the 'decimal places' property to 0. If you want 9.87 to show as 987 then multipy by 100 & set the 'decimal places' property to...
  20. Replies
    5
    Views
    421

    Re: Sync Problem (2003)

    Sadly not a solution. I tried synchronising with a freshly created empty .pst file & got the same problem.

    Its not the cradle & leads 'cos I tried another known to be working.

    Whimsically, I...
  21. Replies
    5
    Views
    421

    Re: Sync Problem (2003)

    Only the hardware one in my router. I haven't made any changes to either firewall that I know of that may be causing the problem.
  22. Replies
    5
    Views
    421

    Sync Problem (2003)

    For several years I have synchronised my pocket PC with Outlook 2003 on my desktop using Microsoft ActiveSync with no problems. Suddenly I get an Outlook message box claiming 'Synchronisation cannot...
  23. Replies
    15
    Views
    805

    Re: Email with a twist (2000/XP)

    You can always do it yourself with the Mail Merge toolbar. I'm sure that as available in Word 2000!
  24. Replies
    15
    Views
    805

    Re: Email with a twist (2000/XP)

    In Word 2003 select Tools: Letters & Mailings:Mail Merge... to start the wizard & then follow your nose!!
  25. Replies
    15
    Views
    805

    Re: Email with a twist (2000/XP)

    Sending emails using Word & getting the email addresses from Access is really very straightforward; the wizard provides handholding.

    The only problem I have had is when trying to attach an Access...
Results 1 to 25 of 92
Page 1 of 4 1 2 3 4