Recent content by JoeTekTips

This has been working really well, but recently the database has been split. Now, if each user starts a record at the same time, the get the same ticket number. This happens until the record is saved and closed. Does anyone have an idea on how to avoid this? Thanks, Joe

Just a note: The DLL only worked for me when it was in the System Folder. No big deal, but it claims on website that it can be only in the same folder as the access db. Otherwise, works great. I put it in OnLoad in both forms with with subforms and don't bother shutting it off. Bravo Lebans...

Works great now. You the man, Tony! -Joe

Tony, Thanks for your quick reply. I tried this, which formats it exactly the right way, but does not increment each time like before. Any ideas? Thanks again, -Joe

This is a follow up. The code above does work wonderfully. Now, I've been given an additional requirement; I now need the value eliminate the first three places. For example, instead it beginning 2005.... it should start 5..... Anything that I have trying so for has been unsucessful. Any...

Hello, I am still stuck on this one; For a form that creates a job ticket, I need to get values from a query and assign those values to certain applicable text boxes. One query value is based on the currently selected value in a combo box (cboCustomer). I had a suggestion in another thread to...

That is certainly an easier approach. I don't know if I can assign the values from each particular column to certain text boxes. That would be nice, becuase the ideal thing is to get the values from that query into the text boxes. I am considering using your idea. If I did, the user would be...

First, thanks to everyone for thier help in the past. There are some tricky things that I have to deal with for the application that I am creating and I am more of an Access novice than expert. Anyhow, hear is the latest challange. On a form that creates a new job ticket record, I need to have...

Yes, is Access VBA. The code posted worked great. Thanks, -Joe

Pretty simple question, sorry if this is a little too simple; How do I check the open propery of a form in an if statement? I need something like this; if( frmJobTicket isOpen = true) 'do this else 'do this Thanks, -Joe

OK, the following does work for the form that creates a new record of rates for a particular customer; Fist, I open it with the code (shown above as well); Private Sub cmdOpenDefaultRateForm_Click() On Error GoTo Err_cmdOpenDefaultRateForm Dim stDocName As String Dim stLinkCriteria...

Sorry if I was not clear... There is one form that is called frmDefaultPricing, which opens to the record of "Customer Quote". Any user can open this form and adjust the pricing close and save. This form only deals with that one record. The other form, is one that is for creating a new...

Thanks, Richard. The default record can change from any user level. From the main menu is botton to open a default rates form that allows the default pricing to be ajusted. That form opens to the default record via the following VBA code; Private Sub cmdOpenDefaultRateForm_Click() On Error...

Hello, I have to open a form that will be used to create a new record. Typically, I would just set the Data Entry property of the form to "yes" and would be pretty much set. However, when the form opens I want to use the default values that are contained in a particular record of the data...

Ken, Thanks for your input. Here is what I did; I used this in the LostFocus property of the first in tab line of text boxes (actually a combo box); MaxNumber = DLookup("Nz(Max([JobTicketNumber]),Format(Date(),""yyyymmdd000""))", "tblJobTicket", _...