Threads Replies Last Post 153 Pages: <<  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  46  >>   Placing a Sum in a main form, from another form. I am a new user to Access, and am surprised at how much difficulty I'm having getting a simple sum function to work. I must be missing something very simple. I have a main form called "Project Data". I want to include the total sqaure footage listed in a table called "Square Footage Table" on this form. I created another form called "Square Footage Table1" which contained the field [T... 7 18.07.2006 04:28:01 Design of relations Dear Newsgroup, I'm did not much Access programming or design until now. I'm trying to figure out a good database design for the following problem. Any advice would be highly appreciated since I simply can't figure out. Maybe I'm overseeing something really simple. I would like to design an employee database. Each employee is a driver. Each driver has a license to drive cars, heavy trucks or... 3 17.07.2006 23:08:01 THE Option Button in the toolbox How i can use it? Hi, I want to Know if there is a code to verify is an option button is selected?? i thank any one can help me ... 3 17.07.2006 23:06:12 Limiting entries in a data sheet of a form. Hello, Just have a question. My main form has textbox: name is Condition. Prefilled by clicking on combo box. Basically, if the condition is GPM, then user can only enter two entries in a subform (Orientation form). But if the condition is DBT, then user can entry up to six entries in the subform (Orientation form). I don't know what property of the form(me.etc) to use restrict reco... 4 17.07.2006 21:20:10 Temp table to solve bloat issue I got a problem that I'm hoping some fresh minds can help me out here. First some background: I have a table in an Access database which I need to update with new information - call the table "Raw". Said new information comes in the form of an Excel spreadsheet. The gotcha with the spreadsheet is that there is a very good chance that there can be information within the spreadsheet that is ... 3 17.07.2006 18:24:36 Limiting entries in a data sheet of a seperate form(continued). Thanks so much Duane. Unforunately, the subform is not functioning in access 2003 on my computer, since not installed. Another question, Say in the main form(clients form), textbox(condition field) displays GPM or DBT. Instead of subform, user clicks a command button to go to the orientation form. This orientation form displays a set amount of records based on the condition field. ... 1 17.07.2006 18:17:11 Help w/ Building Database Hello, I am fairly new to access; and I need an easy way to keep track of a couple things. I was thinking of doing it in excel, but it would be more complicated in excel I was told. So, here I am in access. This is what i need; I had explained it better in excel but here goes: I need to track salesman information. But only certain salesman; and by state. So someone would enter... 2 17.07.2006 18:14:03 ComboBox Issue Hello All, I am extremely new to access. I have set up two tables that I need with the information in them and I set up a relationship that allows me to link invoices with the corresponding contract/vendor number. What I have been trying to do is have a combo box show all possible contract/vendor numbers for the user to choose and then enter in all the information about invoice that... 1 17.07.2006 17:34:01 Submit Button for a Form? I need to create a submit button that will move a text string from a text box on a form and enter it into a query statement. I am learning Microsoft Access. I have created a query where the user must enter a text string to pull information out of a table. Currently this is set up with this statement… Like '*' & [Text String Goes Here] & '*' I would now like to take this to the n... 5 17.07.2006 17:17:02 file review dbase I am trying to create a dbase for employee file reviews. On paper each review, lists: the employee, manager, district, file #, date of incident, customer name and 25 yes/no questions. How would I go about creating a proper table structure for this dbase? Each employee will have an almost infinite number of files reviewed. The same goes for the manager reviewing the files. The purpose for... 2 17.07.2006 12:17:43 Command Button wizard not working in design view I'm trying to create a new report in Design View. I want to assign a command buttom for the report. When I place the command button on the form, and the wizard does not start up to assign a command to it. i've gone through all the online help. Try to install the Jet 4.0 update, run the install and it's telling me it's already install on my system. Running Access 2003 Maynard... 6 17.07.2006 10:38:01 Global Function I an very new to writing Access code so my appologies for what may seem to be a very basic quetion. I have an access Database with a number of "Modules called form a Menu Form. Each of these modules contains Sub's and Functions. However, I need to check a String piece of data that is scanned in from a Barcode Reader to see if the data is acceptable or not. This is done by calling a Func... 6 17.07.2006 07:39:02 Migration tool Access 2003->2000/SQL Express I am looking for a utility that would allow migrating a 2003 BE db back to 2000 format for editing. (The db acts as a table web container.) I don't want to upgrade at present: Office 2K serves me quite well! The db only contains data, no stored procedures. Question: Is there a tool on the market to do the migration? Alternatively, is there a utility out there that supports migrating a 20... 2 17.07.2006 03:49:38 How to contact an MS Access MVp Hi I understand that through MicroSoft Online, there are MS Access MVP who are available to answer specific questions regarding access.Can someone tell me how to avail myself of this service? Haven't been able to see how to do this through the MS website. Thanks for your help. Grog ... 4 17.07.2006 03:39:20 Why does the last picture added always show in all records? Going slowly with OLE objects, I have linked pictures in two records. When I set up the first picture, it appeared in the Form displey for all records in the database. When I linked in the second picture, it now appears in all records. What have I missed?... 4 17.07.2006 03:32:45 Is there a ZOOM feature anywhere in Access 2007 Beta??? I'm a new user of Office 2007 Beta with a significant vision problem. I have figured out how to use ZOOM to increase the view of my documents in Word and Excel...but the same in Access has eluded me. So far I have had to resort to increasing the print font in order to see what I'm trying to work on, however, that means I need to reset that every time I need to print or the resulting mes... 4 17.07.2006 02:26:55 In Access create a command button to replace a keystroke sequece In Access I would like to create a Command button to function equivalently to the following keystroke sequence: Ctrl ' This command button would be added to a form to recall the last value in the previous record for a specific field. Clicking the command button would replace manually typing the two keyboard keys "Ctrl" and the "Aprstrophe" keys.... 2 16.07.2006 15:02:47 how to increase the font size in access 2003 ... 2 15.07.2006 18:16:17 update some values in one table from another table Hi, I hope some one can help me, I have two tables containing stock information I need to update the information in one table from the other, but the tables contain some different products; Table1 just contains a product reference and quantity for about 2000 products; Table2 contains about 20 fields of data for about 500 products including product reference and quantity for each. M... 5 15.07.2006 07:15:02 cross reference 2 tables access I have a project to take 2 tables in access and cross reference them manually. I figured let the computer do the work for me. I need to have access create a 3 table with duplicate employee names to show with their department names in subsequent fields. IE Names in field 1 Department names from table 1 in field 2 and Department names from table 2 in field 3. Then after that is all sai... 2 14.07.2006 23:47:18 How can I get a calculated value from my form into a field in the I have created several calculated values in a subform and I was able to total these on the main form. Now I want to move these totals from the main form into a field in the database before I enter another record. Can anyone help me?... 3 14.07.2006 20:01:01 Run Time Error 3314 I have a table HYInReg in which the field "RegisterNumber" is set as Text and is required and uses the following code:- Private Sub RegisterNumber_Click() If Me.NewRecord Then Dim strWhere As String Dim varResult As Variant strWhere = "RegisterNumber Like """ & Format(Date, "yy") & "*""" varResult = DMax("RegisterNumber", "HYInReg", str... 2 14.07.2006 19:56:02 Windows in Taskbar not performing in deployed run time program My deployed runtime Access 2003 does not show multiple open forms/reports in the taskbar even though I checked it in the options menu in the Access MDE file before I created the runtime program. How do I fix this? -- Juana... 3 14.07.2006 19:52:51 Logon doesn't appear when running under Access Runtime 2003 We have packaged an Access file to run via Access 2003 runtime, using the Package Wizard. We used to use an MDA file to control permissions within the database, but have since changed to an MDW file. The resulting exe file runs normally on a computer with Access 2003 installed, but when I run it on a computer using the Access 2003 runtime and office 97 installed, the Logon dialog box d... 2 14.07.2006 18:24:48 What does "search key was not found in any record" mean? ... 2 14.07.2006 17:38:01 153 Pages: <<  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  46  >>