Recent content by brother

Hello everyone! I'm building a report with 5 subreports in it. Each of the 5 subreports is divided by a page break in between. The reason for using these subreports is that I have to include a lot of graphs in the report, and each of the subreports is based on different tables. Now, I'm also...

I think I'll go for your (much simpler) solution Gizmo, me.invoicenumber = nz(dmax("invoicenumber", "invoicedetails"), 0) +1 Found in this thread. Thanks again for your tip!

Thanks Gizmo! I will search the forums and check it out. Fortunately the system will only have one user at any given time. It's not important that the system remembers deleted records or not. I wrote some code for the continuous form I'm using. Put on the forms before-update event: Dim db...

Hello! I'm currently building a db at work. In one of the tables I need both a random autonumber field and a increment number field. Can this be achieved at table level, or do I need to apply some VBA at form level? Thanks!

Thanks for your responses. I'll take a closer look at your link LPurvis and see what I can make of it :D

Hi! I'm writing an append query in SQL/VBA and I want to be able to trap errors when running the query. Using .Execute is a good way to do this, the only thing is that is does not work when refrencing to a form field as a criteria. Ex. [Forms]![frmExample].form![txtExample] Is there a way to...

Hi James, I found the similar post, I should have done better research before asking. I'll take a look at this approach once I get back to work, and post my comments. Thanks alot :)

Hi guys, I'm currently in the process of making a database that will store data from a questionnaire we are handing out at work. This questionnaire is quite comprehensive and has a lot of questions, which means that I will exeed the maximum allowed number of fields in a table (255). So, now im...

Hello there, It seems that when opening in acFormReadOnly, the forms design is saved and becomes the default view. This is strange, because there is absolutely no code or event telling it to save. Furthermore, when testing the exact same database in ACC2007 (both with and without converting...

Hi, I have three buttons that open the same form in different data modes. The different modes are: acFormPropertySettings acFormEdit acFormReadOnly The event code looks like this: DoCmd.OpenForm "Form2", , , "[ID]=forms!Form1.form![ID]", acFormReadOnly Now, over to my problem. Everything...

Thanks HiTechCoach! To anyone who is looking for the same thing, here is my solution: The button btnProject on FrmMain has the following Event: docmd.OpenForm "FrmProject",,,"[CustomerID]=forms![FrmMain].form![CustomerID]",,[ProjectID] In the OnLoad event of FrmProject I have written...

Hi, I have a form named Form1 with a subform Form2. How can I open Form1 from another form and find a specific record in the subform? This code only filters by customer, and not project like I want it to. docmd.OpenForm "FrmProject",,,"[CustomerID]=forms![FrmMain].form![CustomerID]"...

I've thrown together a db in ACC2003 to try to illustrate your problem as I see it. ACC2003 does not use embedded macros like ACC2007, so this is all done in VBA. In my example there are three variarions of the where condition that is passed to another form. 1) The where condition from your...

DCrake, The challenge here is that the chemical name in the database will sometimes be different from the filename. That is why the code should only pay attention to the number before the separator #. Autonumber#Chemicalname.pdf Is this possible?

Hi guys, Could someone please point me in the right direction on my last post please? Thanks!