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...

Wow I never knew you could do that, even after years of working with VB ! Thanks for the tip !

Thanks for your help Pat Hartman ! You sure cleared a few things up ;) However you said What do I do in BeforeUpdate to stops the update ?

I don't know what the heck you are talking about. "Yes" and "No" are text string, of course they need quotes ! Beside you totally miss the point as my code REPLACE the lines with the "Yes" and "No". Which means there is absolutly no "Yes" and "No" in my code.

Why did you use a hidden textbox ( tbProperSave ) ? Instead I suggest you use a private variable. Just delete that clunky textbox and instead add Private ProperSave As Boolean in the general declaration of your form ( just after option explicit ) Then all you need to do is change the...

I read that already, but yet nobody tell how to makes the update only happens when you press the save button. All it does is prevent the user from quitting or switching records.

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...

Thanks for telling me about that great transfer spreadsheet command !

Great idea ! I didn't think of AfterUpdate..... I was thinking only in terms of query. You really helped me here ;)

Thanks, I will make good use of that link :cool:

Thanks for the help, and I will never use "Name" again as a column name

Thanks, it works ! :) However if I change Select [Name], Sum(Hours) As SumHours, [Wages per hour] From YourTable Group By [Name], [Wages per hour]; to Select [Name], Sum(Hours) As SumHours, [Wages per hour] From YourTable or to Select [Name], Sum(Hours) As SumHours, [Wages per hour] From...

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...

Apparently I need to fuse the textbox with a label but how can I do that

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 :(

Nice. However I have some questions : 1. Is there a way to let the user import the excel document himself, with an interface that I will configure ? 2. While importing, is there a way to automatically skip lines that do not match some criterions ? ( like empty lines, lines with irrelevant...