Search results for query: *

i couldn't find a good example of this in my texts. I need to incorporate a if statement into my query. We add another field to invoices_staging_r100 called shiptype. If the company name = PHYSICIANS SALES then shiptype=STOCK ELSEIF the first 5 character of company<>first 5 characters of...

Did a dts import from an excel sheet and when you go into Query Analyser highlight the table then choose open table, all the records show like (...) (...) (...) (...) (...) (...) (...) (...) (...) (...) (...) (...) (...) (...) (...) (...) (...) (...) (...) (...) (...) (...) (...) (...) (...)...

I created a macro that basically parses a excel worksheet into separate worksheets per sales rep and also saves each worksheet into a separate file. The problem is that when the highlighted total bar is copied into a new file it changes color from a light grey filled background to a dark blue...

I have unique company name for e.g. company = "NEW YORK MED CTR" from that I would like make a function to encode it into some kind of alpha numeric code that would be the equivalent. I've considered maybe doing some kind of string to hex function, but haven't found much in terms of T-SQL...

I've got a simple trigger which places a timestamp in the lastupdated filed upon insert or update of the record. The trigger works fine, however i've discovered that when doing an import from DTS the trigger won't fire. (I know it's not a bug and it was designed that way.) Whats a simple way to...

need the code to do this on sql2000 should be simple. here is the table: comment_id integer primary key, user_id not null references users, ip_address varchar(50) not null, modified_date date not null, content varchar (255) I need a really sumer basic trigger where if any of these filed are...

question. I want to create a sales order database using access 2003 with access forms and reports on a shared network drive. I've created many similar type applications before, however this application I intend to have up to 10 users accessing the database simultaneously. I've found that I...

Problem: I want to be able to display an image on a web page that is pointed to a ASP script. For example. <img src="http://www.myserver.com/firstimage.asp"> firstimage.asp This file should recall a URL from the database that points to an image. I've seen this done in PERL and I assume it...

When I open my access database mdb i get a Security Warning message opening C:\db.mdb This file may not be safe if it contains code that was intended to harm your computer. Do you want to open the file or cancel the operation. This error message is annoying and the file i am using is perfectly...

I've seen it done before. Is there some setting in access where I can set it so when I open up a certain MDB file on my desktop I would just automatically open up my switchboard form?

On a subform I am getting this annoying error message "The LinkMasterFields property setting has produced this error: 'The object doesn't contain the Automation object 'tblMember'. Everything still works and is linked properly, any ideas how to fix that type of error or atleast suppress it?

I have a form that has just a set of buttons on that each of which will launch a report or form. There is no data on this form. Is there a way to turn off the control on the bottom that shows Record 1 of 1. Also there is a Verticle bar on the left side with a triangle. You can click it but it...

I'm working this query and just getting an syntax error. It does work perfect with SQL 2000 just haven't been able to make it work on Access 2003. Any ideas? SELECT ( SELECT COUNT(*) FROM Table2 AS cnt WHERE cnt.LNAME <= Table2.LNAME ) AS ROW_A, RTRIM( Table2.LNAME ) + ',' +...

I've been pulling my hair out to figure this query out. My output is sorted by LNAME, it also must show all the 8 row numbers from TABLEA even though only 6 rows exist in TABLEB. BTW I'm writing this query for access but it should work in SQL just the same. No stored proc or fancy stuff I need...

I've been trying to figure out how to make two data columns in an access report. basically the idea is that I want all the names appearing on one page so the list of names and SSn# data needs to wrap around onto the right side of the page rather than continue onto page 2. here is the basic...

ok I just need a very basic sql trigger and haven't been able to find an example on the net. please help. here is the structure table is vendor namefield create_date update_date --------- ----------- ----------- joeblow NULL 11/1/2004 janeblow NULL 11/3/2004...

I have a challenge where I need to add up two time expressions. In Shift1Duration and Shift2Duration the expression will return a value like 8:20 and 7:00. There is an additional column DurationTotal that must sum these two expression so 8:20 + 7:00 would equal 15:00 or basically 15 hours...

I have a windows NT 4.0 web server where I need to reinstall an ASP component specifically Aspload. Under windows 2000 and higher I normally register DLL's using regsvr32.exe However I was looking for this and couldn't find it in NT. There must be some sort of older program that was used to...

OK I have been an ASP developer for years and never use font page but I have come across some legacy pages on our intranet that were evidentally created in front page. There is a lenthly form that is filled out and submitted on our intranet and when I fill out the information and submit I get...

Question, I am creating some web based reports in ASP with data from SQL 2000. I have created a stored procedure which will create three dynamic temp tables called #Vehicles #Onyx #Sales And data in teach of the tables is populated. My question is, can I return mutiple record sets from the...