Search results

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

Have a look at the sample database for log in here http://www.rogersaccesslibrary.com/forum/topic104.html

Use an update or append query to add the FirstName and LastName to the table - this will add all the names in one go and access will automatically add the value for the primary key - assuming you have an autonumber primary key. Once you have the names in the table, you can use a query to look...

You can hide the error message with some code in the err_handler. Something like this: '--------start code err_handler: DoCmd.SetWarnings True If Err.Number = 1234 Then 'do nothing Else MsgBox Err.Description, vbExclamation, Err.Number End If Resume...

Create a separate field for the Yes/No data.

Without knowing anything much about your database and table setup, you can try to use the current event of the form to requery MatterName. The current event runs each time the form moves to another record. Putting a requery ( of Matter) on the current event should force the form to choose the...