Recent content by abhi.karnawat

please can anyone tell me what this error is about? i have attached the pic of the error.. i use the same odbc connection in accde file but if i try to test the datasource from odbc manager i get this error.. cant see to understand why it works when i login through the accde file and i cant...

hey, i'm having a laptop that has windows 7 home premium 64bit version installed. this laptop is in belgium, and my sql server is in vietnam.. i can usually make the connection to this server with the internet if i use win vista home premium, xp pro win vista business. but some how on xp home...

the following query is based on 2 other queries. i have a table stock and stockJ, from theses tables i query 2 queries of stock that is unsold, after that i have query the comes from both these queries where there are 2 fields linked namely Stock location and Jewl No whenever i want to retrieve...

would u be able to analyse my application if i sent it to u ..i will include the odbc connection username and pass.. ? there are certain issues i would like to go through one by one.. from the sql database till the front end app.. so that i can make this application fast and reliable for the...

hey, my database is located on a MS SQL2005 server, and i use MsAccess2007 as front end for the database.. i have over 3000 records on them and growing every day.. Now i have linked the tables in MS access but am running all my queries in MS access.. which sometimes take a while to display the...

hi i cant really understand what u want to do as what i read from the post it is working as u want .. like when u put in the year it gives u the filtered result.. so what seems to be the problem.. is the the printing? regards abhi

hey, maybe you could put a button to refresh form data and to requery it. under the button u write the code docmd.requery docmd.refresh or u could try with a timer under the forms properties to do a auto refresh or requery every few seconds.. but i...

hi, i'm not to clear on exactly what u need to do but from what i could make out u need to open a form after input of a certain field. maybe this code could help get a little further.. i would use it under the AfterUpdate Event Dim stDocName As String Dim stLinkCriteria As String...

hey thx again for all the help i got everything working as i wanted.. your idea for the subform with multiple linking criteria's helped a great deal and now saves me a lot of time in updating my Inventory prices.. abhi

ok thx got the update query working, now the second part seems a little more complicated.. where would i start.. ?

i did the update query.. it gave me an error.. cannot update '(expression)' ;field not updateable please help on this function first.. thx.. i have attached the query pic in design view..

hi, i have 2 tables one containing stock and one containing prices. in order to give a price to a stock item the following criteria's should match: shape, size, color, clarity for example: my stock table: shape:RB, Size: 3.3mm, Color: F, Clarity: VS1, Price: 0 Price table: Size: 3.3mm, Color...