Search results

Follow up question: Does the owner of the object (in this case, tables) have any bearing on a multi-user database? Also, do the permissions for the database file itself (these would be accessed when right clicking the .accdb file and then selecting Security, Advanced) have any bearing the...

Yeah, like I said this is a very odd thing. The problem is I'm using snapshots for both the datasheet views and for the report views, so not sure why that would lockdown the database tables. Thanks for you help though, very much appreciated.

Yes I have, as I stated in my original post I have set these accordingly and experimented with different settings but to no avail.

Hi arnelgp, Tried that but that did not help.

Greetings all, I've developed a split db (A2010) that has a FE installed on local machines(7 users in all) and the BE up on the network. The issue I'm having is that if one person opens the front end on their machine and they open up a report, or a table (which I have setup using a datasheet...

Check to see if you have a rogue "End sub" within your code. I've gotten this error on occasion and its because I've accidentally chopped off a sub/function by placing code before or after the sub/function declaration (Public sub... or, End sub) or I've made a syntax mistake.

Try doing a requery on the dropdown control. You can place the following code in the Open event of the form. i.e. docmd.[yourcontrolnamehere].Requery HTH Tim

Greetings all, Have a wierd question that I have not found an answer for so I thought i'd post it here. I started a new gig and inherited a database. Database was originally created in Access 2003, but was upgraded to 2007 format. Database is split but runs locally on my HD for the time...

Greetings all, I have a problem and was wondering if I could get some help/hindsight. I have a information file that I need to process. The file is HUGE. Plus it is denormalized, meaning that it has header info, type info and origination info, as well as the records being processed. In...

Thx Guus, but that didn't resolve the problem. Anyone else?

Hi Cozzy, There are a couple different ways to approach this. Assuming you are using a data entry form to enter in the new data, you could write some vba code in the BeforeInsert event, something like this (you'll have to edit it to suit your needs): Dim dbs As DAO.Database Dim rst As...

Greetings all, Have a unique scenario here. I am calling a stored procedure in SQL Server 2008 from my Access 2010 database. (see my code below). Dim objConnection As New ADODB.Connection Dim objCom As ADODB.Command Dim x, y As Variant Dim rst, rst2 As ADODB.Recordset...

Greeting all. I have a question regarding an error I'm receiving when running an SSIS package that xfers data from a flat file to an 2003 Access db. SSIS is able to find the flat file and recognize it. Also, SSIS is able to connect to the database using OLE DB (see attachment 1). There is a...

Not sure what this has to do with my question about default selection. Anyone else?

Greetings all I have a popup form which is used to provide data to a function. On the form are two combo boxes.... these are used as criteria to populate a listbox. When the user enters data in the second of the two combo boxes, I do a requery of the listbox (from OnChange event). I also do a...

Does anyone know if its possible to programatically set the "document window options" in Access 2010?? I'm able to hide the ribbon and navigation panes using VBA and I also want to prevent the tabs from showing using VBA as well. TIA, Tim

Greetings all, I have a procedure that worked fine until I upgraded from Access 2003 to Access 2010. Below is a snipped of the code: Dim xlAP As Excel.Application Dim xlWB As Excel.Workbook Dim xlWS As Excel.Worksheet Set xlAP = CreateObject("Excel.Application") Set...

Hey JZ, sorry for the delay... more endless meetings :confused: Success!! Here's what I did: The code was bombing out on the line: Set rst3 = dbs3.OpenRecordset(strSQL, dbOpenDynaset) I went ahead and simplified my strSQL by creating a query that joins all the information into a staging...

Ok, that worked and unfortunately I'm getting the dreaded '3061' Too few parameters, Expected 1 error. :mad: I have some bookmarked links with regards to this problem so let me investigate those and I'll post back here once I get a solution. Thanks again JZ *cheers*

TY for catch and prompt reply JZ. Made the changes but still getting the same error.