Search results

per post #5 AppointmentDate between date()-weekday(date(),1) and date()-weekday(date(),1)+7 you could of course just apply that as a criteria to the form's recordsource

easiest way is in the form design, data tab change the recordset type to snapshot - that will only make the data read only but any unbound controls can still be changed (such as one used for the user to indicate what they want to filter) You need to get your terminology right - in a query you...

per post#2 the action would need to be in the button on the main form subform.sourceobject="" querydef.SQL="SELECT....." subform.sourceobject=report.myreport

A report is not a form and cannot be made dynamic in the way you want. You can do things like change the sub report source to display a different report and use the subform link properties to display a different set of data - but this is not a true filter Opening as a report (ie not in a...

I guess could be a recordset, just my way of thinking.

If your data is displayed vertically i.e. account 1234 date 1/1/25 etc Use a continous subform to show the number of columns required and populate accordingly perhaps use an ADO disconnected recordset - you can then left justify the 'headers' control and right justify the values...

Precisely

I could be wrong but I think the only device based db RAD tool that works on iOS is Filemaker. As an individual you do have a choice, but the corporate world (with perhaps the exception of those who are into publishing/design/etc) choose windows because of the cost of equipment - iOS devices...

good point :)

to preserve the use of indexes for better performance, better to not use a formula on the target field. Assuming your week starts on a Sunday and your date field does not contain a time element, try AppointmentDate between date()-weekday(date(),1) and date()-weekday(date(),1)+7 If your week...

to clarify what you want is to filter the records to show the current month? (Edit- current week) If so there are simpler methods

Proper way depends on what your app is required to do. But a good starting point is to not allow ZLS's (Zero Length String) to be consistent in treatment of values regardless of whether they are text or number. In your table design, field properties, set 'allow zero length' to no - any zls's...

Not at my computer to check but think one way is to have it populated with some text, then select and hit the enter or left arrow key to delete it - on a form if the control is unbound or bound to a field that allows zls it leaves a zls behind

In vba, check references to see if the outlook module is installed. If it is, you can use vba to extract the attachments and/or sql to view the emails Or you might be able to download and install classic outlook

Why not upgrade to 365 (via 2007). Cost for charities is $3/user/month. The forms still work the same way. You will need to bite the bullet at some point.

In the uk there have been at least two excel ‘catastrophes’ in the last few years. The first when it was stated the level of covid infections had stabilised at 1m - actually due to the row limit of excel. And a couple of years ago the release of data on Afghan nationals fighting against the...

Use format([myDate],"yyyy-mm-dd")

easily handled if that is what is required - the OP's example is too simplistic Iif(max <>min,max,0) as bin2

When you say filter - is that a form filter? Or a criteria in a query? If the former, how is the filter being applied? Using shortcut menus? Or code on a control? If it is criteria - provide the full sql to the query If on a form , provide the sql to the recordsource and the vba to apply a...

I haven’t needed to use it for a while but I’ve used Inno Setup in the past. https://jrsoftware.org/isinfo.php