Search results for query: *

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

Hey Everyone! I have a birthdate database for work and had to convert it to 2003 access. It tells me how old a person is based on this query expression - Age: DateDiff("d",[birthdate],Now())+1 This worked great in Access 97 but in 2003 now anyone born after 07/01/1977 it comes up as a year...

After talking with the other Access programmer, (he is also experiencing problems using the 2000 Runtime.) We presented a united front and have talked with our PC support supervisor and he will see about getting our staff the 2003 runtime. You all have been a big help!! Thanks again.

Thanks for responding again. Hopefully we can figure out something together on this. PHV – The runtime was just bought and pushed to all our machines by our PClan personnel when we went to XP late last year. With company money being what it is, I doubt I can get them to purchase a 2003...

Thank you for your prompt answer PHV. Tho your response is plausible, it is not something that can be done at the moment. Maybe I need to adjust my coding to something the 2000 runtime likes. Does someone have a better coding to send a selected record to a report?

Our company installed all new computers which now uses the XP Operating System. All our in-house databases were created in Access 97 before the new computers, and now have to all be converted to Access 2003 using the Access 2000 format. Our Staff uses Access 2000 runtime to be able to access...