Threads Replies Last Post 396 Pages: <<  13  14  15  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  >>   Advice about setting up form/subform/subform I would like some advice about examples or downloads that would enable me to create a database that manages references needed to be disclosed for a patent office. Basically, there are three types of references: A References: U.S. patent numbers, i.e., 1,234,567. B References: Foreign References, i.e. WO 062345 (this reference can contain different letters (depending on the country, a... 1 09.09.2006 21:53:01 Ooooops Sorry about the multiple post!...... Sorry about the multiple post..... I had problems and didn't know if my posting was successful!.... -- Eric Miller... 1 09.09.2006 19:46:01 Embedding and Display a Image Problem..... I work for this security company for a Mall and they use Access 2000 as there database on a sever and the Form enterface of Access to enter there daily incidents and stuff. They execute Access useing a desktop shortcut to the server. A few of there forms requirer photo's. Here is the problem: It's useing a Bound Object Frame with some properties set to Zoom, Embedded, Always, Content ... 1 09.09.2006 19:43:01 Embedding and Display a Image Problem..... I work for this security company for a Mall and they use Access 2000 as there database on a sever and the Form enterface of Access to enter there daily incidents and stuff. They execute Access useing a desktop shortcut to the server. A few of there forms requirer photo's. Here is the problem: It's useing a Bound Object Frame with some properties set to Zoom, Embedded, Always, Content ... 1 09.09.2006 19:42:01 Embedding and Display a Image Problem..... I work for this security company for a Mall and they use Access 2000 as there database on a sever and the Form enterface of Access to enter there daily incidents and stuff. They execute Access useing a desktop shortcut to the server. A few of there forms requirer photo's. Here is the problem: It's useing a Bound Object Frame with some properties set to Zoom, Embedded, Always, Content ... 1 09.09.2006 19:41:02 Embedding and Display a Image Problem..... I work for this security company for a Mall and they use Access 2000 as there database on a sever and the Form enterface of Access to enter there daily incidents and stuff. They execute Access useing a desktop shortcut to the server. A few of there forms requirer photo's. Here is the problem: It's useing a Bound Object Frame with some properties set to Zoom, Embedded, Always, Content ... 1 09.09.2006 19:41:01 Calling Control Info from Table Not sure I have the title right here, but here goes Thanks to an earlier post I now have my Form with many buttons beautifully coloured etc. However as I update the information the data on screen becomes dated ... I have toyed with the idea of storing information about Control Objects in a table alongside the SQL that provides the value and have written a small if loop to attempt to marsh... 2 09.09.2006 19:27:01 populate drop box with time I am trying to populate a drop box with time in increments of 15 min. However, I want to be able to block (or delete) that time if it has already been assigned to a worker on an assigned day. ie: Worker A tries to sign in on 5/2/06 at 7:15. If there is already an appointment for 7:15, I want that time to NOT be a drop box option. As I am new to this, I will need in depth direction. Wil... 1 09.09.2006 19:24:01 Using Multiselect List Box Values in a Query Is it possible to use the values selected in a Multiselect list box to limit the results in a query (much like using a single value in a combo box or standard list box)? ... 2 09.09.2006 18:28:31 Ms Access HElp Reposted Allen, Thank you for you help I have managed to get it up and working!! Can I ask you another questiong re your AppInventory? I was to create a report based on the stock tootals created what is the best way of doing this as the code which you provide requires for you to enter the prouct code in order to get a total. Any advice is much appreciated! Thanks again "Allen Browne" &l... 1 09.09.2006 16:27:23 Toolbar comand Hello. I have a button in a form which prints the record in use by clicking on it. I wrote some code to do that. However, I would like to replace that button by one comand in a toolbar attached to that form. Can anybody tell me how can I do that? Thank you in advance. Regards. Acores... 4 09.09.2006 13:40:11 Why do I get the Total price saying #Name? afte the calculation? Please somebody help me. Whatever when I trying to put a calculated control in a text box in a form design view , I get #Name appear in my sum total box in the form view. Did anybody experienced this. I thought I was doing exactly the way the instruction says. Thank you -- Pepe... 9 09.09.2006 12:58:01 Insert Object Problem I am having two problems when using insert object. First I am trying to insert a Excel Spreadsheet that has math formulas build in to it. I created a blank form and in design view selected Insert Object, then selected Create from File, then I selected my spreadsheet, when everything is done I end up with a photo image of my spreadsheet, none of the cells can be clicked on. Next I am... 1 09.09.2006 12:36:01 PREVIOUS RECORD VALUE HELLO PLEASE CAN SOMEBODY HELP ME OUT ON THIS PROBLEM I AM WRITING AND ACOUNTING DATABASE AND I NEED TO GET THE PREVIOUS RECORD FIELD (WHICH IS SUM( "A" FIELD + "B" FIELD) E.G DATE FIELD A FIELD B TOTAL (FIELD A + FIELD B) 9/1/2006 100.00 100.00 200.00 NOW I NEED IN QUERY LIKE THIS DATE OPBALA NCE FIELDA FIELDB TOTAL 9/2... 4 09.09.2006 11:35:02 Calling a field from another subform Onclick event - copies data from one field on one from into another field on a different form. Main Form - Potential Two subforms in Main Form (using tab control) Subform 1 - FinanceInfoSubForm Subform 2 - ServicesInfoSubForm The button is in FinanceInfoSubForm. When I click it, it takes data from a field in ServicesINfoSubForm called (control source) - CancellationFee. When you cli... 4 09.09.2006 10:54:01 Assigning an On Click event to a label Is it possible to assign an On Click event to a label on a subform which will allow you to sort the records displayed? For example, the label for the date field on a subform: click on it the first time and records are sorted ascending. Click on it a second time, and records sort in descending.... 4 09.09.2006 03:46:55 Select AS query problem I have a table that I want to query on. In this table for some reason, the original designer used separate fields for Month/Day/Year. So one field for Month, another for Day, and another for Year. The form I created has two calendars on it. The calendars allow the user to select two dates and search for data between those dates. I created a workaround but I'd like to not have to use a wo... 4 08.09.2006 22:44:48 Adding a find feature to a form I am building a form for data entry into a table with about 4000 names. I know the user can use the ctrl + F to search, but can't I just add either a field or button to do a find that will populate the fields on my form so the person can enter new data or edit existing data. Thanks for any help Billa... 5 08.09.2006 22:41:03 Pass Filter from subform back to main form...? Hello, A little background: Working off the premise of the Issues Database or Classroom management database dled from ms. Both templates have a view reports form that allows a user to double click on the name of a report and that reports open up by somehow passing the name to the openreport cmd. In my current db, I have made a lot of query filters to be used in the main form. Is t... 1 08.09.2006 22:35:02 Can Not Select Option on First Attempt I did not get any response to a similar posting last night so I am trying to state my problem more clearly. I have several Option Groups on a Form. One Option Group has 3 Option Buttons with no defaults. The first time I click a button, the first option button "On Got Focus" event for the first button is triggered no matter which button is selected. After that first click, the select... 2 08.09.2006 20:31:43 like a tooltip but with variable info on MouseOver Does anyone know if there's a way to get a value to pop up like a tooltip when you mouse over a field? I want the contact's phone number to pop-up in a tooltip fashion when you mouse over the ComboBox with their name in it. I've got a ton of info on a screen & it's way too busy to put everybody's # on there. I'm learning VB the hard way - through cut & paste, so please spell it all ou... 3 08.09.2006 20:11:02 Form loading slowly Hi, I am an MS Access newbie. I have a form with two subforms. Main form and subform both quries the SQL db though ODBC link. When I run main form and subforms independently, they are very fast but as soon as I put them together in a single form (main form + subforms), it takes 3-4 seconds to load. There are not any complex calculation involved. Is there anyway I make this load fast or at... 2 08.09.2006 20:06:40 rounding I have a form with a command button which does the following: [bprice] = [rprice] * 0.77 [rprice] is $12.50 and when you do the above, [bprice] is 9.625 It works fine. When you view the field it shows 9.63 but when you click into the field, it expands to 9.625. How can I have the actual value be 9.63? What is going on here? I guess rounding. Thanks.... 2 08.09.2006 19:29:02 RTF2 control: RTFheight hides cursor Hello, when I use RTFheight in the Change-Event, the cursor disappears. It is still there, but invisible. How can I get my cursor back? Michael Bruschkewitz ... 4 08.09.2006 19:21:37 Info entered in form goes to table, but not saved in form Ok..so I was on yesterday, and I received some gracious assistance, and after really working on it, I can't figure it out still. Basically, I am not able to enter info into my form and have it save in the form. The info goes to the table, but it doesn't create a new record in the form. Any ideas? All of my editing settings are on "yes." Why does the info go into the table, but not viewed ... 6 08.09.2006 18:37:01 396 Pages: <<  13  14  15  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  >>