Search results

Hi all, I have created a form that lists work to be invoiced. However I have a problem with the following WHERE clause in the query source: WHERE ( IIF( A.DateComplete is not null, Month(A.DateComplete), IIF(A.Fee is not null, IIF(F.DateSpecific=False, 1...

Hi all, I have 3 tables: tblMonth, tblRegulation and tblClientRegulation. Relationships are: tblClientRegulation.Regulation = tblRegulation.ID and a fabricated relationship: tblClientRegulation.Month(DateEnquiryRevd) = tblMonth.ID There is no relationship between tblRegulation and tblMonth. I...

Hi All, I use the following generally available function for rounding. I thought it cured the problem with 'Bankers' rounding which is Access' default method of rounding. But can someone tell me why, when using this function on the value 4.725 it returns 4.72 when it should return 4.73? I am...

I have a number of sub forms managed by a tab control which is on my main Client form. I can enter a new client and complete any of the subforms as required. Most of these subforms are displaying 'child' tables to the main Client table. One of these has a 1-1 relationship with Client. (ie: an...

I have written a query to calculate how many hours we have worked for our clients. This has a number of sub-queries which sum to make different columns in the main query ie: Hours invoiced so far, Hours to be invoiced, Hours remaining from their allocation, etc. I am refreshing the queries due...

I have 3 tables: tblClient (our Company customers) tblContact (people who work at the Companies) tblClientRegulation (1 or more types of Regulation that the Company is obliged, by law, to comply with) Relationships: tblClient - tblContact: 1 to many tblClient - tblClientRegulation: 1 to many...

Can Access produce an XML file similar to the following example? <Company> <registrationNo>178560</registrationNo> <tradingName>Widgets Ltd</tradingName> <SICCodeList> <SICCode>55.50</SICCode> <SICCode>55.60</SICCode> <SICCode>55.70</SICCode> </SICCodeList> </Company> where 'Company'...

I have a main form with Client details on. There is a subform that lists 'Categories' that a client belongs to. (This is a continuous form listing records in a ClientCat table) Beneath that, is a tab control with other subforms on. 2 of which are linked (via Link Child/Master properties) to the...

I want to build a form for my users to allow them easy access to data shown in datasheet or continuous forms view. However, the problem is that they want to also see on the same form Contact details (Name & Tel.no). This is a one to many relationship with the underlying query so I cannot build...

I have a listbox on a form displaying records which can be filtered via a number of comboboxes. These comboboxes allow the user to select "<ALL>" or a specific value from the list. It all works perfectly. However, I would like to be able to select a filter value of "Null" on one of the...

Hi All, Thought I'd share a solution to a problem I've been having today. Problem Word (our Ver is 2003) crashes when attempting to connect to an Access DB (again 2003) whilst creating a Mail merge document. Strangely, previously created documents still work, even when refreshing the data. No...

Is there anyway of defaulting to SQL view when firing up a query to amend it? (Rather than going into Design view) There doesnt appear to be a configurable option to do that under Tools. Thanks

Im having a problem getting this code to work. It is meant to fire up Word (which it does), open up a new doc based on the template (which it also does) and then populate a field in the doc with data from the query table (which it doesn't). I've put the fields in the Word doc via firstly...

the following code retrieves a default value for a textbox on a continuous subform: Me.BodyText.Value = DLookup("[DefaultBodyText]", "[tblHeading]", "[ID] =" & Forms![frmClient]![sbfrmClientDocument]!Heading.Value) This works nicely except it overwrites any value typed into [BodyText]. So how...

Can a textbox be put on a single (record) form and be used as a search filter for that same form? ie: I want to have a customer name textbox to filter for those matching (partial) customer names on the same form (bound to the Customer table) that the textbox is on. eg: I fire up the form that...

I have a filter (via textbox) on a form that only allows 1 character at a time to be typed (!!?) ie: after typing in "a" it highlights it, which means the next letter I type in, replaces the "a". When I use the mouse to re-click after the letter entered, it does allow further characters. What...

Yes, Ive searched the forum and Im still stuck on this most basic of concepts - please can someone point me in the right direction?.. I have a Form [frmClient] and a subform [sbfrmCommsList]. The subform links nicely with the main form via [ID]. However I want to add a second filter on the...

Hi all, Please could someone suggest a possible query (or design) solution for the following: I have a db that records hours of consultancy for our customers. Our customers can have an agreed level of support, giving them a yearly allocation of hours (4, 15 or indeed any number of hours...

Hi All, I have the following calculated field in a query to grab the Month name: MnthName: Format((Month([DateComplete])),"mmm") where [DateComplete] is a Date/Time field from a table Is this dubious at all? Because the results come back with either "Jan" or "Dec" (NO other month names) (Ive...

Hi all, We have an Access 2000 db on a server that I can open. Problem is, when other users open it up and use the Navigation buttons to say, view the next record, Access crashes with the following error: "Method 'Requery' of object '_Subform' failed." (this is the Access supplied record...