Search results

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...

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...

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

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...

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...

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"...

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...

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

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.

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...

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:

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

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...

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...

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...

Thank you. Now it works.

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...

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...