Search results

So I have been working on this project for about a month now. It is almost done. During the course of it's development I have created about twenty tables whose sole purpose is to house data for use in combo and list boxes. They have no other purpose. I am now in the process of creating the...

As you may remember I needed a way for the underlying for frmEmployers to go to the specific record after the new record was created. The form frmEmployers is not sorted by EmployerID but rather by Company name for ease of scrolling through the companies. Because of this acLast would not work...

That generates the error 'can't find the field 'frmEmployers' referred to in your expression'

So I tried this and no go I tried a couple of variations of it This one did not work at all because there is no form called Navigation Form Forms![Navigation Form]![frmMain].SetFocus Docmd.GotoRecord, , acLast I found an article that suggests that the container on a Navigation form are...

I am creating a database in Access 2013 I have created a Navigation form using the Navigation form tool and called it frmMain I have added two forms to the tabs on the navigation form called frmClients and frmEmployers On the frmEmployers form there is a command button (cmdNewRecord) that opens...

Yup. That did it Thank you

That did not work. It still lists ALL of the records not just the filtered ones I placed this at the end of my existing code. Should it have been at a different spot.

I have a form that has a control to search the table for a specific record See code below that is on the AfterUpdate event of a Combo Box Set rs = Me.Recordset.Clone rs.FindFirst "[ClientID] = " & Str(Nz(Me![cboName], 0)) If Not rs.EOF Then Me.Bookmark = rs.Bookmark...

I am in Edmonton. But what I really need is someone I can call, Give remote access to and discuss the issue I need the person to be somewhere in Canada because of long distance costs Are you interested

I am looking for someone that lives in Alberta in Canada who would be willing to assist me with a database. The work has been done by two people, myself an one other person. The other person wrote a massive procedure that I need modified and that person is no longer around. I am willing to pay.

Ok call me dumb. What is an OP. So I checked out your sample and saw that you used two queries, yhis allowed for the join to be changed. So I decided to apply this to my existing query(s) to see if I could duplicate your work on my files. It worked. Sort of. The addictions category did show a...

I am sorry. I did not intend to ignore you. I thought I had replied and stated the error that happened when I tried that. I looked back and there was no reply from me. I truly do apologize, I obviously did not hit the submit button

I am sorry. I did not intend to ignore you. I thought I had replied and stated the error that happened when I tried that. I looked back and there was no reply from me. I truly do apologize, I obviously did not hit the submit button

Ok I have made a change to the query. It now includes the Disability Categories table. This has ALL of the categories in it. I still can not get the addiction category to show up. Here is the code and I will attach the new database. SELECT tbl_DisabilityCategoryList.DisabilityCategory...

In this example that is correct. This table is used to gather a group of clients based on many different criteria, this one being 'Active"

Thanks for all the input Guys. In this case I am dealing with an existing database that would screw up way to much to change the table structure. Addictions is the one that has a Zero Count in this example but it could be any of the categories and even more than one. And I need a line in the...

There really are no calculations. The underlying query of the report does a count of disability categories. It works fine except when it finds a category that the count is 0. I need that to show Here is the code SELECT tbl_Disabilities.DisabilityCategory, Count(tbl_Disabilities.DisabilityID)...

I have a report that is causing me some grief. There is a main report that has about 7 subreports in it. Each one of these subreports is based on a query that does a count on categories or codes and reports the number of each based on counting an ID field. Here is my problem. If the one of the...

Found It On the report properties set the Page Header property to all pages. By default it is set to Not With Report Footer

I am about to rip my hair out. How do I stop the report footer from printing on a separate page. I have seen several suggestions here and othe places and nothing seems to work.