Search:

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

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    2
    Views
    1,326

    Re: Access 2010: Scroll Bars - again

    Thanks for that Micron - I will certainly try that out.
    As for a holiday in Scotland - small world (ish) my sister - now sadly passed away - emigrated to Canada (Toronto) back in the '60's, moved...
  2. Replies
    2
    Views
    1,326

    Access 2010: Scroll Bars - again

    I have a form with a header section (containing controls) and the detail section which returns the result of a Search - determined by what is input in the control(s). If I have the vertical scroll...
  3. Re: Access 2010 - Make Table Query Losing LookUp data

    Thank you all for your advice/help. It is much appreciated.
  4. Re: Access 2010 - Make Table Query Losing LookUp data

    Thanks xenou. I guess I just don't understand the inner workings of how Access makes a table from a MakeTable query. If I create a new table (as in Create|Table) then go to my membership table and...
  5. Access 2010 - Make Table Query Losing LookUp data

    I have an Access "Membership-type" database with two tables as follows:
    - [Countries] with the "CountryID" field set to autonumber and Primary Key and "ContactCountry" set to text
    - [Members] with...
  6. Re: Is it possible to change the color of the borders of an access form

    Not that it makes any difference now but it's Access 2010; oh well, thanks Micron.
  7. Is it possible to change the color of the borders of an access form

    The standard washed out grey color of an Access Form - or any Windows form - leaves a lot to be desired. Is there a way of programmatically changing the colour within VBA. I can't see anywhere in...
  8. Re: Find Next button fails to find records

    I have found out what the problem was. For one reason or another I made the last statement on the On_Current event for the form in question switch the focus to another control - every time the Find...
  9. Find Next button fails to find records

    I have two membership type databases (they are in no way connected, I mention both for illustrative purposes) Both use a form to input data, the control source for each form is a query and each...
  10. Re: Is it possible to return a query that includes a Command Button alongside each record

    Thanks Nori (and ranman256) - didn't even think of continuous forms as a possible solution. Doh!
    Thanks again
  11. Is it possible to return a query that includes a Command Button alongside each record

    Data is entered into my database via a form whose data source is a query which queries two or more tables. If I'm looking for a person in the database, I can either filter the form or run a query. ...
  12. Re: Disabling "Save as.." button on Read Only database

    Thanks Alan, I'll try that on Thursday when I'm next in.
  13. Disabling "Save as.." button on Read Only database

    In our office we have Public Logins, which allow users to access the contents of folders on the network. The folders are Read-only for the Public Login. When a user accesses a MSAccess (2010) file,...
  14. Re: MSAccess limitations when linking to ODBC database

    Norie, revans thanks for your responses. I've tried using the IN clause and am effectively coming up against the same problem. Her's the SQL (changed the table/field names to keep it short.
    ...
  15. MSAccess limitations when linking to ODBC database

    My Office PC has Access 2002 installed (with Office Standard 2003). I'm connecting to a remote Mainframe containing hundreds of DBase2 tables, the structure of which I have no control. Whenever I...
  16. Re: Duplicates in pivot? plz help...look everywhere for 2 days =(

    I think you'll find that "Belguim" is spelt differently to "Belgium" and this would almost certainly generated a duplicate. Unlike us humans - computers are pretty dense at times.
  17. Re: RunTime Error 13:'Type Mismatch' -again

    Thanx for that and I will take a close look at the MSDN website but...
    if 2007 doesn't support the functions I am trying to use, why does vba "suggest" them. Typing "application." brings up all the...
  18. RunTime Error 13:'Type Mismatch' -again

    There are a number of posts on this and other forums regarding this error. I've now got this problem and I'm not even writing any code -per se. Two pcs: one runs XP home with office 2003, the other...
  19. Re: How d'you pass a variable between projects

    Glad I could help.
    D
  20. Re: How d'you pass a variable between projects

    Try this:
    Create two workbooks - I've left them with their default names of Book1 and Book2. In the VB Editor name the Project for Book1 as Phase1 (it's not really necessary to give the default...
  21. Replies
    2
    Views
    371

    Re: Invalid Property Value

    I've had a similar problem except that I was setting the parameters at Design time in Properties. It drove me mad, but we've discovered a workaround. In my situation, I had a form with a combo box....
  22. Replies
    2
    Views
    683

    Re: DCOUNTA Problems - Bug?

    Thanks for that - it works fine now. But I can't help feeling that DCOUNT's help function should point this out. It seems to be behaving in a slightly similar fashion to VLookup/Match where, unless...
  23. Replies
    2
    Views
    683

    DCOUNTA Problems - Bug?

    I have an Excel database as a named range on one worksheet called "database". Each record in the database contains a RecordID (not used), a "unique" userID and a date as well as other data of no...
  24. Replies
    4
    Views
    431

    Re: OnTime event

    Hi Richard.
    Yep - all makes sense now. Can't think why I didn't figure that a double double quote was no different to a double & when wanting to use a literal & in a construct. Can't help...
  25. Replies
    4
    Views
    431

    Re: OnTime event

    Thanks that was just what was required. But it raises a more general question on the use of quotes in concatenated strings and variables. Is there any guidance on this where the individual parts of...
Results 1 to 25 of 43
Page 1 of 2 1 2