Search results

Hi all, I have always relied on Design View to create my queries, usually with great success, but in so doing, I have not become familiar with SQL view, so can't solve this problem: I have a very simple query whose only function is to sum the payment amounts received for each contract number...

:confused: I am trying to get a form to check and see if the contract number already exists before allowing a user to enter it. The form has a cumbersome name, which doesn't help with coding, but I'm stuck with it. The following code is meant to find out if the contract number the user is...

Not exactly what I want to do, but very similar! In our contract writing program, ONE client may have MANY vendors. Usually, all the vendors are reporting to the same address - the one on the client's contract, so I usually want all of the vendor contracts to display the same location address...

I would like to open a custom dialog form if a user includes the word "Addeudum" in a text box AND the property Addendum Yes is No (False). What I have so far is: Private Sub Notes_AfterUpdate() If Me.Notes.Value Like *"ddendum"* And Me.[Addendum Yes] = False Then DoCmd.OpenForm "See Addendum...

Hi, I have gotten in the habit of just copying and pasting my database to a new folder, then changing the name to create a backup copy (for instance: mydatabase_backup_090408 for today's date. But is this a bad thing, as far as the integrity of the database goes? In other words, is there...

Hi, I'm working with a database that I didn't design (but have modified since I worked here). As I found it, everywhere a person's name is required (client, employee) has two fields, first name and last name. Is this a standard design practice to aid in searches? an indexing issue...

Hi, I have inherited a database that writes contracts and invoices and I now need to add something to it that's beyond my pay grade! Right now a command button on the contract form (Me!) opens vendor contracts (called "multi-confirmations") that match the contract number (EventID). It was...

Hello all, I have inherited as part of my job a small database that writes contracts, addendums and invoices. ONE contract will normally have only ONE addemdum, so the fields for these two documents are all in the same table - makes sense. Except, our people often like to have both the...

Hi all, I inherited a small Access program that writes contracts, invoices, etc. and want to add some features to it. Whenever someone clicks "add new contract", Access uses an auto number field (which is the primary key) to give that contract it's unique number, which seems like a good idea...

Hi all, I have a simple little database that I created to keep track of overdue contracts, payments etc and I periodically make a copy of the whole program as a backup. Up until now it's been slowly growing in size as more bits of data get entered in records and was up to just over 12MB, but on...

Hi everyone! I'm working on creating a small database for the company I work at and just can't figure out the syntax to make this work. If I create a query that looks for clients Like '*Smith*' , it returns records where the client is John Smith, Smith and Company, Edward Smith & Jones, LLC...