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  >>   Manipulating frameless windows Does any one have code on how to manipulate (drag) a frameless (Border Style : None) windows with code? thanks ... 2 01.10.2006 03:29:23 Access 2003 - Forms & Sub Foms I'm new to Forms and Sub Forms, so I could do with some help. I have 2 tables A and B, both have multiple fields, but both tables have a Postcode field. Table A has one record per postcode Table B has Multiple entries per postcode. I need to set up a main form based on table A that can be filtered based upon postcode. When a user filters for a particular postcode, as well aspopulating... 4 01.10.2006 00:55:42 Date Time Format I want to change the format of some code in a timer form that records the date in a table to tell if the code was sucessfully run. What I would like to do is change that code to include the time in the same field as the date if possible as well. The following is the code that includes only the date: strSQL = "UPDATE tblTimerDate SET LastTimerDate = " & _ ' Format(Date, "\#mm/dd... 4 01.10.2006 00:26:01 Formatting Text Box Can anyone tell me how to format a text box to display the following:- RTA/CG/0000220/07 Where RTA/CG/ is text 0000220 come from field RTARef (How can i include the preceding zeros?) 07 is the year from the date field RTADate Thanks Andy... 2 30.09.2006 21:07:27 Dynamically setting the recordset for a combobox This is a multi-part message in MIME format. ------=_NextPart_000_000A_01C6E40E.0869BBE0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have a form that has two combo boxes on it. The combo boxes apply = filters to the form's underlying recordset. The first box has a list of states and the second has a list of = customers. When the us... 4 30.09.2006 18:02:02 Displaying numbers as letters I am trying to create a query with a field called CostCode. It is a field that disguises the cost of a product in a hidden formula based letters instead of numbers. The formula is as follows: 1 = P 2 = R 3 = E 4 = S 5 = T 6 = O 7 = M 8 = A 9 = C 0 = X 00 = XY 000 = XYZ Example: $234 = RES Is there an easy way to do this without writing a mas... 4 30.09.2006 17:43:38 Re Post about Cursor Position and Leaving field I posted about a week ago and had some usefull feedback from J Goddard, but ultimately it didn't resolve my problem, so here it is again; My problem is the cursor remains in the field Text34, at the start of the entered text, after the following code runs, I want it to leave and go to the next field, or at worst go to the end of the text in Text34; Private Sub Text34_AfterUpdate() ... 6 30.09.2006 17:17:46 Display conbined information from multiple records in textbox First off, this site has been a tremendous tool for me in the past. I am not all that much of a novice with databases, but I have never been that great with forms. These are the fields that I have in my main table that I will be referring to: Call_ID AutoNumber Ref_ID will = a specific Call_ID in some cases EDS_ID User specific Product_ID Specific to Client, but not a unique number in... 3 30.09.2006 14:22:00 Calculating Average for a field which is calculated field itself Hi, Earlier I have requested for help on calculating the time difference in dd:hh:mm format which is day:hour:minute...as below: ============== Hi, I am a beginner to MSAccess. Recently I imported a huge file contains data about Telco providers outage timings as follows: Following are the three columns from excel. "Problem Start Time ", "Problem End Time" and "Duration", duration is t... 3 30.09.2006 13:48:06 hourglass Hi all. I am working in A2k and having trouble with hourglass. I have a form which takes several seconds to load, so I want the mouse pointer to turn to an hourlgass when the menu item is clicked to open the form, and then back to regular pointer when the form activates. From the main menu: Private Sub Label141_Click() DoCmd.Hourglass True DoCmd.OpenForm ("frmL... 8 30.09.2006 12:42:32 strange table behavior Winxp and access 2003 I have a table with these fields CoID CoName Location Street I pull the info into the form using cascading cboboxes Choose CoName get Location (Cities) relevant to CoName get Street (addresses) relevant to CoName & Location I have approx 1500 records, and on most of them this works great - but on some records, after c... 8 30.09.2006 12:19:26 Disable Delete key I created an employee form which allows the user to delete the employee by hitting a command button. The code behind the command button then deletes the employee as well as all of the supporting tables. How can I prevent the user from deleting the record with the delete key, so the system is forced to delete the supporting tables ?... 10 30.09.2006 12:14:42 Variable Question I have a field that is on several forms. The field is called TxtManagerID. I have a listbox to open any one of these forms. I need to set the value of TxtManagerID on these forms so I thought this code would work. Except I get an error message that I have to define a class. Am I barking up the wrong tree or is there a simple solution to this. Any help appreciated. Thanks DS ... 3 30.09.2006 12:04:21 Select Case - "Invalid use of Null" Problem Hi all, I've got a button which is supposed to open differrent forms depending on some condition. I got a "Select Case" Code for it as below: Select Case True Case ([NotPaid] = True) stDocName = "PREQs" Case ([CashVND] > 0) And (IsNull([CW_No])) stDocName = "Cash Received" Case ([CashVND] <= 0) stDocName = "Cash Spent" Case ([BA176USD_N] > 0) stDocName = "BA-... 2 30.09.2006 10:51:45 Not sure how to achive this... Hi All, I have a main form (currently loads after login, but will be launched from a switchboard later), which has a Tab Control in the detail section. On the first page of the TC i have a form for order entry. All of the Order Info is in the detail sect. of this (sub)form, and a subform for ordered items in the footer. I have the following table structure: tblOrderInfo Order_ID D... 2 30.09.2006 08:54:02 2 List Boxs - Multiple Select - select from single box I have two list boxes in my form. they are both set up to choose more then one item in each list box but you also have to choose at least one item from each list box. I need to be able to also pick one item from one box and not the other, and vice/versa. Example: List Box 1 - dog, cat, child List Box 2 - litter, food, toys I want to be able to chose dog but not anything from List B... 4 30.09.2006 08:13:02 Find Record Hi, I have a main form and another form(1). They both work from the same primary key(application number). When I navigate from the main form to form(1) and then back, the data displayed is filtered by the same application number as I want to be able to display specific data on all forms for the same candidate. The problem comes when I go back to the main form I can't search through all ... 2 30.09.2006 06:49:13 Copy command Hello, I have form that is bounded by a table called Inventory and what I want to do is to push a command button that will copy a record from the Inventory table and paste it into another table called Audited with the same identical fields. How do I do that. Any tips will be appreciated. Thank you in advance. Regards, ... 2 30.09.2006 03:02:00 Search field Hello, In my form I want to have a search box looking for two fields in particular. One field is the Auditors Name and the second field is the Audited Date. For example the user will type example below into a search boxes: Auditors Name Audited Date John Doe 9/22/06 The resulting record will show the above . I want a way so I can input in the search box the ... 2 30.09.2006 02:57:41 Forms & Photos must be the spread of digital cameras......pics of items in inventory, employees, even clients.... so need general advice. It is not a photo db....a regular db but wanting a link to a jpg with a record on a Form. I know you don't want to embed photos into the db itself....so I am presuming a folder with all the jpgs... I think will probably have a "See Picture" command button on the... 8 30.09.2006 00:59:24 Updating Form Field From Another Table Hi, I have a "ProductName" table with two fields: "Product" and "ProductCode". I have this because the product name tends to be very long and I have thousands of products. I have a form that populates fields in a "Customer" table listing the product they have. In this form I have an unbound text box named "Code". I would like to enter the ProductCode into this text box and on ex... 3 30.09.2006 00:04:02 Update a table with 2 concatenated fileds I have a form that has a club and a branch. I don't want to have users having to data enter the combined field: frm_data!combo_field = rtrim([club]) & Rtrim([branch]) I can get it to show the combined field in the form, but can't get it to write back to the table that the form is based on: tblZip.comboKey = Forms!frm_data!combo_field Can somebody tell me how to get this to update t... 4 29.09.2006 23:19:51 DateDiff always tests positive ?? I am trying to test between two dates using: If 2 > DateDiff("d", DueDate, OpenedDate) Then MsgBox "The due date ....... but it always tests positive no matter what the dates are. Can anyone tell me what I am doing wrong? Thank you, Terri... 6 29.09.2006 23:17:19 Trap a return code value from SQL server Can someone point me to how to trap a return code value from a SQL server? I have looked in Safari and in newsgroups... I must be missing it... I see how to send the return code value: [From SQL Server Books Online....] CREATE PROCEDURE checkstate @param varchar(11) AS IF (SELECT state FROM authors WHERE au_id = @param) = 'CA' RETURN 1 ELSE RETURN 2 The ... 2 29.09.2006 22:13:01 Dsum syntax I can't seem to get this Dsum right. Dim PreviousScore as Integer Dim rst As DAO.Recordset Set rst = Form.RecordsetClone rst.MoveFirst PreviousScore = DSum("[Score]", "qryScoring", "GID < '" & rst("GID") & "' And Location = " & rst("Location")) rst("GID") is Long, rst("Location") is Integer PreviousScore = DSum("[Score]", "qryScoring", "GID < " & rst("GID")) returns 6 which i... 3 29.09.2006 22:11:56 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  >>