Search results

  1. A

    Microsoft Jet database engine stopped the process Error

    Hi All My department has customer database using microsoft access with the main table being a linked table to SQL-Server database down in IT department. I've only been recently made aware that the staffs have been having problem when trying to change or delete old data. It keeps on bringing up...
  2. A

    Very Challenging Question

    Hello, I have a table in my database which display supply and return of product from mon-fri. Field names are: Date, Mon(Sup),Mon(Ret),Tue(Sup),Tue(Ret),Wed(Sup),Wed(Ret), Thu(Sup),Thu(Ret),Fri(Sup),Fri(Ret) The date is always a sunday's date which indicate the week ending where the sales...
  3. A

    Changing RecordSource Property using VBA

    Hi I'm trying to create a report that would display data from different tables with similar structure. I have some 30 different tables which outline 5 different products for different years. It is impossible to put all of them in one big table since each of them are used by different...
  4. A

    How to Copy Records to different table

    Hi all This gonna be a long one.... I've search the whole forum for answer to this problem, but couldn't find the one suitable enough. I have a quote table with the following field: QuoteName QuoteDescription QuotePrice and booking Table: BookingName BookingDescription BookingPrice The...
  5. A

    Is there a way to get rid append table message?

    Hi, all I have written some codes to insert data into a table. I'm trying to get rid of the pop up message which say: Can anyone tell me how to do this? Cheers
  6. A

    How to disable form window while the second one is being opened?

    Hi all, I have a main form which contains buttons to control all other window. I'd like to prevent user to work on two forms at the same time. Can anyone advise me how to disable the main window while the second window is opened? thanks
  7. A

    Exporting Specific Record in a table

    I need to export a specific record in the table. The menu's export option only export the entire table. Is there a way to define certain record to export? Thanks
  8. A

    How to Query unrelated table to do a calculation?

    Hi all, I have a problem in returning values from 2 different tables because they are not related. Let me explain: I'm trying to do "Payment Due" query by substracting the amount in the "Cost" table with the amount in the "Payment" table ([CostAmount]-[PaymentAmount]). However, since no payment...
  9. A

    Duplication Problem with sql function in a query

    Hi all, Please note the following table: ShopID | Desc | NumberItem | Price each | Total | ShopGrandTotal 01 | Drills | 2 | $200 | $400 | $425 01 | Nails | 5 | $5 | $25 | $425 02 | Hammer |...
Top Bottom