Search results

Hmm...are you saying I might be over-complicating this and the LIKE operator might do the trick? I didn't think like would work because of the random order people have entered those attributes into one field. Interesting...

Hi All, I've searched the web, the forums, everywhere, for guidance on this, and am just not understanding how to apply the posts and responses to my problem. Here's my problem: Background My small business (an equipment integration company, meaning we use parts from other companies to build...

Well, that little bit of code, and learning about querydefs and recordsets, have cleared things up in the case that a customer does have open invoices. Thank you. New question -- when a customer has NO open invoices, I get the error "no current record" and then the routine is canceled...

Ok, folks, I have a custom database that I'm trying to update at my company. On my Jobs entry form there is a button that "submits" new jobs a salesperson enters to the proper people internally via email notification. This part isn't elegant, but it works. I want to add to that button a...

At this point I am erring on the side of excessive info, though I'm starting to reduce the "prefix" I use a little. Transaction Date and transaction quantity are now TransDate and TransQty. VendorName, et al, is going to stay that way because it is already sprinkled throughout queries...

Maybe like shortening it to CustName and VendName ..? I'm thinking about this along the lines of somebody someday having to work on this DB that I'm rebuilding, and them going, "God, this guy was a moron!" ...on top of that, I just want to make sure I follow industry standards, whatever...

Hi all. So far this forum (three days) has been helpful, and I've searched through past posts to see if this question was asked, but haven't found anything, so here's another thread: I have tables tblCustomers tblVendors (actually there are about 15 tables, but these two will be good reps of...

Huh...this code with "Before Insert" helped me solve the Form - subform - subform problem I posted a thread about last night. Instead of automatically populating the ID fields to maintain the relationship, it forces the user to enter information in the right places first. It isn't what I...

Hello all, I've got a small problem with multiple subforms in Access 2003 (tied to an SQL backend): I have three tables, Jobs, JobsSub, JobsDetails for a project tracking database I inherited. Three forms are tied to those tables, which I've renamed frmJobs, frmJobsSub, and frmJobsDetails, and...