Search results
-
O
Binery Data Copy to Other Table
hello i want to copy binery data to another table with same structure pls help me how can i do this pls -
O
Append Query to insert data from excel
Dear Paul when i run your code it shows error on line fileDump As FileDialog what is the error -
O
Binery Data Insert from old Table into New Table
Hello i have database with images,which saves as long binery data in one access table i want to insert same binary data in other table,which is same as old table but having different values some columns having same values i.e. Table no. Name EMPID Image1 1 Ankur... -
O
Update query with form field
Dear JHB,,, Thanks once again as u provide me solution .. can u give me full detail that how it works as u set recordtype =7 or 10 ,what is the diffrence so i can use it in other same problems and i think ,now no use of update query in this code so can i delete it.. pls -
O
Update query with form field
ok i m attach my data and form pls check and give me solution -
O
Update query with form field
Hello i have two tables one is "empdata" and other is "consolidate data" In consolidate data ,i have all personal and salary data for one year of each employee but i update some employee data in empdata now i want to update each employee updated data to update in consolidate data. i want to... -
O
Append Tables
how can i appnend table from one table to other table when i do it says... Cannot Open Database". It May not be a database that your application recognizes , or the file may be corrupt what is the problem / and how can i solve it.. pls ...help -
O
Create Query to sort Table in particular order
Hello i have a table with multi columns with unsorted data i want to run query to sort data in multiple columns how can i do it pls give me solution thanks in advance -
O
Count Unique Values with Diffrent Values
i want to run update query with a forms value like Creteria, Update value and field(in combo box value) but when it run query it show a messege box when i fill it it say field in not updateble what is the problem .. -
O
Count Unique Values with Diffrent Values
i want of get output of table like this ID NAME PAN 1 A X 1 A X 1 A X 2 C Z 2 C Z 3 D U can i do it in one time command or create query -
O
Count Unique Values with Diffrent Values
Thanks ... But i think i cant explaine my update query i want to update values respectively ID=1,,not for inplace of ID,, like where id=1, name is A, -
O
Count Unique Values with Diffrent Values
Hello i have one table in which ID is Primary ID with Different Values Like ID NAME PAN 1 A X 1 B Y 1 A X 2 C Z 2 C G 3 D U it shows that ID 1 having 2 Name (A&... -
O
Distinct Count and Sum
i m also facing this problem one table in which ID is same but regarding values are different i want to count how many value having one ID and how can i select IDs,which having More than One Value pls help me -
O
Sum of Table in other Table
Hello i have one table"SALARY" which contains all employee's Salary of Complete financial Year. i want to create an other table in which i get all employees total salary in year how can i got it like sumif function in Excel thanks -
O
Error in Append Query
Hello to All my prob is .when i run an append query it shows "Database can't opne",It may not be a database that your application recognizes , or the file may be corrupt . pls help me -
O
Append Query to insert data from excel
Dear Paul how can i use this code pls give me detail step wise process as i m very beginner in access thanks in advance -
O
Import Data from Excel
i am not using any code i am follow as Import Data as import data utility i select excel file but after this screen show a blink and every thing as before -
O
Append Query to insert data from excel
Dear Paul As your Query , I give my Prob in stepwise 1-I have an workbook name TokenCreation with Worksheet Token 2-I have an access 2003 database with Table named TokenDetail now i update data in Excel Worksheet TokenCreation... and want to insert this data into Database table TokenDetail...