Recent content by SkydivingSteve

The title says it all! I have a very successful Access label report. The client would like the text centred vertically within the label... can it be done? Steve "how much can one body take? ...the concrete shoes, the hungry lake.

The following query SELECT CoursesIndividuals.ID, CoursesIndividuals.FirstName, CoursesIndividuals.LastName, Courses.Date, CoursesIndividuals.CourseName, CoursesIndividuals.Attendee, Courses.Venue, CoursesIndividuals.StartTime FROM CoursesIndividuals, Courses WHERE...

I have an "Unspecified error" (error code = 0x80004005)" on my local machine. I need to make sure IUSER has access to the temporary file whose path is defined in the environment variable (C:\Windows\Temp). MS support (http://support.microsoft.com/kb/251254/en-us) says, "Also ensure that the...

Can somebody talk me through changing IUSER access on XP Pro. Assume I don't know anything about IIS (not far from the truth!). Thanks in advance. Steve

You can't, to the best of my knowledge, simply convert the Excel workbook to Access links and all. You'll lose the formulas and lookups. The best I can suggest is that you do as xlhelp suggests and import or link the Excel tables and then recreate the relationships (and normalise as you see...

I've got users completing timesheets in Excel and I need to get this data into Access programatically. Could anybody point me towards some resources? The user must use Excel for the timesheets and the format is not changeable so I must use code from within Access. What I'm thinking of is...

Reposted in ANSI SQL forum. Thanks! Steve "you are the only thing that shines

Let's say I've got a table called Q1. OK I really do have a table called Q1. What I want to do is show some of the values as they appear in the table (SELECT firstname, lastname FROM Q1 WHERE somecondition). For some of the fields I want to return a flag intstead of the field value if a...

PH, This is great! Many thanks. Can I ask a follow up question? This is obviously not standard SQL, is it possible to achieve the same thing in SQL only? Thanks! Steve "My mind, blow out the candle

Let's say I've got a table called Q1. OK I really do have a table called Q1. What I want to do is show some of the values as they appear in the table (SELECT firstname, lastname FROM Q1 WHERE somecondition). For some of the fields I want to return a flag intstead of the field value if a...

OldNewbie, Thanks and sorted. It was just a case of HTML enabling the text field. Thanks! Steve "I've seen some strange things, under the bed

Thanks oldnewbie. 1. Not sure. How you you HTML enable a textfield? 2. Display the text Steve "Big Black Nemesis

I've got a Flash movie and I'm passing a variable to it using a QueryString (<param name=movie value="blah.swf?flah="Telephone" ....) It works fine - the text passed in variable 'flah' appears as text in the movie. I want to use the variable flah to format the text as bold, something like...

I have two dropdown lists; Building and room number. They are both poplated from a database. So far so good. When the Building is selected, I want the Room number to relate only to the appropriate building. I can do this easy with two trips to the server. I want to do it with one trip only. So...

For simple stuff, I'd stick to DW. I've found it a fab package to work with for web design (although I haven't used it for .Net programming). The guy that told you about spurious code from MS was probably thinking of FrontPage, not Visual Studio. VS is a pretty hardcore development environment...