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  >>   Get to print the files to printer Is there a funtion out there that will print MyFileList for me? Private Sub Command1_Click() On Error GoTo Err_Command1_Click Command1.Caption = "Print" Dim FileName As String FileName = Dir("C:\VariousPrintableFileTypes\*.*") Do While Len(FileName) myFileList = myFileList & FileName & vbNewLine FileName = Dir() Debug.Print myFileList Loop Exit_Command1_Click: E... 3 23.09.2006 22:29:47 Images in Records Help please I am trying to create a database with images in each record I am using ole objects and selecting my image from a directory on the hard drive.every time I open the record it shows the image as an icon and when I click on it it opens Photo editor.I just want to display automatically ... 2 23.09.2006 22:26:23 Preventing Record Update Have a main form used for both data entry and viewing details of an existing record. When a new entry is started, I automatically populate some of the fields on that form. In the footer of that form is a continuous subform that shows the records already entered. Problem: If the user clicks on the subform, the partially complete record on the main form is added to the table. If the... 4 23.09.2006 21:08:45 table does not show I'm designing a query and I need fields from a table that does not show (???) in the list of tables to add... the table is in a linked database, with a relationship to other tables in that same database; those 'other' tables in the linked database do show in the list; there is data in the table and the table it is related to how do I / why isn't it showing?? thanks in advance, mark... 5 23.09.2006 20:22:13 On Timer Event is there a way, using access 2003 to view the timer value. for example if i use 100,000 for the timer interval, can i have a rundown timer so i know when the next timer event will occur?... 2 23.09.2006 17:57:31 DLookUp I'm trying to grab the TerminalID through Environ but it doesn't seem to be grabbing it. Any help appreciated. Thanks DS Me.TxtTerm = DLookup("[TerminalID]", "tblInfoItem", "TerminalID = Environ")... 2 23.09.2006 16:14:07 linking to another form using a listbox Good Day! I have a form that has a list box with multiple columns, and obviously, multiple rows. i want to have the user double click a row, and open a form that corresponds with the item selected. now, the double -click operation is fine, and my form is fine, yet i keep getting error messages when i try to do the operation. i am probably not identifying the right column, since that is t... 6 23.09.2006 15:19:02 If Statement Problem I have 2 fields, both Number fields. Whenever I run this if statemnet it always comes out Not Equal. Any help appreciated. Thanks DS If Me.Text0 = Me.Text2 Then MsgBox "Equal" ElseIf Me.Text0 <> Me.Text2 Then MsgBox "Not Equal" End If... 6 23.09.2006 13:57:47 Further help with Email code please - Doug Steele, David Cox? Hi. I’m trying to get the code quoted in the following Microsoft help page to work. http://support.microsoft.com/?id=318881#appliesto I’ve already had help from Doug Steele and David Cox on this thread “Help with Microsoft Help on linking Access to ….”: http://www.microsoft.com/office/community/en-us/default.mspx?pg=6&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.acc... 3 23.09.2006 13:51:01 FTP a file I would like to create a VBA function that converts a table to a html file and ftp's the file to a website. I think I got the converting part, but how would I FTP it ? Access 2003 Jack ... 2 23.09.2006 12:25:23 DLookup Does not work on one PC but it does on another I have a dlookup in an unbound field in a form based on a field within the form =DLookUp("[Christian Name]","tblmember","[member id] =" & [Forms]![frmracemain]![frmraceentry]![Member Id]) This populates on my PC at work running Microsoft Access 2003 but does not on my home PC (same version of Access). I do not have SP2 at work but do so at home. Is there any where I can look or anyt... 3 23.09.2006 11:17:01 Requery error message query won't run My database at the present time has two forms. In both of these forms I need to run a requery to update information. In the first form I need to update the designated region assigned to an individual state. I have a combo box that selects the data from a separate table. In the Form I have code set under “Procedure on Click”. Under this event I have the following code: Private Sub... 1 23.09.2006 09:10:02 Retrieving data into a form I would like to input a part number onto to a form. After entering the part number, I would like to populate the from with the nomenclature, serial number, description, etc... for that specific part number. How do you do this? Thank you.... 3 23.09.2006 06:32:52 Updating several row from a text box or combo box Hello, I have a database that is used to track issues with circuits. I have a main cktid and it can have several issues associated with the one cktid. What I need help with is when I assign the cktid to a tech I need the userid to be enter in the table for all the issues associated with that cktid. I also need this to happen for the [resolved_date] but sometime there may be one or two... 1 23.09.2006 05:52:17 Grrrrrrrrrrrrrrrrr!!! I'm sitting here growling at my computer as I write this ... What does one do if one needs to prevent the mouse wheel from navigating through a recordset, but Steve Leban's website is blocked by your company's web filtering software? Many thanks,... 6 23.09.2006 05:43:01 How to code an event for right mouse click? Hello! Can anyone tell me how to trigger an event on a right mouse click?? I guess the first part is on click but where do I go from there ?? Thanks very much. Mark... 2 23.09.2006 03:40:19 Can't figure out undo Boy do I need help. I have a combo box on a form, cboSAR_ID. Based on the value the user enters in cboSAR_ID I populate many other text boxes and list boxes on the form. If the user enters a different value in cboSAR_ID--no problem--I can handle that. If the user hits the "Esc" button and undos the cboSAR_ID entry, I want to give a warning and then if the user wants to undo, then I n... 4 23.09.2006 03:37:33 Adding an Option Group I have a form on a database that is used to edit records. I added an option group with yes/no values after there were several existing records. Prior to this addition, I do not want this field to show "yes" or "no". I want it to be null. But, on the pre-existing records, they are displaying "no". What do I need to do in order for the pre-existing records to show as null and the reco... 3 23.09.2006 00:43:48 access 2003 pivot table I had posted this message more than 2 weeks before, but failed to get any response. I am reposting this assuming it was lost and not read by anyone. I am sorry if I have offended any policy. But I am still looking for a solutions to this . Gmenon Hi All, I have an ADP project maintaining attendance of employees. I made this project on my home PC with Access 2002. This works fine. I tr... 1 23.09.2006 00:26:29 listing open forms and reports Hi Friend's, I have an access database project with SQL backend. Most of which is completed. I wanted to add a navigaton bar which would list all open forms and reports. Clicking item on this list would make the concerned form or report active. I dont know whether this is possible, but would certainly appreciate any response if reference is available for what i need. Thanks in advan... 4 23.09.2006 00:17:09 Highlight Current Row I would like to use Stephen Lebans AlternateColorDetailSection class to highlight the current row in a continuous form. The code seems to accomodate this option but I cannot get it to work. Has anyone tried this? Rex -- Message posted via http://www.accessmonster.com ... 10 22.09.2006 23:47:45 Query Help I have a Table that has this... tblPrivAssigned SecurityID PrivID And another Table that has... tblPrivileges PrivID PrivName I then have 2 Listboxes... One is ListAssigned the other is ListNotAssigned. The problem is this. I want the Assigned Privileges to show up in the ListAssigned List and the Not Assigned to show up in the ListNotAssigned. This only works if there are rec... 3 22.09.2006 22:17:35 type mismatch Hi, Have an access2003 db with references to both DAO and ADO added. I try this code in the immediate window of a form module and get a run-time error 13, type mismatch. Private Sub cmdRecordset_Click() Dim rst As ADODB.Recordset Set rst = Me.RecordsetClone rst.MoveFirst Do Debug.Print rst!lastName rst.MoveNext Loop Until rst.EOF End Sub ... 5 22.09.2006 21:34:47 Help with filtering a subform - Compiler error HI All, A2K3 on WinXP SP2 I have built a pop-up product search form, but I seem to have something wrong. I have followed Allen Browne's example (search2000), and everything seems to work until I try to use my text boxes (5 combo boxes, 2 text fields). When I click on my filter button I get the compiler error - Method or data member not defined. It always points to my text box name(s) i... 2 22.09.2006 21:01:55 Need Help with Calculating Dates Our client will provide us with a “cycle start date”, each cycle has a total of 9 release dates, the first release date is in fact the cycle’s start date, in turn we have to calculate 8 additional dates. Each of the 8 subsequent dates must be in intervals of 10 workdays, however if the intended date falls on a Saturday the release date is advanced to Friday, if the release da... 2 22.09.2006 20:09:02 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  >>