Search results for query: *

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

...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...

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)

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?

...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...

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...

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

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...

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 =...

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?

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++...

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

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

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...

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

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...

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

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

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...

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...