Search results

Is it possible to update a field in a record using a VBA button ? What i want to do is have a button on a form, which when pressed changes a certain field value from its default "no" to "yes", i am happy with how to do the yes no VBA question box .. but the code on how to udate the field ...

each record is for a report, each report typically involves two people, the team leader and the team member. I have a table containing the staff involved inthe reporting process, other information included is their charge out rate and roles. Staff list (table) ---- Leader (Query)...

Ok here is my problem, i have a table which contains a list of staff, the charge out rate and then team role (this is either leader, member or observer) This table is interogated by three queries to identify the leaders, members and observers, which are used as lookup sources for my report...

any chance of an access97 version pretty please ? thank you

the only issue i found when not storing the result of a calculation from a query came in when persons recieved promotions and payrise, the query would then reflect the new hourly rate and not the old charged at the time to the project which would be incorrect.

Having had a read through the various security options availble to me when looking to secure my database, talks with the users move towards using a system which is based on the current logged on machine user, rather than requiring a user name and password combination. I would have three levels...

works a treat, thank you :D

go for it.

Works a treat, many thanks :) I also must be getting the hang of the VBA (to some extent) as it is now making increasing sense to me) Thanks once again.

Runtime error "13" - Type mis match when running your sample database Function FirstOfNextMonth(datAny) ' Returns the first day of the month following the specified month. FirstOfNextMonth = DateSerial(Year(datAny), Month(datAny) + 1, 1) End Function Sadly i do not know why, any...

that is super fantastic guys :) thank you very much indeed :) :)

ok, what i would like to be able to produce is a report in which every other row has a grey background, so you would have a report in which you had Grey row [information here] White row [information here] Grey row [information here] and so on, i am told this is possible in crystal reports, but...

Why can you not place something in the startup folder ? seems to work on here on my work network.

When using the modUSER and modCNAME to display the current logged in user and machine name, how would i go about writing this to a table when a record is created ? This is a great little bit of code which is fantastically useful, if only i were able to record the instance of the user creating...

ok, so i now have a tick box for the position that each person fills ...

heh heh, duely noted but back to my original question ... ;) anyone ? ;)

I decided upon a value list which contains "Yes";"No", the query is then based on SELECT Tbl_Mytable.PersonID, Tbl_Mytable.name, Tbl_Mytable.Grade_ID, Tbl_Mytable.Leader, Tbl_Mytable.[COR Int] FROM Tbl_Mytable WHERE (((Tbl_Mytable.Leader)="yes")); I used the value list, rather than the tick...

I have a table which contain information about a report, part of the record set includes team members, some are qualified as team leaders, some as team members and then others as team observers. I have used a query to create the list behind the drop down box to select the "person" for each of...

I have a similar thing running on my database, do you want to post your table and form so i can have a play please ? All solutions shall be posted back as a database,

"my table" contains report records, the query runs to create the report number - based on the SAreportref & IWP_number AS NewField query, this will then display on the report form. I was looking to write this as a value to the table so when creating reports and running with automation to word (...