Search results

Thank you so much it has worked very well

See the error down

I'm trying to work on this VBA which helps to send invoices to customers silently without opening outlook, but on the .Edit I'm getting an error message what could be the reason for that and how to fix it. However, this is not my code I got it on the internet, Im simply trying to see if it can...

If think upgrading to 2019 or 365 offices will be ok

Ok after checking their computers we discovered that there is actually access 2019 full version BUT not activated, and so we told them to immediately to find the product key and activate it and then remove runtime 2013. I'm sure this will work now.

Any at query level we always use Format((Date),"YYYY\/MM\/DD") for years over 10 years we do not have any issue I will try it this afternoon or tomorrow and post the results

The Short Date format on the format control fail to work hence forcing the unambiguous ISO date .

See the new code I'm have just put Private Sub txtPosCashEndDate_AfterUpdate() Me.txtPosCashEndDate = Format((Me.txtPosCashEndDate), "YYYY\/MM\/DD") End Sub Private Sub txtPosCashStartDate_AfterUpdate() Me.txtPosCashStartDate = Format((Me.txtPosCashStartDate), "YYYY\/MM\/DD") End Sub This...

To answer your question, it seems like you to say I use this method below which also works in full version Access I do not in runtime: Private Sub txtPosCashEndDate_AfterUpdate() Me.txtPosCashEndDate = Format((Me.txtPosCashEndDate), "YYYY\/MM\/DD") End Sub Private Sub...

No validation rule at all

Here is what happens when you enter the date using a date picker, see the picture below: this only happen in Access runtime NOT full version

I have just encountered a problem in access runtime environment; I have created an unbound access form specifically to aid users to select dates required for a parameterized report, this form work very well in in full version of Access and is able to recognize the dates but fail to recognize the...

I don't understand your first code why you set a recordset to something and set it again to something else right after you just set it I don't understand your first code why you set a recordset to something and set it again to something else right after you just set it There two subform which...

Dear Good morning! First all many thanks to the team members you really helped me a lot from day one when I joined this forum and my intention is to be featuring here frequently to help others as well. This is the only forum that I respect so much, my seven years of coding with VBA would have...

Good afternoon, all! See how you can advise when using MYSQL DB Maria ODBC connector. Connecting to the DB require composing an ODBC string like below: ODBC;DRIVER={MySQL ODBC 8.0 ANSI...

There were some hidden controls in the footer sub report taking a wider space, after shrinking them to zero all was sorted out, thanks to minty he opened up my thinking

The issue on the subreport now its working okay

Hi Is there a way or VBA code to stop access from printing extra page which is blank at the end of the report. For example, page 1 has only two lines of data, but it will also print page 2 which is completely blank which is a waist of paper. We have been intervening manually by going into...

Many thanks to all of you I appreciate your help its well noted

Can you demonstrate what you want to occur? Suppose you have the below sample data, please list the data you expect your query to return: TPIN, ID abc, 1 def, 2 ghi, 1 abc, 2 def, 2 If TPIN = 100 , then even if in a combo there 5 customers with 100 , the combo must return only one