Search results

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

I am using the Northwind sample database. On the Yearly Sales report, design view, there are fields: 1,2,3,4. These fields generate information when the report is loaded. Yet I cannot identify the source of these fields. Normally to find the field references, you select the field then click the...

Your advise is noted and will be applied. Thank you all.

This piece of code is very handy. I shortened my code significantly

I think that I did not state my problem properly; so it might have led you off track. Essentially I wanted to use VBA code to delete an existing query and recreate it. I found the code exactly as I need it on, online. : Dim strSql As String 'as already in example Dim qdf As QueryDef 'as...

ok. It would be good to see an example of how the parameter method suggested by Vlaxiom's works. I would try the delete and replace method as I think I can manage that. Would let you know how it works. But note that the original query does not have a WHERE condition; so therefore...