Search results

Hi, I have a filtered form called frmAssing on which I have implemented a for loop to check and enter some values. So far this is working when the form is open. Is there a way i can get this function to work when that form is closed. Would appreciate if someone can provide the code required for...

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

Hi I am trying to send an email using the below code via button of my access form. But I am receiving a warning message I have to allow every time I am sending an email. Any idea how to stop that message? :banghead::banghead::banghead: Would appreciate if you could post up the modified code...

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, My Reports in my access system is showing the "Design View" and "Layout View" selections on right click. I can't disable the right click entirely because some of the reports are filterable. I got a VBA module code from the web tweaked it to my requirement. It worked when I...

Hi, In my access database I have created an Admin portal (which is restricted to users) so the system admin could view the table data. Since my form is a pop up and I have disabled control box and control buttons on the form. I was wondering if there was a way to get the table to pop up in...

Hi All, I am new to this forum. I am not familiar with modules. But I needed a event logger for my database and I found a solution via module. I have tested the current code and it works perfectly except for a small blip. I have a field called UserName in the same table which needs to be...

Hi, I am new to access and databases. I have 2 tables with the respective fields:- 1) tblItemMaster - ItemCode(PK,Related), ItemDes, Product, Rate 2) tblQuotationDetail - ReferenceNo(PK), QuotationDate, ItemCode(Related), Qty, Total I need to calculate the Total by multiplying Qty with Rate...