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

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

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

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

i have made a code that outputs the records one by one to a textfile.. Dim db As DAO.Database Dim rst As DAO.Recordset Dim strSQL As String Dim strPrimaryKey As String 'if it's a text datatype Set db = CurrentDb Set rst = db.OpenRecordset(&quot;Name1&quot;, dbOpenDynaset) rst.MoveFirst Do Until...

i have made a code that outputs the records one by one to a textfile.. Dim db As DAO.Database Dim rst As DAO.Recordset Dim strSQL As String Dim strPrimaryKey As String 'if it's a text datatype Set db = CurrentDb Set rst = db.OpenRecordset(&quot;Name1&quot;, dbOpenDynaset) rst.MoveFirst Do Until...

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

I have a cmdbutton on the form, I want to disable the cmd button once the user had already clicked it. I mean I don't want the user to click the button twice. Is there a way to do it. Can we disalble the control in the on_click event I mean at the end of the procedure..

I have two listbox lst1 and lst2 what I am trying to do is that when the user suppose the user selects an item in lst1 and one item in lst2 I want to pass the results to a query and then dispay the result in the text box. I know how to pass the parameters into the query but The only thing I...

Why am I not able to export a table from excel in access. When right click on the database windows and then click on import I have all the other tyoes of formats in the combo box but I don't have excel worksheet is there any other way to do this..

Hi I have a field that starts with a letter C or T and then following 4 digits. I want a way that can increment the number by 1 when a record is added. The number starts with 3842 suppose the user wants to add a T product then the next number should be T3843 and after this if the user wants to...

I have an input box is there any way I could disable the cancel button and also change the format like the font and the color of the text through the code.

Hi, I have two tables that have this field I want to know how can if there is a way when the code is running the code looks up the value in the table1 if it is not in there it looks up in the table2 and also if its not there an insert box pops ups (it assumes it it a new record and then puts...