Search results

Hi People!! I need some help with Active X objects. Basically i want to use use various active controls in my Access Form. But i haae not done this before . Where can i get different Active X objects from ( any websites ?) . i ok using VB so i imagine you would treat it like any other control...

Thanks for that!!! works great!!!!!!!

I have a table which has a number of fields, however i need to sort the table in number order, then time order. i have a number field and time field, but i can only sort either by time , or by number. is there anyway i can use a sort order so it sorts the number first, then the time field? ...

Help !!!!!!. Hi People!!, after your expertise !!. I have a table with numeric field. This field stores numbers between 1 - 7 ( which represent days of the week!). so day 1 = Mon day = 7. The field can have a maximum of 7 characters representing the 7 days in on week. So if the record had 1234...

Thanks for clearing that up!!!

What does recordset clone actually do?, when would i use it in my database?. Thanks Milan

Hi People!!, iam really stuck here and would be grateful for any help. Basically i am in the early stages of writing a Multiuser database that will reside on a Network. I am planning to host the database on an existing win 2k server. My initial thought is to use MSDE as there will be about 8...

Hey! thanks for that!. It works a treat!!!! Milan

Thanks for that!! The code Snippet works great!!.and has solved most of my problem!!. Is there anyway of specifying certain attachments to be extracted from outlook and put into a Temp Folder . At the moment the code put all of the inbox attachments in the temp folder. I am really only...

Thank you very much for looking at my little problem!. I have pasted your code into myform and made reference to the outlook library. However the code seems to have a number of problems when i debug it, i think some Variables or not declared, but to be honest that's as much as i know, as i do...

Hi !! This is a real tough one!!!! can any help!! Basically the code below should open up oulook (2000) and look throught the inbox and find any email which has an attachment which is named "openxl.mdb". but the code does not work!!. I really could do with some help here . I need to get mdb's...

why is this not working!!! Me!ACTUALSD7 = DSum("[Actualscore]", "TblComplianceLine", _ "[Process] = 'SD' AND [AuditDate] = '"&xdt&",'") Would be grateful for the solution!!! milan

?Do you have access 2000 installed on your machine!. If so then you need to rename two files before you can install access 97. 1st file is Hatten.ttf rename to hatten.sav, and the 2nd one is Msaccess.exe (version9X) it is the access 2000 one. rename this to msaccess.sav. try installing access...

I have an access database which has a table with names and address . This table is bound to a form which i use to navigate through the records. What i want to do is when i am on the current record i want to be able to transfer the current name and address fields to Microsoft word using a...

I HAVE A TABLE WHICH IS BOUND TO A FORM. I NEED TO DELETE ALL RECORDS IN THE TABLE THAT HAVE BEEN CREATED YESTERDAY, THROUGH CODE. THE DATE(YESTERDAY) WOULD BE ON THE FORM IN AN UNBOUND CONTROL. ANYIDEAS!!! MANY THANKS

HI ALL!! I AM TRYING TO IMPORT AN ATTACHMENT (WHICH IS AN ACCESS DATABASE) FROM MICROSOFT OUTLOOK INBOX. BASIC WHAT I AM TRYING TO DO IS TO GET ACCESS TO IMPORT ACCESS.MDB'S ATTACHMENTS FROM EMAILS FROM A USER FORM WHICH HAS A COMMAND BUTTON. I CAN GET ACCESS TO READ EMAILS IN THE INBOX AND...

Thanks!!! Works a Treat!!!

I have a text box in a form bound to a field in a table. When i open the form i nedd the text box to change the colout of the text(foreground) from white to black , and after one sec change it to black from white. basicly i want the text to appear as if it is flashing on and off from black to...

HOW DO I RUN A SQL STATEMENT IN VB?. DO I USE THE QUERYDEF STATEMENT. CAN ANYBODY SEND ME AN EXAMPLE. MANY THANKS MILAN

posted 03-08-2002 10:16 AM -------------------------------------------------------------------------------- HI !! I HAVE A QUERY BELOW -: BASICALLY ALL I AM DOING IS GETTING THE RESULT BASED FROM A FORM , TXTBOX NAMED TXTCOST. IF I PUT "ALL" THEN IT RETURNS ALL THE RECORDS IN THE...