Search results

  1. F

    I need help concerning table issues

    Do you have an MSN contact where I can talk with you live? I need to get more clerified with you and I believe live is better than message board. My MSN contact is devastating_battle@hotmail.com
  2. F

    I need help concerning table issues

    Hello, I have a major problem with the tables I have and the forms. This is the scenario: For every single client info (address and so on) it can have many estimates, many invoices and many internal invoices. This applies for all the three what I am going to say next, but I will use the...
  3. F

    Insert SQL Error for access

    I have added you to my MSN contact list (I hope you are ok with that), my name is Fahed Al Daye. I want to talk to you live to solve the problem, and I want to leave sending you the file as the last resort. Please, can you go online as soon as you read this message? My MSN contact list is...
  4. F

    Insert SQL Error for access

    I follow your advise I remain to obtain the syntax correctly as you adviced and I followed your advice to the word and I still get the error message. Is it because the tables are in a relationship? If you have any idea please tell me, I remain to be stuck. This is the new line of code from your...
  5. F

    Insert SQL Error for access

    Refusing to work still, HELP I have did the new changes as you have suggested and this is the result I have made with the new changes: strSQL = "INSERT INTO Paid-Address (Invoice-Number, Invoice-Date, CustomerName, Balance-Due) VALUES (" & intInvoiceNumber & ",'" & strInvoiceDate & "','" &...
  6. F

    Insert SQL Error for access

    I keep getting the error Syntax Error in INSERT into statement. I don't know why This is the sql statement: Dim intRequest As Integer Dim intRequest2 As Integer Dim strSQL As String Dim intInvoiceNumber As Integer Dim strInvoiceDate As String Dim strName As String Dim intBalanceDue As Double...
  7. F

    I have a question about copying record please

    Please be more specific than that, as far as that reply goes it is all jebrish to me. If you can give me some examples too that would be greatly appreciate it.
  8. F

    Question about copying a data with a condition.

    Please I need help here, please.
  9. F

    Question about copying a data with a condition.

    I have an invoice set in a lovely form using Microsoft Access. Each of the invoice there is an option on the top called Paid, ones I check the paid it will stamp it as paid, how do I make it such as, it will copy the paid ONLY record into a summary cheat, which is a report? It have to be copied...
  10. F

    I have a question about copying record please

    I have two tables, one is called Table A and the other is called Table B: Table A contains these data: I II III Table B contains no data in the form of Microsoft Access, I want to be able with a push of a button and DEPENDING...
  11. F

    Problem calculating the sum of the entire Outstanding invoice.

    I have an outstanding invoice, it contains all the necessary information about the invoice, such as the customer name, billing info and so on. Each of the invoice holds the total balance after calculating the taxes and if there are certain discounts to be calculated. By the end of the invoice I...
  12. F

    Problem with my invoice and report

    Where would you find that option in the form design view?
  13. F

    Problem with my invoice and report

    No, in the table there are many columns Name Address City Province Telephone number and so on now I have created a form that links to the table, I want to be able to enter the name of the person in the form (bare in mind linked to the table) and with either macro or VB in the out of focus event...
  14. F

    Problem with my invoice and report

    No that would be silly because I have to enter every combo box to fill in the information where as what I wanted is to fill the entire field if it found the person's name already in the database automatically.
  15. F

    Problem with my invoice and report

    I have one more question I would like to ask you please. Thank you so much for the informtion it really helped a lot. I have one more question I would like to ask you please. I have this information Name Address Telephone I want to be able in Microsoft Access, when I enter the name "Fahed Al...
  16. F

    Problem with my invoice and report

    I have couple of problems I need to be resolved and I hope someone here can be able to help me. I have an estimate (all form designed), that when I click the button export to internal invoice, I want the contents of all the estimate moved to the internal invoice and display the invoice, without...
Back
Top Bottom