Search results

I don't know anything about .ini files so if you can create one that knows where everyone's BE is without you telling it then I say go for it because to use my suggestion you will have to tell the program where the BE is the first time you/they use it. I know you are against the Common Dialog...

Save the path in a table.

Hmmm, you say, "Is there some way to get the order by BotanicalName when there is no botanical name in the tblPlantCharacteristics?" If there is no field in your table called BotanicalName then how can you sort on something that does not exist? If your statement is in error then create a query...

I would use a combo box to display the CustomerName or ID, whichever you prefer, and then use the combo box as the criteria for the query with code similar to this: [Forms]![FormName]![ComboBoxName] If the combo box is bound to CustomerID then you will be good to go and the user cannot select...

You are welcome. Continued success with your project... Jack

You only want one table for cases, old, new, complete or incomplete.. Entering them in any order is not a problem for Access, only people, so you need a way that you can see the data in a way that you can relate to it and that is what queries are all about. You can add a Yes/No field to your...

I don't know how you have things set up but could you have a field for the point(s) and a Yes/No field for POD. You can give everyone, or no one, points but only check the POD box for the player that was in fact selected as POD. I am not sure that will work but it is the only thought that comes...

I am glad you found a solution that worked for you! Jack

Why do you have two tables with the same fields? I assume that they have similar data and if that is so then you should only have one table. I am beginning to think that your database structure is not correct, especially if you have two tables with the very same fields and this may be why it is...

You are welcome. I am glad that it worked for you.... Jack

I have seen a lot of sample databases but I have never seen a database for a catering business. You might look at the sample databases that come with Access to see if one of them can be 'modified' for your situation. hth, Jack

Would it work if you had a player called All and when the coach wanted everyone to be POD you could select All instead of a single player? Jack

You can make a separate subform for each item that you want to appear on the mainform. As long as you can properly relate the data you can have the three separate subforms on your main form. These three subforms can be in a forth subform if you like so you and have your mainform and subform with...

YEEHAA! You are welcome... Jack

1. The Control Source for the Calendar control should be blank. 2. In the On Load event of the form use code like this to set the Calendar to todays date: Me![Calendar3].Value = Date 3. Go back and add an unbound text box control and it can be hidden if you like. 4. Use this code in the Dbl...

This statement is what I was basing my answer on, "...when I double click a date on the calendar I want it to invoke a query based on only the date I picked. (My table is an event planner, so when I double click a date, I want to see all the events on that day only). " Now, do you want to show...

Make a new, blank database. Import everything except the modules from the db that is hinky. Now make a copy of this to set aside so you do not lose any data. Now import the modules from your 2 month old backup and see if that cures your problem.... hth, Jack

Add this to the Criteria line of your query in the Date column. Change the names as appropriate: [Forms]![FormName]![ControlName] Also, is the name of your unbound control "UnboundControlOnForm"? If not, change your code to the actual name of the control. Be sure and do the same with the code...

Your table is not normalized. Once you normalize your table then you will easily be able to get the information your boss wants. tblOrders OrdersID (PK) OrderNumber (FK) OrderDate Item hth, Jack

Code similar to this plus the criteria I suggested (using your actual form and control names) in the previous post should do the trick: Private Sub Calendar3_DblClick() Me.UnboundControlOnForm = Me.NameOfCalendarControl.Value DoCmd.OpenQuery "BOOKINGS Query" End Sub The above code will put...