Recent content by rbasram

Suppose you have doc1 and doc2 in microsoft word. Is there a way to design a macro so that if you press any key, whatever text is in doc1 is added to the text of doc2?? (Like backing up). The text is only copied below to the existing text of doc2. I have no idea how the macros work. Can...

Thanks a lot

How to check for syntax errors in the query...I am unable to execute this query it gives me syntax error can someone help. txtTracking is a text box.. str1 = "SELECT * FROM CancelTracking WHERE [Tracking#]= & txtTracking ;" Thank-you...

Hi, I have a code in which I want to set the rowsource properties accordingly. str1 = "Select [Lib#], [CLName] from Library where [CLName]= '" & lstTResult.Column(Item) & "' " Set Rec = CurrentDb.OpenRecordset(str1, dbOpenDynaset) //here i want to set the rowsouce...

HEY DALE THANX FOR FOR ATTACHEMENT FILE. YOU HAVE GIVEN ME A GOOD EXAMPLE OF THE WITH THE FILE YOU SENT, I HAVE TO GO THROUGH IT THOUGHLY INORDER TO UNDERSTAND HOW THE MACROS ARE WORKING, YOU HAD BEEN A GREAT HELP, THANX FOR YOUR CONSIDERATION. I'LL TRY TO CONTACT FOR ANY FURTHER QUESTIONS...

Hi, I have a spreadsheet, with auto filter, for a group of records, is it possible or a way to modify the choices in the autofilter. I mean in the pull down can i have my query ">30 days" in the date field so that if the user selects it will give all the records that are grated than...

Hi I want to format my c; drive but when ever I type the command format c: it gives me the message bad aommand or file name, is there a way to format my drive...

HI TAFFO7 BUT HOW CAN U DELETE THE QUERY IF THE USER IS RUNNING THE QUERY FOR THE FIRST TIME. I MEAN THERE WIL BE NO QUERY NAMED MYQUERY IF THE USER CLICKES IT THE FIRST TIME, DO YOU HAVE ANY SUGGESTIONS I DON'T KNOW HOW TO CHECK IF THE QUERY ALREADY EXISTS USING IF STATEMENT, IS THERE A WAY...I...

HI REWDEE THANX FOR YOUR REPLY BUT I THNK I WILL USE THE FIRST PROCEDURE IT LOOKS MORE SIMPLE. I TRIED OUT WITH THE FIRST CODE BUT I GET THE ERROR, "YO CANNOT DELETE THE QUERY WHILE IT IS OPEN" IS I HAVE TO SET FOCUS TO SOMTHING ELSE BORE DELETING IT. DO YOU HAVE ANY SUGGESTIONS, THANX

HI I HAVE WANT TO MAKE A PARAMETER QUERY WHOSE PPARAMETERS ARE PASSED BY THE USER AFER SELECTING IT FROM THE COMBOBOX. I HAVE USED THE CODE BELOW, BUT THE QUERY ONLY WORKS THE FIRST TIME THE USER CLICS FIND THE SECOND TIME WHEN THE USER TRIES TO RUN THE QUERY HE GETS AN ERROR, SAYING THAT...

HI I HAVE WANT TO MAKE A PARAMETER QUERY WHOSE PPARAMETERS ARE PASSED BY THE USER AFER SELECTING IT FROM THE COMBOBOX. I HAVE USED THE CODE BELOW, BUT THE QUERY ONLY WORKS THE FIRST TIME THE USER CLICS FIND THE SECOND TIME WHEN THE USER TRIES TO RUN THE QUERY HE GETS AN ERROR, SAYING THAT...

I have a field named HISTORY(Type Text) in the table TIP. Is there a query that can count the number of times the word "VALIDATED" occurs in this field and give only the records that have only count=1 (i.e VALIDATED occurs only once) Any suggestions will be appreciated.. Thank-you

It worked thanx a lot

strSQL = &quot;<Title> &quot; & rst!Title & &quot;</Title>&quot; & (here is where i want t new line) &quot;<Author> &quot; & rst!AuthorName & &quot;</Author>&quot; I am trying to put a new line in the sql statement because I want to print the whole data into a text file. Is there any new line...

strSQL = &quot;<Title> &quot; & rst!Title & &quot;</Title>&quot; & (here is where i want t new line) &quot;<Author> &quot; & rst!AuthorName & &quot;</Author>&quot; I am trying to put a new line in the sql statement because I want to print the whole data into a text file. Is there any new line...