Search results

Dear All, Can somebody help me how to show my criteria on to my report header.. I based my report on a query and fill the criteria (StartDate) and (EndDate) to "PDate" control from a form where i open my report.. I would like to display the value of the StartDate and EndDate to my report.. I...

Hello all, I have this dateadd function, i wanted to add a year (2/3yrs) depending on the value of "terms" and "ctsreleased" field.. =DateAdd("m",[terms],[ctsreleased])-1 Like i have a date "30-Jul-2024", i want to give a me date "29-Jun-2027". Thank you.

Hello all, Just today when i opend and browse one of my table, i found out that some rows are blank.. Can someone pls help me, what causes this blank rows, and how to trap and avoid this to happen. All my entry form are bound to a table. Thank you..

Dear All, I need help to my report, please see attached, (a query data source and the report). I could not get a correct total (Sum) of commissions as it sums up all the rows as displayed in the query.. "Sum" function is not giving the correct summation.. You can see on the query that it shows...

Dear all, Please help me to write an expression for a commision.. Scenario are.. Agent code=1 (8%) Agent code=2 (10)%) TCP = 550,000.00 I need to test if the agent code is "1" (550,000.00*. 8%) or "2" (550,000.00*10%).. Please i need help very badly. Thank you.

Dear sir, Can someone pls help me to write a "word" for a "number", like php.150 - (one hundred fifty).. Thank you.

Dear all, I have a struggle in filtering a buyer having a 1 or 2 number(s) of payments.. Appreciate any help. Thank you.

Hello all, How to filter (date field) blank/no value of a query.. "IsNotNull" is not working.. I wanted to show only records with value (date). Thank you.

Hi all, Is it possible to make a template "certificate" and fill the blanks, like name and other details of a buyer when i print the template certificate? Any help would be appreciated.. Thank you.

Hello everyone, I would like to export my query to excel, and I grab the below code, sorry i don't remember the owner.. ------- Dim filepath As String Dim FileName As String filepath = Environ("userprofile") & "\Desktop\qryCrosstab_Payment" FileName = filepath & "as of" &...

Hello all, I have set on opening of the my db to hide the navigation pane and the shortcut menu bar.. How can i open the Access Option dialog/form to change the setting of navigation pane, shortcut menu bar from a button? Thank you

I need help of my report, I based my report to a query, and i wanted if no record to display, a message popup "no records to display", close the msgbox, focus will go back to "printmgr" form control where my selection starts.. thank you for any help..

Hello all, Can someone please help me to create a table for entering and monitoring a commission for each agent from buyers.. I have tables of buyers, payments and agents.. i hardly create a table which field to include in table commission.. i am thinking to put the id's from buyers, payments...

Hello all, What are these properties (pop up & modal) do to my form if set to yes / no?. Thank you..

Good day, How could I show all my records in my data entry form by clicking a button.. I tried "ShowAllRec" but it is not working (Invalid use of property).. Thank you

Hello all, My form opens in maximize even there is no maximize command on open/current/load. How to avoid this to happen.. Thank you,

Hello all, I am strugling to make a filter to my crosstab query, but i always get a "MS Access database engine does not recognize [Enter Remarks]as a valid field name or expression.. I think crosstab query is not same as ordinary query that can easily filter.. Can someone pls help me, i...

Hello all, Is there an easy way to syncronize record?. Situation, the main db is on the office (desktop) , 1 laptop is on site/off office.. My problem now is office desktop is updating/entering records, site is also updating/entering records, at the end of office work, site needs to upload...

Hello all, I have a situation that I was asked if possible to load records on form after selection on combobox of site id?.

I know this is a basic thing for expert here, but my knowledge of vba is very limited as of now.. I want to hide my calculated control on main form (based on subform control) if the control is no data, null or 0.. Thinking to put some code on my main form on current/open, but no idea what...