Search results

Okay, so here is tblStudentEmployment TblStudentEmployment StudentEmploymentID (Primary Key) (Auto number) StudentID EmployerID SupervisorID HireDate Related Title TerminationDate TerminationReason Now, my StudentID, EmployerID, and SupervisorID will have a relationship to those tables. Will...

I would try the On change event - instead of locking the field, you can also try to disable it altogether and it allows the user to visually see that its not accessible. Private Sub Combo2_Change() If Cmb1.Value = "No" Then [txt1].Enabled = False [txt2].Enabled = False Else...

Here is another option utilizing a cmd button - If the user indeed wants to change the name, they need to first click the 'Change Name' button. The problem I have run into is that everyone is so 'click' happy that if a box pops up, they are apt to just hit 'okay' to get on with the process...

Im just curious on how some of you made a career by creating DB's for clients. Everything I see is generally some other program besides Access. Is Access something I should not learn because there is no demand or is this strictly free lance work? These past few months have captivated my...

I got it to work. Instead of referencing the checkbox itself on the report to format a box, I referenced the checkbox on the form. So the new line of code is the following: If Forms!frmfilterform!UnavailableforCompletion.Value = True Then It still gave me errors on every IF statement so I...

I also checked if it was set to 'triple state' and it is set to no. Im so confused :confused: any more suggestions is greatly appreciated

Peter, I tried the line of code and it gave me the same error and highlighted the line of code debug.print me.completioncheck So I added this line of code before the If statement Detail_Format_Err: msgbox Err.Number & " - " & Err.Description Im not sure if I did this correct but this is...

I did some research on the Nz function. In simple terms: It lets you return a value when a variant is null. Okay, now my check box displays either a 0 or a -1. 0 being false and -1 being true. This means that my check box is NOT null....correct? :confused: (I thought a check box could...

This is my command key to preview the report: Private Sub cmdOpenReport_Click() If Me.Filter = "" Then msgbox "This preview is record specific, apply a filter before proceeding" Else DoCmd.OpenReport "Newptd", A_PREVIEW, , Me.Filter DoCmd.RunCommand...

I tend to do things the long ways anyways - but why not make a form (lock its position at the bottom right or wherever it suits you) with a field that is unbound and a command button that prints what is specified in the unbound box. You can set multiple reports that you want to print by using...

Why dont you just use a command button in your form?

What would trigger an error to occur if there has been no changes to a DB. My error # is 2427 (You entered an expression that has no value). This error occurs when I click on a command button to open a report. When I debug, it sends me to an IF statement that I have loaded in the On Format of...

Perfect, I made only a small change that worked out great Private Sub cmdOpenReport_Click() If Me.Filter = "" Then msgbox "This preview is record specific, apply a filter before proceeding" Else DoCmd.OpenReport "Newptd", A_PREVIEW, , Me.Filter DoCmd.RunCommand...

Every time a report is opened, it displays the page at 100% - thus allowing you to view a small portion of the document. Is there a way to lock the zoom at 75% to view the overall page upon opening the report? Thanks, John D

I removed the reference and it works fine now. Thanks again Ghudson John D

Okay, just did some checking, but before I do this can someone verify that I am doing this correct? Under the references in A97 on my system, it specified that the file: actskin4.ocx was the file for the ActiveSkin 4.0 Type Library. It was located in my System32 file. Can I just copy and...

I have found what was missing on the other staffs cpu. ActiveSkin 4.0 Type Library Now how do I add this on her CPU and where would it go? ...its amazing how computer illiterate you guys make me feel - but its with much appreciation ;) John D

I will try to explain as best I can. Each AR has between 250 - 350 students. Each Record (student) has the students start date and has a field to which AR they belong to (2005, 2006 or 2007) and many many more things that relate to each student. The start date of the student is what...

SJ This is before I learned anything about Normalization. Everything was grouped into one table which housed all data for the 2005 Annual Report. In the meantime, I created another table for the 2006 AR (all same fields, just different data) and 2007 with seperate forms that reference the...

Actually, another problem now. A user from a remote cpu has an error now when they attempt to access the AR. The error is: "compile error: cannot find library" :confused: :confused: