Search results

Hi, I've built a few databases over the years but none have had this requirement and I can't work out where to start.... I'll want a form where I'll need to filter by project and then by month - this will probably need to then open and populate a embedded child form. Once I've made my...

Thanks for your response - this will be used purely by me - I'll need to gather the data from the project managers for their projects but the input, changing and reading will all be me. There is nothing as i understand unique about my plans but I could find any template that i could simply...

Thanks David - yes that is exactly what I want! :-) I think most of my follow on questions would be form design specific... as in how do i get an entire period of time (likely a month) displayed on a form for me to then choose the dept and resource type and then put in the FTE usage per day...

Thanks to you both In simple terms There will be a Project Table with project names on it Dept Table with dept names on it Resource Type Table with types of resources on it i.e. manager, admin etc Then I need to find a simple way of choosing a project and then for that project selecting by...

Hi - not sure where to post this... so apologies if it's in the wrong place... I am started a new job and have been handed a very clunky excel spreadsheet with columns for each day going off infinitely.... I need to be able to by project, select what resource type and what FTE is required for...

Thanks Trevor just watched that and that makes sense when you do have two identical tables or queries. But mine is identical apart from the budget and actual columns... Say for example both queries simply have two columns Cost Centre and Amount - so I want to join these two queries together...

Hi, I think this may be a union query solution but I cannot work out how to do a union query... I have two queries exactly the same except one has Budget Amount the other has Actual Amount I want to join the two together in a new query that displays everything... Currently using a select...

It's not that I think that these things are unnecessary it's just that I didn't know what they were and how to do them... I normally do compile to check for any obvious errors but because I'd copied some forms over to this small database for posting I'd not recompiled after removing some fields...

Thanks to you both - I'll have anothe rlook at this query link instead... Is it the case that you should always link forms to queries and not directly to the tables?

Yes ok in terms of physically changing the record source yes a matter of seconds ;) But I had several subforms that simply wouldn't allow data entry when set to having a query as a record source... I am not good enough at this stuff to work through the why's of this - I simply wanted something...

I had my forms based on a query before and it caused me no end of problems when it came to actually using the form and inputting data so I went back to link to a table... When I put the code back on on form load code on my frmProjectFinance I found the number being passed to varStartDate varied...

Ok I've managed to find something that I've butchered and appears to work - does this look to ok to you guys? Or will this miss something? Dim varStartDate As Variant varStartDate = DLookup("ProjectID", "tblProject", IsNull([Start Date]) And IsNull([Proposed Project Start Date])) If...

Thanks vbaInet - and thanks for your patience I do understand why my code cannot work because of the reasons you say BUT I do want to do this check on the subform frmProjectFinance opening/loading I cannot find any DLookup example anywhere on the net for checking multiple fields and then I...

Hi RainLover - sorry yes because I'd tried a quick and dirty cut down so I could post something I'd not fully cleaned up the code so there were some compile errors relating to fields and boxes that didn't exist. With regard to Error Trapping - I've no idea where to begin... my limit is on error...

Now this code and still get the msgbox even though i have a date in one of the fields... Private Sub Form_Load() On Error Resume Next ' We have to go through with this come what may! Dim Answer As Integer If IsNull(Me.Parent.sfrData.txtStartDate) And...

The frmProjectMaster is the masterform which is open the whole time... I then have frmProjectGeneral, frmProjectFundingApplication and frmProjectFinnace which are the three subforms that open in sfrdata...

Hi, I have a database with a dynamic subform (sfrdata) which displays different subforms when menu buttons are clicked When I open one subform I want it to check if I have a date in EITHER of two date fields which are on different subforms. If they are both blank I want it to display a message...

Thanks :-) that set me on the right track at least and now I've fixed it :-)

Still unable to get this solved... so far none of my users have tried to do this but I'd like to get it solved as I know it's a potential problem... Any ideas??

Hi everyone - this is still doing ym head in as I'm so sure it's something basic but I can't figure it out... I've tried everything I can think of - how can I get all entries displayed (so both ID's 1 & 2) when I choose "All Projects" Thanks for your help