Search results

Import as text then run an update query You will get dates that can be sorted any way you wish what Vince has sugested is a good answer Regards Bjackson

I should mention ,that sub will create a txt file for every querydef in the db including combo boxes,list boxes etc.If you just want the stored querys you will need to export them into an empty db and then run the sub Regards Bjackson

This is not my work but i have used it and it works. Of course you need to change "C:\qryDef" to the full path of where you want to create your txt file.If you have 100's of query it will take a couple of mins to run the sub Sub OutputQry() Dim qdf As DAO.QueryDef For Each qdf In...

If you import the field as a text field and not a date field you will get exactly the same as the txt file 2002/10/04,12:58:38,12355,3,1,2,2 Do you want to convert ' 2002/10/04' to another date format ?If so What format ? Regards bjackson

Try using the access built in documenter Select Tools > analyze > Documenter Regards Bjackson

Ken There is also another you can use which i find easier to remember VbNewLine Regards Bjackson

If its just a db password and not related to database security passwords try http://www.shatterock.com. They have a free db password sniffer that is extremely easy to use.Of course you should only use it for databases that you own. Regards Bjackson

For other access 2k users There is a known bug when dealing with numbers in a combo box not in the list event.microsoft mention that it is when the format of the field is set to currency,however it is also the same problem i am experiencing,although my field format is set as single Regards...

I am using the not in the list event to add the new value to a table.I dont want to ask the user whether to add the new item to a list, i just want it to be added.This all works fine except when the value entered is a number less than 1.Access adds the value but then prompts with the usual "the...

Heres one way Link to the file from your db. Run a make table query on the linked file Add your record to the table Re write a new file based on that table sorted in the order you require Overwrite the original txt file.All this could be acheived with one button click Regards Bjackson

Well here is my suggestion for a tab delimted txt file make 2 or 3 or 4 or however many copies of the txt file you want to import.Open access and create a linked table to the first txt file,Selecting only the first 40 columns and unchecking the rest.create a linked table to txt file...

Can you post a sample of the txt file ? It would be easier to make a suggestion if you know what the txt file looks like.Is it fixed width,comma delimited etc Regards Bjackson

Thanks Mile-O-Phile I'm not sure i can add or change anything in the data base as i dont know what effects it may have on the application that uses it. I was just curious, as this application is a relative expensive $20,000 s/ware program, that i assume was created by professional...

I am linking to a database that stores data from a VB application.This application uses the first 6 Characters of a Brand and colour as the unique id for the material. I am just curious to know Why this application wouldnt use an autonumber.When you look at the data its a mish mash of names...

Thanks Again I will Get There !! Regards Bjackson

Thanks for the help Pat The Table LaminateSizes Now has three keys.How Did you do that? The query still returns 3 values, so what i will try next is to set up a purchase order form with all the relevant criteria's and see what happens when i enter an actual purchase order. Again...

Thanks Pat I Guess its like "How Long is a piece of string?".What takes you hrs blindfolded takes me weeks.Even though i get it down on paper i still struggle to understand how to connect it.My parents were right,i should have finished school. Anyhow i will wait for further...

Pat Have i done the wrong thing by not following your advice exactly ? Regards Bjackson

Mike375 I tried to be polite in the my last post with you,but fair dinkum, you will give us Aussies a bad name.Instead of taking up the time of the many experts(And they are experts) in this forum,why not bundle up your program and make a fortune by selling such an excellent product...

Pat I set up tables as you suggested,which helped me realise that possibly i needed another table to reduce the amount of times i would need to enter the same price.When i started to fill a few rows of the table tlbCategoryprices it dawned on me that for every sheet size(108 of them) i...