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 Chriss Miller 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: Tekhelpnet
  • Content: Threads
  • Order by date
  1. Tekhelpnet

    Form opens forms not too cool

    I have a few sets of reports for different departments. I need a form that will have names of the departments and when they click it should bring that department feom with bunch of reports to run. My question is how to make it pretty? I know I can have a Main Form with macro running on click...
  2. Tekhelpnet

    Clear Combobox when Error message closed

    I want advise. I wrote this Private Sub Business_Unit_Click() On Error GoTo ErrHandler Me.BUSINESS_UNIT.Enabled = False ErrHandler: (it is a wrong one but for example it works) If Err = 2501 Then ' Report canceled - ignore this Else MsgBox Err.Description, vbExclamation End If End Sub I am...
  3. Tekhelpnet

    Pick second value - get error message

    I have 2 combo boxes on a form. Report can be run for only either - or value. If empty - brings all data. So if user is picking the value in one of the boxes and then trying to pick in another - message should appear like 'Report can be run for one value only' BUT if they change their mind...
  4. Tekhelpnet

    No Report Header on Last Page

    How do I prevent information in Report Header to be printed on a last page? Thanks
  5. Tekhelpnet

    SUB Report showing in a wrong place

    Hi! I had almost finished Report with 2 subs. And of course ran into issue. I have Main and 2 sub reports. Second sub is the summary of the 2 and suppose to be printed at the last page like standalone page. I have Page Header that has Report Name and PersonalID. Than I have JobID section...
  6. Tekhelpnet

    Every sub from a new page

    Having 2 sub-reports inserted into main how do I make each Report printed on a new page? Thanks
  7. Tekhelpnet

    3 in 1 Reports

    Tricky task here. I am recreating Report that containes 3 different sets of data coming from the same source. 1 Reports showing Past Transactions 2 Report showing Present transactions 3 Report showing Futire projected transactions Each Report has different looks and amount of columns and totals...
  8. Tekhelpnet

    Add 2 text fields error

    I need sum of 2 fields from the table. Text datatype. I am writing =[Field1]+[Field2] and it gives me 2 3 23 instead of 5 1 5 15 instead of 6 What is wrong with my formulas? =VAL[Field1]+VAL[Field2] gives error SUM([Field1],[Field2]) gives error as well... Thanks
  9. Tekhelpnet

    ODBC connection to Oracle view crashes Access

    Hi again! I have 2 views in Oracle that I am connected to through ODBC. Connection is bad like really bad so I had to create 2 static tables otherwise my report would not open in desing view. It crashes Access while opening in design view! Little over 1400 records per view. Nothing really but...
  10. Tekhelpnet

    Addition of the text field numbers

    I have crosstab query. 2 text fields (containing numbers) are suppose to be added. What is the syntax? I had tried about anything =[071 ]+[080] =SUM([071 ]+[080]) =Count([071 ]+[080]) =([071 ]+[080]) etc Nothing works
  11. Tekhelpnet

    Access maddness

    Hi! My Access2000 converted into 2003. Whenever I want to put cursor anywhere and highlight part of the word - it will highlight whole sentence... Insert button is not it! Is there anything else I need to push to stop this maddness? Also when I am placing controls on the form I click once but...
  12. Tekhelpnet

    Access Reports with parameters and without

    I am creating Access2003 Reports with parameters. Also Form that has buttons with all Report Nmes listed. Macro behind the button will Open Report. However some users will choose to print ALL - no parameters entered. What would you suggest I do to not to have param window pop up and no parameter...
  13. Tekhelpnet

    Access Report Parameters

    One more question. What is the most officient way to have parameters to run Access Report? I am building form with buttins with Reports names. Parameters will be like ALL, UseID, Job# etc. So should I use formulas or something else?
  14. Tekhelpnet

    Simple (()) issue

    Can someone see what is wrong witht his formula? IIF(ISNUll([GRADE_FROM], [GRADE_TO], [GRADE_FROM] & " - " & [GRADE_TO]) OR IIF(ISNUll([GRADE_TO] , [GRADE_FROM], [GRADE_FROM] & " - " & [GRADE_TO]) Thanks
  15. Tekhelpnet

    Excel/Essbase

    Hi! If anyone warking with Essbase... I am having a problem with formulas in Excel with Essbase. When I want to drug formula down to copy over it wouldn't. I have to type formula into each cell and it is very time consuming. Thanks
  16. Tekhelpnet

    Function in Access to Open Excel adn Save as .pdf

    Helo everybody! I am going to try my best to explain. Just got a new job. I am System Analyst and writing some Reports. I just saw few Excel Reports that are suppose to be saved as pdf file and send by email to clients. It takes ennormous amount of time to do this. I was wondering if I can...

Part and Inventory Search

Back
Top