Search results

Indeed! Thanks Arnel

Dear readers How can I modify textfield.backcolor via a function? I use Public Function ChangeColorDropDown(Variable As Variant, Backcolor As Long, Forecolor As Long) If IsNull(Variable) Then Backcolor = vbRed Forecolor = vbWhite Else Backcolor = vbWhite...

All, thank you very much for the tips. I solved it by adding the fields in the subform + showing them to the user. It has to do with one machine producing min 1 and max 4 items simultaniously, while the products are already entered in a subform and the database need to react with SPC on...

Dear readers I have in my form a recordsource containing several columns with nearly identical names DR01, DR02, DR03 etc. How can I use this dynamically in VBA with a counter? So when it is a field on the form, one can use for counter = 1 to 10 ME(“DR0” & counter) Next counter But what...

Agree wit Ranman. My solution is also to keep the documents stored on the network and to save the whole path to the document in a text field To open the document I use one line of code in for example a doubleclick event on the document name in a form Shell "C:\WINDOWS\explorer.exe """ &...

Hi thanks all for looking into this. @arnelgp. Many thanks. I tried your solution but it gave me the same result as I already had: no records when no limit was found I thought about a workaround I left joined the two tables and created the output in two steps FIRST without constraints on...

Dear readers, A question I am dealing with for a long time now As company we are controlling all kind of emission. Each year we are improving and each year the government decreases the limits to motivate companies to continuous improvement. So far so good In reality we have a lot of data, but I...

Hi again everybody Thank you very much for the tips. A little more background might explain my despair. Somebody recognizes this maybe? I am responsible for developing, maintaining and administrating a production MES system: 20 frontends linked to 31 backend databases in SQL server. Databases...

Dears, Thank you all for your valuable input. I will (for now) not take the risk to end up with different versions. IT installed a VMWare and made a decision to install 64bits which forces work to another. According to my opinion one should use a development version closest to the one in use...

Dear ACCESS experts, I am still developing in ACCESS 2010, 32 bits (sorry, but we are not a very rich company :) ) My "development server" (an old HP proliant, RAID 1, retired already 5 years ago as fileserver) is still servicing me, but is showing some red LED's which indicates me the disks...

Thanks! It is indeed the top N per group. This is actually what I use to create the first query, and on the result (query1) I just have to perform it again

Dear Query experts, In the below example I am able to get the correct answer, but I have the feeling my method is too complex A very simplified example is the results of a UNION query (records are coming from different tables) Query1 Position ; DateTime ; Value 242 ; 26-12-2019 10:00 ; 1...

Glad I could be of any help.

to find the code - right click on the function and select: definition then the cursor jumps to the code everybody is referring to

did you check if "accounts@mycompany.com" is a user or a distributiongroup. In the last case you will highly likely not be able to send mail

so... everything :D but the good thing is: there is no error either

It sounds like you compact the database, which is good reduce it some Mbits, but did you also decompile it? You do this by starting ACCESS with MSACCESS.exe /decompile And then selecting your db

Can it be that your default layout is exceeding 1 page

I would suggest to try a decompile first ben

You can define an exit button. In the onclick event, you can add for example Dim answer as long If isnull(me.yourfieldname) then answer = msgbox("Are you sure you want to close the form without an email address?", vbyesnocancel) if answer = vbyes then docmd.close end if end if Ben