Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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!

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

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

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

thats brilliant, thanks a lot!

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

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

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