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))...

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...

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

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?

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...

Hello, I have an issue with an option group. I have 3 options in the box that has a combobox seelct a list to whichever option is selected. On value #3 instead of it using the combobox, I am trying to let the user input "details" rather than have it selected from a combo. I have an if statement...

Hi, I am trying to lock a text field in a tab control with a check box. I am able to lock the field but it locks all the records. I unlock the field it unlocks all the records. any ideas? thanks Private Sub Form_Current() If Me.NewRecord Or Not Me!LockE Then Me.txtSecE.Locked = False...