Search results

I think you should be contacting Transoft Support for this. http://www.transoft.com/support.aspx

That would be my thoughts.

Portland Access User's Group

Can you actually add a record from the form? I'm guessing that you don't have a primary key of INT assigned to the ODBC table. What version of Access and Windows do you have and what is the ODBC data source and version?

^^^^^^^^^^ + 1 ^^^^^^^^^

What is the SQL to the query?

To supplement what Trevor wrote, just putting it in a Trusted Location doesn't necessarily work. You need to open the Trust Center and go to MACRO SETTINGS as he wrote and make sure that ENABLE ALL is selected instead of DISABLE, DISABLE WITH NOTIFICATION, OR DISABLE WITH NO NOTIFICATION.

The code that I created which you are using would not be able to do what you want it to do. What you would need to do is iterate through the individual records and find the row it needs to be on. Without seeing your spreadsheet and database we can't know how it would know which record goes...

Only messy if you choose it to be messy. What I did when I worked for a healthcare company is came in and found they had issues constantly with corruption. I figured out they had been opening up the same database frontend with all 100 different users (not all simultaneously). I told them the...

You may need to do a DECOMPILE as the VBA may be out of synch with the form. http://www.granite.ab.ca/access/decompile.htm

The answer is no with a caveat. The database should be split and EACH USER needs to have their OWN COPY of the frontend or else you can be at high risk for corruption.

Not sure but could it be your misspelling of Navigation? NavegationSubform].[ NavigationSubform

I don't have enough time to go into great detail at the moment nor try to fully analyze what you have and where you need to go. But this data model is similar (a Bill of Materials where something can be part of a larger product) http://www.databaseanswers.org/data_models/bom/index.htm

I'm suggesting that you give us more information about what it is you are tracking and your business processes are so we can help you determine that. But it sounds like it based on your initial question and cursory look at the relationships.

Not sure which version you are on but you might need to use Set con = CurrentProject.AccessConnection

If you include the date, it becomes way easier in calculating elapsed time. The people inputting don't need to deal with the date or enter it. Just do as Pat said and use Date() + the value of the inputted time.

Before going further. What happens if you just go to the VBA window and click DEBUG > COMPILE?

Actually your structure needs fixing. One way you can tell that you likely have a problem is if your relationships form a circle (what Mihail referred to as cycle). So, I think we need to start over a bit and kind of get an explanation of what you are trying to do with the database and the...

First you say that it is causing the query to stop responding, and then you say that it is now taking 20 seconds less? I don't get it. The problem of it not responding would be because it was in a perpetual loop as it would not have moved on after it hit a certain record based on your If...

Yes, and that is what is normally done by people. But if you call out the same database you are in to create a new connection, you can actually quickly get the UNABLE TO CONNECT, TOO MANY CONNECTIONS error. There is no reason to create a new connection if the tables are internal or linked. If...