Recent content by MontgomeryPete

Thanks for the tips, PHV and SkipVought. This was a good exercise (and lesson), although it helps more when I got into the right forum! Pete

Hello: I new to VBA, and I'm not sure if I have a code problem, or if I am calling the routine incorrectly. We want to generate tickets with varied data on them, but need to keep the numbers in sequential order for accounting purposes. I have built simple form to let the user input ticket...

Thanks. I got rid of the join and the auto number. I added a function I found on TechOnLine (Access section)to enable a loop to control the ticket number field. My work is not elegant, but it got the job done. Thanks for taking a look at this for me. Pete

Hello: I am trying to develop a quick application where "tickets" could be generated quickly for a transportation service. Basically, I am trying to print these with MS Access label function so they can be obtained on demand. The following sample code should take the text input in Ticket and...

Thanks for the help. Sorry for the slow acknowledgment--family emergency. This solved the problem. Pete

Hello: I am having difficulty with an inner join generating thousands of records on query execution. We are matching addresses in order to load a geocentric address to optimize our routing. I have cleaned up the addresses to conform to the style provided by the software vendor. We have to...

Thanks again for your help and advice. I wish we could predict the future, but best guess is we will be independent for another 24 months. So, we will stay on SBS 2003 for now until the crystal ball gets a little clearer. Pete

Thanks for your help. Do you know of any reason why we just can't move our SBS 2003, together with applications and data to the new server? Thanks again, Pete

Hello, we are planning to upgrade our server which is running SBS 2003. Our principal application for passenger reservations is running on MS Access 2007. Our network people (outside firm) want us to upgrade to SBS 2008, but JET SQL is not based on 64 bit architecture, so presumably it will no...

Hello: I am preparing a purchase order system with the first grouping level being the vendor and the second the equipment item number. I have a sub-report with the detail work to be done on the item. Group 1 Vendor Group 2 Equipment number Subreport New Page Repeat until...

Thanks MajP. This worked fine with the network.

Hello: I am trying to populate a field called UserID, contained in a subform using a module written by Dev Ashish. The module is cited in http://www.mvps.org/access/api/api0066.htm. We are using Access 2007, running Windows Small Business server 2003. The workstations use XP/Pro. I have...

Thnaks to both ZmrAbdulla and TheAceMan1 for different but good answers to the questions. Thanks much for the fast response. Pete

Hello: I am trying to update a field based on the action taken on a checkbox as follows: Private Sub Dispatched_AfterUpdate() Dim strSQL As String Set strSQL = "UPDATE Ride SET TimeDispatched = Now()" DoCmd.RunSQL strSQL End Sub The error message returned is Object required (Error 424)and...

Our email in inbox disappears if you open it more than once. We cannot find it anywhere. The safest place to put the mail is in the deleted folder. We do have the spam rules turned on. We are not running email over our network--we are still using Cox (braodband) servers to handle the email...