Search results for query: *

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

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

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

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

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?

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

I need a textBox to display the week day of the week-given a certain day in the form of Sun, Mon, Tue... is there an easier way than an if statement? if (weekday(DATE))=1,"Sun",IIF(weekday(DATE))=2,"Mon".... Thank you I'm putting this code in the control source of 15...

my dateAdd function is not working properly-when I add one to 9/30/03 I get 31 instead of 1(for october) my code is (in a control source of a textbox) : =IIf(Month([txt1])<>Month(DateAdd(&quot;d&quot;,1,[txt1])),Null,Day(DateAdd(&quot;d&quot;,1,[txt1]))) any ideas?

I have a date field-set to shortdate and in my code I'm trying to test it if it's null-in an if statement-but the problem is that it never tests as null (although the field is empty) -it always executes the else part of the statment. is there another word to use instead of null-since it's a...

Is there a function (as in microsoft excel) to check if a certain date is the last day of the month? thank you

Is there a function (as in excel) to check if a certain date is the last day of the month? thank you

I have a recordset that extracts some records from a table-but the problem is with my code-is that it only extracts one record-instead of a few-so the only way to delete the whole recordset (that's what i want to do ) is to keep on looping and setting new recordset-and I get one record every...

I'm trying to make a few movie clips a certain type of object-and then putting it into an array. This code is not working properly what am I doing wrong? function objLine33 () { } Line33=[]; Line33.push(new objLine33(Line33A)); Line33.push(new objLine33(Line33B)); Line33.push(new...

I'm using access event procedure- I'm a beginner and I'm trying to create an event procedure by an onChange event of a field in a form. I'm having a hard time setting the recordset... so would appreciate if someone could help me. I need to add/delete records to a table-based on information of a...

I have an array of movieclips-and I want to set an onclick action to each of them (the same action) is there a shorter way to do it than array[0].onClick=array[1].onClick=...=function(){}? maybe some kind of loop?

I have a movie clip that the user-can drag onto the grid-and move around the grid. But, I want the user to be able to drag onto the grid as many of the item as he/she wants to-so probably the best way to do it is to duplicateMovieClip on the fly-but then how do I keep track of them-and give each...