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  >>   DB Review Greeting All. I have been coming here for a while now asking many questions and reading thru many posts....you guys are awesome. I have been working on a Voting database for about a week, I have come a long way as far as the Table relationships and so forth. My question is: Will someone out there be willing to take a look at my projects, just to have a look and maybe point out some def... 9 17.09.2006 21:35:18 Screen shot of a form Hello, I like to have a command button that will do a screen shot of a form and if possible send an e-mail of the screen shot automatically. How do I do that? Thank you in advance. ... 2 17.09.2006 20:22:01 Upload file via FTP I am trying to upload a file Dim ftp As Inet Set ftp = New Inet 'Set ftp = Inet With ftp .Protocol = icFTP .RemoteHost = HostName .UserName = UserName .Password = Password .Execute .URL, "Put " + Lo... I get an error on Set ftp = New Inet where the errormessage is 'ActiveX component can't create object' reidarT ... 7 17.09.2006 19:15:35 Computer Vitals - Your Online Computer Helpline http://computervitals.com Hey guyz, I welcome you yo Computer Vitals, Your Online Computer Helpline. A new venture to help people with all sides of software and hardware. Pay a visit and experience yourself. Lets get together and help eachother. Post your questions and get answers from some really experienced people. http://computervitals.com Help sections include Computer Maintain... 3 17.09.2006 19:12:59 delaying an event for several seconds I'd like to delay the event of a command button for several seconds so that I can focus my cursor onto another window of another app. Is it possible to set a delay without a timer event that cycles? if so -- any suggestions? Also - when the event runs - will it re-focus back to the form that calls it?... 3 17.09.2006 18:28:14 How to access a field value in Access VB MILKMAN ROUNDS PROJECT: I have a simple project that has a customer table (Detail) and a "Rounds" (master) table that contains the round details for the round each customer belongs to....no problem. I have created a query and then a report that selects all customers that belong to a selected round number...fine In the reports detail OnFormat event i want to reference the value of an... 5 17.09.2006 17:27:21 Looping through subforms ? I need to open a form in "read only" - it contains many subforms placed within tab controls: /begin diagram Forms![Master] Forms![Master]![frmA] Forms![Master]![frmB] Forms![Master]![frmB].Form![frmB1] Forms![Master]![frmB].Form![frmB2] /end diagram frmA and frmB are in a tabctl in Master frmB1 and frmB2 are in a tabctl in frmB i need to loop thru all the forms to set the read ... 5 17.09.2006 17:27:17 Too Few Parameters when opening query Hi, everyone! Have a query, "BOMWeights", that resides in the front-end database. It brings together into one record summary data produced by 3 other queries that extract data from a table in the back-end database. When I double-click on the query, or use a OpenQuery command in VBA, it displays fine. When I try to open it using the OpenRecordset command, however, it generates a run... 3 17.09.2006 16:24:01 Calendar control.. Hi all... For some months now, I'm trying to get a six months view in my form.. where the first month is the current month.. Unfortunatlt I'm not able te get it right!! Does anybody has a clean example? Best regards, Arjan... 3 17.09.2006 16:01:01 Lookp Acrobat install location in code and assign to a variable In the code below I have hard coded the path to where Acrobat is installed. What I really need is to look up the install path via code and write it to a variable so that the code can be computer independent. For instance, this is where the patch is stored in the registry. HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\Acrobat.exe Here is the code I'm using now that I need to m... 3 17.09.2006 15:17:49 Referring to a control Hi. I am trying to change a control based on the result of a function.... Example ReturnDay returns the day of the week as an integer. How do I refer to a Command Button named "command" & ReturnDay?? Such as Command3... I am trying to change the caption on that specific control. I hope the question is clear . Thanks in advance!!!... 5 17.09.2006 15:14:02 Form Keeps Closing I set up a form to select a specific report from a dropdown list. When the report is clicked, a script issues code to enable specific selection criterion options on the screen: Me.OptScreen.Enabled = True etc. Every time the above code is hit the following happens: Microsoft Office Access has encountered a problem and needs to close. We are sorry for the inconvenience. Any ideas ... 3 17.09.2006 14:39:01 Outlook email routine - "From" field At work (using Access 2003 and Outlook 2003) we have the ability to send an email from within an access program. It will come up prefilled in using information from the Access database. when it is received, the recipient will see that it is from which every member of the team originated it. There is a function in Outlook (and perhaps I should be posting this item on their group) where by you... 2 16.09.2006 21:02:07 CopyFromRecordset Is it possible use this method or similar method to copy recordset to MS Word? Another away to copy data to word is with merging, but I don't know how can I do. any suggestion I'll apreciaste, Thanks JP... 4 16.09.2006 19:35:30 Adding a Row--Spreadsheet Simulation I am trying to get a button to work to add a new record. The glitch is that I want certain fields to be duplicated, since from the point of view of the user, they are adding a row between two other rows. Since opening a new record navigates them away from the original data, I want to do two things: 1) Give them the reference data from the row above the place where they want to insert the... 3 16.09.2006 17:51:01 Genealogy database I downloaded a genealogy template from microsoft here http://office.microsoft.com/en-au/templates/TC011031131033.aspx?CategoryID=CT063459251033 but I noticed there isn't an option to display a treeview for descendants, only for ancestors. Since I am a beginner I'd like to know how to modify the code to see the descendants instead. Here is the code to modify I suppose: Sub AddParents(... 1 16.09.2006 14:32:55 notinlist combobox i would like to use the not in list event to tell the user it is not in the list and open a form to allow the user to to enter a new record and then requery table to update combobox. table is "asset" record is "assetserial"... 3 16.09.2006 14:20:22 Pictures and text in the butonn As you know, in ms access there many pictures (bitmap) that we can embbed in the button. My qustion is: 1. How can I add my personnal pictures? I know we can link for external file. Is it possible create and add a picture to the button without link? 2. How can I add picture and text into the butonn? Thanks JP... 8 16.09.2006 10:16:19 Get Format date from windows How can I get the default format date in the computer? I mean if the default date is mm/dd/yyy or d/m/yyyy etc. Thanks a lot JP... 5 16.09.2006 10:14:41 How to remove a filter Hello, I'm having a hard time removing a filter. Form 1 has a combo box, to select a person. AfterUpdate of this Combo1: Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[ContactID] = " & Str(Me![Combo1]) Me.Bookmark = rs.Bookmark Dim stDocName As String Dim stLinkCriteria As String stDocName = "Form2" stLinkCriteria = "[ContactID]="... 8 16.09.2006 06:49:43 r_with_listboxes I have a “persons” form (bound to a “persons” table) that has a “PersonsGroups” listbox that is bound to a “joins_persons_groups” table; the “PersonsGroups” listbox lists joins between the “persons” table other tables that the user selects from the “groups” listbox. I have VBA code linked to a button that makes joins between the tables and updates the “Persons... 1 16.09.2006 01:31:01 Filter continuos form Hi all, I would like to know how to create a filter in a continuous form. I have a continuos pop-up form which I would like to filter but not using the Access toolbar filter by form icon. I would like to create my own filter. In the end I would like to be able to filter all the "Smiths" then from the "Smiths' I want to be able to sort the "Johns" and so on. Can anyone point me in the ri... 1 15.09.2006 23:12:47 Display x of y on form If someone has removed the standard record count that usually is displayed at the bottom of a form - how could I program a text box to display the same information ie x of y I need to include a record count not only on the main form but on each subform (there are 3) ... 11 15.09.2006 22:45:02 Suddenly CAN'T DELETE / EDIT Records ??? This is driving me CRAZY ! I'm doing some weekend work here..... Have done some editing on an existing Access App. Earlier...I had NO PROBLEMS editing / deleteting records...... I've been adding various features....but have NOT changed any edit settings Anywhere (that I know of)....everywhere that I know to check in properties, etc all have a 'YES" in the fields relating to allowing ... 4 15.09.2006 21:52:01 FindRecord Not Changing the CurrentRecord? Hi, I am attempting to control and error check the deletion of records that my users are allowed to do. So I want to have an edit box and a delete button on my form. The user will put a record ID into the edit box and then click delete. I have been attampting to use something like the following: Me.DeleteThis.SetFocus DoCmd.FindRecord Me.DeleteThis DoCmd.RunCommand acCmdDele... 1 15.09.2006 21:26:49 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  >>