Threads Replies Last Post 19 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19   Command buttons in forms I have used an Access database for 6 years to collect and manage faculty data and just recently my data entry forms have started malfunctioning--Command buttons for adding records, searching records, etc. now give the following error message: "The expression On Click you entered as the event property setting produced the following error: Object or class does not support the set of event... 1 7/28/2006 5:04:02 PM How to automatically update text boxes (NEED IMMEDIATE HELP!!) I have three text boxes. When a user manually inputs data in one text box, I want the other two boxes updated automatically. In other words, everytime Textbox 1 is updated, Textbox 2 and Textbox 3 automatically are updated. For example, TextBox 1 Textbox 2 (automatically fills in 100 x .5) ..5 is a rate User enters 100 ... 2 7/27/2006 7:35:52 PM DoEvents and SendKeys I am running a utiltity (CutePDF) that allows me to output my report as a PDF. Works great ... most of the time. When the dialog comes up, the user must insert the report name and CutePDF saves it as a PDF file. Love it. Here's the problem: I have a SendKeys that fills in the name of the report and this works 90% of the time. The problem is I need to slow things down so that the wh... 6 7/27/2006 6:31:50 PM deleting files based on a list I want to delete files from a list that i have in ms access database how can i do that? i have a list of files that have to bo deleted,all files are in same folder. thx rene deleting files based on a list ... 2 7/24/2006 1:32:36 PM Help with This Code Hi, I am traying to build a criteria string from a table that contain selected ID (eg [ID]=1 or [ID]= 58 or [ID] =74 and so on). I have code below that seem never work Dim Stg As String Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim I As Long Set dbs = CurrentDb Set rst = dbs.OpenRecordset("tmpSelected", dbOpenDynaset) With rst Do While Not .EOF Stg = "[ID... 3 7/21/2006 4:54:08 AM 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 7/17/2006 3:07:16 PM 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 7/12/2006 3:27:34 AM 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 7/11/2006 9:19:02 AM 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 7/11/2006 9:13:02 AM 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 7/10/2006 10:10:02 PM 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 7/10/2006 10:06:17 PM 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 7/7/2006 6:07:56 AM 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 7/5/2006 6:31:02 PM 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 7/3/2006 3:06:01 PM 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 7/2/2006 8:07:05 PM 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 7/1/2006 6:19:53 PM 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 7/1/2006 2:38:02 PM 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 7/1/2006 9:30:21 AM 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 7/1/2006 5:59:10 AM 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 6/29/2006 11:35:03 PM 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 6/28/2006 9:30:41 PM 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 6/26/2006 10:58:02 PM 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 6/26/2006 5:19:45 PM 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 6/25/2006 4:13:28 AM Amigos.com Amigos.com http://amigos.com/go/g671669 ... 1 6/24/2006 7:38:34 PM 19 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19