Search results

  1. B

    TimeStamp Record After Update event and copy data into another form

    Hi all, I'm back again with another challenge in my working life :banghead:.... I have a simple data entry form on which there are about 30 to 40 data fields to be update by users. One of the field is called "Stage" which is a combo box with 2 entries "Formal Case" and "Informal Case" with...
  2. B

    Retrict User to enter data if Dsum exceeds total

    I need to be able to restrict users enter a value in the text box (on Form B) callled "FTE Assigned" if Dsum of a field called "FTE Allocated" in another form A is less than what is going to be sum of FTE Assigned after the value is entered. Both these forms are used by users to enter data in...
  3. B

    NetworkDays returning #Error

    Hi there, I'm using the following function to calculate date diff in network days (excluding weekends) Public Function NetWorkdays(dteStart As Date, dteEnd As Date) As Integer Dim intGrossDays As Integer Dim dteCurrDate As Date Dim i As Integer intGrossDays = DateDiff("d", dteStart, dteEnd)...
  4. B

    Text Field auto update when adding new records

    I have 2 tables Master table (Jobs) containing the primary key ("Job Reference") and 2nd table (Candidates) with the foreign key ("Job Reference") 2 Forms frmJobs Form to view job details frmCandidates form to view Candates information I have placed add new candidate button on the frmJobs...
  5. B

    Sub Forms based on a query.

    I have a search form on which I have 2 subforms that bring back search results based on a combo box selection on top of the page. Search results come back fine but I have button on both of these sub forms that needs to open record based on the subform values. Code is DoCmd.OpenForm...
  6. B

    Like "*" and Date Range in a query

    Hi, I have built a search form based on a bound to a query where I have Like criterias to search data by Departments, Groups, Names etc... For e.g to search by Surname - I have -- Like "*" & [forms]![frm_Search]![Surname] & "*" This works great and returns Surname data that looks like...
  7. B

    Button Click and then Date/TimeStamp

    Hi, I'm new to access. I have created a form that is bound to a table. There is a button on the form that allows users to send email with the form as an attachment in pdf. I'd like to create a date/time stamp in another table called tblLog. Trouble is the code works uptil sending emails but...
Back
Top Bottom