Search results

Could you tell us what errors they are getting? Could be anything from their local settings to reference settings so any information you could provide would help.

Sorry "psychotic lunatic" was meant as a term of phrase not a medical statement or diagnosis of a condition my apologies for any misunderstanding :)

To sum up, if the ProductCode from SalesOrders matches the ProductCode from PurchaseContracts, the OrderInTonnes from SalesOrders would be added up and the total going into the Offtake field. If Me.ProductCode = (Whatever you want could be another control or table lookup) Then Me.Offtake =...

Marianne is correct the Package and eployment wizard was in the developers edition of 2003 which included Access runtime which allowed you to deploy your database to people without access installed. The 2007 version however has been made available as a free download I don't know if this is...

Also hold shift down while access is starting up this will bypass startup features if you cannot see the database window goto Window>Unhide and you should see it there. Alter your startup options as usual and always make a backup of your mdb before taking and measures to secure it... good luck...

Could you tell us exactly what you did eg. Altered start up options etc..

Ahh ok thought that was what I was doing in the first place...

This is also linked to the genetically modified versions of "weed" often known as skunk (depending which part of the world you hail from..) which has far higher levels of THC which causes the psychotic symptoms and lower levels of another compound called cannabidiol which seems to protect users...

This is usually due to a spelling mistake referencing an object or not correctly identifying a field type such as text instead of numerical field. John :)

Assuming its just your wording of "schemes" is incorrect and you mean import the database objects e.g. Tables/Queries into another database then open the database you want to import to select file>get external data>import use the resulting dialog box to select the path of the database you want...

Have you looked at can/grow/shrink properties without seeing the layout of the report very hard to help... :) PS. Thats only part of the problem would really need to see the db to address the other issues..

And you’re sure the accountants get it right... Don't know about outside the UK but been developing a DB for a friend and discovered he now owes a large amount of VAT because of their advice.... Ultimately your accounts, record keeping etc are your responsibility no matter how good the software...

Amen to that :)

Yep Curtis is right was just throwing out ideas I use calculated fileds in queries as well which is ok as long as you don't want to keep historic data if the prices change :)

Surely some of the older records could be archived split the database and have links to several back ends to view old records if required? this could then reduce the overall size of each to a manageble amount but 50gb for text and numbers.... you say the companies being going a long time were...

You can populate other controls (textboxes) from a combo box by using something similar to: Me.WO_CompanyName = Me.cboCustomerID.Column(1) Me.WO_Address1 = Me.cboCustomerID.Column(2) Me.WO_Address2 = Me.cboCustomerID.Column(3) Me.WO_Address3 =...

This quote explains it better than I could: An MDE file is the same as a regular Access MDB database file, with the following changes: All VBA procedures are compiled — converted from human-readable code (more or less readable, anyway) to a format that only the computer understands. This...

I already use it and its a very good little app just asking if you had considered this :) thanx anyway John

"i'm sorry, that's not true." Sorry it is... just not found the bug yet.. By definition a database has "data" which it gets its results from so its not random you just asked the wrong question...

well to me looks like you want a multiple search criteria in your query something like..: Like "*" & [Forms]![frmYourForm].[MySearchText] & "*" That can be used in criteria of each field for your query to return your result.