Search results for query: *

..forgot to add - the first list box may not necessarily have 1st in it / the 2nd list box ;2nd etc ie they may not be in order eg first listbox value = 3rd , second listbox = 1st etc - so i need to match the order they choose in constructing my SQL string !!!

Thanx - ill give it a go (when i get the chance)

I have asked users to choose from 8 listboxes the values 1st,2nd....8th. This corresponds to fields which they wish to return and group by in a query. Therefore i need to translate these values into ordering the corresponding fields correctly in a SELECT (and GROUPBY) statement. What is...

..none of any use - im new to this !! - i looked at collections - but can't find a way of ordering the strings

I have a collection of string values which contain any or all of the values "1st", "2nd".....up to "8th" OR "n/a" What i need to do is first discard those with value "n/a" then order the remaining strings, "1st" to "x th" ..any help gratefully appreciated Elliot

For the last 2 years I've been running an access97 mdb (on windows nt)which contains a module which uses office 8.0 references to perform the following code to search for .dat files : With Application.FileSearch .LookIn = "C:\My Documents" .FileName = "20*.dat" If...

I am current administering a client/server mde which uses VBA to transfer Access 97 field data to a Word 97 template to create new documents and then email them through MS Outlook 97. As far as creating the documents - no problems. But when the emailing procedure is called it throws up amessage...

I am running an access 97 db in a multi user environment. A couple of tables require a lot of MEMO fields for the users to enter detailed notes. This seems to have caused errors due to the overall size of the records - there is no supporting help file in Access - can someone please help - is...

In MS Excel, you can use the date type format [h]:mm to express time values over one day in the form of hours and minutes e.g 46:23 (would be equivalent to 2days 2hrs 23mins) and these can be added together. I need to know if MS Access can create this format. I have tried the Format function but...

That would work if I used a startup form as the splash screen - i could do that, but i'd still see the standard access splash when the application loaded - it's that which i wish to replace

That would work if I used a startup form as the splash screen - i could do that, but i'd still see the standard access splash when the application loaded - it's that which i wish to replace

i have just worked out how to replace the standard splash screen in Access 97 but do not know how to create a PAUSE so that the splash screen is visible for a tangible amount of time b4 the database loads up - at the moment it only shows for a fraction of a second !!! - Any help please!!!

I have just worked out how to send emails in Outlook from Access - including Subject and Body text - how do I include attach any files The mailitem object has a .attachment method but I dont know the syntax for pointing it to a certain file - can anyone help ?

Unfortunately I dont have that option - i was wondering if it could be done in vba using connect strings perhaps

I am building an Access data base which needs to link to a few Oracle based tables via ODBC. This works fine except everytime the database is opened and I try to access these tables it asks me for the Userid and password for this connection - is there any way I can automate this process so that...

I am working on a Form based Access system. The form needs to have a button which triggers a mail merge of the record details into a predesigned form letter in Word 97 -How do i write the code for this ?? Please help ASAP Elliot