Recent content by lorenzoaj

I just started this database and was wondering if someone would take a look at it and let me know if I am on the right track. Also if you could help me get rid of this error #Name?. I welcome all feedback. Thanks in advance. AJ

I have one txt box named txtDEROS and another named txtDaysLeftInCountry. In the after update event of txtDEROS I Have me.txtDaysLeftInCountry = DateDiff("d", NOW(), [txtDaysLeftInCountry]). It works fine except that it does not update daily when the date changes. I then tried it with a...

That worked great. Thanks a bunch. AJ

I have this in the control source for a txt box on a report. It works great but I need help. The [Loss] field is set to yes/no in the table. What do I need to put to have it count the boxes that have been checked? =DCount("[AUTH MOS]","tblGroupOfficerSlate","[AUTH Gr] = 'COL' AND...

Hello all. I used the wizard to create command buttons next record and previous record. Is there a way when it gets to the last record to go to the first record? Thanks in advance to anyone who can help point me in the right direction. AJ

I use this in the after update of my text box. It changes the first letter to capital. Me!YourFieldName = fProperCase(Me!YourFieldName) AJ

I had a problem with my toolbox also. I downloaded this example and mine showed back up. Hopefully it will work for you. Show hide toolbar example AJ

That wasn't it. I checked and they are all checked. Thanks AJ

Hello all, All of a sudden my toolbox is not showing up. I have gone to customize toolbars and it's not there. If I go to the view menu and click on toolbox nothing happens. I have uninstalled Access and reinstalled it. It seems that since this has happened all my reports have gone back to...

Thank you both very much. This is not my db I am just trying to help make it a little better. I do realize that spaces are not a good idea and I do not use them in mine. Thanks again AJ

Hello all. I have been searching the archives all afternoon and have come up empty. I have a form that has multiple command buttons that view different reports. The reports are based on queries. Right now I have a text box with the control source set to =Count([ASSIGNED NCO]![LAST NAME])...

Hello all. Is there a way to create a macro or write code that will unhide the database window. I have unchecked the box Display Database Window on startup so It doesn't show. What I want to do is add something to the switchboard so someone who knows what they are doing can create new queries...

Thank you both very much I will try your suggestions. Alex, I wish I could take credit for the code but I can't. The only thing I changed was the SQL statement and I copied that from the SQL View in the query. I do consider myself a beginner because there is so much I am learning every day. AJ

I am having a real hard time here and hope someone can help. I am trying to add to my report selections from a listbox. The report opens up but it is empty. I think the problem is that the data is not being sent to the table but I am not sure. I have attached the database because I am having...

Alex, The more I think I keep learning about VB and Access the more confusing it gets. I'm not sure how to go about putting breaking points in the code or executing it step by step. My knowledge of VB is very basic. I am very interested in learning all that I can. If you can help with this...