Search results

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

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

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

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

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

How do I populate a text field on a dialog form to the value of a filed on the calling form?

I have a set of checklists using the standard vertical format: tblList, tblData, tblMaster (see thread http://www.access-programmers.co.uk/forums/showthread.php?t=283525) The twist is that not all of the tasks are the same type of field (in this case, I'm using a date field; click and it...

I'm getting this compile error, on the code below, on .ChecklistID even though ChecklistID does exist on the form. stSQL = "INSERT INTO tblChecklistData SELECT " & Me.ChecklistID & " As ChecklistID, TaskID FROM tblChecklistTasks WHERE tblChecklistTasks.ListID=" & Me.cmbListType It compiles...

I want to be able identify certain tables, and then run actions using only those tables. How do I do this? Background: I have a database of checklists. They want to use this to make sure they follow consistent and complete procedures on different types or projects, and to track the progress...

I have a form based on a non-udateable query. To change data in a field, I click on the field. It makes visible an unbound combo box, and assigns the underlying value to that combo box (Me.cmbSID = Me.SID), and shifts focus to that box. AfterUpdate changes the value in the underlying table...

What's the best (or another) way? When I try below, I get error #3061, Too few parameters. Expected 1, on the line highlighted. Dim rs As DAO.Recordset Dim stSQL As String stSQL = "SELECT qryRevTranBiller.BillerName, qryRevTranBiller.ClientID, qryRevTranBiller.Prod...

Since updating to Office365 (not Access, still using 2010), I've been getting the following errors in code that worked before the update: Err#2046, The command or action 'Send Object' isn't available now." on the line "DoCmd.SendObject ..." "Run-time error '1004' Method 'Save' or object...

Hello all, I'm an experienced Access and Excel vba programmer from Denver. Adam