Search results

  1. C

    SQL Statement I can't figure out :(

    I have a table (Well actually a query called ClientSearch) which is for example holds this data: CUSTOMERID NAME APPLICATIONNO 1001 Bob 5001 1001 Bob 5002 1002 Jane 5003 1003 Fred 5004 1003 Fred 5005 1004...
  2. C

    Sql query to test you, Im having trouble with it..

    I have about 4 attributes of a table called Customer which has a primary key CustomerId then FirstName, lastname, phonenumber Then it has a relationship with another table called Application with a primary key of ApplicationId then Type, ExpiryDate, CustomerID CUSTOMER(CustomerID, FirstName...
  3. C

    Running vba code in a Mde

    Whats the deal with Mde's? I can compile my mde fine. But it wont run any of my vba code that ive written for my database. I know that the source code isnt displayed. But I didnt think the vba code just wouldnt run as well. What is the point of a mde if you cant run vba code?? I must be doing...
  4. C

    Which database is recommended to use?

    Our business is using Access 2007 for its database. It users the workgroup way (Not sure what its called) to connect multiusers to the database. Our database is a immigration company that records information on customers names, address's, what visa/permit they are on, invoicing and recept...
  5. C

    Question about Normalization

    Im new to Normalization and working on updating my database which has about 1500 clients in it for my parents immigration company. I want to reduce the size of the database. I have for example two tables that are CLIENTS(ClientID, FirstName, Lastname, PermitType*, PermitLocation*)...
  6. C

    Select latest Address

    Im trying to create an invoice but if there is more than one address. Then it keeps on creating more than one Account information. For example more than one quantity, description and unitprice. Ive tried to use MAX on AccountID but this dosn't seem to work. Any ideas? Here is my SQL
  7. C

    New record forecolor

    Ive got a datasheet on a form. Is there anyway to change the forecolor of the default values on just the new record bar?
  8. C

    Sub subform, improper use of null

    I have a form (shown in the picture) that has a sub form and a sub subform. Im woundering what is the best way i can add a record in the subform so i dont get the error "You tried to assign the null value to a varable that is not a varant data type" when the user tries to add a new record...
  9. C

    Query Help

    Ive been trying for days to get a query to behave the way I want but ive come to the end of the road.. I have a table called ClientDetails and a table called Applications. They are linked up by a field called ClientID. In ClientDetails i have another field called ClientNumber (along with many...
Top Bottom