Recent content by blues763

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

Its a text field. On the form my Dsum is getting calculated fine. Its just when user update a new record on in tblStage2 via frmStage2 data entry form. I don't want users to proceed when they enter a WTE value that results in more WTE than the Dsum. This mean I would also require my Dsum to get...

Hi, Thanks for replying on this. I'm still having dificulties to work this out. Please see the attachment of a screen shot of my form. WTE Appointed is where I need to update the value that gets stored in table (tblStage2) At the bottom of the form there are 2 text boxes:- Total_WTE_VA is...

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

Perfect.... Thanks a lot I did think that but I guess a new-bee is always scared..

Hi Tried using above but it comes back with a "Invalid use of Null" error then kill my database where my forms stops working (File Not found) luckily I have a back up copy

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

Yes it did Thanks a lot

I'm sorry I might not be very clear. Job Ref Table is the main table containing the "Job_Ref_No." as primary key , therefore it cannot have duplicates. Candidates can have a multiple "Job Refs Nos" which also act as foreign key in the candidate tbl code im using is on the button placed on...

Candidate cannot have more than 1 Job Ref but Yes a Job Ref can be assigned to more than 1 canditate. I do have tables for Candidates data with Job Ref as a Foreign Key which is on one-to-many with Job Ref (Primary Key- Jobs Table) The add button I have on the Main Form which has only Job...

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

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

Sorry mate... Ignore my previous reply. I just managed to use the nz function with between parametre on my query and it works.... Thanks for you help... Regards...

Hi mate Thanks for a quick reply My search Form is based on a query not table. I could do with a like criteria with in the query or code as well as long it runs the query. Yes 2 dates being used on the same field...

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