Search results

Hello, I want to check if a form is open in another database. I've already now how to do this on the current database. Thanks in advance. Bieke

Hello Doc, i’have tested your solution and it is working fine. Thank u very much, it saves me a lot of time. Regards Bieke.

Ok, i will test it. I hope it works. Thank u for your help.

I already use sleep in my code as you can see. The problem is that the message before the sleep will not be written to the textbox.

It is already a loop, how to stop is not important. My problem is displaying the text. If you can make an infinity loop that displays two different texts displaying in the same field alternating with a pause of 1 sec between 2 texts should be a nice solution. It is a challenge 😉

And where is the delay of 1 sec?

The operator has to follow these instructions on the screen otherwise thinks go wrong.

Hello, I want to scan 2 labels with a barcode reader and check if they have the same code. I have 2 fields to where i scan the 2 labels, first i scan label 1 in field 1, with the event "Private Sub LBL1_AfterUpdate()" i write a text to an info field 'scan label 2' then i set the focus to label...

Hey MarkK, i never worked with Querydefs, it looks more structured. I will test it. Thanks for the reply.

Thanks Minty, it works !! Probebly easy for you but this saved me a lot of time ...

Hello, I want to have multiple conditions on a recordset based on a query. It works well with only one condition (Forms!frmalarms![M]) but i also want to add the date condition (>[forms]![frmAlarms]![cmbodate] And <[forms]![frmalarms]![DTM2]) It works fine in the query (see below) but not on my...

It were around 7000 records in the table i guess around 3000 files from different filetypes : jpeg, bmp, png, pdf, …

I changed the field in a textfield, when I compres the db now the filesize shrinked to 17 Mb instead of 2 GB 👌

I don't change to sql server now i know that the problem was with the photos in that table. I just have to change the field attachement to hyperlink.

I first test with replacement to hyperlin, if not satisfied I change it to textfield. Thanks.

Hey CJ, I discovered that 1 table ‘products’ is the one with almost 2GB filesize. This table has indeed a field with attachment wich contains photos. These are responsible for the big filesize. I now going to replace this field by a hyperlink field and store then the photos on server. Thanks...

Thanks, i keep it in Mind.

I´ll give it a try, thanks. Bieke.

No it is stil working but if i try to change my vba code en save it than it is corrupt. Luckely i made a copy of the original before testing. But it is a matter of time when i put in new data. :-( Thanks