Search results

i use the id to create the path and open them.

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

Yes...

No, it doesn't work

Thanks! It works, but my field also saves the time... How can i fix that ?

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

Thanks, I ll check it!

Thanks for your answer! I really know nothing in form designing... So i need soemthing to start. I currently working an MS ACCESS project and the design-time has came... so i guess i will find something on the web

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

I have a query that returns the clients and there total orders. That query is used by a report. And I want to create a custom "sorting filter" that sorts my data based on the client's name and the increasing order of orders. It is possible with some trick or i have to create another report...

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

Thanks for the quick answer. Well, my sql code is this SELECT ORDERS.Week, Sum(ORDERS.TOTAL_ORDERS) AS SumOfTOTAL_ORDERS FROM ORDERS WHERE (((ORDERS.CLIENT_ID)=[Forms]![Contact Details]![ID])) GROUP BY ORDERS.Week; What do you think i should change?

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?