Threads Replies Last Post 363 Pages: <<  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  >>   Email current record Hi I have a form and I would like to email the current record I am looking at. I have a report which it would use for the email but I can't get it to work. Can anyone help? This is what I have been working on Dim strWhere As String If Me.Dirty Then 'Save any edits. Me.Dirty = False End If Dim stDocName As String strWhere = "[Reference Number] ... 3 01.09.2006 14:46:52 find button in form I would like to make a button that could be used in a form to find records, friendly enough that untrained users could make use of the feature. I would like to create a button that does a "find in form", provided the user isn't already trying to do a find or filter. I would like a second button that would apply the filter created when the user entered data in the "find in form", and a ... 4 01.09.2006 14:44:02 Sort Ascending on Subform Hi I have a form with a subform on it in the format of one of the tables. When I open the form it does not show the entries in alphabetical order, so I right click it and go to "Sort Ascending". When I close the form and reopen it, it again is not sorted. If I open the subform it is sorted there. Does anyone have any ideas on how to get this to work? Thanks Colin ... 4 01.09.2006 14:32:51 Open form listed in Text Box I have a form being used as a menu. I'd like a command button to open which ever form is listed in a text box. The text box is not visible and is populated once the user clicks an employee's name in a list box. the DLookup function is then used to find the form (menu) corresponding to that employee. Instead of: DoCmd.OpenForm "frmAaron" I'd like something like: DoCmd.OpenForm text... 7 01.09.2006 14:09:03 Combo box/ Subform question Can someone please explain to me what is happening here? I have a form with an embedded subform. The form and subform are linked by "SongTitle" field. The form has a combo box to select a song title. Whatever title is selected, the subform is filled with details about that song. If I go to the subform and edit any of the fields, the title of the FIRST record in the table is overwritten wit... 3 01.09.2006 10:37:09 Navagate Record + Event problems Ok, I have a form where depending on which options are wanted, certain controls are disabled. For example, say I have a checkbox labeled "Free Widgets". If the checkbox is empty, then the control beside it called "No. of Widgets" becomes disabled. The code I have works (for checking the checkbox/control pairs), but the problem is that when I navigate records (with the ... 4 01.09.2006 10:05:02 Reset All Check boxes Hi there I have a form where I have a subform view in it showing a table. One of the columns on the table has a checkbox. Is there anyway I can reset all the checkboxes in a particular column so they are all "No" by clicking a button? Thanks Colin ... 5 01.09.2006 08:29:03 help on moving through records. hi there. I have been attempting to fix this for just over a week, the problems result in either the queries not returning anything or the movenext function not working, please could you help me, any ideas would be helpful. The purpose of this code is to populate a bookings review form with the other people staying at the same time as the one being booked in, this has proved difficul... 2 01.09.2006 06:56:01 DCount Date Problem I keep getting Type Mismatch.....its gotta be the date! Any help as always appreciated. Thanks DS Me.TxtCount = Nz(DCount("[PaymentID]", "PayApplied", "PayApplied.PayDate = Date(Now())" And "PayApplied.SalesID = " & Me.TxtSalesID & "")) If IsNull(Me.TxtCount) Or _... 6 01.09.2006 04:57:31 Several Forms I have a form that is a number pad. Sometimes it's used to enter dollars, sometimes numbers, sometimes percents. It's called from 25 different forms. Hence I have 25 different versions of this number pad form. This is not good. I would like to get it down to one form. And have a select case behind it choosing which action it does alon with what form it does it to. I'm a little nerv... 4 01.09.2006 02:22:01 Importing Excel Spreadsheet I have been importing a txt file into my database for years. My work program now has been updated and the file is now in an Excel Spreadsheet. When using the import wizard for a text file I was able to create an import spec that handeled the formatting and renamed each column to match my database. When using the import wizard with excel the wizard does not allow me to either use an impor... 2 01.09.2006 02:09:43 Command Button, ComboBox or something to Filter my Records on my Form. I am trying to create a Command Button or ComboBox to Filter my records/Cases. Each record/ case is either: Open, Closed, Action Track. Named (ComboCurrentStatus) Control Source (CurrentStatus) I want to be able to filter all my OPEN cases, CLOSED cases, Action Track cases, and lastly be able to see all records on my form (HOTLINE_INFO). What is the easiest way to filter these reco... 2 01.09.2006 01:35:13 Programatically send email How do I use VBA to programmatically compose and send an email? Kan ... 3 01.09.2006 01:27:45 Inserting Record from Multiple Tables Hi everyone, I have a form (form1) that is controlled by table1 (Orders), which launches another form (form2) controlled by table2 (Items) - upon completion of a record in form2 (and closing of form2), which adds a record to table2, I would also like it to add a record to a table3 (shipments), using a combination of fields from table1 and table2. I thought about using a DoCmd.RunSQL INSE... 3 31.08.2006 23:08:01 Dim VS UnTexbox Which is better to store temporary values? Dim or an Unbound Textbox. Is one faster? Is one more stable? Can you have several Dims? How many Dims is too many? Any downsides to one or the other? Any info appreciated. Thanks DS... 8 31.08.2006 22:48:02 problem with spaces hi, On my continous form I have a textbox (znaam) in the form-heading. On the "change"-event, I look in my recordset for a match with the text I type , and then I try to go to that record on my form. This works fine as long as I do not type a space. When I do that(as in "De Bock") access looks always for a text without the space at the end, and it is impossible to type a character after ... 3 31.08.2006 21:42:46 If a value is negative how to make it equal 0 If I do a calculation between two fields and the answer ends up to be negative how do I make the negative number equal 0.... 4 31.08.2006 21:42:01 Access: Opening a file path stored in a text field from a form? I would like to store the logical path to a file in a table, and then from a form have a command button open this logical path. Specifically I am trying to store imaged documents in PDF version on a file sever, and then using this logical path as a means to access them. Any ideas on the code for the command button to make it do this. I might add that the table is in a SQL server, and the... 6 31.08.2006 21:34:02 Help! Update Records W/Dup Project # I have a form with a listbox that is used to select a specific project request number. Sometimes there are duplicate project request numbers (yes it needs to be that way). The project number is not the primary key in the table. I also have a button to save changes to the currently selected record. What I want to do is, once a user enters a project close date and clicks the save button, I... 1 31.08.2006 21:04:01 Random PO Number Generated with a Format Mask? Possible? I have been using an alpha-numeric PO system at work and have recently been asked to create a database to automate a great deal of our system. We are a small company(less than 100 employees, 1 inventory person, me!), and I am trying to learn Access as fast as possible. Is there anyway to randomly generate a PO with a format masked field? I have a form with a command button. I would like to cl... 10 31.08.2006 20:52:28 Printing VBA Code Does anyone know how to print (or save to file) all of the VBA code in a single Microsoft Access. I know I can print all code from each individual object, but with 105 forms and 75 reports plus all the modules, I figure there has to be an easier way! Thanks! Brian ... 3 31.08.2006 20:49:12 Cannot open any more databases I have a routine which cycles through records from a table and, for each record, temporarily opens a form which does some processing on that record. Then, it closes that form and repeats the whole procedure for the next record. So, the routine has a couple lines like this: DoCmd.OpenForm "frmUpdateCustomerHistory", , , "CustomerIDr='" & CustomerID & "'" DoCmd.Close acForm, "... 3 31.08.2006 20:48:01 Color Coding I have a cmdButton that goes out to a directory, looks for a .pdf file that matches a field in my database. If it finds it, it opens the file, if not it returns a msgbox saying no document found. Is there a way to change the color of the button so blue means there is a document in that directory before you push the button? Would this be a good way to ensure all documents are being sc... 2 31.08.2006 20:26:02 Bring form to front Using code how can I bring an open form in front of other forms? Thanks in advance.... 2 31.08.2006 20:25:33 reading values from multiple memo rows into textfield Hi, I've got a db where I've split users and notes. I did this so I can have large memo fields (more than 65000 characters). Now I would like to read (from a query (that works fine)) the values of all memo fields for that user and show them in a form text field. Is there also a limitation in the amount of text that a text field can display? And how can I read these values? I hope this exp... 2 31.08.2006 20:13:31 363 Pages: <<  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  >>