Advertisement

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

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 23
  1. OBP
    17-Jun-2014 11:17 AM
    OBP
    I have replied to your Forum question.
  2. roshni007
    17-Jun-2014 02:32 AM
    roshni007
    Hello,
    Thank you for helping me earlier. I was wondering if you could help me wight his as well. Thank you so much in advance.

    http://forums.techguy.org/business-a...-new-post.html
  3. SlowHnds
    29-Jan-2014 06:59 PM
    SlowHnds
    Sorry to be a pain but rather than post in the forum on a thread that is marked solved or start a new thread I thought I'd ask directly.

    An issue has popped up with the 30 working day fix you had helped me with
    Access 2010 Set a date field to today plus 30 working days

    For whatever reason when I exit the field and the macro runs after update event. I get the error message
    "No current Record" it sets the return by date correctly (at least I think it's correct)

    I hope you can help me with this. It has just started happening apparently and no one is too excited as it appears that it is still giving the right return date.

    You can email me direct at Dwade@northwestel.net
  4. BoaterJohn
    20-Jan-2014 02:19 PM
    BoaterJohn
    Obp,
    just wanted to wish you a healthy bd.
    Boaterjb
  5. Garth H
    13-May-2013 11:41 AM
    Garth H
    Hi OBP,

    Left you a message on gmail.

    Thanks Garth H
  6. 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
  7. 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
  8. vinwin06
    17-Feb-2012 01: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
  9. OBP
    03-Feb-2012 02: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.
  10. ade7985
    03-Feb-2012 01: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.

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: 20-Aug-2014 11:37 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 ↑