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

we can use the datagrid to show the columns in tables but hiding column will not directly serve the purpose. Since there is group by clause in the query called, so we need to edit the query dynamically....

That will work for a simple select query.. but what will happen if the query uses group by clause.. in that simply hiding the columns will not be a good solution as it will not give correct data.. we need to remove those column from group by clause also..

what if the query is using some group by clause. in that case, hiding column will not be a solution. we need to build dynamic query to get those column filtered out from the query output..The Show property of in Query design does the same but how to get it done through VBA.. any help? Thnks...

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

Thanks but sorry. I am unable to get this done. Can you provide a sample file by putting only few elements in a list box and checkbox associated with it to do selection. Thanks in advance. Ashish

Hi, I got the code for table linking work and that solves my problem well. Thank you so much. One more question. I have a function say "relink" which takes care of table relinking. I have put this function in form load. Is there any way that I can call this function when the database gets...

Thanks for deep anlaysis. My requirement is something like this. I have a table DEV_FE.MDB which contains the forms and macros. This contains table linked to file DEV_BE.mdb which contains the tables and data. This is working fine with me. Now very often I need to copy these two files from my...

but how can i make the checkbox appearence there?

i tried using linking tables and it worked too. But it doesn't solve my problem fully. My Development MDB file(say MDB1) contains 10 tables. I need to copy the data from production MDB files(Say MDB2) often. But the thing is I need to only 5 tables data from MDB2 to MDB1. So the option of...

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, might be I am not able to relate my requirement with your solution. What my requirement is : I have two tables in MDB1. And I am using the table data in my forms and macros present in MDB1. Now I have a form present in MDB1. In this form I am giving a file path say MDB2 file path. Once we...

Hi, Is there any way to access without using linked tables. I need to define the MDB path in macro and access the table data using macro, not using linked tables. 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 =...

it worked dude.. Thanks a lot.

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