Search results

I have been working on this database for a few months now (it's quite the work in progress!) and since putting it on a network 2 days ago all of a sudden I've developed an error. Whenever I try to use a certain form I get the message that "an application error has occurred and an application...

Thanks for the suggestion, KKilfoil. I'm not sure how much work that would involve in changing everything, however it sounds like it would solve the problem of having all of the forms open at once. I'll have a look at it and see how much work it would be to make the changes. Thanks again for...

Thanks for the advice. I found that my problem was that I didn't have both forms open at the same time. I'll just have to work around that (if it's even a problem for me). I know that the setup that I have isn't pretty, but it's a difficult marriage of Excel and Access. The data is written...

I could do that, however I was being VERY simplistic when I gave my problem. I will likely end up having 4 or 5 forms, each form having 40+ control boxes based on this one table. (It's quite a table!) The formulae are becoming a little awkward for my non-mathematical mind, things like...

To be honest I haven't decided. There is no reason why I couldn't have them both open if that is easier. These forms are more useful in paper format anyway, so it may be that they are just printed. Does that help, or even make sense?

I'm trying to do a very simple calculation and I'm probably missing something pretty obvious. I have 2 forms, Form1 and Form2 which is fed from the same table. To simplify my question, each form has a box, Form1 has Box1 and Form2 has Box2. Form1.Box1 is a formula based on the table. I want...

Wonderful! Thanks pdx_man! That worked perfectly, thanks for your suggestion. Happy Holidays!

(I posted this yesterday but my computer sneezed in the middle of composing my posting and I don't see it anywhere. I apologize in advance if I'm re-posting.) I have a table with 3 fields: CITY, DATE and LOGIN_ID. I want to COUNT the number of LOGIN_ID's where CITY = "London" and the DATE is...

This should be easy, but I'm missing something. I have a UNION query that is combining 3 tables with identical fields. On my form I have a control box that I want to use to display the COUNT of all employees hired within a certain date. I can handle the COUNT part with no trouble, but I...

I have a database which reads an Excel workbook. There are 12 worksheets (one for each month) in this workbook and each worksheet has a range that is linked to a separate table. So there are 12 of these tables in Access. I'll try to be brief, but essentially each worksheet is a monthly...

Great - thanks PhilE - it seems to be working perfectly! Much obliged!

I have a form that has 3 check boxes and each check box has a corresponding combo box. For each check box, I want a user to check if the situation applies and if so, they then go to the corresponding combo box and select a value from the list. For example, say I have 3 crime categories -...