Search results

Indeed, should be possible. But, without any information about your DB, any suggestion seems to be impossible.

I hope. I like very much to do this, Paul.

Or Left("Paul.Eugin",InStr("Paul.Eugin",".")-1) Hi Paul ! What about yours meeting in London ? Hope you (all) did have a good party. Some stories for us ?

If you can "calculate", is no need to store. You will "calculate" this every time you need to see this by using a query or other approach. What about to show us the entire structure of your DB ?

A "subform" is a control in a form. So, will be moved with the form as any other control: textbox, combobox etc.)

Welcome to the forum ! Sorry, but I understand... nothing from your explanation.

Unless I misunderstand, you try to save something that you already have (is calculated) in a new table. If so, DO NOT DO THIS. Database Normalization and Table Structures - Microsoft Access / VBA

By using the .Top and .Left properties of the form.

You can't. Create a form with this message, show it when the update start and close it when the update is finished.

Read, very carefully, this: Database Normalization and Table Structures - Microsoft Access / VBA

Do not close the forms. Just hide it ( .Visible = False) Do not forget to save the current record (this is automatically done if you close the form).

The setup of your DB is wrong. Read this: Database Normalization and Table Structures - Microsoft Access / VBA

Salut ! Nu te-am mai vazut de mult pe aici. Sper, totusi, sa citesti acest mesaj si, daca ai vreo idee, sa ma ajuti cumva. As vrea sa utilizez baza de date a DEX. Este "free", o pot descarca, dar este (cred) in MySQL. Stii cumva daca si cum as putea sa o convertesc in format pt Access (.mdb)...

Glad to help you, but we need too to learn something from this forum. So... what was the solution that you adopted ?

Add a LABEL with commas.

Because OURS "<=" is different from YOURS ">=" Take a look to the IIF() function syntax.

No, but is only my opinion. Access and Excel work very different. If the job can be done in Excel then why you need Access ?!? On the other hand, if you need a DB, Excel don't help much. Here is something that, maybe, can help you...

Welcome to AWF ! I haven't any problem with this download.

This is a big mistake: The FK should to point on a PK (ID in your case). Can you upload the DB ? (Access 2003 version)

As Galaxiom already said, your data is not correct structured. Because you are lucky to have a very skilled guys from this forum here, I'll not comment. Just I converted your DB in A2003 version and I added all the tables to the Relationships window.