Threads Replies Last Post 570 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  >>   ) missing.... but where schljaar=IIf(Month(Date() Between 9 And 12 , Year(Date()) & "-" & Year(Date())+1 , Year(Date())-1 & "-" & Year(Date())) returns an error saying there is a ) missing... Can anybody help? Thanks... 3 12/18/2008 1:31:19 PM How the imported data will add to the exixting data Hello, I created a church database and the data will be combined in the higher office. My questions are as follow: 1.Waht should we use to combine, is it import or append data 2. If the record number is generated by the the sistem when inputting the data in the form. Can we do import?, or it will zeopardise the computer generating number system 3. Is it better to do export to sprea... 1 12/18/2008 8:48:07 AM Unhandled runtime errors kill form timer events Does anyone have a decent way to deal with unhandled errors, which kill globla vars and stop form timer events from taking place? I use unbound forms (and temp tables) to keep alive some data points for reference, so the global vars part is not so much of a problem. But I'm having a hard time coming up with a good way to deal with form timer events which stop firing if there is an unhand... 13 12/18/2008 5:00:13 AM Tab to next subform I have a form (frmAssessments) with three subforms(sfrmAssess1, sfrmAssess2, sfrmAssess3). I want the user to enter data into the main form and then be able to tab to the fields of each subform and enter data. I got it to the point where they can tab to the first subform, but once you get to the last field of that subform - tab puts you back to the first field, new record. I have lo... 2 12/18/2008 2:16:05 AM Updating all records If I have a price calculation based on a complicated query with aggregate and subqueries which uses the part ID on the input form as the filter for the subqueries, the part price calculates fine, but if the material costs change and I wish to do a "batch" update of the part prices I need to loop through all the records in that form. Since the queries all have "forms!frmPart!PartID" as t... 15 12/17/2008 11:41:00 PM Filtering combo boxes based on a selection in another combo box Hi Guys and Gals I have a subform which is designed to look like a datasheet because I need to filter a combo box called Materials based on another combo box earlier in the selection process called Region. To explain the data, Regions are like a location on a site. Materials are exactly what they sound like. Each Region contains a different combination of Materials. Obviously, ther... 2 12/17/2008 9:50:38 PM Displaying records that have one of two fields equal to Master Field I have both parents and children in a table (with unique ID numbers). I am making a form that will display a parents name and then all children related to that parent. In order to do this, I made two fields for each child named "Relationship1" and "Relationship2" that contain a parent's ID number. I can successfully make subforms that match the parent's ID to the ID number in Relationship... 4 12/17/2008 7:40:43 PM Multi Select List I have a Multi Select List box on a form. The user selects the items in the list and a report is generated. If the user selects more than 100 items in the list box we receive a 7769 error...The filter operation was canceled. The filter would be too long. Is there a way to allow the user to select more than 100 items? Thanks. Private Sub OK_Click() Dim varItem As Variant Dim strInCla... 5 12/17/2008 7:02:46 PM Inserting picture I couldn't find another location to put this question out, so I apologize. This is probably not what you think, I don't need to create an OLE Object or anything. All I want to do is put my company's logo on an invoice / packing slip which are both set up in reports. Everytime I have tried inserting, copy and pasting, and paste special, the picture blows WAY up. Then when I reduce the... 3 12/17/2008 6:49:02 PM rs.FindFirst limits? Hi, I've been using rs.FindFirst to search by two criteria using the following code: Private Sub FilterSamp_AfterUpdate() On Error GoTo err_Handler Dim rs As DAO.Recordset If Not IsNull(Me.FilterSamp) Then If Me.Dirty Then Me.Dirty = False End If Set rs = Me.RecordsetClone rs.FindFirst "[RE Job #] = """ & Me![RE Job #] & """ and [Task ... 4 12/17/2008 6:22:03 PM MsgBox window when you receive a new record in an IM type of DB Hello. I have created an Access database that will be shared by a few people that will work almost as an Instant Messanger. The querey on the "Main" form pulls all records created by the person logged in to the computer (using a module that pulls the LAN login ID) and any record assigned to the person logged in. The "Main" screen also refreshes automatically every 60 seconds. I would l... 2 12/17/2008 5:57:50 PM Query Of Totals I have a table that has some fields, “typeMeeting”, (11 types of meetings), “NumberOfBooks”, NumberOfItems”, “NumberOfPages”. I would like to create a TotalQuery that gives me a break down for the totals numberofpages, books, items for each type of meeting. Can this be done using 1 query?? Can someone help through it and to understand it?? -- NotGood@All... 4 12/17/2008 5:02:34 PM Problem with requerying a combo box I have a form where I am using the double click event of a combo box to open up another form so that I can add additional records for the combo box. On the close event of this second form I have the following code: If Forms!frmWorkOrder.IsLoaded = True Then Forms!frmWorkOrder.cboAssignID.Requery End If The desired result is to requery the combo box on my primary form so that I ... 3 12/17/2008 3:38:01 PM how can i check if an value is integer or string? how can i check if an value is integer or string?... 2 12/17/2008 10:45:07 AM printing records to Excel worksheets I am trying to open an excel file and insert the data from a Table or Query into a sheet and print. I actually need to loop thru all the filtered records and do this task. Currently I am using this code to open the excel file and place the data into Cell B2 then print. This part works but I need to integrate the table/query loop to print all the records. I have a table called tbl_data ... 5 12/17/2008 7:51:03 AM how to off cursor dear friend, any body can help... i would to off scroll thru cursor data in the form. what heppen now, data in form can scroll bar from cursor.... 3 12/17/2008 7:46:11 AM Count records in another table I have a "Project Action" form with a button that opens another form, the "Risk Form", using a DoCmd.OpenForm command. The records displayed in the new form have an associated Project Action number that is the same as the Project Action number in the calling form. The users would like the Project Action form to indicate if any matching risk records exist without having to actually open... 4 12/17/2008 11:35:01 PM Form.Requery problem With a button onclick event i've deleted all rows within the table and try to requery, but i always get "record is deleted" how can i bypass this?... 2 12/18/2008 5:14:01 AM Runtime error 3008 Runtime error 3008 The table tblBaskets is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically. Ive for form_load event on a form (bounded to tblBasketContent) and when it loads i run Sql to insert a record in tblBaskets, but it saying its already open?... 2 12/18/2008 5:16:01 AM setfocus problem I have a main form, frmMain with 2 subforms. By default, SubformSecond is made invisible. SubformFirst is in datasheet view. Before updating data in a textbox, txtPhyBal in subformFirst ,a message popup form opens (fired by before update event of txtPhyBal). On clicking an OK button on the message pop up form, the pop up form closes and subformSecond becomes visible but the focus can be ... 3 12/18/2008 8:21:16 AM How to find the text contol Hello: It could be when I redo the textlabel or the other text control, I changed the name. Can anyone tell me how can we find where is the "text139". I know how to find it in the VBA and the form, but I do not know where is the control, I went a round the form one by one but I still can not find it. Is there anyway to find it? Thanks for any help provided. -- H. Frank Situmo... 5 12/18/2008 1:25:31 PM Package solution wizard and diferent languages? In Access Package solution wizard one can choose from different languages as "Install language". If you choose some other language as english the "Ok -button" is dimmed out. There's an link to the right of the dropdown meny where you can choose "Add support for more languages" that links to http://office.microsoft.com/en-us/access/default.aspx. In this (or any other page) i haven't been ... 4 12/17/2008 8:10:24 AM What is wrong with my code? The code below works on some computers and does not on others. all computers are on the same net work. the code breaks on ".send" and gives me an error message "user send error". I am using Access 2003 so are the others. any idea? Sub Mail_CDO(strTo As String, strFrom As String, strSubject As String, strBody As String) Dim iMsg As Object Dim iConf As Object Dim ... 5 12/17/2008 3:41:04 PM Listbox SQL Here's my code to fill a list box when a combo box is updated: Private Sub cboCustomerName_AfterUpdate() Dim sql As String sql = "SELECT tblCustomer.CustomerName, tblClientBuildings.JobAddress1, tblClientBuildings.JobAddress2 FROM tblCustomer INNER JOIN tblClientBuildings ON tblCustomer.CustomerName = tblClientBuildings.CustomerName ORDER BY tblCustomer.CustomerName, tblClientBuil... 4 12/17/2008 6:02:02 PM Close Preview Select Form I have a form that allows you to select one or several reports for preview by using a command button. I want the Form that has the selection of reports to automatically close after I've hit the print button. Here is my code. What Event Procedure do I use? Private Sub Report_Open(Cancel As Integer) Dim Bar As Office.CommandBar Dim Ctrl As Office.CommandBarControl For Ea... 4 12/17/2008 6:11:01 PM 570 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  >>