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 Chriss Miller 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. jdrawmer

    5 table SQL Statement

    Hi Alex, I'm running the query through my VB.NET code. Its straight from the SQL Server database and table, as i have no data bound objects set up its all code based. it doesn't like the quotes at all, but i'm reckoning it must be some form of date formatting i'm missing on first, second and...
  2. jdrawmer

    5 table SQL Statement

    well the format in the SQL database is **/**/****. and to my knowledge the format of a VB.NET DateTime was the same, however it just doesn't seem to. I may have to write a little conversation function to convert the string into the EXACT format of the database, but having changed it to a string...
  3. jdrawmer

    5 table SQL Statement

    i'm using SQL Server; and i'm writing my system with VB.NET. Its strange. it doesn't accept the #'s, but also says it cannot convert from char to datetime (because of the single quotes). I've found yet another way round it, and that is to say... for each row for each cell in rows...
  4. jdrawmer

    5 table SQL Statement

    hey, i'm working on a simpler method, but more long winded of firstly finding all the users favourite jobs and their subjobs... then, for each one of those putting a blank entry into my VB.NET DataGridView. Now i've got a query that finds any of those subjobs, and matching dates that have any...
  5. jdrawmer

    5 table SQL Statement

    Hey dude, Thanks for getting back to me - and understanding my ridiculous thread! lol I think this is getting towards what I need to be honest. Getting some inexplainable results in the joins though as you imagined... I'm currently testing the data with... ==== FavouriteJobs ====...
  6. jdrawmer

    5 table SQL Statement

    I am effectively trying to create a timesheet system for an engineering company. They have a list of 'favourite jobs' that automatically populate their timesheet for the week. Another problem is, that jobs all have sub-jobs, for the purposes of booking time to them, to then later invoice... What...
  7. jdrawmer

    problem with 'item send' event

    I've got an item send event on my outlook macro, and when the send button is clicked, i am wishing to bring up a form - really simple: Sub Application_ItemSend(ByVal item As Object, Cancel As Boolean) frmOutputControl.Show If frmOutputControl.txtCancel.Text = "Yes" Then Cancel...
  8. jdrawmer

    Deploying Outlook Macro

    Hi, i've posted this the other day, but really need someones help with it. I've recently finished work on a macro within outlook, for a small engineering company - to help manage their contractual emails (saving them to job folders, saving emails seperately, etc.) And i've been testing it...
  9. jdrawmer

    Deploying Outlook Macro

    anything anyone? Surely i don't have to export all files and forms, and import them to the target machine?
  10. jdrawmer

    Deploying Outlook Macro

    Well, as this has been my first time programming macro's in VBA for outlook, I am completely unsure as to the best way, or whatever way, to deploy my application to the rest of the company! Its a program to help maintain contractual emails - incoming and outgoing, and I need the macro to be...
  11. jdrawmer

    When Form is closed, not close only hide

    Never mind just got your second reply, that worked a treat! thank you very much!
  12. jdrawmer

    When Form is closed, not close only hide

    i'm sorry, but it doesn't seem to do very much. Do i have to trigger this sub with anything when the form is deactivated or anything? Its not the end of hte world if i can't do this, but it would make the system a lot more user friendly Thanks a lot
  13. jdrawmer

    When Form is closed, not close only hide

    this may be very simple, and i'm sure it should be... but when the 'x' button is pressed, i don't want the form to unload completely, i just want it to hide... And its really not happening for me! Any help would be appreciated. Thanks!
  14. jdrawmer

    List of Directories

    i might check that out, but for now its working perfectly as it is. Thanks a lot
  15. jdrawmer

    List of Directories

    thanks a lot. I thought it would be something along those lines, but thats great! Jay
  16. jdrawmer

    List of Directories

    infact, thinking into it a bit deeper, what i could do with, is the drop down list containing all sub-dir's of a directory, even sub-dirs of sub-dirs e.g. Input Input/Drawings Input/Pictures Output Output/SomethingElse Output/SomethingElse/Again Would the best way, be to create a function...
  17. jdrawmer

    List of Directories

    thats brilliant, thanks a lot!
  18. jdrawmer

    List of Directories

    Hey, I'm sure i've done it before but i have no recollection of the answer - and would like some simplified code anyway... I'm trying to populate drop down lists with the sub-directories names, of a specific directory. So really, i just need the code for bringing up a list of directories Thanks
  19. jdrawmer

    Moving to next sheet in excel (Using VBA)

    as far as i know with my experience of VBA with excel, there is, like most things, a display name for a sheet, and its actual name. Do you keep the actual names as Sheet1, Sheet2 etc. Or do you change its display name AND its actual name? If you keep the original names and only change the...
  20. jdrawmer

    Outlook deleting flagged mail

    Hi Guys, I've got some outlook code which manipulates emails, saves them elsewhere, and now i am required to simply tick a box thats says 'delete original' which basically, will delete the original from the inbox. My method behind this was to flag the email as 'olFlagMarked' and then a simple...

Part and Inventory Search

Back
Top