Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SkydivingSteve

    Long shot... can you centre a label report vertically?

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

    Please help me debug my query...

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

    Changing IUSER settings using XP Pro

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

    Changing IUSER settings using XP Pro

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

    Excel to Access convertion question

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

    VBA to pull information into Access from Excel

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

    Single table (simple) SQL question

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

    Single table SQL question

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

    Single table (simple) SQL question

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

    Single table (simple) SQL question

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

    Passing formatted text in QueryString

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

    Passing formatted text in QueryString

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

    Passing formatted text in QueryString

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

    Dropdown list from dataview

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

    .NET using DreamWeaver vs VisualStudio

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

    Insert today's date into Access database

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

    Insert today's date into Access database

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

    Insert today's date into Access database

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

    Outlook 2002 - Import pst problem

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

    Outlook 2002 - Import pst problem

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

Part and Inventory Search

Back
Top