Recent content by Access_Person

Ok, despite the lack of responses I haven't sat idly by. I have created a crosstab query which actually adds up the total per "Agency" and adds up the totals for "hired"/"declined" for each Agency. Here's a visual rendition in case you are unclear: Source Name | Total |...

Thanks a lot for your reply, but I don't quite understand how to create a query that counts applicants by company. The applicants table has the "source name" field. There is therefore a company next to each person's name. I need to count the number of applicants but then I also need to find the...

! I tried your code (the first batch that you gave :p ) but got the following error in the following line: Private Sub One_Forward_Command_Click() Dim rs As DAO.Recordset Dim intNewRecord As Integer Set rs = Me.Recordset.Clone intNewRecord = IsNull(Me.Date) "Compiler error: Method or data...

I need to sort a report according to a value that is obtained in one of the text boxes in it. I have read on this forum that this is impossible and that a report can only be sorted based on the fields available in the table/query it is based on. Is this true? I also read that I must build...

Thanks a bundle! At first it didn't work but it set me of on a path of "Access Visual Basic self discovery". I ended up (after an hour or so of trying numerous dead ends) using DoCmd.CancelEvent due to the fact that Cancel=True prevented any error message from beig shown.

I still haven't solved this... anyone?

In my database when a combo box is changed to a certain value a validation rule is supposed to get turned on in an adjacent text box. My code works but it lets me tab into the now restricted text box (it's empty) and tab out of it without getting an error message. The only way I can trigger the...

Ok, I had the exact same issue to deal with and decided to search, following the ubiquitous advice of forum goers fed up with repeat questions. I used the above code (with a few modifications) but can't get it to work. Any help would be appreciated: keep in mind that those cookie crumb infested...

I didn't change that. It's the original setting. Why?

I tried that but it didn't work.... better yet when I deleted the form and pasted the old form (the old sample one) back into the database the form kept showing the data from my actual database. It's really messed up (yes, I did reboot excel between the attempts). But don't worry about that...

Like you suggested I made a copy of the DB where the code came from and attempted to play around.... However all of the nw tables are unreadable (boxes, strange symbols, etc) to the naked eye. I did open "MSysRelationships" but this table was empty. Does this indicate a lack of relationships? I...

That's exactly the thing, the sample database that I got this from has the exact same command and yet it works like a charm. Let me try finding a link.... Wow, I just spent a good 20 minutes going through yesterday's history but couldn't find it. Attached is the sample database.

I am attempting something similar to what you are doing (see this thread). What you could try (no guarantees since I have had no success myself yet) is to add the following code to the text box's on change event (open up properties, click on events, on change, and then go to code builder)...

I get the above error message when I click on a listbox that's inside a form. Here's the code that causes the problem: Edit:The set rs = ..... line causes the error. Private Sub Search_Area_AfterUpdate() Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[Applicant...