Search results

No ... I did not get any result out of that method... we had SQL server as back end and we made the sql authorization method to hide our code.

copy the value, close the excel sheet and then paste in the range of cells in the access table.

Hi all, I have Access as front end and SQL Server as back end. The Access application is placed on a common network drive for theusers to access it. The compact on close option is enabled when the access application is closed. I have a local copy of the access app. When I close the app, it...

Hi all, I observed that when I copy a value, select a range of columns and try to copy in the entire range of cells, the value is pasted only in the beginning cell and rest all are empty. But i have a requirement when after selecting the range of cells in the table and press Ctl+V the user...

Can u explain the answer more

Hi all, I have form which displays all the records in a table. The table has 600 records. I want to display the records in multiple pages. Is there any setting with which i can display the records in multiple records or will i have to do it manually through code? Thanks in advance.

I faced some of the issues mentioned. I did not mean to offend. I just started working on the project so wanted to gather as much info as possible. Thanks for the information.

Hi all, I have an access DB which has some tables and queires. While migrating the DB to SQL server 2008, the tool SSMA is migrating the tables but not the queries. Does anyone of you have a prior experience with queries migration from Access to SQL Server 2008 using SSMA tool. Kindly...

I will let u know once i have compiled

Hi all, I have query regarding the "make accde" functionality in the Access 2007 database. My Db size is 100MB. I want to hide the VBA code from the users by converting my accdb file to accde file. But when I use the Database Tools-> Make ACCDE option, I am getting the following error...

Due to tight deadlines, I am unable to continue this thread. "import XML file using XSLT transformation" is the new thread in which I raised the XSLT transformation issue.

Hi all, I have to import a XML file in Access database as tables. When i import it directly I get 13 tables in Access database. I use the method Application.ImportXML (DataSource:=,ImportOptions:=) for importing. But to reduce the tables to 1 and take only the data which is needed I am using...

i was suggested to use the transform functionality of Import wizard in Access and use a XSLT transformation to do the task.... Is this of any help.

In the link you sent, the tables mentioned have a unique identifier PRBLM_ID. But i do not have any unique identifier. Hence is it possible to import the data as GEMMA-the-husky because in the net I ahev read that MSXML comes with MS Office 2007 but when i run the code is is throwing the error...

which version of MSXML do i need to download for access 2007????

Here is the sample data <?xml version="1.0"?> <STUDENT> <StudentInfo> <RollNumber>1</RollNumber> <Name>DON COBB</Name> </StudentInfo> <StudentSubjects> <SUB1>PHYSICS</SUB1> <SUB2>CHEMISTRY</SUB2> <SUB3>MATHEMATICS</SUB3>...

Is there a way to import the data line by line through VBA code????

i wanted to know is there a way in Access to import the XML file data line by line into a variable and fill the tables indivisually.

Hi all, I have data in a XML file. I have to import the data into the Access database. In the XML file each node has 13 child nodes. Hence, when I try to import the data, 13 new tables are formed. Since no 2 tables have a common column I am finding it difficult to merge the data into 1 big...