Search results

David- No offense taken. I certainly appreciate you advice, and definitely agree with your motto. Thanks again for all of your help. Jeff

How did I miss this? How to Use a Bound Control to Find a Record (95/97) (Q136123)

Hi David- Thanks again for your help. Not just for the solutions you have provided but for getting my mind working as well. However, since the initial request was more concerned with how to handle an attempted duplicate entry on a new record, rather than looking up existing records, I wasn't...

David- Though I can't explain why, my experimenting with the solution led me to believe that the problem lies in the fact the lookup is unbound. The following uses the bound control with satisfactory results. Private Sub SSN_BeforeUpdate(Cancel As Integer) 'If SSN already exists, move to...

David- Thanks for all of your help! It turns out that I came up with a simple solution that has worked well. My code: Private Sub SSN_BeforeUpdate(Cancel As Integer) 'If SSN already exists, move to existing record Dim strLookup As String strLookup = Forms!frmSubscribers!SSN If...

AllowAdditions, Deletions, and Edits are all set to yes. Do you have any other ideas as to why I could get this message?

Jack- I tried adding... DoCmd.GoToRecord , , acNewRec ...on the NotInList event but it gave me run-time error '2105'. You can't go to the specified record. You may be at the end of a recordset. What am I doing wrong?

I currently have a form linked to a subform by SSN. If a previously used SSN is entered into the master form, the subform displays the information for that SSN. Of course after a user enters all the other data into the master form, or tries to make an entry into the subform, they are told...

Thanks Ott! That is exactly what I was looking for.

Thanks Pat! Pardon my poor naming. It was a test table I created and it must have slipped my mind. Unfortunately changing it to DateUsed yielded the same results.

Thanks Ott- That seems works to some degree. Unfortunately when I run the query the "HoursRemaining" value is the same for every date. How can I get the results to show the hours remaining on each and every unique date?

I would like to create a query that includes "Date", "HoursUsed", and a calculated field named "RemainingBalance". The “RemainingBalance” field needs to be computed on a rolling basis and would look something like this: 480 - (Sum(HoursUsed) WHERE Date > (Date - 365 days)) In other words, 480...