Search results for query: *

I do not know if this should go into the SQL forum instead but I will try this one first. I have a contact database in MS SQL. IT records the following data, Name, Email, Address, City, and State. There are about 50 records in this one table. There could be more but not a lot more; maybe another...

I need a way to send the data in a form to multiple emails, by way of checkboxes, I want to have a list of people with checkboxes next to there names and if there name is check off they will receive that form data.. anyone have a way of doing this. I can send email. That is not a problem, it is...

I need to display a random 4 diget number in a Textbox field.I know javascript, but how do I put the number in the field. Thanks for any help

I have several reports. But now I want the user to be able to select which field to display in the report. I want the user to click on report and then a report creator displays; it will display 5-9 Drops down boxes with all the fields in the drop down available. Does anyone have a clue on how to...

I am looking to create a desktop front end database application (NOT MS ACCESS). I also would like some info on the difference between MS SQL and Oracle Backend. I need to develop a front, what would be the best front end and what would be the backend to go with that front end. I am clueless...

I have a table called UPS. I import my flat file into the table weekly and then run the following update. UPDATE UPS SET [Invoice Number] = RIGHT([Invoice Number], LEN([Invoice Number]) - 1) This takes off the very first 0 in every record. My issue is when I import more data into the table and...

I need to run either a stored procedure, trigger, update query. I am not sure, maybe some can help me, I have a flat file I import into my database. I have a field called [Invoice Number]. This field contains both alpha, numeric values (Ex. 000001754HRE0), what I am trying to accomplish is...

I get a flat file form a customer, I import the file into a MS Access table, but somehow i need to drop the first zero form the invoice number, any help would be great

I get a flat file form a customer, I import the file into a MS Access table, but somehow i need to drop the first zero form the invoice number, any help would be great THANKS

I am brand new to CSS and I am very confused, maybe someone can help me. I bought a book to help, and I noticed that inside of the HTML <style> tag you use the “div#” and sometime you use “div.”. What is the difference, and when do you use one appose top the other. For example Example 1 <style>...

I want to be able to click a button which is located on a webpage that will either trigger an .asp page to run or whatever it needs to do. To send emails out. The email addresses are located in a table called “EADDRESS”. When I hit the button, link, whatever, I want it to look or loop through...

I want my customers to be able to check status of an order from there desktop by clicking on a Browser window. But the window will only open to s certain size and will opne in the center of the page. With no toolbar, Etc... I can do this from my website with java. but from a desktop. So they...

I have a Page that generates a report. On the top of the page I have a link that says save page. All it does is takes the url of that page and inserts it into a field on the next page. The next page is obliviously a record insert page. The record insert page has the following fields. UserID...

But I have come across a problem where when the user creates a report they want all of there companies users to see the report also. So instead of each user logging in and creating that same report. I have placed a checkbox on the bottom of the save report page that if check will also make...

I need a little help not only on the backend part of this project, but the logistics of the project. First of all; my project is an order entry system. Several different companies log into the website to check status of their orders. I have this part working perfect. The login, the reports...

I need a little help not only on the backend part of this project, but the logistics of the project. First of all; my project is an order entry system. Several different companies log into the website to check status of their orders. I have this part working perfect. The login, the reports...

Email automatically send out an email when the value of a field in a record changes? For instance when someone looks at a record and the status says open. But they want an email as soon as the status changes to close. Can that be done and how or a brief idea. Thanks

This code was working until 3 days ago. i have no clue why. Does anyone see anything wrong with it?. Thanks a bunch. SELECT Holiday, HolDate, PERSON FROM Holidays WHERE ( Convert(char(20),HOLDATE,101) BETWEEN Convert(char (20),GETDATE(),101) AND Convert(char (20),GETDATE()+30,101)) AND PERSON...

How do i change the column name withouth changing any formats? Thank You

How do I delete all the Records in the table but keep the table structure the same. Any help would be great, Thanks Joe