Recent content by JoeBeach
-
J
Generating records
Hey yall, Here's one to stump the band. I must find a way to generate multiple records that consist of a ticket number as one field, and whether they have been used or not as another. The ticket numbers need to be sequential, with an increase in value of 1 over each previous record. The... -
J
Overwriting subform address
Thanks for the alternate idea. (I too got sucked into the diversion of work, for a few days.) This solution seems to use alternate addresses saved for possible reuse in a third table. Unfortunately my original question is a classic case of thinking that giving an overly simple explanation... -
J
Overwriting subform address
The change in Name or Address would be for the bill of lading record only. The user wouldn't be concerned with making a permanent change to the NameAddress table record in this application. Here the change would have to be made on, say, AddrLine1 field(first address line), or, city field, and... -
J
Overwriting subform address
Hi. I am in transportation and am designing a form for bills of lading (air/sea/truck). There are two tables, a NameAddress list, and the BillOfLading record list. The bill of lading form has a drop down combobox to let the user choose a Ship From name and address, and another for a Ship To... -
J
Changing attachment name
Hi, I'm designing a quote application that assigns a quote number to each record. By choosing the email button, the user get's the option to convert the report to .rtf, .snp, ...etc, and then have the file automatically attached in a new email in Outlook or Outlook Express. That works. But... -
J
How would you create a trip enquiries form?
Re: Re: How would you create a trip enquiries form? Thank you. That's it in a nutshell. You use the subform input to generate the records in the junction table that consists of the ID#'s for the customer and the ID# for the trip preferred by the customer. -
J
How would you create a trip enquiries form?
As you have a table for Customers, and assuming separate table for Trips, try this. You’ll use your tblEnquiries table with its customerID and enquiriesID, by having a separate record for each enquiry/customer. As example, the tblEnquires’ records will be store the ID’s for Paris and Smith...