Threads Replies Last Post 225 Pages: <<  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  >>   Trying to catch a bad user. I did not setup the existing software. I have a user who has decided that she has the right to go into the program code and write queries and run forms manually. She is causing problems! My intension is to catch her doing what she is doing. Now the reasons for catching her and not just stopping her are complex and I am sure none of you won’t to hear about my office politics problems.... 12 23.08.2006 22:54:15 Immediate Window code --> listbox value I am attempting to debug my form. I know there is a way to use the immediate window to return the values of listboxes (lstRMonth, lstRYear) on my open form. Thanks in advance!... 4 23.08.2006 22:25:02 How can I enumerate the macro list in Access97? In VBA in an open DB, I am creating a new blank DB, and copying over every object from my open DB. Everything can be copied except for the Macros. I can't find a collection of them or any way to enumerate them. Any ideas out there? I just need to loop thru the list of existing macros so I can use CopyObject on each of them. ... 3 23.08.2006 17:23:47 Turning on/off Fontbold for Numerous Controls I have a form with about 50 different listboxes - each displaying a differnt data 'highlight'. I would like to have the text in a box become bold on mouse move, and loose its bold when mouse is moved off or onto another listbox. Rather than enter code for each box, how would i go about writing a macro to do this for each one - what would said macro look like? Thanks, ... 1 23.08.2006 16:21:01 Selecting a specific record in a subform I have a main form for people that has a subform to load their addresses which are multiple. How do I get the form to open to a specific address (i.e. a default address). I want to avoid opening to the first address in the recordset. The table for the addresses distinguishes them by an "AddressType". Here is the code I have developed so far but it gives me an error #3070 indicating t... 3 23.08.2006 16:17:02 Email Does anyone know of a way to use VBA within Access to email a database as an attachment. What I mean by this is to use one database to process the data and then after I have put the data in a table in a seperate database I want to use the current database to email the other database to the end user. The senditem function will not let me send the entire database. Hope this is clear enough.... 4 23.08.2006 16:01:02 How/can I use a calendar control as an input to a parameter query I have setup up a parameter query that I want to run with a user input date range. Rather than having the user type in the date, I want a calendar control to prompt for start and end dates when the query is run. Any help on this issue?... 2 23.08.2006 15:22:08 Help with Code I have a form to record proposals. Each proposal covers at least one communes. I wrote a function to display name of communes in one field but getting error when a proposal does not have Commune entry. I got "Error 5 - Invalid procedure call or argument". I think this code run find if we can at blank field to those proposal that did not have communes. The code is list below Public F... 2 23.08.2006 14:46:01 Error descriptions Is there a web site in Microsoft for trappable error descriptions? I got a book that lists some common ones but not all of them. I’m using an Allen Brown code and I get an error # 3265 -- thank You... 4 23.08.2006 14:39:02 How can I update 2 tables by the criteria of a field in another? Okay, I have one table that everyone can enter company information into for clients, contractors, suppliers, etc... However, I also have individual tables for each which are then linked to a table of primary contacts for those companies. Here's my problem. I need the "Architects" table and the "Contractors" table to update automatically when information is entered into the "All Companies... 4 23.08.2006 13:13:15 Easy question (I'm just ignorant) I know this is really basic, but I don't really know what I'm doing. I have a tiny table that records start and end date of the current financial period. Just one record, four fields. I also have a little form that these details can be entered into once a month. How do I get the form to change the details in the table to those entered in the form? Many thanks Vaughan... 2 23.08.2006 11:57:47 speaking of Access bugs... Periodically, selection behaviour goes wonky on me -- as though I were holding down the Shift key while clicking. I first noticed this in the SQL View of the form-design window (whereby it was impossible to edit unless I was prepared to delete swathes of text ), but it also happens on forms (i.e. in Datasheet View, if I click on a record, all records from the top-most to the clicked one ... 2 23.08.2006 06:48:48 multiple columns in report header I have created a report that shows a list of part numbers in the Report Header, and a list of kits containing these parts in the Detail. The list of parts is usually less than 10, which is not problem. However, I have struck examples in which it is > 50, causing the header to take up more than 1 page. I tried creating a multiple-column report and dragging it into the main report's he... 1 23.08.2006 06:48:03 My converted 2003 database will not pass dates to queries I have developed a small database in Access 2000. My client has recently converted to Access 2003 and we passed the database through the conversion tool. there was a simple error about unsafe objects but never seemed to affect the performance. Now we have come to find that the dates necessary for running the reports are no longer being passed from the forms to the queries. Can you ... 2 23.08.2006 06:46:17 If / Then/ Where ? I have a form with 4 combo boxes. Each combo box stores a piece of info into the table. But I need to be able to restrict what the users are selecting. For example if the field Service is selected, then I need the field NonService to be null. Also if my field Service is selected, I need field Product and field ConcernDetail to NOT be null. Then likewise is NonService is selected, I ... 2 23.08.2006 05:47:01 sharing read only tables in multi-user application I am developing a multi-user Access application with a front and back end. I have several tables that I use for combo box lists that are updated frequently by another application. I set these up as text files that are linked into the front end so that the text file could be replaced as needed without any importing or code changes needed. This works beautifully until the second pers... 4 22.08.2006 23:14:29 i have an opt in and an opt out database i want to create a report which prints email addresses which only appear in one database. Im new to access and cant seem to get going on this one. ... 1 22.08.2006 20:48:02 Recovery .mdb file Hi all: We have a .mdb file from some1 who left our company a year ago. Now we open it and see this message : "This database is in an unexpected state; MS Access can't open it. This database has been converted from a prior version of MS Access by using the DAO CompactDatabase method instead of the Convert Database command on the Tools menu (Database Utilities Submenu). This has left ... 1 22.08.2006 19:59:01 runtime error 3265 item not found in this collection In a make query there are 2 concatenated fields that end up as text fields in a Excel report output which are the maximum and minimum of a set of cells. We just need the fields the max and minimun fields not the concatenated fields. So I added the fields to a table and hopefully to all the related queries. Then in trying to output it to Excel I added ..cells(lrow,28)= rsData!minti... 2 22.08.2006 19:51:48 Need to data from a field in one query to populate another query I currently have a form that allows the user to mark a record as inactive. I am loading the field using the Now() function Private Sub MarkAsDeleted_AfterUpdate() Me.DateDeleted.Value = Now() End Sub I compare that to the begining date of the reporting month to determine if that record should appear in reports going forward. What I actually need to do is use a period deleted field to... 1 22.08.2006 19:51:01 User name retrival locks data entry I have a form, Logger, that is opened by an autoexec macro and is not visible to users. The Logger form gets input when a user leaves a control in the form the user has open. I have just added coding by Dev Ashish to retrieve the user name from the advapi.dll and place the name in the Logger's user name control text box. The user's name shows up in the logger's User control field, but no... 1 22.08.2006 19:14:02 Read only error A client sent me a CD with four different Access files on it. When I try to open one of them I get this error" You are trying to open a read-only database. The first time you open an earlier version database, you must be able to write changes to the database. *The database file's read-only attribute may be set;clear this attribute. *You may have chosen the Open Read Only command in th... 3 22.08.2006 18:34:59 CHECK REQUEST FORM LOOKING FOR A SAMPLE OF CHECK REQUEST FORM... 2 22.08.2006 17:55:32 DAO.TableDefs & Fields, and scope I often use the code toward the bottom of this post in my subs and functions. For this one particular function it seems that as soon as I set a DAO.TableDef object it falls out of scope. Sometimes, I can't even set the TableDef object - but the table clearly exists. My code just doesn't work consistently. I saw a similar post that suggested the use of .... Dim db = DAO.Data... 3 22.08.2006 15:57:02 references trouble (maybe...?) Sorry for re-posting this, but I really need help. There's something going on that I cannot immagine how to manage anymore. I have developed an application on Access2003. It is a database code behind the scene. But it's not that complicated. All forms are unbound and a mix of SQL and ADO is used to pull data into tables. Sometimes a few DAO is used for some other purpouse. On my pc everyt... 7 22.08.2006 15:46:01 225 Pages: <<  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  >>