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 derfloh 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: tziviak
  • Order by date
  1. tziviak

    OLE Error

    thank you -it was norton that caused the errors-who would have thought???
  2. tziviak

    OLE Error

    ...the report-and I get this error: A problem occured while microsoft access was communicating with the ole server. Try one or more of the following: *Make sure you're connectd to the network server where the OLE server application is located. *Closed the OLE server and restart it outside of...
  3. tziviak

    phone number format

    yup -it now worked-simple enough-I guess you learn new things every day. (I didn't realize there is inputmask in the report too-I just knew about it in forms)
  4. tziviak

    phone number format

    I have a phone field with a mask (###)###-#### but when I put it in a report I get the numbers without the formating -just 10 numbers without dashes and ()-how do I format it so the phone numbers should be formated?
  5. tziviak

    OLE server Error

    ...the report-and I get this error: A problem occured while microsoft access was communicating with the ole server. Try one or more of the following: *Make sure you're connectd to the network server where the OLE server application is located. *Closed the OLE server and restart it outside of...
  6. tziviak

    SQL/Access time fields differences

    well basically I have a table in SQL with session notes-which includes date,studentID,therapistID,timeSessionStarted, and timeSessionEnded now, I need to run a module from access-to find if the therapist overlaped during the day (if she entered a session that overlaps with another session that...
  7. tziviak

    SQL/Access time fields differences

    not an option for now. does anyone have any clue?
  8. tziviak

    SQL/Access time fields differences

    I'm using the date/time field in both access (I'm using the 97 version) and SQL-yes, I am using MS SQL database. and regarding the time/date format check out this link from microsoft...
  9. tziviak

    SQL/Access time fields differences

    I'm working with a access database that has a table in sql. so in my module when I'm trying to run an sql statement to get records from my sql table("seesions") I have to use this sql statment-because of the differences in the time fields between access/sql-the cvDate format sqll =...
  10. tziviak

    page number in report with groups

    I'd like to have page number for the report-that has group header-but if the report extends on more than one page the second page should be page 2/2. any ideas?
  11. tziviak

    putting copied movieClip into a variable

    I used the duplicate movie clip to duplicate a m.c-but later on I want to refer to it in a variable-so how can I put the value of the copied m.c into the variable? here's my code: duplicateMovieClip("Tline","TLine"+number,2); avail="TLine"+number; number++...
  12. tziviak

    custom menu bar

    cool-thanks-I thought they both had to be named the same thing!! thanks a lot
  13. tziviak

    custom menu bar

    sure-here's the code: Public Function ModOpenForm(strForm As String) On Error Resume Next DoCmd.openForm strForm End Function
  14. tziviak

    custom menu bar

    I have created a custom menu bar and a module to open a specific form but when I put this code in the onAction of the bar-access gives me a message that "The expression you entered has a function name that microsoft access can't find" here's my code in the onAction...
  15. tziviak

    movie clips

    thanks i'll try it-but what is the substring function return the first character -and what 2 numbers do you pass to it? thank you
  16. tziviak

    movie clips

    I have many movieclips -I have 10 movieclips for each type-and i have around 7 types of movie clips (ex. 10 red squares, 10 green triangles, 10 blue circles movieclips) now I want a different action to occur if any of the movieclips get clicked-but the same action should occur if the same type...
  17. tziviak

    leap year function

    is there a way to check if a certain date-is a leap year?
  18. tziviak

    spell check in text boxes in microsoft word

    ladyck3-if I understand correctly-in the article-they are basically uprotecting and reprotecting the form-while performing a spell check inbetween-but if I do it manually-the spell check just checks the form-and not the fields.-so why would coding it-make it work? thanks
  19. tziviak

    spell check in text boxes in microsoft word

    Hi-thanks for all the responses-I actually tried skip's advice-and realized that the only way to copy and paste it into another document and it should spell check-is if the form IS protected-because otherwise you're sort of pasting the whole textbox-so spell check doesn't work-but if it is...
  20. tziviak

    spell check in text boxes in microsoft word

    I have a protected form with textboxes-that I want the user to just enter information into the textboxes-but the problem is that they can't spell-check their work -the spell check is greyed out so I tried to unprotect the document-which got my spell-check back-but not for the data-that's inside...

Part and Inventory Search

Back
Top