Search results

I think you may have misunderstood what I meant, but that is my fault as I didn't word it correctly. What I should have said is that I believe your FinanceMethod table should be related to your FinanceCompany table and not your VehicleDetails table, i.e. a Finance Company can have many Finance...

Can you upload your Database so I can have a look? Your relationship between Manufacturers and Products also appears to be the wrong way around...

Ahhh, its a 2007 Spreadsheet, I assumed your file ext was correct and that the Spreadsheet was created in a previous version. Anyway, sorted now so well done!

C:\Program Files\Microsoft OfficeXP\Office10\excel.exe "K:\Rapid\BST - general\Release Testing\Testing Database\Progress Stats Template.xls" This is what I use in the Command Line, just replace the file path for Excel app with your own and change the file path for your Spreadsheet

I just played around and On Load is the wrong place, it should be in the On Current only. With On Load it appears to set the change for the whole form (i.e. all records) based on the value of the Quota check box in the first record. Take the code from your On Load event and place it in your...

See the post at the end of this thread - http://www.access-programmers.co.uk/forums/showthread.php?t=130648 It seems the macro action is still available, just not displayed by default as is not a 'trusted' macro action.

Place the following code into your forms On Load and On Current events:- If Me.Quotas = -1 Then Me.Capacity.Enabled = True Else Me.Capacity.Enabled = False End If If you then require the ability to check the Quotas to enable the field manually, you need to place the same code into the...

I see where you're struggling with the FinanceMethod relationship. I would have thought the FinanceMethod should be linked to the FinanceCompany table, not the VehicleDetails table? You still need to do something about the invoices. Currently a supplier or purchaser can have only one invoice...

Just upload when you can and we'll check for you. Like I said you have made a good start, just a few changes needed. Its extremely important to get this right now as it will save you major headaches in the future!

Sorry for not getting back sooner, have been busy. I have to say that I was hoping that when I looked at your Database you weren't storing the preferred days/working days in a single field, which was what your OP suggested, but you are. I would have created a field for each day of the week...

Having had another look it looks like there should be a few more tables:- 1. Invoices 2. FinanceCompanies 3. ServiceProviders Also, you appear to be storing duplicate data across tables, i.e. you are storing:- 1. Model in the FinanceMethod table which is already stored in the...

No problem mate

nice one, glad to be able to help!

Like I said, my suggestion was based on the assumption that the text boxes to be hidden/unhidden were bound and even then I agree that there really doesn't seem to be much to be gained by going through all the effort of doing this, but I offered the solution and it is now down to him. I have...

I don't think so, surely its along the same lines as using Access as a front end for the Database so should be fine.

Then you won't have a problem doig it the way I suggested. Simply link the table to your DB, set up your append query and maybe attach it to a command button so you can turn the warning messages off. I've just tested on one of my Databases with 8000 records and it took seconds so you wont be...

How many times do you need to run the append each day and how many records are we talking about each time?

As long as you have a primary key set I don't see why you can't just do a straight forward append as any duplicates will be excluded anyway???

I don't use lnk criteria often either, but I would think it should update the data on form 2. Either way I believe you are correct in saying that the save should occur before the OpenForm command

Would I be correct in assuming that the text boxes to be added are existing fields from the query/table the form is based on? If this is the case (and I do hope it is), then you obviously have a limit on the number of text boxes that can be added, eg you only have so many fields. This could...