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...

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...

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

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...

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...

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...

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 –...

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...

I have a form with a combo box for the user to select a code from one table which then populates another table. The tables are linked MS SQL. The fields are nvarchar. The codes are 01,02,03 etc. If I type the code into the table the leading 0 sticks, but if I select from the combo box the...

Does anyone know how to uninstall SP4? It does not show up in Add or Remove Programs in Control Panel. It may have been installed without saving old files. I'd prefer not to re-install the OS if I don't have to. thanks

I have a form with a drop down list on which the user selects a criteria to be used to generate a report based on a query using the selected criteria. It worked as and .MDB, but after I ran the upsizing wizard to convert to a .ADP it no longer passes the selected criteria from the form to the...

how can I change the behaviour of windows explorer so that when I open it it does not expand the C: drive and jump to Documents and Settings?

Is there a way to set CAPS LOCK on when a form is opened, and set it off when the form is closed? I want all user input to be in uppercase. Thank you

I have a form with a subform. I want the subform to not be visible unless a command button is clicked, which sets the visible property to true and the subform displays. I can set the property in design view, but what is the coding to toggle with a command button? This does not work: Private...

Is there some way to force a page break in a report when a grouping (group header field)changes? Thank you

Is it possible to specify a class in a span (or div, or table, etc) that will allow hyperlinks to pick up the class behaviour without specifiying it in the <a> </a> tags? I have this external CSS .textmenu {font-size: 10pt; font-family: Arial; } a:link.textmenu {color:blue...

Is it possible to capture the users windows authenticated logon information (user name)? CurrentUser uses the Access Security. I don't necesarrily need security; I just need the network logon information. The info will be displayed, or written to a table. thank you

I created a select query in Query Designer which gets data from a linked MS SQL server table. It works, and the recordset is updateable. Then I converted it to a SQL Specific Pass Through Query. It still works, but the recordset is now read only. Does anyone know if pass through querys are only...