Threads Replies Last Post 363 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   StatusBarText How can I display a message at the botton of the form. I'm trying to set the StatusBarText but it won't let me. Me.StatusBarText = "Hi everyone!" <<< doesn't work ... 3 22.09.2006 19:32:21 Archive memo fields Could you give me an advice on how to achive this? In the form I have a couple of memo fields that user would like to "archive/save" whenever or each time those field values changes. Is this even a good idea?... 6 22.09.2006 19:33:02 Different format in Continous form Dear All, I have a control in a continous form where I want to apply to it different currency format for each row. i.e. one row $ format a second row a Sterling format and so on) Can anybody help ... 2 22.09.2006 19:22:31 Record locking Access FE, Sql Server BE I have an Access database front end which is linked to a Sql Server back end which contains all the tables. In the Advanced Options, I set the Default Record Locking to Edited Record. On the Form I set the Record Locks property to Edited Record. However, multiple users can still open up the form with the same record on it and edit it simultaneously. How can I stop multiple users from... 2 22.09.2006 18:44:01 Bound combo box on continuous form Access 2000 Hello expert, I have a continuous form (Data Entry is Yes) with the following 2 cascading combo boxes. 1. Batch Type - Unbound, 1 column, string. 2. Doucment Type - Bound, 3 column, the bound column is 1, integer. The value of the Document Type is dependent on the selection of the Batch Type. The porblem: ======== When the first record is entered, the values populated on the t... 2 22.09.2006 17:57:00 Is Dirty for a field? Is there a way to determine if the current field is dirty? I need to know if a user has changed the value in the current field. That way if they press the escape key I will allow access to undo the field but if it is not dirty then I want to display a message to the user asking them to answer yes or no to losing all of the changes to the current record which is what happens when you pre... 3 22.09.2006 17:42:29 Weird characters in a textbox I was looking at the data in a system I developed and came across some strange characters in a textbox. They look like thick vertical bars but they aren't the vertical bar character. When I click the zoom box the characters appear as double quotes but not the double quotes on the keyboard, the double quotes where the right one and the left one are different like \\ and //. My question is... 3 22.09.2006 17:35:09 Asign a color in RGB Hello I don´t get with the solution for asigning the backcolor to a form. I know the method but I don´t know what kind of numeric system uses the program to identify the color. If I want to asign the color RGB 153,204,0 How should I write the code? detail.backcolor = ???? Thanks ... 2 22.09.2006 17:08:50 Like Record Grouping Hello All! Ok here is the scenerio. I have table "TblZooA" and table "ZooB", they share the same structure. I am trying to put together a query that returns "Bobo and Zoey" from both tables, and groups according to Animal Name. Ideally my query would return the following results.... "QryZooReturn" (sample query return, "AnimalName" and "ShipDate" are column headings) AnimalName ... 5 22.09.2006 16:04:25 How do I 'Select' my Pivot Table In Access 2003, how do you refer to a Pivot Table object in VBA? It does not have a Name property, but ‘Help’ describes the programmatic identifier for the PivotTable object as CLSID:0002E552-0000-0000-C000-000000000046 I have experimented with this but with no success. There is an example in ‘Help’ but only in HTML. My problem is that I need to use VBA to select the Pivot Ta... 2 22.09.2006 15:37:02 ADO File Open Error Hello, I have a strange error I've not seen before. When opening a recordset, I get the following error: "The connection cannot be used to perform this operation. It is either closed or invalid in this context." The following snippet of code is what I am using. The last line produces the error noted above. Dim cnn As New ADODB.Connection Dim rst As New ADODB.Recordset, rst... 3 22.09.2006 15:13:01 Change background color on all controls How can I change the background color to say, white if it currently is yellow and to blue if it currently is grey on all of one databases forms. Thanks for your help!... 4 22.09.2006 14:42:09 ADO With Text Files I am having problems connecting to text files using ado and im certain its my syntax. I need two connections for this exercise: 1 to an access database to write records and another to a group of text files, which will supply me the data i need to add records to the ms access database. the routine crashes on this line: rsTxt.Open "Select * from " & strFileName, cnTxt, adOpenStatic T... 2 22.09.2006 14:05:02 Use last update value from table to default in TxtBox I'm was created login list in database. How to use last updated value (lngEmpID) from login table (tblLogIn) to default value in text box ...Form![LogOn2]![txtUser]? lngEmpID is number linked to another table with user names. Thanks!... 5 22.09.2006 13:51:02 SQL and Checkbox problem Hey, I need to check the value of a checkbox in the On Current Event to check whether it is checked or not. If it is, I need to lock all the values of the form and its subform. Here is my code: Private Sub Form_Current() Dim SQL As String Dim CLOSED As String CLOSED = "SELECT CLOSED FROM PVT_TBL" & _ "WHERE PVT_ID = Me.PROJ_ID" If CLOSED = "-1" The... 4 22.09.2006 11:31:15 Help with Microsoft help on linking Access to Outlook Hi. Is anyone willing to start a dialogue with me on the following Microsoft help page? It details a method of automatically populating the Outlook 'To' window with email addresses contained in an Access table. http://support.microsoft.com/?id=318881#appliesto To start, I have a three questions and would be grateful if someone would help me along. The article provides code for a... 16 22.09.2006 10:06:02 Load a combo selecting especific item by a query while running the DB Hello How could I load a combobox while running the database depending on a field? I mean, I have four different sections in the database, children, men, women, babies When I want to add a new cloth I have a form in which a have several comboxes. Each one contains the type of clothe, size and model. So I would like to load on the comboxes those sizes, type of clothes and models which are... 2 22.09.2006 09:32:32 Conditional Row coloring in Datasheet view Is there a way to programatically color rows of a form in Datasheet view. e.g.: all rows with a certain column value have a green background.... 7 22.09.2006 08:14:02 Fields displayed based on entry field What's the code for a field to display based on an entry of a field... 5 22.09.2006 03:10:02 how to keep old record into tblHistory or archive table? i need help and its urgent... i have created a table with fields: ItemNo, ItemName, IncomingStocks and also DateReceived. The IncomingStocks and Date Received are volatile. it is expected to change several times during the life of a record Data is being entered via a form. I want to create a so called HISTORY or ARCHIVE table that receives an insert when the record is updated showing ... 1 22.09.2006 02:17:25 Open Form on Start I need to open a form on start-up. The problem is it can be anyone of 25 forms depending on a number in a table. How would I do this? Any help appreciated. Thanks DS... 3 22.09.2006 01:04:31 Please HELP!! I have the following code which gives me my stock quantity .... Function Onhand(itemCode As Variant, Optional vAsOfDate As Variant) As Long 'Purpose: Return the quantity-on-hand for a product. 'Arguments: vProductID = the product to report on. ' vAsOfDate = the date at which quantity is to be calculated. ' If missing, all transactions a... 5 21.09.2006 23:04:11 Referencing a table while using Dlookup on a form Hi there, My question is about writing a DlookUp statement, where the Criteria can be found on a separate table. For example, Dlookup ("[LastName]", "tblNameList","[FirstName] = ' " & [tblGuest]![FirstName] & " ' ") The TblGuest contain only 1 row of data, thus, no addtional criteria will be needed. I know that this code is wrong, but realy have a hard time trying to fix it. I don't... 5 21.09.2006 22:17:05 set the value of a control in response to a control or event Hey, I have a dataB Table Called AMedPick with field called DeptA displaying a value list 1-9 for selections, and a field called StantTot1 displaying 2600 as a default. 2600 was used 100% of the time. StantTot1 is hidden on the Table view but used to calculate on a several queries. Problem now DeptA field changed 1-9 to 0-9 when 0 is selected StantTot1 should be 0 and not 2600. can I u... 1 21.09.2006 21:51:02 Escape Key on Forms I would like to have the escape key undo any changes on the current field if the field has been changed on the first press and then prompt the user before allowing them to undo all of the changes on the entire record. How would I go about doing this. I can watch for a keypress but then it seems to eliminate the first undo for the field. So user updates field LastName, they decide the... 2 21.09.2006 21:50:01 363 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>