Recent content by tziviak

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

I have a report-in which I have an OLE object-from microsoft word-but the ole object doesn't show up when I preview 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...

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?

I have a report-in which I have an OLE object-from microsoft word-but the ole object doesn't show up when I preview 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...

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