Search results

The open table and closed table are part of the Corporate database that I use and I am stuck with them. My database is an adhoc off the main dbase. In my question I am only working from the open table based on criteria. What meets criteria today and is reflected in the sum total may not meet...

I am re-designing a database for 2008 and trying to eliminate my Make Table Queries as I have found them to be somewhat consistant over the last year, particularily when the users do not open the database on a given date. It seems there should be a simple way to accomplish what I want but I am...

I am trying to do exactly what SLH has described for the subject line. I used the same format that SLH did, but it is not working for me and I get an error message when I run the macro that says: Microsoft Office Access can't parse the expression:""="Work Order Status/Completion Details: Work...

I am currently designing an employee suggestion database. Does anyone have, or does anyone know of a location to where I might find the shell of a Employee Suggestion Program?? sorry if this is the wrong place to post but was not sure where it should go.

thanks for the send. Actually, I also found the same database sometime ago and that is the sample I am using. I have removed the buttons but as the code is written, it will only read the first message I put on my table, and none other. I want it to read the Last message on the table...

Have a database that when opened, has a message box that appears and when this box is closed via a Close button that I have named "OK", the main form opens. I have a Tip table that I type in the message which then appears in the messaage box form. It works perfectly providing I use a Next...

Filter Report by Form No, that did not work, but I did find out what was wrong. The tag names were not set on my property fields correctly. I have everything working perfectly. When the report is opened, it will autmatically open the filter form that contains the combo box's that are used for...

I have a report "Work Order Details" that that is based on a query and opens along with a form that is used to set filters. Based on samples I have looked at and reading, I cannot figure out what is missing. When I select my item form one of 5 unbound combo box 's and click the "Set filter"...

Thanks for your help, and I apologize for my late response. with your help, have everything working as I would like.

I am not an expert by any means and after several hours of fighting with this I could really use some help. I have a form based on a table that has multiple combo boxes. I did make a query (with filter) from the table linking to the other tables used in the combo boxes so the fields would...

I figured it out myself. I used DLookup on my new record button that would capture the name they had originally set on the form.

I have looked at multiple samples on this forum and others and cannot seem to get the result I want working. Have main form TmLdr made from table of same name. Entries include ReqName and CostCenter. These same entries are on a subform. On the After Update event on the CoRecDt (main form)...

I would love to be able to help you, but I have exactly the same situation as you, using the same code format. Only problem is you got yours to work, even if for only 1 address. I cannot even get one address working. I have tried so many changes that I have lost track of where I am at. Even...

OK, I think I figured out what I will do and that is set up some drop down boxes based on a few extra tables. I think that will do the trick.

Looking for advice on how to make changes required in my database designed to track health wellness. Here is a breakdown of what I have now: Membership Query built off membership table that isolates one employer group and creates age off birthdates that will change as the months go by...

Perfect!! I almost had it, except messed up on a few of the "". You have been a terrific help and I can't thank you enough. This one example has showed me a lot of things that will come in handy on all kinds of projects. Jean

thanks for your help on this, I really do appreciate it. I was looking at all the code entries to see how it was put together and it will be useful for future projects. I understand what you are saying about the multiple entries. What I may do is use this for a specific group that is smaller...

This is very neat. Thanks for posting. I can see many uses for this.

I appreciate you assisting me with this. I am frustrated when I cannot figure it out myself but I do realize that I still have a lot to learn. Will I ever know it all...............No!

I appreciate it. It is so frustrating to know what you want to do and not be able to quite finish it. Unfortunately I want to be able to do anything and everything in Access right now, which is what makes going through the learning stages so hard.