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  >>   Attaching files to database records. I've created a database for users to log bugs and other issues they come across while doing user testing. I want to add a function where they can add attachments as well: screenshots, pdfs, etc. I have no idea how to do this, either how to create a file upload object on the form, and if I can store these files in the same Access database (if so, how do I specify which table they go int... 1 20.09.2006 20:08:01 On Double Click Event - Open to add instead of edit I have a combo box set up. The pull down menu is a list that is tied to a table "Titles". I have the event "On Double Click" set up to open that form so the user can add a title if not already on the list. Currently it opens and the first Title of the form shows up (edit mode). I would like it to open to a new file. How would I do this? Do I add code to the "On Open" event of the Ti... 3 20.09.2006 19:49:02 Pass a variable from a form to a sheet? I have a variable on a form that I need to pass to a sheet for a query. It appears that I see the data on the selection (Treeview) and have set the variable to "Public", but when it passes to the sub routine that value is now empty? Confused? Any help is greatly appreciated. Thanks in advance ... 1 20.09.2006 19:46:39 two fields to make up a forgin key I have a many to many table with 2 fields that makes up the primary Key pkJobName pkCabType If I want to use this table as a parent table in a form does the sub table have to have two foagain keys? fkJobname fkCabType... 4 20.09.2006 19:17:11 filter query by current record for combo box I have a continuous form with a "productID" and a "type" combo box. The Product can have more than one "type" for this entries. The combo box source is a query with all types available today (the value types change a lot). The query has a "productID" and "types" fields. How can I filter the query (source of the combo box) by the current "productID" on my continuos form to show only th... 2 20.09.2006 18:43:46 No Records On Linked Form I have a form that has the following code: strFrmName = "FrmTNCHPProfileDemoP3" strSQLstmt = "SELECT DevelopDisabil_ID FROM Development_Disabilities_Master_Test " & _ "WHERE Tnchp_Profile_ID = " & intTnchpProfile_ID Me!LstDevelopDisabilID.RowSource = strSQLstmt intRecCnt = Me!LstDevelopDisabilID.ListCount If intRecCnt = 0 Then strLinkCriteria = "[D... 1 20.09.2006 18:36:01 Searching equals records I have two tables named PERSONAL and CUSTOMER PERSONAL table has fields : ID_PER, P_LASTNAME, (key = ID_PER) CUSTOMER table has fields : ID_CUS, C_LASTNAME, (key = ID_CUS) I need a process to review each LASTNAME in PERSONAL table and to search if there is a equal LASTNAME in CUSTOMER. How can I identify equals records and to save them in another table named EQUALS ? Thanks in advance... 5 20.09.2006 18:19:16 Determine if an unbound field is in a table I have a form where a user enters a date that is unbound. The form is bound to my table (Mill Production Data). The user enters the date each day with the necessary production data, including the date. Quite often the user enters the wrong date, that is a date that they have already entered information. I am trying to write code that will take the entered date (txtHeadDate) and check it a... 3 20.09.2006 17:27:18 Pop up form and return values help please Hi All, I have built a order entry form, and a have a button that pops up a 'search' form. I read through a bunch of other posts about how to return the selected value form the pop up, but I can't get it to work as suggested. I think it was a response from Dirk, and he said that you open the form in Dialog mode, then when the user selects the value you sent the visible property to false... 5 20.09.2006 17:22:16 Code in a Form I have a form with several fields in which the user will input data in some of them and then a querry will open with the criteria entered. Right now I have 3 fields (and eventually I want to have 20). When I test it, and enter data in one of the fields, the querry runs perfectly, but if I enter data in 2 of the fields, the querry doen't run. Any suggestions?... 7 20.09.2006 15:50:02 VBA code for import of Excel spredsheet Hi I am trying to make a bit of VBA code that will import a Excel spredheet, the user want a button that promt her for the spredsheet that she want to import. And after that imports the spredsheet in a table that are allready made i Acces. Can anyone help ?? Kind regards ... 3 20.09.2006 14:55:01 Show date in field when checkbox is checked Hi all, When a certain checkbox is checked, I would like to show a date (the date of chekking) in a textbox.. How can I do this? Arjan... 3 20.09.2006 13:33:18 Creating a SEARCH BUTTON I am having trouble knowing how to and where to start to make a SEARCH BUTTON. The search button the wizzard gives me is not what I need. I need to search either Query or Tables for a certian field on the form. The search field is: frm_txt_Return_Number ("AR"999999) - this field is bound. Do I need to use and an unbound field? What I need to be done after the search is to bring up all t... 5 20.09.2006 13:21:09 Stock Value Calculation I have the following code which gives me my stock quantity .... Function Onhand(itemCode As Variant, Optional vAsOfDate As Variant) As Long 'Purpose: Return the quantity-on-hand for a product. 'Arguments: vProductID = the product to report on. ' vAsOfDate = the date at which quantity is to be calculated. ' If missing, all transactions a... 1 20.09.2006 10:13:43 Sub form duplicate records entry Hi I have one main form in this only i am entering unique date, (primary key) in subform displaying the date as well as entrying some code that is selecting from combo box, actually my problem is that ,when i am selecting some code is reentering, how to stop this duplicate entries Help me in this regards Thanks ... 1 20.09.2006 09:47:22 Fixed widths in datasheet columns I want to define fixed widths in datasheet columns (Access 2003), how? Example: first two columns in datasheet must be fixed specific widths. Thanks!... 4 20.09.2006 07:11:01 Path Expression on Form Hello all: I have a Table which contains hyperlinks to Files stored over a network share. The table is Linked to the main Employee Table FileID (PK) Employee ID FileType hypFile The hypFile is the Hyperlink to the File (could be a Word Doc, or a BMP, or anything; but it is always linked to an Employee. I would like to set the Folder Hierarchy up in such a way that users will ... 4 20.09.2006 04:31:24 Email Code Hello, I am trying to figure out what is wrong with my code (see below). When I press the email button I get two New message from outlook. The first show the actual email message and then a second new message appearing, but is blank. What am I doing wrong. I should only get the e-mail with message displaying not a blank. Thank you in advance. Private Sub cmdEmail_Click() On Erro... 3 20.09.2006 03:58:22 Using a button to create semi-random numbers I have a database that tracks inventory. Sometimes we receive orders that have a number pre-assigned, and sometimes we don't. When the user goes to create a new entry in the system, I'm popping a msgbox that asks whether or not the new item needs a number. When the user selects "Yes" I want to generate a 10-digit # beginning with EX, for example "EX01234567", then automatically insert... 3 20.09.2006 03:47:01 Query Criteria I'm trying to set a criteria in a query. Its on a number field. Not Like 1 or 7 Not Like 1 or Not Like 7 Not Like 1;7 None of These work, any help appreciated. Thanks DS... 4 20.09.2006 02:43:39 Continous form Hi, I need to know how to make the form continuosly showing all the data. ( with or without coding).i've search info about how to do it, but don't really understand. i'm quite new in acccess.beside, i don't really see the difference made between bound and unbound field/form -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200609/1 ... 5 20.09.2006 02:32:56 Problem with Displaying Percentage when percentage is 100% I've got a text box on a form that has a calcuation in its control. It calculates the precentage, then displays it in the easy to read % format (e.g: .89 is 89 %, .02 is 2%, etc). I've having a hard time getting stuff to show and may be being unnecessarily complex. Here is the formula: I need to find the total % of Shoe sales of all sales items. There are only 3 sale items: ... 8 20.09.2006 01:40:42 data from one form to another. Hello Friends, I have an ADP project with two forms. On the Form1 i have 1 unbound combobox1 connected to a tableabc and a subform1. Based on the selection in the combobox, data is filtered in the subform1. This works fine. I want to incorporate a command button on this form1 which when clicked will open the second form2 and copy value from the combobox1 into form2's combobox2. Is th... 3 20.09.2006 00:27:26 Clear Button in a Form-Code I have created the Clear button in a form. On the ONCLICK properties field, I want to use the Code Builder option. Does anybody know the code to clear the fields in the form?... 6 19.09.2006 23:34:45 run a function in another database to modif that db from "current i have a database that auto archives data after 30 days. this will delete tables and redords that are associated and older than 30 days. i found help here http://www.microsoft.com/office/community/en-us/default.mspx?cat=&lang=&cr=&guid=&sloc=en-us&dg=microsoft.public.access.formscoding&tid=b2020b53-1e91-4451-b465-14b2ef0a5dac&rmid=8e7d9cf9-a74a-4353-a763-00d1eaca8124&helpful=-1&p=1&stgxml=... 10 19.09.2006 23:12:54 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  >>