Hello everyone,
With the rapid advancement of AI, are there any platforms or applications where you can simply describe the tables, queries, forms, and reports you need, and it will generate an Access database to meet those requirements?
hi dears , i hope you are doing well
i have two issues here
1- in "Salaries_Emp" and "Salaries_Temp" Form when i Payroll Period then select Dep_Code then ID and save the record by clicking button Save
the Dep_Code combobox does not return to the last selection department so i have to select...
Hello Dears,
i have a form to record employee monthly Attending and leaving days and over time
i have Combo box have employees names , on the combo box after update i set text box "days" value to "30" as that is the most default number
in text box days i have some events after update it
but...
Dears ,
i hope you are doing well
i use the form ' Salaries_Emp ' to record the attendance of employees to table ' Salaries_Emp '
i need when i chose the department from ' Combo_Dep '
show only Employee Name in ' Combo_Emp_Name ' that dose not recorded yet
any help will be appreciated
Hi dears
In form invoice
i want to get US Dollar (Unit rate) in case the Project currency is USD from this site
for example invoice to : AC Boilers EGYPT -- Project name : Cairo West E USD 10089-CP-105 / Electrical I&C Supply and Installation
to be paste on "Currency Unit Rate" Text box
* date...
hi Friends , i have contract form which contain Contract_details subform
every contract have his own details items
in invoice form i have feild called invoice value
it should be sum of "item_Value_Current" in contract_details table
now i want When I choose project name , the items of this...
hi , I have a report named " ReportCustomerProject " it should show all projects in one page sort by
1- project type
2- customer name
3- project name
and it should show the sup total of every project but now the total text box shows total of all projects under every project
any help or advices !
I’m now try to mack clients management database for contracting company
It Consists of two parts invoices and payments
Every invoice have unique number
To be considered that every payment should be against specific invoice and not necessary that the client send all invoice at one time let’s...
I am now make small data base for client department, invoicing and payment
all data exist when i enter the invoice or the payment so it will be nice if i can make query or report to make the journal for this invoice or payment
i have the data base ready if any one want to give it a try
hi Dears ,
I have Date of invoice and collection Days i want to make Due date and statue of collection "Due or Not Due " and remaining days
for example:-
Date of invoice is 6/6/2021
number of Collection Days "30" days =6/7/2021
Due Date will be date of invoice + 30
statue of collection will be...