Search results

It helped! Thanks. Tell me 3 things: 1. Why do you use the NEW? 2. In the SQL string, how can i use the Me.Recordset (my form is based on a query that i whant to use)? 3. What the hell is the "Provider" ? Newby stuff about SQL server ... p.s. Very good rate

Hi I'm not a newby in programing/code but in Access-SqlServer i am. I have all my code (and works fine) in DAO but with a connection to a mdb db. Now i've already passed to sqlserver and need to put my code to DAO. Problems!! I can't establish a connection into my db. I have: 1. A DSN called...

James One solution: 1. Create a form without a source 2. Create a combo for location (1 colum) 3. Create a combo for status (2 colum) with criteria for 2. 4. Create a combo (3 colum) with criteria for 2. and 3. 5. Now create a textbox (with your query) that performs the calculation Hope i help...

Hi I have a field that counts the records of a subform. The problem? When i haven't records my field = #Error. Can i, on the enter event, perform/count the records on my subform to disable my parent field ? Thanks

Calendar problem Hi For now i send you to the northwind db calendar. Check if you can understand how the calendar works. It help me. pacg