Threads Replies Last Post 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13   Error 3027 using TransferText Method I'm using Access 2003, file format though is 2000. In a Userform I'm using Docmd.TransferText to transfer a table (with one field only, Memo data type), using a Data Spec file that I've set up and saved, to a file name abc.txt. I get error 3027 Cannot Update. Database or object is read-only. the database is definitely not read-only. It's on a stand-alone PC. If I go through this pr... 4 17.07.2006 15:07:16 Jet links and SQL links = failure ? Another try to find why i get so eften a broken database running under Access 2002 RT and VB6.0. My project is organised with a distibuted front-end Access 2002 sp3 .mde with no data on a few PCs, another front-end VB6.0 sp6 .exe installed on 3 PC, a main Jet database Access2000 .mdb format recorded and shared on a server and an SQL Server database on the same server. In the BE data ... 2 12.07.2006 03:27:34 Using ADO and DAO Do you know if there might be a problem having a mdb database accessed simultaneously from DAO.Jet.engine via an access GUID application and ADO connection open and used at the same time in a VB6.0 application. -- Programmer c''''''''est engager une partie d''''''''échecs contre un adversaire plus fort que soi mais que l''''''''on finira toujours par vaincre... 4 11.07.2006 09:19:02 Temporary files in a Data.mdb I'm used to use "temporary tables" in a shared database containing only datas. I never had problem with this technic when my application was running under Access2000 runtime but since i have upgraded to Access 2002 the database is broken near each day! The technic consist of creating a table at any running time mainly to become the datasource of a form or a report then deleting it when th... 3 11.07.2006 09:13:02 Multiple events in a command button I have a command button(cmd_submit) on form. This command button basically adds selected fields from the form to another table. This part works fine. Want I want to know is - Can I also add another procedure within the same code(cmd_submitclick()) that will open a Reports form for example.? I can figure out how to open the forms reports, I just want to know how to implement the proce... 2 10.07.2006 22:10:02 Compile Error: Label Not Defined I have a form that has the following command buttons, submit, retry, close, and combo boxes. After selecting my options from the combo box, and hit the submit button, I get the following error message: Compile Error - Label not defined. I have looked at my coding and can't seem to find anything wrong. Here is my code: Private Sub cmdSubmit_Click() On Error GoTo Err_cmdsubmit_Click... 3 10.07.2006 22:06:17 Crosstab query with Date() function I want to create a crosstab query that has a Date() function as a criteria. I know that I must also set the Query Paramaters for Crosstabs. When I put Date() in the Parameter it converts Date() to [Date()]. Any suggestions on how to enter a function in the Parameter instead of a control box? regards george ... 2 07.07.2006 06:07:56 VBA forms that open query and reports I have a form that has a coding for a set of query and reports that I would like to open, when the name is select. What I would like to do is open the query or reports from a radio button that say. Query Detail, Report Detail, etc. Please help. Jeffrey Johnson ... 1 05.07.2006 18:31:02 User-define type not defined I'm trying to run a program to determine who is on the database. When I run this on my C-drive everything works. However, once I placed it on the server where my database is located I get the following message "Complie error: User-define Type not defined" with the following highlighted in my code in yellow "Private Function WhoesOn() as String" then in blue "Dim dbCurrent as Database".... 7 03.07.2006 15:06:01 Problem adding a record via ADODB with an AutoNumber field. Hello everyone, Think this is a quick one for you professionals :) I am just a starting programmer, so here is my question: I have a table on a SQL Server that has an autonumber ID field thats bugging me :) I use linked tables via ODBC and this is the connection on my form (I simplified it a bit): strSQL = "SELECT * FROM MyTable" Set rst = New ADODB.Recordset rst.CursorLocation = ad... 1 02.07.2006 20:07:05 Using InternetExplorer Object Library I've installed the InternetExplorer object library in my References. And I am successful at creating an object of that application. But what I want to do is to be able to invoke the Internet Exporer's ExportToExcel command from my Access application. Can't quite piece it together. Got any pointers for me? Many thanks, Janie... 8 01.07.2006 18:19:53 Snapshot / PDF Outputing I have a report that I have setup to automatically generate and save as a snapshot report on our server. The report is around 20 pages and has several pictures (total size of pictures saved as JPEG format is 35 KB). When I output to snapshot, for some reason the file size bloats to 20 MB. If I remove all the graphics, file size is 22 KB for all 22 pages. Any ideas why the files size ... 3 01.07.2006 14:38:02 Running a macro or executing a module from an ASP page Is there a way to run a macro within MS Access, or Module, from a web page? I have a macro that runs a series of update make table and update queries and would like to execute it from a web page. The DB feeds an ASP page with info and when updates are made I would like to create the Table that feeds other pages info. Thanks... 2 01.07.2006 09:30:21 Insert Grouping Using Excel Object Model I can use the Excel Object Model to populate an Excel sheet using Access data, but I hoping there's a way to insert grouping as I loop through records. I have regions and products that I loop through and insert into the Excel sheet. I was hoping to do this: Add Region Grouping Add region to excel sheet Add Product Grouping Add Products End Prouduct Grouping End Region Grouping Add... 2 01.07.2006 05:59:10 Connect to DB on Web Site Unfortunately my VBA help is hosed and I have another newsgroup posting for that so until I can do some of my own help... I'm using Access 2000 & FP 2000 and have created a web site that contains a subset of the tables in the local Access DB. The web site DB is a read only use. I want to create a form w/module to connect to the web DB to clear the tables and refresh the data from the lo... 2 29.06.2006 23:35:03 user input This is hopefully an easy one to answer, but I cannot find what I am looking for. I have a function that writes data to a text file (makeflatfile). Can I get the function to allow the user to enter a starting and ending range of numbers? I would like the function to ask for the starting PO_nbr and ending PO_nbr. Thanks in advance.... 2 28.06.2006 21:30:41 Active Directory Usernames I was wondering if you have or have seen a routine to generate unique username from first, middle and last names. Here is my requirement - by default first initial and last name of a user is their username. But if the expected or default username is already taken then if the user have middle initial, then the username for this user would be first initial, middle initial and lastname. If the u... 1 26.06.2006 22:58:02 Binding forms to ADODB recordsets I have been using the technique shown below to create forms bound to SQL server tables and views using ADODB recordsets. It works so well that it seems almost too good to be true. My major concern is whether using ADODB recordsets will lead to deadlock problems on the SQL server? Even though I have closed the connection object and the original recordset object, the recordset, which is... 3 26.06.2006 17:19:45 Newbie Queston: ADO with 2 MDB's I wanted to split two Access MDB's. One MDB will run locally as the client. The other MDB will be on the network. My question is how does the client connect to the server data. Here is my code. Dim rsClient as ADODB.recordset Set rsClient = New ADODB.recordset rsClient.Open "Select * From tblClients", < what do I put here ??? > ... 2 25.06.2006 04:13:28 Amigos.com Amigos.com http://amigos.com/go/g671669 ... 1 24.06.2006 19:38:34 bind variable I'm using VBA to get a recordset from Oracle: SQL = "SELECT * from 010_TABLE where custno = '" & var_custno & "' " Set rsora = New ADODB.Recordset rsora.LockType = adLockBatchOptimistic rsora.CursorType = adOpenForwardOnly rsora.CursorLocation = adUseClient rsora.Open SQL, CnRasprd Set frm = Formulier Set Formulier.Recordset = rsora Because the SQL-string is send to Oracle and is ... 1 22.06.2006 06:10:02 InternetExplorer.Application Hallo NG, in my vba-module a part looks like this Set br = CreateObject("InternetExplorer.Application") rem br.Visible = False br.navigate ("http://www.pr....sget.php?id= ........) For this request I get an answer in the explorer window. (For example: "0") How can I analyse this response. For example If response = "0" then .... I hope its easy. Thank You Christian Schar... 1 21.06.2006 18:50:42 insert into ... values - a new record and modify the first record of the table I'm having a problem with an insert into statement base on a button click. I have a form that is used to enter energy monthly rates. I design the form base on the fields of the rate table. For assistance, on the form load, i fill the fields with the last month values. Values that have change are overwritten by the user and I use a button to validate the new values with this bit of code. ... 1 20.06.2006 01:52:50 VBA and ASP My local Crinklys group(U3A) want me to develop a noddy database and web site for their members. Some are computer literate, others not so. I thought an Access 2000 mdb on a server from the local council with a web page in Active Server Pages(ASP) and using ADO would do the trick then one of them could update it at home on the web to keep track of members and somebody else could do the same f... 2 19.06.2006 21:22:21 ADO & local tables All of the examples that I have seen on hoe to use ADO/or ADOX seem to be using an external ODBC driver (provider) or external MDB file. Can anyone direct me to an example of how to use ADO or ADOX to access a local table contained in the current project (MDB)? Thanks! ... 2 17.06.2006 19:52:56 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13