Search results

I have tried that severally without any luck. Do you think reinstalling my MS Access can restore this back?

Hello Everyone, I noticed an unusual thing today. While on design view, my properties window doesn't show any more. Even when I right click an object and select properties, nothing happens and this has prevented me from setting any property. Can anyone point me to what I need to do to get this...

Thank you everyone. Thanks for the effort, time and ideas. Both samples worked with the same result giving me exactly what I want. The figures and logical ideas I am working with is from here: http://www.firs.gov.ng/personal-income-tax.aspx. I don't know if I was able to relate that well in...

I am trying to build a small payroll and so far everything has been OK until now. The challange I have is calculating the PAYE (Pay As You Earn) personal tax from the employee total earning. I my country the tax rate for PAYE is applied on a graduated scale as shown below: - First $30,000 at...

Here is what I have done: Private Sub cmdCopyToExcel_Click() On Error GoTo ErrorHandler Dim sData As String Dim X As Integer 'Select all Set lst = Me![lstContacts] lngRows = lst.ListCount - 1 For lngIndex = 0 To lngRows lst.Selected(lngIndex) = True Next lngIndex...

Thanks for your help Dave. I have observed that your listbox MultiSelect property is set to Simple which enables the select all button to be able to select all the rows on your listbox. This is not the case with mine as it's set to none. How can i modify your code to either at run time or...

I have attached a sample of what you need. It works like a charm. Unfortunately I can't remember from where on the net I got it from. If you do, say a BIG thank you to him.

Dear all, I have a BIG challange and I confident someone here can assist me. I have a list box with whose row source is a query (QryEmployees) bout to the table (tblEmployees). On my form I have a search box that filter the information as you type a serach item. What I want is to be able to...

I found away around it. Thanks for all your help. What I did was to have two hidden text box (txtFrom and txtTo) on my from. I have a function to get me the following das/period: Today, yesterday, This week, last week, this month, last month, this year, calendar year to date, and last year. On...

Hi, I have a record of my staff members. I display this on a form using a list box. What I want to do is to be able to click on various buttons each with an SQL statement like the one below that will filter the data by Today, This Week, Last Week, This Month and This Year. The code below works...

Attached is a sample of my user interface which will be deployed as an Mde file.

I will try this and revert back but just a quick one please. What is the appropriate code or method of passing openargs using .sourceobject = "frmCha"? It is very easy to use DoCmd but not with sourceobjetcs. Thanks.

David thanks for your quick reply. I do not have any master and child links. All I just wanted was for my form to open inside the sourceobject or subform but with the openargs. I have attached a scenario of what I am trying to achieve in the attached sample file I found somewhere on the...

Hi There, I have run into a problem I haven't been able to work around. I have a complete database where I open all my form mostly using this type of command: DoCmd.OpenForm "frmOrders". Now I am trying to redesign my database using a sourceobject where I can open all my forms directly into...