Search results

ideas anyone?

well it was nice to see the forum didnt keep my table format.. grrr! right well part of this post was a brainstorming idea, but this is my idea let me give you the updated table structure. ID | PartName | ComopnentID | No. in Stock | PrimaryPart | Installs | 1 | Part X | 2...

Hi, I need to work out how many components we have in stock that make up a Part - identified by being the PrimaryPart. Each part has a component, which in turn has another component, but different part have a different number fo sub-components, a simple display of the table I am using is shown...

http://news.bbc.co.uk/1/hi/england/london/6586879.stm its a weird feeling laughing and cringing at the same time!

yep those typhoons blow you away.. I work next to an airfield where they do some flight testing and that think does rattle everything in a 5 mil radius its so loud!

from ms.. Running the Compact Database utility within Microsoft Access can also improve the performance of the database. This utility makes a copy of the database file and, if it is fragmented, rearranges how the database file is stored on disk. When completed, the compacted database has...

apologies rich i r dyslexic.. as for the competition part think not so high profile as NASA.. think UK and this will give it away think Typhoon ;) the Saudi's reference was the original hint.. lol just googled it and you'l get what what your looking for! As for non-descript characters turning...

I've been considering it since my sporting days have been non-exsistent the last couple years but do you consider it to be worth it or just a waste of money?

You might need to genre'lise this topic b/c how can you compare say Some Like it Hot to Die Hard? both great films, both very difficult to compare because of how different they are..

Working for a large defense contractor (I wont disclose which one) but its the one which pretty much makes all the 'planes trains & automobiles' for the UK & US army & we do alota work for the other countries such as the Saudies. However as all companies do we had a team day the other day...

Tools > Database Utilities > Compact And Repair This will shrink it back down for ya.... there is a loada reasons why its gains in size buffers, actual data etc..

wats your application do?

From the sounds of it you are trying to create a Sales System Tracking db i.e. Have a root around in the sample db's section you'l find some very insightful stuff in thier & some good starting points. You also need to read up on Normalisation aswell...

more so i would check your date fields... is their a predefined structure for dates i.e. dd/mm/yyyy if so check that out & check no text is trying to be inserted into a date field of course a date can be inserted into a text field though. Also as i said Access gets funny about ' so if you're...

In the MSDE 2000 User Logins and Permissions Manager make sure the Read only user have db_datareader permissions chk box ticked and nothing else..

you copy & paste special your excel spreadsheet every day? thats not good db design at all , forgive me for saying! There are so much easier ways! Does this excel file get replaced everyday or just updated? If it gets updated then create a Link-Table to it there for you'l never have to...

Its weird I'm not sure if this is a general trend within the Access world but in my experience I have found that documentation on Compacting & Repairing a db has always been minimal to say the least. I know at uni we were barely told about it.. just a thought

Im not sure i understand your what you're doing a cookie is created on ones computer so that if he/she is to return to that program/site etc.. then essentially their details will be remembered. What your suggesting is that when the user enter their details you save it but as soon as he/she...

So you gotta search form that searches for a ViN Number. Then I assume this is attached to an IF statement saying something along the lines of: IF VIN doesnt exist Then Open form, populate this text box with the VIN blah blah... then you need the user to fill out other details on the form? or...

do you have some form of login for the user?