Search results

Hi All, I have three databases; Frontend, Backend, Snapshot. I want to be able to have a feature in a form in the frontend database where I can delete a table which I select from the Snapshot database. Any idea how to do this? I have the following code I need to change the copy...

Hi guys I've got a form with a subform, which has 4 records below: ID - sStatus - sAvailableStatus 1 - Holiday - Unavailable 2 - Unavailable - Unavailable 3 - Confirmed - Chargeable 4 - Provisional - Chargeable Then in the main form there are two buttons cmdExcludeProvisional runs a...

Hi guys, I have a table which has several fields but im focusing on job names [sJobName]. Example: sJobName Jobone Jobtwo Jobthree ZZ_Jobfour ZZ_Jobfive I want to somehow filter out any records which have a job name starting with ZZ_ How would I acheive this? I have tried using...

Hi All, I have an employee table (tblEmployees1) which has all employee information including their grades (sGrade). I want their grades to be converted from Manager, Senior Manager, Director etc. into M, SM, D etc in a new table. I made a table (example of it shown below) (tblGradeFilter)...

Problem I've got a main form (frmChoosePeriod) which has a date selector option and a calendar set up so you can choose a start and end date. Note - this start and end date is understandably temporary so when you close the form these chosen dates reset to blank again. It's all coded and...

Hey, I wanted to create running totals for each of those cells in the form. Basically just to add up each of the columns and when the period (record) changes, the totals will recalculate and display the correct values. Ive tried the simple sum formula but ive been having lots of problems and...