Search results

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, 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?

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 ?

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

I have put icons on the buttons of a form. But every time I click the button, the image disappears and the button prevails. How can i avoid this? Also the picture type has to be "shared"?

Hello, I have a form to save some invoice's informations ( Id, Date, Amount etc) But the process is time consuming: 1) Receive invoices from Outlook. 2)Add them to a spesific network shared file manually 3)Rename them to invoice_id.pdf At first can i "upload" them from the ms access form...

Hey, i want to run a query that uses a DateTime criteria as follows: Dim SQL As String Dim rs As Recordset clientId = Me.CLIENT_ID supplierId = Me.SUPPLIER_ID dateIss = Me.AddedAt SQL = "SELECT TRANSACTIONS.ID FROM TRANSACTIONS WHERE (TRANSACTIONS.TRANS_CAT = 1 OR 3 OR 4) AND...

Do you have any guide that could be helpful on how to export tables and data from ms access file and import them to sql server ?

Do you have any suggestion about the form design?( fonts, Colors, etc) is there any form template that would be ideal for a small company application?

Hi there! I have a table which i store my invoices which are divided into 3 categories. I distinguish them, depending on the value of a field is 1, 2 or 3. Also, I have a form in which I have 3 check boxes, corresponding to the 3 different invoice categories and I want to make a query in...

So I have, a report that shows all the customers and their total orders. I want to custom-sort this report ( alphabetically, ascending order, descending order based on the total number of orders) without creating multiple queries and reports. Is there any solution with VBA code? Thanks

Hello, so i wanna create a query that returns me some recordsets( sum of orders/per week). After that, i want to make a graph using that data. The problem is that i want to display in x axis all the weeks of a year(52), but the query returns only the weeks that orders exist. And my task is to...

Well, I have my order form and a button which it should open us the invoice form for this spesific order, if exists or add new record (invoice data) How can i combine these two functions?