Search results

I'm not storing the data for long in the table, amongst the process the table will get deleted, and re-created. But for the purposes of this exercise is ideal!!!. Cheers!!!

Hey Thanks Sorry for not getting back to you earlier!, Thank you very much for doing that!! Works A Treat!!. Where would we be without you people! It is always nice to have a fall back option when you are stuck!. Thanks Again!

Sorry I have had to re-posted this one!!! Hi People, I have a table which has the following fields: CreateFieldNm , startvalue, endvalue TEST1 1 56 TEST2 57 120 TEST3 121 245 basically what needs to happend, is when user enter the createfield name , start and endvalues. the code will...

Wayne, I hear what you are saying !, but the reason i am storing numbers in a table like described is to then use that table as a lookup table. I have a table with equipment(boxes) that store different quantities of items. The quantities that can be loaded into each box depend on two...

Hi People, I have a table which has the following fields: CreateFieldNm , startvalue, endvalue TEST1 1 56 TEST2 57 120 TEST3 121 245 basically what needs to happend, is when user enter...

dcx693, Thanks for that work perfectly!!!!! cheers

Pat, The make table query is making a table not for the listbox, the table created will be used for process information in other tables. The list box idea on the form was to show the new recordset for that table. Sorry for not making myself a bit more clearer!

help!!!! lstemail.RowSource = SELECT TblEmailRecords.Name, TblEmailRecords.EmailAddress, TblEmailRecords.CategoryA, TblEmailRecords.RecipentType FROM TblEmailRecords; I have put this code on a button, but what needs to be amended? for it to work. Where do the brackets need to go?

Thanks for that i will give that a go, seems easy enough Thanks

Hi People, I have and table of records which is bound to a list box on a form. The table is is created via a make table query. I run the maketablequery from a button which is on the form which has the bound listbox to the table. what i want to do is run the query and then requery the list box...

Thanks guys for all the help!.

That is much clearer, thanks for that!!

I need to store mutiple values into a variable, but i have never used an array. Can somebody give me an explanation on how to use an array. May a brief example would be very useful. Thanks Milan

Thanks for the example!. That work fine!

Hi People! I have tables being imported into my database (all ok now!), but i need to transfer the information into a new working table. Is there anyway i can get access to give me the names of new fields in each of the imported tables. As each table has a different number of fields!. Thanks

Here's more background!! Basically i have a routine in my current Access database that imports Mdb attachments from Ms Outlook and saves these attachments into a importfolder called "importmdb" . The mdb's that are being imported to the "importmdb" folder can be any one 16 different types of...

Probably not, the name of the Access Databases that i want to import have different names!, which keep changing as users put files into this import folder!.

Hi People, I need to import a table from another access database into my existing database. However i the imported table to transfered to an existing table, rather then it create a new table in my existing database. I am using the Transfer database command, but i cannot get it to transfer the...

Hey! Thanks for that site . Real useful!!! Will hopefully get better at sql!! Thanks

Thanks for that advice !. It has cleared things up. So i will now use Quotes when i paste. One more question if i may trouble you!. Well i am quite interested in the way access makes the sql part of the code for you when you create a query in design view, then view it in sql view. I want to...