Search results

hi, I have a saved in querydef.. I am able the columns using field property of querydefs.. anyway I can delete few fields from querydef and use the other remainining fields of the query. Thanks, Ashish

Hi, I have a query in Access which return the selected column as per designed in the query window.. If I uncheck the "Show" check box those columns are not displayed in the output. Is there any way that I can do the selection of columns using VBA? Thanks. Ashish

Hi, I need to link data from Oracle to Access via DSN. I can link the tables by manually going thru the link wizard and linking the tables by selecting the DSN. But I am unable to get it thru VBA. Any help will be appreciated. Thanks, Ashish

Hello, I need two small inputs in Access forms How can I make the size of a form fixed. No resizing allowed When I open access form it should open a form in running mode. No default access tables and form design mode. Thanks in adv for inputs. Ash

Hi, I am reading from a CSV file. My code is something like this: Set f = fs.OpenTextFile(sDesktopPath & "\" & "Download.txt") f.ReadLine Do While Not f.AtEndOfStream sLine = Replace(f.ReadLine, Chr(39), Chr(39) & Chr(39)) 'Replace all ' symbol with '' symbol sLine = Replace(sLine...

Hi, I have a macro written in file1.mdb. This maro should copy a table from file2.mdb and paste in a third file file3.mdb. When i use docmd command it gives me a option to define the destination database but I am unable to define the source database which is file2.mdb. By default it takes...

Hi, Is there any way that I can display checkbox in list box in forms. I mean any property which makes this working.. I need to select the items which are displayed in a listbox. Kind Rgds, Ashish

Hi, I have forms and macro written in a file say MDB1. Is there any way to access the data of table present in file MDB2. To access the data from current database I am using the code as Dim lrs As Recordset Dim lrs1 As Recordset Dim db As Database Dim i As Integer Set db =...

Hi, I need some help in calling form.. A function is being executed in a form1. In this function a call is there to open form2. The form2 opens. No problem in this. But when form2 opens it resumes the execution of the remaining part of the function in Part1. What I want is once form2 opens it...

Hi, I need some help in calling form.. A function is being executed in a form1. In this function a call is there to open form2. The form2 opens. No problem in this. But when form2 opens it resumes the execution of the remaining part of the function in Part1. What I want is once form2 opens it...

Hi Ppl, I have few questions in access forms. 1) I have a few forms in my access file. When a user opens the file the main forms pops up. When the user wants to go for design he need to press Shift Key and open the file. Any way to make the design mode password protected. 2) Suppose I make a...

Hi, I have a made a query named "Alert_data" in query option which selects the data from a table. When i click a button in a form this query output should be displayed.I am using the code in the button click event as DoCmd.OpenQuery "Alert_data" Its working fine. But the problem is if i...

Hi, I need to send e-mail through Access. I got the way to send mail through Outlook library in access But is there any way to send mail without using outlook configuration. In VB6 i used the code to send mail through Vbsendmail.dll but when i am trying to use the same code in Access its...

Hi, I have my 2 MDB files. One test version and one production version. Both have the same table structure. Periodically I want to copy the data from production MDB tables and pasting in test version MDB tables manually. Is there any way to do it using macro. I can write macros but i dont know...