Search results

Results are in: seems to work fine! Ignores the records with no 'Finance Report Date' - i.e. they are still editable. Thanks again!

I'm going to experiment now, but can anyone tell me what the code will do if there is no date in the 'FinanceReportDate' field in the Transaction Table i.e. if the field is empty? I guess it would make sense if the code ignored the records with the blank FinanceReportDate, instead of making...

Thanks! This actually worked, i had tried not including that part - i was doing the 'classic' spelling field name incorrectly mistake! Thanks for your help on this! Eddie

Hi, thanks again for replying. OK, i've put it in a table. I've got the following code, could somebody please correct the syntax? You can probably tell what i'm trying to do: Private Sub Form_Current() Dim q As Date q = DLookup("AllowEditsDate", "AllowEditsDateTable", "ID=1") If q >...

Thanks! The example is cool, but it seems to require the form being left open to get the date from the unbound text box? It also seems to simply not show you the results which aren't greater/less than, as opposed to allow you to see them but stopping you from editing them - i think AllowEdits...

Hi From reading around, i am seeing that i could place some code in the Current event. I found this code which locks records where FinanceReportDate is older than 3 days. Would anyone know how to modify this so that i can set a 'global' variable (in a module?) set in another form, for the...

Lock all 'old' records (older than user-allocated date) Hi guys I've been asked to provide a function where, once all records are 'finalised', they can be 'locked'. I have a very simple db with two tables: 'Transactions' and 'TransactionItems', which have a one-to-many relationship...

You're a genius! I've set it to become invisible when you search (and the results pop up). Then when you close the results page, the search comes back up. Great! Now i can access those fields with no problem. Thank you so much - i owe you!! And it even comes up in the correct date format...

Hi, I see what you're saying! I could leave the search form open, and 'steal' the dates that are entered. That certainly works! Thanks :) However, what if the user closes the search form before generating the report? The guys using this aren't going to be very computer literate. It could get...

Ah, that was it. Thanks! I will stick to MM/DD/YYYY in my VBA and try to convert it to solve the issue in the other thread you just replied to. Thanks! Eddie

Hey Paul - sorry, i'm a bit confused by that (so nothing new there)! I don't display the criteria anywhere after the search is done. You search and create the query, the search form closes, and a new form comes up with the results. On that results form is a button which can open up the...

Hi I"m re-using some code i used a long time ago (Access 2000/2003), for a dynamic search. I can search for a date (which in the UK and in my DB is dd/mm/yyyy) by doing: If InStr(Me![SrchEntryDate], "*") > 0 Then where = where & " AND [EntryDate] like '" + Me![EntryDate] + "'" Else...

Hi I've created a nice report, which pulls its fields off a stored query (called TransactionQuery) which is created dynamically after a user searches (called Dynamic_Query). One simple example could be: SELECT * FROM TransactionQuery WHERE (((TransactionQuery.[EntryDate]) Between #1/8/2011#...

Thanks so much! I'm going to have a 'meeting' with the folk who will be using it and show them how it is currently (with the dates as real/full dates in the tables, and the mm/yy or qq/yy for the format on the form fields). Most of the time they will be simply using the date picker and...

Thanks so much for this! At a glance, it seems to work OK for continuous forms? That's how i'm going to be using it, inside a continuous (sub) form displaying a list of items that pertain to the main record. I'm going to have a play now!

Hi there! Thank you for your post. My only problem is turning your directions into reality - i'm not quite sharp enough on my VBA to write this from scratch. Could anyone lend a hand on how to get me started? I'd appreciate any help at all! At the moment i've converted it to mm/yy (for...

Sorry for wasting your time guys. You're right, after i corrected the error i could simply reference/access the aliases. I misinterpreted something you said in your post on the othe thread, sorry about that and thanks for taking the time to check things out!

Hi - that's correct, i thought i fixed that before i uploaded. Sorry about that.

Ah - so sorry - will edit the post above when i've sorted it, any second now. My zip file is over 2mb so... brb! I just needed to compact and repair...

Hey man, sure thing. I've attached the real thing - there isn't much data in there, i've just stripped the logos out (which seems to have broken a couple of things, but nothing important). Please press shift on startup. You can see my 'CompleteSearchForm', this searches 'TransactionQuery' and...