Search results for query: *

Can anyone help with this problem? Page one has a drop down where the user selects a Site. Site is passed to page two where the selection is used in a SQL where clause. That works fine. Page two has click to sort column heading which re-loads the page with Order By info. However, when the...

Thanx philhege, that did it. (lastname+',%20'+firstname) AS URLNAME

I Create a list with this query: SELECT lastname, (lastname+', '+firstname) AS NAME This results in a name correctly formated as Doe, John It displays as a hyperlink: <cfcol header="Name" text="<A HREF=owner.cfm?name=#name#>#name#</a>"> Clicking brings up the owner.cfm page, which gets info...

If you are using Internet Explorer you could check Tools, Options, Advanced, Multimedia and be sure there is a check in the "Show pictures" box

When editing a page in Dreamweaver MX 6.0 the styles (linked to external CSS) are not rendering. Is that normal behavior in Dreamweaver? They do render when viewd thru a browser or when I edit in Front Page. I'm not sure what is normal or if I have something turned off. Thanks for any advise

Thanx linney. The registry edit procedure allowed me to change it to an X instead of the G. This is a work-around, but seems to be ok. I have never seen the FAT partion on the C drive be given a drive letter before.

My computer has started mapping the FAT boot sector as letter drive G. It boots ok, but I need G for something else. Any ideas on how to move it back to not having a drive letter map. I can’t do anything with it in Disk Management. It is a primary Fat partition on Disk0 (same as the C drive)...

I installed XP pro on a couple of computers and assigned them both to a workgroup (not a domain). I also set up the user accounts. Now, when the computers start up the users names are listed on the screen. They click their name and log in. I would prefer the traditional Ctrl Alt Del to get an...

Thank You, that did the trick.

I have a single Server with a single database with multiple tables. I want to split off some of the the tables into a seperate database on the same server. I have been able to do that by various methods - attach, copy, restore and giving the new database a new MDF and LDF name. Then just...

Thank you. The cfif IsDate thing works as a fix. Other info: There is no mask, no default value, and if I add data via a Microsoft Access front-end, the date field stays NULL if no data is input.

I have an insert statement that inserts data from a form into a MS SQL table. One of the fields is a date. If the user leaves the date blank (perfectly acceptable) It inserts as 1/1/1900 rather than Null. To avoid that I am testing for no date input, then if blank it uses an insert statment that...

Ok, thanks for the advice. I guess I will split the table up and go from there. Thanx. I gave you a star for not encouraging me to head down the wrong path.

I have a table which contains “hours worked” for different trades (electrical, plumbing…) there are 14 of them. A single record has a field for each trade. There is also a field for total hours, which is the total of all trade’s hours for that record. I know this could be calculated at runtime –...

You may want to try TOOLS, Database Utilities, Compact & Repair database. Then, open a form in design view, click the "Code" button on the toolbar, then in the Code view click the "Debug" tab and select "Compile" then try makeing the mde again.

I know this is an old thread, but here's how I solved it for myself : It is explained in Microsoft support article ACC2000: Write Conflict Error When You Try to Update Records in a Linked SQL Server Table View products that this article applies to. This article was previously published under...

I want to select a name from a select option, and have related information show up in other boxes based on the name selected, on the same screen. I can do a second query on a second page to the get the data, but is there a way to get it on the first screen. This code works to populate the boxes...

How would I get a list of distinct records, with a count of how many occurances of each there are? I want it to look like this: NAME COUNT John 5 Tom 10 Nancy 25 I think it would use DISTINCT and COUNT, but I can't seem to get it. this doesn't work: SELECT DISTINCT name, count([name]) as...

Have you thought about running it as a &quot;Published Application&quot; thru a Citirx / Nfuse server? It's a quick way to launch an existing application to the web without doing any reprogramming. Read up on www.Citrix.com to see if that may be a solution. Not cheap, however.

I'm not sure if I used the Format as you described, but I was able to get it to work by using it in the Row Source box SELECT Format([invitemcode.itemcode],&quot;00&quot;) AS ic, INVITEMCODE.itemcodedesc FROM INVITEMCODE ORDER BY INVITEMCODE.itemcodedesc; I don't understand why the zeros were...