Search results

Hello, I'm trying to search an entry of a recordset with VBA The entry can only be found by searching 3 field values. In my case the correct entry can only be found if the data in the field Date, No_Employe and No_Project all match the data of the entry I want. Findnext doesn't work, it only...

I searched google for sample databases and most forms are rather primitive... Currently there are some features to make more user-friendly forms that I have yet to find in excess: 1. Stop updating record automatically : For some strange reason access auto-update the records the user...

Say my table looks like this Name Hours Wages per hour John 7 7,75$ John 9 7,75$ John 10 8,75$ John 2 8,75$ Mary 3 7,75$ Mary 4...

How do I make it so that while filling a new entry in a form, the form's fields contains by default the previous entry's values ? So if for example the user put "20,95$" as the hourly wage for a person, once the user makes a new entry it puts 20,95$ on the hourly wage of that person ?

Say I have table called "project" that hold info like project name, project date, # of project, etc. And I have a table "employee" that hold info like name, salary, # of employee, etc. Project and employee are linked together ( many to many ) on a junction table. Basically "# of project" and...

I'm trying to update a control only. The control updates if I do NameOfForm.requery Yet it doesn't update if I do NameOfForm.NameOfControl.requery Why not ?

My form is in datasheet mode. One of the textbox is called txtHours When I access the form the column caption is "txtHours" ! As you can expect it looks ugly. So to get a decent caption like "Hours" I am forced to set my textbox name to "Hours" ! As you can expect it goes against my coding...

Is it possible to export the report as an excel document ? It only let me print the record :(

Is it possible to import excel data in a table ?

I have a textbox on my main form that calculates the total of a field on the sub-form. It works well and display the correct ammount on the textbox when I load up the form, but if I do changes the values of the sub-form it doesn't update at all ! I need to close and open the form again to see...

I'm using one form and two sub-form. You can select a project ( main form ), for each project you can select people who work for it ( sub-form 1 ) and for each person you can add work hours ( sub-form 2 ). How can I calculate how much total hours were spent on a project ( or on all project ) ?