Recent content by dxqwest

I check the subreport properties and it is set to 'None'. The problem is that when a person goes on the form they enter their information that go on the main table only once but they can enter as many as 1 however many entries needed in the subform which goes to a 2nd table. I have the report...

I developed a form with a subform with both having its own table and I am wanting to create a report that reflex information off the main form and subform by have a report with a subreport. The main report is based off one query and the subreport off another query. I have it working to the point...

I just received notice that my boss does not want a look up fields for the name and pin #s because we want to keep this information confidential. Is there still away I could do what I want without a lookup field but maybe have this information stored in a different table.

Jack Cowley Member wrote: Using DLookup to see if the entered Name and PIN exists in your table should work for you... If IsNull(DLookup(....)) Then Msgbox "You are not authorized" Exit sub End If Before I set up this code, how should I bring...

I have thought of that but that would take more time than I have, sense there are about 300 people in this building and about 200 people in our Minneapolis building. Is there any other way?

In a spreadsheet I have a list of users and their pin numbers. On my form I want to develop two text boxes that the user enters their last name and pin # and a button that they click on verifies the name and pin # which then determines if they can enter in data. How would I go about doing this?

When using more than one column in a combo box will a query be able to recognize both columns as a value or just one?

jatfill, Thank you so much!!!!! It does work and just in the nick of time because I have to present this database to head district boss with a 15 page presentation on Monday. Again thanks a million to you and the ACCESS WORLD FORUMS!!!

jatfill wrote, Is the "% To Objection" field just a number, or is it an actual percentage calculation? Also, if you're doing this from VBA, it would be done differently... the code I mentioned above would be appropriate as a query expression, or as the control source on a report or form...

I tried that expression but I am still getting error messages "Compile err-Expected : )". This is what I have so far, IIf(IsNull([% To Objection]),"No Data Available",IIf([% To Ojection]<100,"D - Needs Development"),IIf([% To Objection]>99.9 and ([% To Objection]<115,"M - Meeting...

I have a question on building an expression through the expression builder in my query or in my report or in VBA. I have a rating field which need to auto populate from a % to objective field. If the % to objective field is 99% or less then the rating field needs to auto populate to "D-Needs...

iif (obj = 99 or obj < 99, "D-Needs Development", (iif( (obj >99 and obj < 114.9 ) or obj = 114.9,"M-Meeting Standards", (iif ((obj >114.9 and obj <200) or obj = 200, "E-Exceeding Standards)) ) ) Now do when I enter this in my VBA it gives me an error response of "Compile err Expected; list...

I have a question on building an expression through the expression builder in my query or in my report or in VBA. I have a rating field which need to auto populate from a % to objective field. If the % to objective field is 99% or less then the rating field needs to auto populate to "D-Needs...