Search results for query: *

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

Thanks jbenson. I'm sorry if I wasn't clear in my initial post.I know where the problem is; there's a datatype mismatch is in the line; objCmd.Parameters.Add("@entered_date", DateTime.Now); I'm looking for the correct syntax to cast the .Net DateTime.Now datatype to an Access date datatype...

jbenson, Same line objCmd.Parameters.Add("@entered_date", DateTime.Now); DateTime.Now from namespace System.Globalization . The property is working o.k. as I've tested it by casting to a string and response.writing it to the page. Steve

Using C# / ASO.Net to create a record in Access. I'm having problems figuring out the syntax to add today's date into a date field in Access. The error message I'm getting is "Data type mismatch in criteria expression. " and the line flagged is "objCmd.ExecuteNonQuery();" Any thoughts...

Thanks for the replies. To answer questions in turn; 1 login I have admin rights 2 person who exported the pst is away. I can't reach him - I'm not sure how the export was done. 3 I've tried all the options. Same result. 4 Outlook 2002 5 It's not read only. Thanks for all your help. Steve

I'm trying to import a pst file created by someone else. Everytime I go to File -> Import and Export -> Import from another program or file etc The process appears to work and I don't get any error messages. During the import process, I get a personal folder appear in my folder list but this...