Threads Replies Last Post 363 Pages: <<  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  31  32  33  34  >>   Brown dot HI guys, Can anyone please tell me why a brown dot appears next to a line of code and that line is high lighted in brown when you click next to a line of code on the left hand side? Maz ... 3 12.09.2006 23:38:06 Forms for history and new data? Hi, Here is my real world setup I am trying to model. I have 3 tables with data (mainly serial #'s and model #'s) of equipment that is all related to each other somehow. I have a table called 'Work Orders' that is going to be used to track and create maintenance requests needing to be done on the above equipment . The configuration of the equipment must be shown on the work order.... 1 12.09.2006 23:19:02 Record selector jumps back to first record I have a from with a subsorm. When I select any record in the subform other than the first one the message at the bottom left of the scren shows "calculating" As soon as the message shows "form View" the record selector jumps back to the first record. I have two other very similar form/subform screens that act normaly: the record selector stays where it is put after the message shows ... 7 12.09.2006 22:01:02 Hyperlink in Text Box Hello, I have a form that uses a select statement that I coded in VBA as its record source. One of the text boxes which displays a field from the search result is formatted as a hyperlink. All I did was set the properties of the text box to "Is Hyperlink"=Yes. It looks like a hyperlink but it doesn't work if you click on it. The hyperlink links to a field in another form called "case... 1 12.09.2006 21:58:01 Temp store multiselect itemselected ?? Hi, How do i in vba temporarily hold the selected values of a mulitselect listbox while the listbox is being required from another listbox for more values selection and once all wanted values are selected, I would like to insert them into a table by a click on a cmdbtn. I think I would store them in an array but I read somewhere that itemselected on a multiselect lstbox is already an... 3 12.09.2006 21:51:02 Conditional Formatting on Current I would like the current record in a dtasheet form to have conditional formatting, not on focus because that requires the initial clicking on the field. What expression can I use in the conditional formatting dialog box to make this happen? Thanks... 2 12.09.2006 21:26:59 Names with multiple forms This may be obvious, but I can't find any documentation on it, so ... With multiple forms in a single Access 2002 database, how does Access determine which event procedure to use with which form? I have a form with a defined event procedure ("Private Sub Form_Current") but if I define multiple forms in a single database, can each form have a seperately defined event (for example, "Current... 2 12.09.2006 20:46:01 DCount issue I made a form that consist of two textboxes and a subform thats based off of a query. I placed this code to count the number of rows that contain a certain value (rec_num) in the subform, but i get a "You cancelled the previous operation" error message. Before the form opens, it prompts you for the rec_num. This is the code. Private Sub Text9_Click() Dim x As Integer x = DCount("[agre... 7 12.09.2006 20:30:02 linking a filtered subform I have a subform that is filtered by a combo box on my main form. The combo box is called cmbModelNumber. There is a Model field in the query which the subform is based on. Therefore, I have put the two model fields from each of the two forms in the Parent/Child properties of the subform. However, this only provides me with a filter. I would also like to link the main form to the subfor... 7 12.09.2006 19:58:45 Chg prop of button on form = not visible perm via code after exec I need to change the property of a button to not visible and not enabled permanently after execution of the macro that is run by clicking the button. It works until you reopen the form and then the button is back.... 3 12.09.2006 19:47:02 Empty TextBox Why this code can't response empty textbox? I also try with "" Thanks! Private Sub Command1_Click() If [Text10] = Empty Then MsgBox "Please enter value!", vbExclamation, "ERROR" Else DoCmd.OpenForm "My Form" End If End Sub... 2 12.09.2006 19:08:46 How I pass a value from a form to a subform? I am creating a student database in which I have a form (displayed as a continuous form) that lists the terms that the student were enrolled in the school. Beside each term that the student is enrolled, there is a button that links to a subform where I want to enter the courses that the student was enrolled for the corresponding term. I have been unable to successfully link the "termid... 2 12.09.2006 18:51:02 one form or another, please help i have a form on a qry in which the user can select whether a product has been accepted or rejected. if rejected the user must go to the next from to justify the decline then onto the final summary form. if no products declined the user can go straight to the final summary form. i currently have 2 commands one for the justification form and one for the summary form. what i would real... 1 12.09.2006 18:34:01 Extracting text from a declared string Ok...I've been searching and searching but I haven't been able to figure a good way to do this. I sure it will be easy but my brain has had enough. This is not designed by me so I am having to work around a poor design structure.... I have a resultset that has 213 char. within it. This I am declaring to a string called temp. What this resultset contains is the full business name, cont... 3 12.09.2006 18:21:31 Form On exit event I have posted this thread last week. I apologize for posting it again but I could not solve my question. May be someone else can give me an idea. I need when closing a form to open a report on a specific record. So, I have this code: Private Sub Form_close() DoCmd.OpenReport "Invoice", acViewPreview, , "[DocId] = """ & Me.[DocID] & """", acNormal End Sub The problem is tha... 4 12.09.2006 18:10:02 Adding Weeks & Months together Way beyond me... need help! I need to add together a specific number of months and weeks to a target date. The TargetSubDate field is filled in by the user and formatted for Short Date. The MonthsToComplete field is formatted as fixed, 0 decimal, and the user would simply enter in a number. The weeks field, EstLeadTime, is a calculation as follows and works correctly according to the amo... 3 12.09.2006 18:05:02 Subform Properties Changing Unexpectedly I have a database application where a subform’s properties are being changed unexpectedly. The properties being changed are AllowFilters, AllowEdits, AllowDeletions, AllowAdditions. These four properties are being changed from Yes to No. The database will work fine for months, then one day, I cannot edit data in this subform. When I view the form’s properties (listed above), they... 4 12.09.2006 17:15:26 Changing the color Pallet in MS Access I can very easily edit the color pallet in MS Excel by changing the ActiveWorkbook.Colors(1) = rgb(255,100,100) etc. However, I do not seem able to edit the color pallet in an MS access form in the same (or similar) way. Is this possible? Thanks ... 1 12.09.2006 16:24:50 Page Down on Form When a certain combo (cmbBill) gets the focus, I want the form to automatically page down. cmbBill has just a Yes or No selection. Using SendKey to Page Down does not work because if you hit Page Down and the form is already Page Down then it count the records on form. Is there anyway to have Access not do this because then the SendKey would work? SendKeys ("{PGDN}"), False T... 1 12.09.2006 15:45:02 calculating with Null fields Hi, I have a table with some fields defined as Numeric with default value 0 I want to do some calculating with some of this fields but noticed that when nothing is entered in those fields they are "Null-field" so no calculating is possible... how to solve this? Thanks... 4 12.09.2006 15:26:00 SQL SubQuery I have an SQ Statement. It's a Query based on a SubQuery. I need to make it all SQL by incorperating the Query into the statement. Any help apprecited. Thanks DS This is the SQL Statement SELECT Query12.LogJobID, tblJobNames.JobName FROM Query12 INNER JOIN tblJobNames ON Query12.LogJobID=tblJobNames.JobNameID GROUP BY Query12.LogJobID, tblJobNames.JobName ORDER BY tblJobNames.Jo... 8 12.09.2006 15:04:55 Limiting number of decimal places after calculations Him im using this code to calculate ratios: Private Sub Staff_AfterUpdate() DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 [Staff_Pupil] = [Pupils] / [Staff] [TotalAdults] = [Staff] + [OtherAdults] [Adult_Pupil] = [Pupils] / [TotalAdults] End Sub I want to limit the output of the following two calculations to one decimal point, if there an easy way? I have a... 4 12.09.2006 14:28:02 load image control from emf in a byte array Hi all, Can anybody tell me how to load an Access Image control with an emf in an in-memory byte array? I am building an interface between an Access 2K application and a SQL Reporting Service. I have a byte array coming from the webservice that I am inserting into an Access report. Currently, I am saving the byte array to a temporary emf file on disk using an ADODB.Stream and t... 3 12.09.2006 14:15:02 How can I create a dynamically FORM? I would like create a FORM and open it in datasheet view and binding a recordset via ADO. I can bind the recordset to a form without a problem. But, I would like create just one form for all my recordsets and I need the following changes programmatically. 1. Change programmatically the name of the controls (acTextControl) 2. Change programmatically the source control of the controls ... 9 12.09.2006 13:53:51 lookup lists in alphabetic order Im using lookup lists and the key is an id and the data is then the second field, I would like these to be in alphabetic order of the data is this easy? if so how? ... 3 12.09.2006 13:29:33 363 Pages: <<  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  31  32  33  34  >>