Recent content by grenee

Thanks. This is the problem. I forgot to change OffsetPolyline to the argument: PlineObj

Good Day. I my module there is a pop-up message: "Object Required" But a Polyline Object is passed as an argument. Looking at the code can anyone explain why this message is appearing? Please note that if this code is cut and paste into an existing module it works fine. Here is the code: The...

Good day. Is there any information available on the changing of fonts in the design view of the forms and on the design view of the Querys?

Good night All. I am collecting a date on a form in one format like so: 01/03/2021. This is intended to be 1st March 2021. This information is passed to a query, but in the query is is presented this way: #03/01/2021# . And this represents a date of 3rd January 2021. This situation is...

Thanks for the Link. It enlightened my understanding and the problem is now solved

Good Day All. I can convert a date in the form 1/12/2020 to a serial number, in the query window and it runs well. However it would not sort nor can a selection of the results be obtained. The error message is "Invalid use of Null" Criteria for the selection is <2. My expression for the date...

Perfect. Works fine. Thanks

Question: why did you use NULL?

Thanks for that quick response. Yes it works as you prescribed.

Please don't bother with this concern. It worked out as normal

Thanks. This working, but how can I add a restriction of the data. E.g. Suppose I only want to return transType: Checks and exclude Credit Cards. I am asking this because the query window does not show the table lists to select from.

Yes I do record them.

Thanks. Do you mean that the resulting query would not be editable? if so that's no problem, cause I am only trying to generate a report of the combined data - no editing needed. But I do not want to join the table at all.

Thanks for your response: Only last night I asked myself this question too; but here is the reason why: long ago when I started this database as a rooky these 2 tables were created. One showed customer deposits on orders and the other subsequent payment on invoices. In the end I would like to...

Good Day All. Can anyone tell me if is possible to combine two tables with similar fields, in a query, without actually combining the tables. The tables would appear like if they are union, but in actually fact the tables remains separated. I don't want to create a third table from the...