Runtime Error 7 and unable to Requery

[zool]

Hi,

I'm having a huge problem with my database. I could not execute requery command due to Runtime Error 7.
I have 2 forms, New Equipment and Equipment Database. I'm trying to Requery the data whenever there are changes made into New Equipment form.
I have two options to execute Requery, 1. Using command button 2. New Equipment form changes.
I don't know whether it is correct, i tried to put [Form_Equipment Database].Requery on of the two options but it came out as Runtime Error 7.
Is there any other way to Requery the data inside my Equipment database form?

This is my database if you're interested to solve it.
http://www.filedropper.com/equipmentdatabase

[John_G]

The syntax of the requery command is incorrect:

try: Forms![Equipment Database].requery (the form must be open), or if you are requerying the current form, Me.requery works just as well.

I don't know why you are getting Error 7, though.

PS - You do realize, I hope, that forms do not contain data - they only display, modify or enter it.

HTH

John

[zool]

Thanks for the reply, however your method doesn't work. This time it shows different error. "Method 'Item' of Object 'Forms' failed"

I do realize that forms does not contain any data because that is how I intended it to be - only Equipment Database forms has data.
I'm having a hard time to create this database because the last time i made one for my project was 4 years ago
Please give me any feedback so that I can improve the database.
Thanks.

[John_G]

Hi -

Please post the Sub with the code that is generating the error. It's hard to diagnose a problem without seeing the source.

What is the structure of your database? You mention two forms - do they both have the same table as a recordsource?

Please post more info - thanks!

John

[zool]

I think that I need to revise back the database structure. There is a possibility that the structure is the one causing the error.

I have several questions here.
Is it better to have a form which is mean to be edited get the data directly from table or use query?
I used query so that I can combine all the data inside one form easily.

Is there any good site to learn Access (starting from design of ERD/Data Model up to Advance training) for free?

New problem:
I've fixed the requery problem using "DoCmd" but new problem arised after that.
I could not set HasModule on form because i converted accdb to mdb (my colleague used Access 2007).
Because of this, all command on my buttons disappear. If i set the HasModule to Yes, I can not save the database after making modifications.
Do i need to redo the whole database using mdb format?

[John_G]

For the first question, my own opinion is that a form used to update data should where possible be based on a table, or a query based only on that table. You can use a multi-table query if it is updatable, but if the query is one-to-many, you really have to know what you are doing. Use a main form - sub form arrangement instead.

I can't answer the second question because I don't have A2007 - but if conversion from accdb to mdb results in loss of all your form code, Microsoft has a very serious issue to resolve (IMO). Can our experts help, please?

John

[zool]

Thank you John.

I'm trying to restructure my database and create lots of tables and queries so that the database will be more flexible.

The conversion from accdb to mdb creates a huge problem for me since i have to remove all my code in order to save the database. Basically i had to recreate the database.

I have another question here. Is it possible to sum data from specific table using expression builder? I do not intend to use query's "sum" function because it will hide other data which it could not sum up.
Solved: Just need to create additional queries, 1st query to "store data temporary" and 2nd query to calculate the temporary data.