As well as looking for changes, you may want to work on tracking changes where the user deletes an entire record - if users can delete records in your database.
I use this code, and I have separate fields for date created and created by for new records.
That code goes in the Before Update event of the form.
If you want to only catch updates where a value in at least one control has changed, then you check for changes in each control and only run the...
My guess is that you need to open 2 different recordsets. (Can't see the rest of your code for this).
One recordset will get the value for strinfo for one row of the table rsNoun.
The next recordset will take strinfo and put it into the field called strName as in your sample code.
After you...
You probably have used the access feature called a lookup in the projects table. This would be a combo box in the table for projects.
Change the lookup in the table so that the priority has only 1 column with High, Medium, Low. - For a simple database this is probably the easiest solution.
On the after update event of the combo you could test for the value of the combo and if it is 13, open the pop up form where the user makes an edit to the data for that record. I assume that you have a textbox on the form that will show the additional info for the appropriate column of the...
When you use FindFirst, you need to use the NoMatch test with it. That will fix up the error with bookmarks.
The NoMatch test tells access to skip the bookmark bit if there aren't any records that fit the criteria.
Replace
If Not rs.EOF
with
If Not rs.NoMatch
Just realized there may be other ticket types, so use:
SELECT tblGym.TicketTypeID, Count(tblGym.TicketTypeID) AS CountOfTicketTypeID
FROM tblGym
GROUP BY tblGym.TicketTypeID, tblGym.GymDate
HAVING (((tblGym.TicketTypeID)="MG" Or (tblGym.TicketTypeID)="NG") AND ((tblGym.GymDate) Between...
SELECT tblGym.TicketTypeID, Count(tblGym.TicketTypeID) AS CountOfTicketTypeID
FROM tblGym
GROUP BY tblGym.TicketTypeID, tblGym.GymDate
HAVING (((tblGym.GymDate) Between #02/01/12# And #04/01/12#))
This will look like:
TicketTypeID Count
MG 25
NG...
You asked "but when used in a report I want to have "High" as the greatest value; how would I assign that property?"
If I am understanding your question, you want the report to show the "high priority rows at the top of the list?'
To show High priorities at the top of the report:
You can do...
You wrote: "I was looking for a solution that wasn't so "Access-centric". I ended up scripting a solution that worked on an excel file."
However you posted to a forum that specialises in access and vba - next time choose a forum which specialises in the type of code you are looking for. The...
Here is a way to hide the nav pane for A2007 and later versions. The great thing about this code is that it compiles in A2003.
http://allenbrowne.com/ser-69.html
I always use an ad blocker and I never have any problems with loading speed.
Are the ad posters those answering questions?
Why would a poster put 3 ads in a single post?
The front end won't compact the backend automatically.
There is a sample database that shows how to write code to compact the backend.
http://www.rogersaccesslibrary.com/forum/topic378.html
Note: you can't compact the backend while any of the front ends are connected to the backend. All users...
Here are links to code to compact.
1.Compact the front end
http://www.rogersaccesslibrary.com/forum/topic377.html
2.Compact the back end
http://www.rogersaccesslibrary.com/forum/topic378.html
Compact on close on the front ends is not a good idea for a multi user database. Especially in A2010 it can cause corruption - there have been posts where this has happened.
Assuming that you want to compact the data in the data file - the back end - the compact on close call in the front ends...