Search results

hey SQL Hell, do u have solution to my query?

hi all, Basically, Via the sql express I have managed to create a manual backup of my customer database on the hard disk. And its saved in the following location. C:\Program Files\Microsoft SQL Server\MSSQL.1\Backup\Customer.bak Can anyon ehelp me automate the backups (instead of me having...

thanx boblarson, ur db was very helpful. I managed to mould ur code to fulfill my requirements and it works excellent. thankyou very much for your help :) !

hi, im currently working on a db in ms-access. I have a table with the following columns: user_ID, name, password and group (admin/normal user). i wish to create a login form such that when a normal user (where the user group = normal user ) he/she shall have access only to the forms in the...

brilliant stuff, thanx alot khawar..:) ......your db gave me the exact solution that i needed. Once again thankyou very much!

hi KenHigg, your suggestion is quite pleasing, but it gets very complicated as i need to work on the last despatch date of a product_id (in the previous year) and the very first order date of a product_id in the following year. Khawar ... many thanks for the db.. the results look promising...

hi, im working on qureries in ms-access and need a way of writing a query to achieve the following: With Reference to the table below: Product_ID Order_date Despatch_Date 001 01/12/2007 05/12/2007 002...

hi all, can anyone let me know if its possible to export all my tables from ms-access to Microsoft SQl Server?????? Any help would be much appreciated!

fabulous krester! the code u gave worked for my condition, thank u very much! im happy to have got it working at last.....:)

hi all, im working on qureries in ms-access and need a way of getting the following: With Reference to the table below: Cust_ID Order_date 001 01/01/2008 002 05/01/2008 001 05/01/2008 001 07/01/2008 can anyone help me design a query that gives me all the order_dates greater than the first...

Secondary IDE channel error hi, i use windows server 2003 O/S and in the Device Manager I get a yellow exclamation mark on the secondary IDE channel,, can anyone help me with this?

hi thr, Thanks ruralguy! with your advise I was able to sort out the tab order issue :) but for the solution mentioned by you and missinglinq for the record locks i had no luck :(. i havnt yet created an on lostfocus event and when i change the cycle property to current record i get the same...

Hi, I am currently working on a database that stores customer details and order details. the back end is SQL Server and the front end is MS Access. I have recently come across the following problems: First of all, in one of my order forms (which has a couple of text fields and drop down...

These links are quite informative but I think I managed to get rid of the error by copying the svchost.exe file from other location and pasting it under windows :). anyways many thanks for your help.

hi again, I did the windows repair but that didnt resolve the problem.Then I went to start up programs and disabled the C:\Windows\svchost.exe. it seems to have worked. I dont get any such warnings again. However I would like to know if I have done the right thing to stop the error message...

HI! Recently my system that runs on win 2003 O/S has started to show up an unusual error which is: C:\Windows\svchost.exe not found Can anyone help me deal with this?

well, I have a pc with 20gb hard disk which is almost full and i decided to go for a new hard disk with more space. so i purchased a new hard disk with 80gb space. i wish to install it and also copy the contents(all files & folders,softwares etc) from the old hard disk to the new hard disk and...

Hi! Can anyone help me on transferring data from one hard disk to another hard disk?

HI! i am having problems with the libraries (DAO,Adodb)that support recordsets. when i write sql code and try to assign it to a recordset varaible it doesnt work........ Can anyone let me know which library do i need to select from the 'reference' dialogue box to get me going with recordsets ?