Search results

Ok - need to explain what I am trying to do and why... I tried and failed to get this to work using a multiselect listbox... I have a list of departments in tblFunctionalArea My main table is tblStatic I want to be able to for each record select multiple departments affected by a record and...

Hi, I had a Nested IIf working fine... Fix RAG: IIf([Fix Date Variance]<=0,"G",IIf([Fix Date Variance]>5,"R","A")) Well working kind of... as where the Actual Fix Date was blank it showed #Error... So I tried to include an And in there as well and think I've thrown the arguemets out of the...

Hi everyone - I have some code I found and am using that appears to be throwing some strange results out... I am calling the following code in a query using Age of Defect: Workdays([startDate],[endDate]) Public Function Workdays(ByRef startDate As Date, _ ByRef endDate As Date, _...

Hi, I have two tables linked with a 1-2-1 relation with enforced referential integrity based on a input ID field. I originally had autonumber field which was the primary key on them both but then wasn't able to update any of the fields. I then deleted the autonumber fields and made the manual...

Hi everyone - I've got a couple of interesting challenges that i don't know where to begin... I have a WorkingDay module (found elsewhere on this forum :-)) that is working well for me elsewhere that feeds off a holiday table etc (1) Calculated Target1 Date With this challenge I have a start...

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

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

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

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

Hi I'm using this code that I found on the internet to correct capitilisation Public Function ProperCase(AnyText As Variant) As String 'r_cubed 'Convert passed text to all lowercase. Use ProperCase() as you would a built-in Access function. 'If passed value is a null, ignore all...

This sounds so simple but I cannot get it to work Combo box has three options 1 Yes 2 No 3 All Table field has two options 1 Yes 2 No In my search form the query on this field Like [Forms]![frmProjectSearch]![cboProjectType] Works if I choose Yes or No but nothing if I...

Hi I've found an old thread called this same thing but it didn't quite work for me still and didn't want to post onto a 2 year old thread... so figured I'd start a new one... hope that is ok and I am staying the right side of the site admin's... I have a cmd button on a form which if clicked i...

Ok - I am losing the plot!! :confused::confused: I have this working in one part of my database and I think I'm using the same principles but cannot get it work in another part. Where it works: I have a parent form with annual totals on and a button which opens a detail form to add the data...

Hi, I have a database that has a table for Project data (tblProject) which is linked via a foreign key ProjectID to a table for financial years (tblFinanceYear) which is in turn linked to a table for Year (tblYear) through a foreign key YearNameID. There must be a way of doing this but cannot...

Ok this feels quite weird... I've played around with a calculated field on a subform and now I 'sometimes' get this error message... I changed my calculated field so that it is now =IIf([currencyid] Is Null,0,FormatNumber(ExchangeRate([Start Date],[CurrencyID]),10)) As previously if there...

Hi, I've seen a few posts around this subject but none seem to hit the spot I need.. I've seen pbaldy's link; http://www.baldyweb.com/wherecondition.htm And I'm trying to use it BUT... I need to pass two parameters in... Using the above link my code is DoCmd.OpenForm...

Hi, I'm trying to build something that started life as quite simple but now has grown and grown and grown... I have a form for projects and a subform form that holds finance details i.e. top level budget etc On this subform I have a button to open a detail sub-sub-form which shows the annual...

Hi, I have an exchange rate field which is calculated to ten decimal places. This is looked up from a date field and a currency field via a select query which when I test that shows to 10 correct full decimal places. When I try and show this calculated exchange rate in my form it gives me 10...

Hi, Not sure if this should be in here or in the query section as I don't really know where to start... I have A LOT of exchange rate data in excel each in a massive matrix per month but alot I could trim out as I'm only really interest in one row per month I have about 10 currencies then I...

Ok I've been a member of this forum for a while but as I'm not a programmer by trade the different jobs I've held have required different levels of use of Access - so I've not be very active for a while... I'm in the process of trying to get my company to ditch the very expensive Microsoft CRM...