Recent content by southboy

TheAceMan1 I appreciate your help with this. The form is bound to a query that has all the fields from both tables in the database. The combo box is unbound and yes I want only the latest record to show in the combo box. The code is: Private Sub Pick_Click() Me.RecordsetClone.FindFirst...

Thank you for the tip and I'm doing well, thanx for asking. I now can get the combo box to fill the form, but the combo box now list every instatnce of the record by date. How do I get just the last entry to show in the combo box and fill in the fields in the form as well? Thank you!

I have a form I use to pay monthly bills. I had a findrecord combo box and a find next record button that worked before MS Access 2007. After I selected the bill I wanted to look at it would fill the form fields with that record and I could edit it. After I converted the DB to 2007 now I get...

Thank you jsteph. That does do the trick some what. It stops another instance of the DB opening with the MS Access application opening and producing an error that has to be answered and then the MS Access application closes. Do you mean in using a front-end/backend, to split the database? I...

I have a database I use. If the database is open and the shortcut icon is clicked again, another instance of the same database is open, so now you have two instances of the same database open. If you enter information in one, it is not reflected in the other until it is closed and reopened...

Thank you both for your responce. Pwise, both of yours worked just right. Output...rsouthboy Thank you for your help with this.

I have a database that has tables based on the Windows userid of the person who opened the database. When opened a form opens that the user inputs work information for their job. The form is linked to each of their personal userid tables. The windows userid's where based on the first initial...

That worked GREAT! Perfect! Your Awesome Remou! Thanx for the help! Southboy

I have a bills database and I need to find the last date paid for each bill in the bills table so I can start weeding out bills I don't pay on anymore. I'm tring to do this in a query but can't seen to get it. I've tried using the MAX, DMAX, DMIN, datediff and between dates to not avail. Any...

I agree, it does seem strange. Maybe someone reading this thread along the way to a fix for their problem will know what the deal is and let us know. In the mean time, the last code I posted is working, although I don't know why since it is using "yyyy" and the others using "yyyy" wouldn't...

If your getting something different than I am, then there must be some setting in my MS Access that is changing the way dates are set. Most of the code I have looked at is they way you are stating, but gives me different results. I did find this code and it seemes to work, but it also checks...

Your code only returned everyone as 1900 in AGE. If I use "yyyy" instead of "d" it returns 1900 for everyone. Here is the SQL code I'm using: SELECT TokcPersonnel.Fullname, DateDiff('d',[Birthdate],Date()) AS Age, TokcPersonnel.BirthDate FROM TokcPersonnel ORDER BY TokcPersonnel.Fullname...

SkipVought, yes, the table birthdate field is set to Date/Time and the format is set to shortdate. Southboy

SkipVought that is the code that worked in Access97 for years and works somewhat in 2003. If I use Age: DateDiff("yyyy",[Birthdate],Now()) Then it returns the year 1900 for everone in the query regardless of them being born before or after 07/01/1977. query result using 'yyyy' in the...

Skipvought Thanx for your quick reply. I only request help to Tek Tips as a last resort and only after checking the MS online help, MS Access application help and Tek Tips for my problem. I have tried all sorts of similar suggested coding from all other area's I could think of. Some gave...