Search results

I have created a new database and imported everything, but I am still getting SOBC. When I go to design mode in formA, formB closes, and vice versa. Any other thoughts?

I agree. It turns out that one of the SQL BE tables has some duplicate records, I'm not sure how that could've happened since it violates data integrity rules. I think I need to clean that up first.

It is a major corporation with lots of systems that are accessed from around the world. So, I would assume that the WAN is very good. I will look into the other methods. They queries are all pass-throughs. What are SQL Views? Time/date based info is not an issue. Editing is required, for...

They are not doing a lot of scrolling. I'm able to display everything. There's only one where they might scroll regularly, the list of individual services (his is one that they would click on to drill down into account detail). That would only happen if the customer has a lot of accounts. Even...

Another SOBC, when I go to design mode in formA, formB closes, and vice versa. As far as I can tell, that doesn't happen with any other forms, either causing others to close or being closed. Related? Corrupted? New/blank and import everything? Do I hear Twilight Zone music?

Minty, I'll consider that (haven't worked with tabs yet). However, the original idea was to have all of this info available on a single view, without requiring additional clicks. Other thoughts?

I have an important form that has 7 (count 'em) sub forms. It takes several seconds to load locally, and 15-20 seconds for people at remote locations. I need it to load more quickly. The data BE is on an SQL server. 6 of the 7 subforms use a parent-child relationship. I use pass-throughs for...

Goh, The error message is what I originally posted, "Name conflicts with existing module, project, or object library." I went to a backup version from a couple of days ago. Reminds me that I need to (and not just say I will) make a copy at the start of every day, before I start working on...

Not reserved. "frmParentInfo" Was working well before this.

Access changed the name of a form, forcing me to do a SaveAs. Now, I am not able to rename the form, or copy it under any new name - "Name conflicts with existing module, project, or object library." This happens too when I try to import the form into a new database. In VBEditor, the code...

I am able to edit the data via a query in Access. However, I can't and get that same message when I try to run the query via VB, just like when I try to edit directly in the linked table, or from the form without code.

Of course it's split. That was implied when I said linked table. No one else is in the table. There is code. However, I am getting that same message when I try to edit directly in the table.

When I try to change a field on a form, I get a message: "This record has been changed by another user since you started editing it...." This happens whether or I do it directly or via code (SQL update query). The table's underlying record source is a linked SQL table. What am I doing...

Thanks. We're either going to use Table Valued Functions or, Build them entirely as stored procedures, create Execute pass-throughs, then use those as record sources for the forms and reports. I'm writing all the SQL code in Access for now. Then the SQL dba (not me) will be able to modify...

The bigger/real issue is that I want to refer to the stored procedure in another pass-through. WITH BillerIDProd as (SELECT tblBillerList.*, tblBillerIDProd.PROD, tblBillerIDProd.Status AS 'PRDSTS' FROM tblBillerList INNER JOIN tblBillerIDProd ON tblBillerList.ClientID =...

Why isn't this working? SELECT usp_BillerStatus.* FROM usp_BillerStatus Error message: ODBC--call failed Invalid object name 'usp_BillerStatus'. #208. However, Execute usp_BillerStatus does work. These are pass-through queries from Access2013 running on a SQL server 2005

The external C/R seemed to work. It let me open the form in view mode, go to design, then make and save changes. However, it crashed the next time I tried to open it. I even tried removing all the VBA code from the form. If I went the blank database route, there are a lot of linked tables...

Let me add that the code compiles

Access is crashing repeatedly. It happens on one, and only one form (as far as I can tell), whenever I try to open it in form view, save design changes, or copy the form. When it crashes, I get Microsoft Access has stopped working, then either that it has to Reststart or Close the program. I...

I'm developing a database that will allow people in different departments (e.g., sales, finance, customer service, executive) to be able to view revenue related data (revenue, transaction volume, principal) in different aggregations and summaries. Background: This is a unit of a company that...