Search results for query: *

Hi, I have a database where users login into the Db. On a particular form, there is a combo box where I only want the user logged in name to appear. This is what I have and it works. Form_Current Me!cboInitBy.RowSource = "SELECT EmpID, LName & FROM qryemplist WHERE...

Hi, I am trying to validate a field on a subform, where do I put the validation on the form to prevent the user form leaving the record. this is what I put on the subform but it goes to next record Thanks Private Sub Form_AfterUpdate() If IsNull(txtCompletedDate) = True Then...

Hi, I have an OLE object that is a gif. One the form the user will select from a combobox and select an image. The selected image will then print out. What is the property so that it prints an ole oject. I don't know what to use after the dbpic. DBPic. (Forms![frmform]![cbocombo].Column(2))...

Okay, I see thanks

PHV, I have tried looping with the With Me.recordset but it never goes to the next record. It's not iterating to the second and so on record on the subform. It does the first record loops and still shows that it is looping back to the first record.

I had int = int +1 that made the next record 5, however It was getting an unrelated errors for the table. What is in this table updates a joined table. The next mailinglistid is = 9 for this particular subform record. How do I then get to the next record?

Hi, i have a subform that has a command button. When i click on the command button it is going to update a query called qsponser. However, the record is only updating the first record in the subform and not iterating to the next record. When I debugg, the mailinglistid is always 4. Thanks...

Hi, I have a tab called file, where employees read a report, they go to the DB and select the option that it has been completed. Now, let's say user John Doe has 30 records filled with completed and Not completed. I am going to create new tab so that is called completed, so that all the...

Hi, I have main form that has an unbound combox and an command button, there is also continuous subform. What I am trying to do is select an item from the combobox and then click on the cmd button to add this item into the subform list. This is what I have so far in my command button click...

I made certain the unbound form is frmEmployeeRecords the subform is sfrmEmployeeList and the field is called EmployeeID The form that I am trying to opne is frmEmployeeRecordsIndividual

I get errors 'ms office can not find the field 'sfrmEmployeeList' referred in your expression. When I change the code with "Forms![frmEmployeeRecords]![sfrmEmployeelist].Form![EmployeeID]" I get a parameter On Error GoTo Err_Command13_Click Dim stDocName As String Dim stLinkCriteria...

Hi, I have an unbound form that has a continuous subform. When I select a record from the subform, I want it to open the form for that selected record. stDocName = "frmEmployeeRecordsIndividual" stLinkCriteria = "[EmployeeID]=" &...

Hi, I am trying to set rights to a folder that stores images on a network. Whenever I remove access rights to users on this folder and they go to print a report, the image is not displaying. If I add the read write to the folder, than the users are still able to copy and paste other user's...

Hi, I am trying to print a signature(s) that is an image on file that is in a subform. The combo box in the subform is 0";1"0" EmpNo, EmpName, EmpSig Thank you frmEmptrainingDoc = Main form FrmTrainingSignature = subform imgEmpSignature.Picture =...

Greetings, I have an unbound form that basically is doing a filter by Name, dept and Date. The date I am letting the user select a date range. All this works fine. When I go to print the data in a report The TO and END date are displayed on the first page but I get a #NAME? on the following...

Hi, I noticed that on my form that I have created it uses an autonumber. Users are going in and going into a new record and generating a new record but leaving it blank. How can I error trap so that Last, Fist and SSN are entered in before an autonumber is generated? Thanks

I did it as, DoCmd.Save acForm, Me.Name. Thank you, that looks to have resolved my issue.

Hi, I have a 3 level cascading, which is working perfect. However, it is not printing the current selections. If I exit the record and go back into it, then it will print what I selected. I tried to save on the print button on the database but it didn't work. any ideas?

Inititally, I had this code as an Event Procedure and it works fine on FORM OPEN. That is why I did not list the code above and below. When I created a module and calling to this function from a form I am having a problem with !FormName = Me.Form.Name I get an error stating that !FormName =...

Hi, I am trying to call this from a module but it isn't working. It works when I put it as a private but I will be calling this many times in a form so I don't want to have a bunch of code. !FormName = Me.Form.Name Public Function fctT() As Boolean ........ '!CompName = strCompN...