Search results for query: *

Hi, I have a unbound form with 2 list boxes lstReq (reqdate,reqtime,vehiNO,vehistatus) & lstVehi(vehiNO,vehiavail). I need to update lstVehi(vehiavail=false) automatically (Maybe on timer event) according to the data in lstReq according to certain criteria(reqdate=date,reqtime=time,vehiNO=is...

Hi, I know this is an old thread but I hope someone will post an answer to my query. I have a table tblRequest where I have 3 fields RequiredDate VehicleNo & TeamSplit. I need to get a count in my forms code of to the selected RequiredDate and selected VehicleNo how much is the count of...

Hi I was searching for an option to send an email on a button click. I found the following code. But I am getting a compile error when I try to run the code. Please help!! http://www.tek-tips.com/viewthread.cfm?qid=1670887

Hi, This maybe something simple but I couldn't figure it out yet . I have a list box with two date columns (EntryDate & RequestedDate). I need the list box to show records according to both dates. For Example Entry 1 EntryDate 9/12/2016 RequestedDate 9/13/2016 Entry 2 EntryDate 9/13/2016...

I need to update two records of the same table (tblVehicle) during a button (cmdAssign) click. The record is selected from a list box and at the button click the currently assigned vehicle's info (vehiIn = True , vehiOut = False [Where = vehicleNo{Current}]) needs to be updated. And...

Hi I have a form in which there is a close button (cmdClose). I want the prompt to request for Discard. If yes discard and close form. If No to Set focus to previous control. And if no change close the form. I am having trouble getting this to work. Would appreciate your advice. If Me.Dirty =...

Hi, I have a form called frmMaster. I am trying to apply a code when the form is closed mid entry or full entry, So that the user can discard the changes if necessary. I am having some trouble when the form is fully completed. It closes even though I give a vbNO option. Would appreciate some...

This is my current code for comparing passwords If Me.txtPassword.Value = DLookup("Password", "qryUser", "[UserID]=" & Me.cmbUserName.Value) Then But there is no case sensitive validation. Would appreciate some advise on how to add a case sensitive validation to this code.

I have a form "frmMenu" which contains a sub datasheet form called "frmDashBoard". This form opens Maximized. I have added the following code to re-query that sub data sheet as it is a live update screen. Private Sub Form_Load() Me.TimerInterval = 1 End Sub Private Sub Form_Timer()...

I have a form(frmMaster) with a save button(cmdSave) I need to open a temporary screen(frmDone) with a button(cmdDone) to complete another record. The function is all going well except for running through the code of frmMaster before the temporary screen is closed (The saved successfully message...

I have a form called frmMaster(tblMaster),n which there is a combo box called cmbRequestID (The combo box is populated from a related table called tblRequest). The table tblRequest has a field called Done which is check box. I need to update this check box when I am saving a record on frmMaster...

thread705-1299579 I found this thread and its useful to what I am looking to do. But I need something different than what happens in this thread. I require a notification to show on my login screen (text box) stating that the Capslock is on if the Capslock button is on. And the notification...