Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: TinaS
  • Content: Threads
  • Order by date
  1. TinaS

    Quick one I think - question about Properties window in Form Design view

    Hello!! I have been working with Access for many years, but came across something I can't find out to fix. In years past, when I was using the properties window, if I clicked on any of the events, in the bottom left of my access window, it would give a little note about when each event would...
  2. TinaS

    Using VBA to add a calculated column to a pivot table in excel

    Good Morning!! I currently am using Access 2003 vba to export data to an excel pivot table via automation. The table creation works great - and I have added a column to the end of the table to calculate percentages on 2 of the rows (it looks like this): ClosedBy (All) Closed (All)...
  3. TinaS

    Proven Code Stopped Working - Does not appear to be a references issue

    Help :( I have HOURS into this database setup, and noticed all of a sudden my ENVIRON("USERNAME") was not working.. I thought it was acting funny based on other posts(i.e. not reliable), but then tried it as a function/api instead - still didnt work, then I noticed that NONE of my code is...
  4. TinaS

    need to get an event to fire in a tab Control in ACCESS 2007

    hello all! My issue is this: I have a main form frm_Tasks with a suform frm_TasksTracking. Because this will be used heavily, I want to NOT force the users to click a button or 'goto' a new record, I want to the New record on the subform to auto set when the form loads, and when navigating...
  5. TinaS

    Can't Assign Value to this Object - INCONSISTENT error

    I have a Simple Database with a parent and child form. 2 tables - parent and child, with ref integrity enforced. I am getting an inconsistent error upon typing the first value into the subform record: You can't assign a value to this object. *The object may be a control on a read-only form...
  6. TinaS

    OUTPUTTO works inside Access2003, but not when called from command lin

    Hey guys! I am almost done with this automation and hit a snag. I had the public routine in a module, but reading found that I couldn't call the routine from a command line for task scheduling (please advise if I am wrong). The only way I can find to call this, is to create a function and...
  7. TinaS

    Chart shows total Count of records, instead of field value

    HI! I've been working in Access for years -but - admittedly - there are some areas that I've never had need to work with - charting is one of them. Now I am doing what should be a simple chart - and I am sure it's an EASY fix - I just can't find it. TRANSFORM Sum([OpenDays])*1 AS...
  8. TinaS

    Sum groups from a table to ONE record returned in the query

    Hey all, I've been searching and can't find exactly what I need - Part of this may be due to not knowing EXACTLY what I am looking for ;-) I am pretty sure I've done this in the past, but I've been out of the loop for a couple years (working with other software) - and am pretty danged rusty -...
  9. TinaS

    Bug? Hidden Database Window won't stay Hidden...

    Hey all - this is a cross post - sorry - Just trying to find out why the database window will not stay hidden in my application and if it's a bug that someone knows about. I've disabled bypass keys, hidden the db window, and it doesn't show up until I hit an error of some kind - basically a...
  10. TinaS

    BUG? Hidden Database window appears on errors...

    Hey all, I am getting very frustrated. I have hidden the database window, disabled bypass keys, done everything I can think of to get the database window to hide. It hides and stays hidden just FINE until any kind of error occurs. Even though the errors are handled, the fact that the error...
  11. TinaS

    70-156 Exam

    Hey all, I was just reading in the new FoxPro certification study guide, that on the exam, incorrect answers are penalized, so if you don't know the answer, you are better to skip the question entirely than to answer it wrong - can anyone confirm this?? I historically at least GUESS at an...

Part and Inventory Search

Back
Top