Search options (Page 91 of 104)

Hi Adam,
Attached is an example from something I wrote a while ago.  It uses a postcode (zip code) from the tablegrid and builds a url in the script.
I think it should be enough to show you how to get your working.
Regards,
Derek.

Hello Nitin,
I believe your problem is fixed by updating the comboboxes after you've clicked 'clear';  for example
form1.combobox1.dbupdate
However, I think this will only work if you are using Version 3.
If you are using an earlier version and this doesn't work, let the Forum know and I'm sure there will be another solution.
Please see the attachment.
Regards,
Derek.

Adam,
Please find attached which I think is what you are wanting;  each page control grid displays as per your screen-shot (I assumed you also wanted the totals altering (ie 3 rows in total for Organisation 1 rather than 5,  2 members rather than 4 and  2 smokers rather than 3).
The 'fake' edit should also be working.
Regards,
Derek.

добрый день Stas.kodpi,
Sorry, I do not speak Russian so I hope I understand your problem.
I think your table field names must start with A-Z, not 0-9.
So, replace dela.101 with dele.a101, dela.105_106 with dela.a105_106 etc etc.
See attached.
Derek.

Hi Adam, Hi EHW,
I was wondering if you could take a slightly different approach to this issue which might eliminate some of the complications.  My idea is as follows:
1.  For recurring expenses, use both an  'expense from' date and an 'expense until' date (I suspect most recurring expenses WOULD have an end date rather than being totally open-ended).
2.  Specify the frequency of expense payment (ie daily, monthly etc)
3.  When you click 'save', immediately create ALL the expense payment records (ie, for a recurring monthly expense that lasts for 12 months, create 12 records where the expense date of the first record = 'expense from' date, the expense date of the second record = 'expense from' date + 1 month etc etc
4.  Filter your main tablegrid to only show expenses due by the current date or earlier.
Using this approach, the whole question of 'when do you generate the next recurring expense record and what is the trigger' simply goes away - they're already there and waiting.
It also has the added benefit of being able to see what future expenses you are committed to but which aren't yet due (ie what are my recurring expense commitments next month etc etc)..
Anyway, have a look at the attachment and maybe it will help.
Please note - I used EXCEL to generate my test data rather than writing any of the script that would be needed to insert records when 'save' is clicked - but the script that EHW has written already does most of what is needed (it looks like you'd basically be using the 'expense until' date rather than 'today').  I didn't have the time to modify it (and I suspect I'd have struggled anyway - it's a really neat bit of coding).
Regards,
Derek.

Hi,
If you are using a text field, then you can use substr instead of strftime - for example substr(textbirth,1,2) will take 2 characters, starting in position1 (which should work for your mm/dd/yyyy text field format).
Please see attached.
Regards,
Derek.

Hi Adam,
So are you actually wanting to filter rows or just display them differently ('yes' and 'blank' rather than 'yes' and 'no')?
In that case, I'd use a couple of calculated fields (see attachment).
If you DO want to exclude rows (ie where they are neither a 'member' nor a 'smoker') then that's where you'd use a grid filter (in my example, I have two grids, one unfiltered (returning 7 rows) and one filtered (returning 5 rows).
Derek.

Hi Adam,
On the face of it, I would have expected what you've done to have worked - is there something else going on?
If you attach your example, someone might be able to spot something.
In my attachment (each grid filtered slightly differently), you see that it's quite tolerant of 'is' or '=' and any brackets.
Derek.

Hi Gonpublic,
Maybe the attached project will help you.
I have used a calculated field (employees.cfmonth) to temporarily store the month (in english, sorry!).
You can then compare the month selected in form1.combobox1 with employees.cfmonth to filter those employees with birthdays in that month.
Because there is no relationship between the 'employees' and 'months' tables, I use a very small script to copy the value from form1.combobox1 to form1.edit1 (defined as employees.cfmonth) so that form1.edit1 can be used as the search filter.
But there will be other ways as well - this is just one suggestion.
Regards,
Derek.

Hello Jean, Mathias, Adam,
I've been away so only just now catching up on comments in the forum.
Jean, I'm not sure if it helps but attached is a little application I wrote a while ago when I was VERY new to MVD (which is why the script is terrible - LOL!).  I use it for simple diary / notes / reminders but I'm sure if you changed the labels, you could use it for bookings.
In the meantime, I might 'steal' some of Mathias' good ideas and try and develop it around tgrid more.
Adam - correct, it was simpler and quicker to knock up the data in Excel and then import it into sqlite so that each day is already there, as a container, waiting for any notes to be written.
Regards,
Derek.

Hello Dmitry,
Just downloaded the fix and it's working now.
спасибо,
Derek

Hi Adam,
Not sure if I'm misunderstanding you about the clock.  Why do you need to go onto the internet to get specific location times - can't you just work it out as plus N hours or minus N hours offset from your PC's own clock?
Example is attached (for maximum flexibility, you can select your own locations (up to 24), the time zone offsets etc etc by clicking on the 'SETUP' button).  I appreciate it's just a digital clock (rather than the analogue one) but the principle is identical if you want to make use of it.
Regards,
Derek.