Recent content by dancarter

Hi, I get this error when trying to rung a piece of code: The expression On Load you entered as the event property setting produced the following error: Member already exists in an object module from which this object module derives. I have the EXACT same code working on other forms using...

I want user to be able to add a new record from the main form though, is this not possible?

I have navigation between forms and when a user navigations from the main form(candidate) to another form(1) and then back there is only 1 record displayed on the candidate form as it is only bringing back the record tied in by the application number. So if you then want to search for another...

I think my problem is that all of the data is held in spreadsheets at the moment and I've tried to mirror that to some extent. The received dates are for references for employees but even if I had each reference in it's own table I still don't see how I could perform the same query any easier...

In your query, right-click in the design area, choose properties and set unique records to Yes. Make sure you only bring in the company name to the query though. Hope this helps!

Hi, I want to run a query that returns only records where we haven't received 2 items for them from a possible 4. I can't seem to get my head around it! At the moment I have:- Recd Date 1 Recd Date 2 Recd Date 3 Recd Date 4 Is Null Is Null Is Null Is...

woohoo! hadn't seen that function before that works for me Thanks very much

Hi, I have some code that runs on Form_Load() It basically uses a case statement to say if a value in a combo box equals one set of values then make somethings visible and invisible, and for all other values make some other things visible and invisible. The problem I have is that I have defined...

Thanks, but if I try this in BeforeUpdate then I get the error:- Procedure declaration does not match description of event or procedure having the same name Any suggestions would be received greatfully? Thanks

Hi, I'm trying to populate a read-only field on a form with the time and date the record was last changed. This is to acheive seeing a list of records that have been updated this week for example. I have this at the moment:- Private Sub Form_AfterUpdate() Last_Updated.Value = Now() End Sub...