Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search
Tech Support Guy Forums > >
(!)

OBP OBP is offline  is a Trusted Advisor with special permissions.

Trusted Advisor

Visitor Messages

IMPORTANT! READ THIS FIRST!
This form is to write a personal message to another user. DO NOT ASK FOR TECH SUPPORT HERE. To ask your tech support question, please go to the forums or read our welcome guide for new members. Thanks for your cooperation!
Showing Visitor Messages 1 to 10 of 19
  1. Garth H
    13-May-2013 11:41 AM
    Garth H
    Hi OBP,

    Left you a message on gmail.

    Thanks Garth H
  2. BoaterJohn
    13-Jun-2012 12:43 PM
    BoaterJohn
    Hi OBP,
    I was away for awhile fishing. Thanks for responding to my thread. The two queries were the key. I had to make the join a 1 to many. worked like a charm
    Thanks Much,
    boaterjohn
  3. Garth H
    21-Mar-2012 03:12 AM
    Garth H
    Hi OBP. Greetings from the south. Do you still have your Gmail address? Garth H
  4. vinwin06
    17-Feb-2012 12:31 PM
    vinwin06
    HI OBP,
    how are you? i think you could remember me we work together last year for one thread called "MS access query". I have attached the file too with this message. Now i am facing a big problem in the database while running that macro its generating more space and database size became more than 2 gb. As you already know 2 gb is the maximum size of the database.

    Kindly let me know if there i can do with this macro or u can help me on this. I know the problem would be like the data volume is huge (approx 4 million).

    Regards,

    Vinoth S
  5. OBP
    03-Feb-2012 01:07 PM
    OBP
    If the dates for the query come from a form, then use
    =forms![Formname]![Enter Shipping Begining Date:] etc.
    If they are not I suggest that you put them on a form.
  6. ade7985
    03-Feb-2012 12:42 PM
    ade7985
    Hi OBP,
    Help again pls.
    I was trying to figure out how to setup Date range in report header.
    I got to setup query date range but on my report I setup text box on controlsource I put this: =Format([Enter Shipping Begining Date:],"mm/dd/yy") & " through " & Format([Enter Shipping End Date:],"mm/dd/yy"). then after I tested by entering date and is not showing on report header its says' #Name? on text box. I need your assistance. Thanking you in advance.
  7. Cambium
    10-Oct-2011 12:00 PM
    Cambium
    Just wanted to leave a message saying that OBP is superman. Thank you for your help and making my idea happen with my data on excel. This member is amazing, what goes around comes around in one way or another. :-) Thank You.
  8. TheSteelGeneral
    20-Jun-2011 07:28 PM
    TheSteelGeneral
    thank you for the example database! I'm late, but you know what they say, better to copulate than never.
  9. OBP
    24-May-2011 06:46 AM
    OBP
    I have looked at the Relationships and they are Ok for now.
    I will post what you want shortly.
  10. WandaNezar
    23-May-2011 04:36 PM
    WandaNezar
    Ok - now I am confused, got feedback from RockN and once again I am lost? I didnt link fields - agge nee - and I thought it was working.. Seriously.. thought I was getting the hang of it....

About Me

  • About OBP
    Location
    UK
    About Me
    Started programming in BASIC in 1982 on a Commadore Pet.
    Learnt Visicalc, Lotus 123 and then Excel, mostly self taught and some would say that it shows.
    Trained as a Systems Analyst to NCC Standards.
    Learnt database design, DataMaster, DataEase and then Access.
    Interests
    Creating Access Databases, These forums, Solving Problems, Chess, Table Tennis, Air Rifle and Pistol Shooting.
    Occupation
    Retired Quality Engineer with Ford Motor Company.
    Computer Specs
    A new HP Pavilion Laptop running at 2.2ghz with Centrino Duo technology T7500 and Nvidia GeoForce 8600 GS HD graphics Card and a 17" widescreen display.
  • Signature
    OBP
    I do not give up easily

Statistics

Total Posts
Visitor Messages
General Information
  • Last Activity: 19-May-2013 11:01 AM
  • Join Date: 08-Mar-2005
  • Referrals: 5

Friends

Showing Friends 1 to 10 of 33
WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑