Search results for query: *

I have a form created with multiple text fields for users to input the information and the data is saved in the access table. How do I add a button to the form for user to attach a word document for each item the user has entered into the form. The word document is different for each item...

I have a pivot table layout liked the following. Is anyway when I double click on the items counts listed under each aging bucket and it will show the detail for the age bucket and the user I clicked on?? For example, if there are 2 items listed under age 1-30 bucket with user Mary, when I...

I have a pivot table created by a former colleage and it was connected to a different sql server. How do I change the datasource so it can connect to the new sql server?? I tried to create a new data source but I still can't get the pivot table to change it to the new server. Any help will be...

How can I find out what is the operation system account assigned to the sql server agent?? Any help will be greatly appreciated. thanks

Is SA a default username setup up by sql server?? Does it come with a default password??

We had a server move last month and the scheduled job ( a dts package) started failing after the move. I kept getting error message " access is denied" and can't figure out the reason. All the databases were backup and restored to the new server. I can manually execute the package and it ran...

How can I suppress duplicate records at the detail section?? The report is group by customer id and below is an example. Any help will be greatly appreciated. Thanks customer id Productid transdate 1234 a50 5/10/07 1234 a50 5/10/07

I am trying to convert a number field to a string field but when I used the totext function, it returned 'comma' to the output. How can I elimiate the ',' from the output?? Any help will be greatly appreciated. Plan_id with type= number (22,0) left(totext({plan_ID}, 0), 5) output 13,22

I am trying to do an insert statement and kept getting this error message and couldn't figure out the reason. I have checked all the fields and they all matched between the two tables. Does anybody know what this means?? Is it because of the datatype?? insert error: column name or number of...

I have a database with some forms that was created by former employee and i am experiencing a problem. Whenever someone closed the database abnormally, it will create a seperate database file in the directory for ex, db1, and if 2nd person doesn't close the database by clicking on the close...

Does anybody know how to copy a dts pkg from one sql server to another sql server with *.dts pkg?? thanks

Does anybody know how to track who delete the DTS pkg from sql server?? Or who has logged on the the server during certain period of time?? thanks

I don't have a backup for msdb database but i have the mdf and ldf file. how can I attach the msdb database?? any help will be greatly appreciated. thanks

Is anyway I can rollback transaction to sysdtspackages at the msdb database?? any help will be greatly appreciated. thanks

If a sql package was deleted, where does it go? Will it be possible to restore it??? Any help is greatly appreciated. Thanks

I have added the password on the excel spreadsheet to protect the formula. How can I just protect section of the file?? I want to allow user to insert row or column into the file. thanks

Pick from list I have a column that has drop down box on each cell. Does anybody know how to add new name to the drop down box on each cell?? I have a column with list of people’s name but I need to add the new name but not sure how to do it. Any help will be greatly appreciated.

I have a front end database that was developed by another person which is no longer working in my team. I am having an issue opening the database. This front end database which is using by the users contains a lot of links to the backend table. The backend database has been moved to another...

I added a check box to the access form and to the table (“fed_express” with data type = yes/no) . I am getting an error message if I don’t check off the fed_express box. The error message is "run time error 3421: data type conversion error". I tried to debug but and found out it stopped at...

I added a check box to the access form and to the table (“fed_express” with data type = yes/no) . I am getting an error message if I don’t check off the fed_express box. The error message is "run time error 3421: data type conversion error". I tried to debug but and found out it stopped at...