Search results

Hi, I have one form to calculate selling prices based on various currencies and generating customer quotations. Exchange rates and other parameters are entered on the MainForm A SubForm is used and based on a query where I have all calculations in the query. The calculations are referring to...

Hi, I have been searching and struggling with this for a while. I am looking to Round Up numbers as in Excel. I know Int function can be used as follow: Int(100 * [MyField]) / 100 Works well, however I want to have different roundings depending on the numbers. if value is between 0 and 1000...

I am looking to have a sequential number generated automatically that should look as follow YYMM+sequence Each new month, the sequence part would restart from one Example for June: 160601 160602 160603 ... For July as of July 1st: 160701 etc.... What the easiest...

Hi Guys, Been struggling for a while on this. I am trying to copy same records from a stand alone PopUp form and past on another subform by cliking a button placed on the PopUpForm PopUp form name: QuotationCreateForm Main form: Quotations SubForm: QuotationItems This is...

I have an Access 2010 Report derived from two tables joined by a UnionQuery for a "look like" bank statement with the following fields: TransactionID (Primary Key) TransactionDate Credit Debit The report is based on the following SQL: SELECT Q1.TransactionID, Q1.TransactionDate...

Hello everyone, I have a database connected to sharepoint lists. It's working fine. I would like to be able to create one form to display my contacts on a form based on the sharepoint list and open it with an Android smartphone. Can anyone help me on this ? What is the best way ? If...

Hi, Can anyone help me on this ? I have a table where I list the months by their numbers, "1", "2", etc in a column. On a form I have a comboBox [Combo46] based on that column to select the month. Now I would like to add quarters "Q1", "Q2", "Q3", "Q4" I have tried entering values in my table...

Hello, I am trying to have some DLookUp functions updated automatically. I have one table where I enter the monthly average exchange rate of currencies, the entry is made in the beginning of the following month. I have one table, where I enter all invoices and date of invoice. At the...

Hi everybody, I have bee stuck on this for two weeks now. I am traying to have a query sort out my invoices by year but also to have the possibility to show all invoices. I have one table "INVOICE" where I have a column "YEAR" calculated with DatePart function from the invoice date. On my...