Search results

By the way... if you need to open the db in design mode hold down shift and open db!~)

ok.. I had a quick look and made something that works but maybe not with all the functionality you had in mind looking at your original data.. So you have to take it from here... and help from the forum!~)

everybody wants everything today... so I have to try again tomorrow.. sorry ..if you upload your db, maybe someone else can lend a hand!~)

Glad to help!~)

no.. it's a message board.. check my profile..

Hi lk12!~)

...and I have just been moderated for posting my email address!~)

If your table was something like this: ID, Name, SupportType, SupportDate then a query could look like this: SELECT TableName.SupportType, Count(TableName.ID) AS SupportCount FROM TableName WHERE (((TableName.SupportDate) Between [Enter start date:] And [Enter end date:])) GROUP BY...

Det er noget af en opgave!~) Smid en email hvis i er interesseret i lidt hjaelp... [email removed by moderator]

When I get a moment I will try and give your db a push in the right direction... Probably tomorrow morning..

which version of access are you using?

You need to restructure your db... sorry... Your relationship layout should not contain cascade delete related records. As it is now if you delete a client you will loose every rawmaterial and delivery related to this client. The relation between RawMaterial and deliveries should be between...

can I have a quick look at you database?~)

DoCmd.RunSQL "UPDATE [Hardware Asset]" & _ " SET [Hardware Asset].[OS] = '" & Me.[OS] & "', [Hardware Asset].[State] = '" & Me.[State] & _ "' WHERE [Hardware Asset].[AssetNumber] = '" & Forms![Hardware Asset Update Form]![AssetNumber] & "'"

if you need assistance you're welcome to take contact and I will run through your db's!~)

...this will show you how much still needing to be delivered... if you want to know the total quantity from the other table you could use the above mentioned approach and change NameOfToBeDeliveredField with DLookUp("[NameOfTotalQuantityField]","NameOfOtherTable","NameOfTypeFieldInTable = '" &...

Just add a field to your form and in the control source you write something like: =NameOfToBeDeliveredField - NameOfItemsDeliveredField

I just downloaded it to a machine with Access 2007 and it worked... my reference shows Microsoft Access Library 12.0 reference. agalti068> I now my English is a bit funny!~)

Have a look at this example based on your db: http://dl.dropbox.com/u/7719196/Imagetest.mdb

Hi, I'm extremely busy.. but if you send your db to (..got it..) then I will give it a quick update, with the code from the previous link!~) ...then you can have a look at it again and it might make some sort of sense...