Search results

  1. S

    Error: You cannot add or change a record

    Thanks for your comment. I will do that on my current project..;)
  2. S

    Updating a split database Question

    I also have a split database and i need to merge some old database into this database. What i do is i copied all data into excel and then paste also some other data from my old database and re-import that excel into my database as my new and updated backend table. As of this moment my database...
  3. S

    Error: You cannot add or change a record

    HI. I don't know if i am on the right page but my question is regarding the error message "You can't go to specified records". I have created a 'remove duplicate query' to eliminate duplicated data entered by the user. But when a user try to enter a data which has already entered, this error...
  4. S

    How to Retrieve Deleted Table??!

    luckily the IT people in my office do an automatic backup of our network drive so they succesfully recovered my file.:D
  5. S

    How to Retrieve Deleted Table??!

    Thanks sir. But my computer in office restricts installation of software by an administrator...:o
  6. S

    How to Retrieve Deleted Table??!

    :mad: Is there a way to recover deleted table for access 2003? My database has a table split into back-end and placed on the network drive. Unfortunately the backend table where my project was referenced was accidentally deleted! I have no backup for that, now my database was a messed!:mad:
  7. S

    Single Table used for Multiple Forms

    Thanks for all your suggestions. But just now i found what is the error in my database. I just try to remove all the "validation rule" for every fields in my table and when i tried to enter data in different forms the error "you cannot go to specified record" disappears and the data i encoded...
  8. S

    Single Table used for Multiple Forms

    Sir i still cannot paste my file. PLease see photo of the webpage. When i tried to drag my file to the webpage, it just downloaded my file to my computer. Still no luck in pasting my file:(
  9. S

    Question How to Average certain data in a Query

    Thank you sir, i almost forgot that command:o
  10. S

    Averaging Records thru Query

    ok thanks...
  11. S

    Averaging Records thru Query

    sorry for re-posting. There just no answer coming......
  12. S

    Question How to Average certain data in a Query

    How can i make an average for a certain record that only when a data for an item reaches 30 then the query will give an average. I already created a query that shows what are the items from my table that has 30 data records. I just dont know how to create an average data per item that reaches 30...
  13. S

    Averaging Records thru Query

    How can i make a query on my table that when a certain single item reaches 30 records it will show an "average records" in a query. I cannot find a way to make such formula in a query. I can only make a list where it shows what are those items that already reaches 30 data points. But averaging...
  14. S

    Single Table used for Multiple Forms

    `up:confused:
  15. S

    Single Table used for Multiple Forms

    Hi Sir, My file is 2.2mb which is beyond the allowable limit on this forum, therefore you may download it through the link provided below. http://www.mediafire.com/file/zwjaihmxynf/changeover.zip Thanks.
  16. S

    Single Table used for Multiple Forms

    Please help me on my project. I created a table based on 3 different processes, all the required data from process A, process B, and Process C are combined in a single table. Then i created Forms each for every process wherein the data are those selected fields from the Table. Is this really...
  17. S

    Question Merging two database and use single form

    We have 2 databases that need to be combined and i dont know where to start. I tried creating another table where all data for the two tables are there and creating a form from that. But when i created an append query i got an error saying something like i cannot proceed to append query probably...
  18. S

    Question Merging two database and use single form

    Hi Sir, thank you for the reply:). Correct me if i am wrong, I will make a table for my unbound form and then create an append query for the two tables? Is this what you mean sir? Ok i will try to do this and return for my feedback. Thanks:D
  19. S

    Question Merging two database and use single form

    Hello. I am having problem with my current project. I dont know how to merge two database and combine all the data for the table, and also use only one Form to update data on the two tables. We currently have two database, one is for parameter entry and the other is for performance monitoring...
  20. S

    Question Make table query

    May i ask from anyone a sample dbase for "make-table query".
Back
Top Bottom