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  >>   Embedded excel spreadsheet will not update when form is opened I have a number of forms that have embedded excel spreadsheets in them. I took over modifying these forms and apparently they use to automatically update when the form was opened. But now with the new excel spreadsheets in them they will not do that. How to I programically force the spreadsheet to update when the primary calling form gets updated or changed? The following is the code i... 1 12/5/2008 4:21:01 PM Saving Content of Embedded Excel Control on Form Hi, I have a Microsoft Office Spreadsheet 11.0 Object on my Access form and I can't seem to save the contents. I have the following code in place: [CODE] xlsReceiptContainer.ActiveWorkbook.Worksheets("ETSReceipt").SaveAs uploadPath & "\" & fileName [/CODE] I've got to be close. Everything clicks along and then on the above line I get: "Run-time error '438': Object doesn't supp... 1 12/5/2008 2:44:01 PM Change font if #Name? I have a simple '97 database for tracking our equipment inventory, and one component of that references the status of the equipment—“Deployed”, “On Hold”, or “In Stock”. For doing a quick stock check, I have a continuous form based on an underlying query. The form has a row for each type of equipment and a column for each status where the records are counted (and I have t... 4 12/5/2008 2:40:38 PM clearing previous value of a combo for a new one. Hello, I have a combo1 that gets its value from combo2 of a different form. combo1 is locked and is set to ItemData(0). combo1 works well with new value, but if If I want to edit or change its previous value, it will still keep the old value seen and the new value in the dropdown list. How do I clear the old value so that the new value replaces it ? many thanks. ... 1 12/5/2008 2:28:42 PM Different Access protection Hello Is there a way to secure at 100% an Access database? The password offered in the security options of Access is not secure enough. There are many softwares on Internet that can get this password for less then 20$. What I thought to do is let the users get connected to an application that will check the rights of connection. If the user has sufficient rights, then lunch the ... 10 12/5/2008 1:38:57 PM Continuous Form Records question Hello, I have a continuous form, when users edit on a row I have to issue a requery on the form because the data source is a query of 3 tables from linked Oracle tables (so they can see the changes in real time and other issues). My questions, once the form requeries, the record pointer goes back to record 1. The users are complaining that if they're on record 225 for example, the for... 3 12/5/2008 12:37:02 PM Module Hello, I am relatively new to do access, I started it as my hobby. VBA is triggerred to act by event procedure, my question is how about the module, what and when it starts to act. If someone put the name of the module as he wants says: Public Sub LanguageControls(), how does it work. Thanks in advance for enlightening me. -- H. Frank Situmorang... 3 12/5/2008 9:34:11 AM Can not email from form. I get: Run-time error '2292': can't send message for the reason ated in the previous alert. Resolve the problem, and then send the message again. Microsoft Outlook 11.0 object library is ticked. There is no previous stated alert. I suspect this is caused by copying this database on to a computer with Office XP/2002 and back to a computer with Office 2003. Using Access 97. Thanks, ... 14 12/5/2008 7:18:55 AM Able to DELETE Query Generate in Table? Hi, My subform output from a query running behind, Can I detect which recordset user selected ? Also Will I able to delete the recordset? Cause it seems that Query generated Recordsets do not permit deletion though i open the Subform.AllowDeletions =True Edison -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200812/1 ... 6 12/5/2008 5:56:36 AM ge if txtProductPrice.Caption is £25 how can i force it into a integer? in php its (int)var... 2 12/5/2008 2:51:24 AM documents i looking for tips on creating documents... 2 12/5/2008 2:31:22 AM Prompted to Default Date or User Option to Change Date My form opens with current date. I want it so that user has the option of using either default date or changing the date as necessary. Can someone please give me the VB code on this? I've tried looking it up, but have not found anything. Thank you everyone!... 7 12/5/2008 1:22:00 AM Error in insert syntax qryString = "INSERT INTO tblProductsLog (staffID,productID,quantity,timestamp) VALUES ('" & staffID & "','" & txtProductID.Caption & "','-" & cmoSelectQuantity.Text & "','" & Now() & "');" whats wrong?... 4 12/5/2008 12:39:43 AM How to insert multiple DIFFERENT recordsets into single form Hi, I had a form that need to look up records from multiple table and insert them into my form controls (certain values but standard Field & Name for different Table) Anyone ever tried it ? Edison -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200812/1 ... 10 12/5/2008 12:25:47 AM fiscal year I have a database that calculates the total times an object appears in a field on a form. I can get it to calculate the last 6 months or the year from the calendar but I cannot change it to calculate a fiscal year. This is in a function, not a query. Public Function gettxt6MET(UserID As Variant) As Integer Dim strWhere As String If Not IsNull(UserID) Then strWhere = "User... 6 12/5/2008 12:25:01 AM I split a MDB, and now the front end don't work I have a Project, which already had a linked set of tables (to a single database), but still had a other tables integral to it. I decided to split the integral tables from the project, so that it will have 1 set of tables linked to one database, and a 2nd set linked to a 2nd database... Having cut and pasted the set of tables integral to the project into their own database, I imported ... 7 12/5/2008 12:05:00 AM Incrementing a number for each row Hi Guys, I need some help in numbering incremental rows for a particular project. For instance if I have 3 records I am trying to have the name of the project, a slash and then the nuber of the record. ie. RecordNo: Type projectRisk Record1 Risk 02033/1 Record2 Risk 02033/2 Record3 Risk 02033/3 You see under Proje... 6 12/5/2008 12:02:48 AM how to just increase a field how to i increase a field rather than setting it? e.g. total= total+price... 2 12/4/2008 11:57:40 PM how to just increase a field e.g. total='" & total + prove & "'... 1 12/4/2008 11:18:02 PM how can i make sure the form only opens once? (cant have same form how can i make sure the form only opens once? cant have same forms open... 2 12/4/2008 10:36:40 PM how can i get the newest record id? (the last record entered, the how can i get the newest record id? (the last record entered, the id field)... 2 12/4/2008 10:12:57 PM error 2499 hello. I've looked for an answer to this but can't find one. I get error 2499 on my form when I click the "save" button and if the term date field has been populated. here is the code: Private Sub cmdSave_Click() On Error GoTo Err_cmdSave_Click If Not IsNull(Me.Term_Date) And Me.Dirty Then Call TermGroup End If DoCmd.GoToRecord , , acNext Me... 10 12/4/2008 9:18:07 PM Hyperlink from BrowseFolder Dialog Greetings, I am trying to make a hyperlink textbox that on oneclick will open an explorer window to the hyperlink targer (the easy part), and on doubleclick will open a browser dialog that will allow me to choose what the target of the hyperlink will be (to be stored on a field in a table). I have tried several different views, most of which coming from links on the mvps.org API lists, ... 2 12/4/2008 7:40:18 PM Filter Records in a Subform from a ComboBox within a Parent Form Hi group Hope someone can help me with this one. its been driving me crazy I hope that the description I have annotated below is adequate:- I have a continuous form “FRM_REASONS” which shows records with 3 fields in each 1 = “Type_Name” 2 = “Reason_Code” 3 = “Reason_Description” On the Header of the Form “FRM_REASONS” I have a ComboBox “Select_Type” whic... 6 12/5/2008 12:42:02 PM Rin Time error 2465 "Microsoft Office Access can't find the field 'cboMovieLookup' referred to in you expression." I have a subform that I am attempting to add a combo box that lists the movie ID and when the user clicks on the movie ID it will fill in info like the Movie Title in a text box. I've doen this on the main form using similar code and it worked fine, but it is not working now and getting the Ru... 6 12/5/2008 1:57:22 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  >>