Search results

  1. aikea

    Edit A Record Via Form

    I haven't got time to look at your database blk133, but I am strongly against using subform in any scenario. I have got too much pain from it when few years ago I started my access study. The best solution is. Create a query which you want you subform to present. Add a lisbox to the form...
  2. aikea

    Edit A Record Via Form

    Why not just use VBA in "Form_Load". Create a connect to the table then retrieve the data and fill the form. It need some programming, but this is the only way to decouple your data from the form(user interface). It offers you much better control over your data. This is the only sollution if...
  3. aikea

    Controlling other Applications

    Create a query with the data you want to output, the output that query with "docmd.outputto" command.
  4. aikea

    Access 2007 time based deletion

    Create a query contains only records you want to delete. Run it and check the result. The create a delete query, copy paste the SQL created in the last query then run it. Use Day() function to get name of the day. --------- Sorry, I misinterprete your question. There is no good way to run a...
  5. aikea

    Edit A Record Via Form

    Yes, like bob said. You have bound the textbox control to the data field. You have to unbound the control and use VBA code to navigate between records. I never use bound control unless it is for presentation. --------------------- I found using subform in any situation is annoying. I have...
  6. aikea

    autonumber linked tables

    Could you give me more info about your table defination. I never use autonumber in this way. Normally, set "cascade" as reference integrity rule will make sure if a record is changed, its corresponding record in other table is updated. In a more proper database product you can set a "Trigger"...
  7. aikea

    A lot of fields...

    There is something called Normalisation. For example if you record a person and his disease type, you should have two tables. One for the detail of that person (age, gender etc), one for the disease type recorded. The person will give a field named "diseaseTypeID" which contains the "ID" of his...
  8. aikea

    Controlling other Applications

    I find the article here: OutputTo In both 2003 and 2007
  9. aikea

    Controlling other Applications

    I am not sure whether this is only available in Access 2007. You can use "DoCmd.OutputTo" command to save a table or a query straight into Excel format.
  10. aikea

    Disabling INTERRUPT when code is running

    LEXCERM, Do you mean to disable the "Shift" key on startup. If you do, give me your email address, I send you a module which will do that. If not, basicly anyone can just press "Ctrl + Alt + Del" to force your application to stop. And there is no cure for that. PS. May be some WinAPI can...
  11. aikea

    Backup In VBA

    If you already have a backup database, just use docmd.transfterdatabase command transfer the table the backup database. Or you create that database first then transfer the table. Here is the syntax:
  12. aikea

    Can't Run Sub

    You need to place you sub in a module. If it is in a form, it won't work. This happen since Access 2002.
  13. aikea

    Archiving a database

    I used to work on an ordering system that a company use it to track orders. Because the company process few hundred orders a day, I create two table, one "Past Order" table and one "Recent Order" table. I first created an append query, the query will open "Recent Order" table, find all records...
  14. aikea

    Database size problem

    Separate database into front end and back end You may try to separate your database into a front end and back end. Just create a new database, import all queries, reports, etc into the new database but only import links fromt he table. Delete all queries, reports, etc from the old database...
  15. aikea

    Access runtime reference issue

    I am going to deploy an application to a pc without Office Software. I included access runtime engine with the application. However, it seems that I also need to distribute whatever the library file I referenced in the application to the client and create reference to each of them in...
  16. aikea

    Open OLE object

    Thank you. Now it works.
  17. aikea

    Open OLE object

    I got this program in my project. The "TestFile" is a table with only two fields. The "ID" field and a "FileName" field which stores OLE object. In the program "rs.Fields(1)" would be the OLE object, "rs.Fields(0)" would be the ID column. Anyone know how could I display it in an unbound...
  18. aikea

    How to get and set "SourceObject" value in program?

    I create an empty form, drag a subform control to that and set that subform's "Source Object" property to "Table.Books". I want to display the value stored in sourceobject property, so I placed a command button and typed in following code: After I clicked the button, I received an error: Is...
Back
Top Bottom