Search results

"hh:mm" seems to work for me??! and so does "hh:nn"!! :) I did notice that when you enter the above into SQL View and then switch to Design View, Access (2003) translates it into "Short Time".

Thanks for your reply Doc Data, but I don't think that will help. I think the problem lies in the "Like" criteria in the result query because how can it check both for a specific value (ie "Like 9" or "Like *" ) and then also check for Null values (ie "Is Null") ??? - which is what I want.

have you tried: Format(value,"hh:mm") ?

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

Have you seen the following method for filtering using Combo boxes? - I use it all the time and it works well.

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

solution.. Hey guys, thanks for dropping in. I managed to solve this by using the following instead: With CurrentDb.OpenRecordset("tmpClientWelcomeLetter", dbOpenDynaset) not sure what the difference meant but it worked! ;)

Surely, I'm not the first to have winced at losing SQL join statements after making a design change to the DB? :mad:

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

ahh, I was 'erring' on the side of caution with that one. ;) Thanks RG

Excellent! Thats done it! Thanks for your help guys. Yes, I wanted it to re-retrieve any default if the user deletes all the text and they changed the drop down value. I also just reversed the sign.. If Len(Me.BodyText & vbNullString) <= 0 Then Me.BodyText.Value =...

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

Yes you can do that. Im new to Access also but experienced in DB design. I'm doing a similar thing to you and have had to: create new tables with primary keys, 'normalise' data (clean it, clear out duplicate data, setup new tables for codes, etc, etc) setup relationships between tables, Create...

Im so very close now to having this done, except my first subform (for new record entry) has ALL the existing child records in it. Properties set for this subform are: Record Source: tblActivity Filter: - Order By: DateComplete DESC Allow Filters: No Allow Edits: No Allow Deletions: No Allow...

Found a solution! I put the following in the OnEnter event for the Textbox and it works! - it repositions the cursor to the end of the text in the control. The only thing is that even with just 800 records its slow to requery after a letter change in this search box...

Im doing the same here and having problems... Can the first subform (for new records) be linked to the main form? (via Link Child/Master Fields) Or do those properties need to be blank? thanks..

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

Can I assume this is one of those 'quirky' problems that no one can suggest any possible hint for? :(

I've tried out a new filter text box on a subform header and I'm still getting the same result! Suggestions anyone please? btw, the actual search part does work - but the text box is not allowing any contiguous typing!