Recent content by npa3000

Maybe I didn't analyze it well. The user can, for example, enter a price of €1.23(2 dec digit) or €1,305(3 dec digit). In the report, I want the prices to appear as they are in the form. I just can't find the right settings to make it work for both cases at the same time because either it will...

I have a form for creating offers and the user enters the items with their prices. Τhen there is a report where there is a "mirror" of the actual form. Normally the prices have 2 or 3 decimal places. The problem is that I don't know how to make it work with both cases as even with the...

Hi, I 've been wondering if it's better to have my FE file in each computer that uses the application or have it on a shared folder on our local windows server? What do you believe?

Hello, I have 2 tables where from one I want to transfer a column to the other based on an ID. Specifically I have the PRODUCTS table with the fields PRODUCT_ID and TRANSLATION. I also have the TEST table with ID and trans fields. So I want to transfer all the trans fields from TEST to...

Hello again, most of you are right that I do not explain in detail exactly what I want to do. Let's start from the beginning. The company receives via email some PDFs which contain many invoices. Whenever we download and break them so that each PDF is an invoice (For example a PDF can have 4...

Hello, I managed to connect the SQL Server with the front end file but i am a bit concerned with the security of the connection. What can i do to ensure that the connection is encrypted and no one can access the data of SQL Server?

Yes, we are using Outlook. I don't think so that i can do it from there... Do you have something on your mind that could help?

Thanks for your answer! Yes and i couldn't find something. We receive them via email.

Hello, On our company we receive some invoices and at the same time we do 2 things: 1) Pass new record to access ( Id, Amount, supplier name, etc) 2) Save the invoice PDF at a network folder Is there a way to save the file to the network folder from a drag n drop field in ms access form? Thanks

Hello, I have a table called "LOADINGS". In that table there are informations about the loadings of orders.(Some orders have a lot of loadings) For example some rows: I want to create a query that shows me the LAST Loading Date of an order for all orders. F.e. for the order 20220160 i...

Recently, the laccdb does not close at all when the last user closes the database. Do you have any idea what's going on ?

Yeah i know that. I am tyring to apply the code in the default value property of the text box

I still get the same message. Does it need some special quotations in the criteria area? I just want to get the next loading id in a form, so i want to put this command to the property "Default value" I tried your suggestion but it doesn't work for all the records. In this point i have to say...

Good evening, I am trying to put the specific part of the code in the default value field of a text box but I get the following error. = DMax("LOADING_ID", "LOADINGS", "ORDER_ID=" & Forms![LOADINGS]![ORDER_ID] & "") + 1 What can I fix? Thanks!

Hello, i have made a script that compacts my access project based on a daily scheduled task. The command is: "MSACCESS.EXE" "\\server\DB_BE.accdb" /compact "\\server\DB_BE.accdb" It works, but every time it runs, i get a warning that says that the new name is the same with the old one. How can...