Search results for query: *

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

...rsMyRS As Recordset Dim strMySQL As String Dim lngParam As Long Dim RItem As Integer strMySQL = " Select * from ClientDisplayQuery WHERE [Product].[ClientDisplay] = '" & cmbCName.Column(RItem) & "';" Set dbMyDB = CurrentDb Set qdMyQuery...

...rsMyRS As Recordset Dim strMySQL As String Dim lngParam As Long Dim RItem As Integer strMySQL = " Select * from ClientDisplayQuery WHERE [Product].[ClientDisplay] = '" & cmbCName.Column(RItem) & "';" Set dbMyDB = CurrentDb Set qdMyQuery...

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

...rst.EOF DoCmd.SetWarnings False DoCmd.OpenQuery &quot;Query1&quot; DoCmd.SetWarnings True strPrimaryKey = rst!DocumentID strSQL = &quot;Select * Into Table1 From Name1 Where [DocumentID] = '&quot; & strPrimaryKey & &quot;'&quot; DoCmd.SetWarnings False DoCmd.RunSQL strSQL DoCmd.OutputTo...

...rst.EOF DoCmd.SetWarnings False DoCmd.OpenQuery &quot;Query1&quot; DoCmd.SetWarnings True strPrimaryKey = rst!DocumentID strSQL = &quot;Select * Into Table1 From Name1 Where [DocumentID] = '&quot; & strPrimaryKey & &quot;'&quot; DoCmd.SetWarnings False DoCmd.RunSQL strSQL DoCmd.OutputTo...

I have a table with 5 records each with 6 fields, is there a way to export record by record on different textfiles which are named after the primary key.. please help

Suppose Have 5 records ina table, I want to design a macro or a cmdbutton when clicked it should give me 5 different notepads with all the fields of each record respectively. And all each file should be saved as of the primary key like the lastname or emp#..Does any one has a slightest idea how...

Thank you Jeff, it worked