Search results

Thanks for the help! For some reason restarting the mysql daemon didnt fix the issue, but restarting the server did. I didnt think I was going to have the opportunity to restart the server for a few weeks but as chance would have it...

Hello, The database ran this same query as part of a macro that is run weekly for over three years: SELECT tlog.Num, tlog.Uniquet, Count(tlog.Code) AS CountOfCode, Sum(tlog.Amount) AS SumOfAmount, Min(tlog.tTime) AS MinOftTime, Max(tlog.tTime) AS MaxOftTime, transacts.fValid FROM tlog INNER...

Wow, that was really quick. Thanks for the help, looks like that function is just what I need!

I'm trying to update a dozen or more queries that have january first of 2009 hard coded into them. So that I'm not doing this same thing again this time next year, I was hoping someone could provide me with the correct syntax for criteria of 1/1/[current year]. I've searched the forums and...

Oh I see...That makes sense. Since my combo box is bound, do you see a problem with the way my code handles preventing an alteration to underlying records?

Awesome code missinglinq! That's a great help. I used the wizard to re-create my combo box so that it goes to view the selected record in the combo box. Which created this code. Private Sub Combo43_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs...

Thanks for the suggestion pbaldy! Changing the form properties to not allow editing does prevent the user from editing the record. However, it makes the combo boxes I have on the form pretty much useless. You can scroll through the list, but can't select a different name. My desired...

I have a form that has two combo boxes that display a persons first and last name. Those combo boxes are pulled from the names table. Based on what value the user chooses, the appropriate name ID is stored in the application table. That is fine and dandy for creating a new record. However...

Lagbolt, thanks for letting me know what event to place the code into. Will definitely come in handy in the future. Somehow I glanced over the event current in my search... HiTechCoach! That's exactly what I was looking for. You coded it and everything, awesome! I hate to go asking...

I created this code to change some text on my form to indicate if the name record is a current card holder or not. It's overly complicated because all cards expire at the end of the year, but if they applied within the last two months of the year then we give them a card that will last until...

Thanks for the information. I will keep your suggestions in mind, but in the case of adding an application I'm not sure I can get away with using the notinlist event since it would mean needing to input a complete name record instead of an application record. I fear that using the notinlist...

I have an application entry form that has combo boxes to display the existing name records. Currently if someone searches through the combo boxes and hits the "add name" button upon realizing the name is not in the system, an error is thrown asking for input into the phone field. This could...

I changed the syntax to what you wrote and it didnt work initially, but after changing 'DoCmd.OpenForm frmNames, acNormal' to 'DoCmd.OpenForms "frmNames"' it worked perfectly. Thanks for your help!

I'm stuck on how to solve this problem. The onclick code below is to open the names form, and is located on the application form. I want to set the initial view of the names form to the record with the name ID currently being viewed. This code does that perfectly. However, if someone...