Threads Replies Last Post 396 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  >>   Product already selected in Current Record Hi; Need code in "Before Update" that would warn a user that a product has already been selected in the current record. Have read other post replies concerning this issue, and although they seem to work for others the answers I have found are not working in this database. Have Tables: tblCustomer MainTblID (AutoNumber) tblProductBought ProductID (AutoNumber) & MainTblID (Number) &... 2 01.10.2006 02:53:01 Calculated Default Value I'm making an estimate sheet and want to create a default value that is based on other form/table values. I know I should just do a query calc and not store the total but I can't trust the salespeople to do the math properly and ultimately we have to stick by the price so I have to store 3 values. The math is simple: HorzFt x HorzPrice = HorzTot when I tab/click over to the HorzTot fie... 2 01.10.2006 02:25:04 Macro ignores missing data Hello, I'm a relative novice when it comes to access, so I appreciate any help you can provide. I've set up a number of forms each linked to an individual table of course. These tables have a number of fields were a value is required. I've also placed a command button at the end of each form that runs a macro. The macro opens the next form in line and closes the form that was just f... 2 01.10.2006 02:19:41 Conversion Form into DAP Hi: Is there a way in latest Access 2003 to do conversion from Form/Reports to DAP(of course with some manual untervention in HTML file) or may be some third party wizards or use only Visual Studio? I have to move existing Access 2000 Applications into Web and would appreciate your help to cut vaisting time. Thanks in advance. -- Ilya... 2 01.10.2006 00:45:56 Date Calculation and Notification I have fields called InitialAssessmentDate and ReviewDate. I want to be able to have a bold coloured label appear on the front page of a client record informing a user (when they access a clients record) when the client is due a review - usually three months after the Initial Assessment Date/and/or three months after the Review Date. So far I have a couple of bold coloured labels that a... 1 30.09.2006 22:49:01 case select statements? someone has suggested I use case select statments to achieve my aim of bringing up a message when one or more conditions are met when a user arrives at a clients record. Some clients are high risk (in terms of personal safety) and I have managed to get a message to pop up for that event. I also need to be able to advise users by means of a message if the client needs a interpereter or ... 6 30.09.2006 22:05:24 deleting part of the data Hi All I am looking for some ideas how to do this. I have a form based on a query that shows customer and Plot. There is a relationship between the Customer and Plot so that the plot is selected from the customer table. In the Query view I can delete the Plot ID so tha the customer has no plot, however, I need to be able to remove the Plot but keep the customer hopefully with code. ... 3 30.09.2006 20:27:26 Validation on a form using properties I have a box on a form that I am trying to validate the length of based on a field in another form. I have tried using vb code but I get a type match error or can not find the form if using the logic below. I do not think that I have the right process in the code as I am new to this. Code I have used in the beforeupdate is below: Private Sub key2_BeforeUpdate(Cancel As Integer) Length... 2 30.09.2006 18:53:37 Keeping Form Maximized From a maximized form, a button opens a 2nd form which is maximized in its OnOpen event. When it is closed, the first form is no longer maximized, with the database window visible beneath. Adding a DoCmd.Maximize works in the OnActivate event procedure, however, the DB window is still briefly visible. Can anyone tell me how to return to the maximized form? Thank you. Sprinks ... 2 30.09.2006 18:35:18 Partial payment on event database i downloaded the event database, but if a person wants to registure and pay for more than one person how do you do that? Also, if a person wants to make part of a payment how do you do that?... 4 30.09.2006 18:03:53 new record in subform i have a main form with several sub forms located in it, built in access 2003 on my main form is a cmd button which makes sub form 1 visible and hides all the other sub forms. sub form 1 is connected to a table. on sub form 1 is a cmd button for inseting a new record. all works fine im trying to get the cmd button on the main form to insert a new record once the form is visible. my co... 2 30.09.2006 14:45:52 Resizing forms What is the best way to fit more data per page on an access report? I have tried to resize it, and there's more than enough room on the page as the data gets smaller and smaller, yet the same mount of rows show. Is there another way to do this aside from the typical manual resizing in design view that I have been doing? Thanks -Jimmy ... 2 30.09.2006 14:12:39 Global variable Hello. In my Access database, the user is asked to select a folder which path defines a Global variable (c:\\whatever\). And everything is working fine. However, when the user quit the application and reopen it again, he must select the path all over again. Is this the only way? Is possible that Access could storage the last Global variable defined in previous sessions? Thank you.... 4 30.09.2006 10:48:40 Refresh or requery. Where, please? Hi! I have a form based in T_Ocorr. In this form there are a cboOcorr. When I click in cboOcorr row, open another form, based in query with a condition to show us only records with condition choosed in that combo. I would like to refresh (or requery) data in second form when we choose another option in combo but, now, only change data if we close and "re-open" de second form. I would lik... 3 30.09.2006 10:33:02 email pdf document Hi, Some time back, I entered a question asking if it was possible to be in Access, click on a command button, store a created pdf document in a "temp" file so that I might also be able to include, with code, the Access documents that I need to send with this file. I had to pull away from this project, but now am ready to tackle it again. Here is the code that was sent: Dim strFil... 14 30.09.2006 10:27:35 Copy comments In my form I have comments memo box and next to that box I have command button. When you click on button it should copy data from comments box and paste to MS Word to check spelling. Then it should copy after checking spelling and past to same comments box. Or if anybody knows different way to check spelling in my comments field??? Thank you.... 2 30.09.2006 06:01:38 Read only mode disables combo box I have a form and a subform that I want to be able to open in 3 modes: review existing data without editing, enter new data, edit existing data. I can use openform from a Switchboard and this works well for the “enter new data” and “edit existing data modes”. I am having trouble with the “review existing data without editing” mode, however. The main form uses two combo box... 2 30.09.2006 05:46:08 Some Built in function stop working In existing database that was working now some of the built in function stoped working and i get an undefined function error. in a new test database they work. the functions not working are; date() Left(expression,number) Rightexpression,number) When i call the db from different computers the same thing happens Help Al ... 3 30.09.2006 03:29:40 Round function Hi Dont know exactly how to explain. I have a field name cost, currency 4 digits afler dot. The second field is setup to Round cost 2 digits after dot. The problem is If my cost is like : 1.0050 when I round (cost;2) it give me the result of 1.00 It did not recongnise the 5 and then not give me 1.01 I tought to add in my procedure a variable call priceok If right (2)[cost] = 5 ... 2 30.09.2006 03:11:49 Form: Spelling check I have in my form comments column the data type is 'Memo'. Is it any way I can check spelling in my form for only one comment field? Thank you... 2 30.09.2006 02:22:32 field does not always display my information. I have a database developed for tracking control results, for each test we perform in our lab. This also tracks control lot number, expiration date, target mean and STD Dev. Plus much more. This part all works fine. I have a form, that I have an issue with. This displays the control results alone with other information we enter. I have a field in this form that shows arrows, up when grea... 3 30.09.2006 02:01:02 Store data from form in table associated with subform I have a subform linked to a form. I know how to copy the data from the main form onto the subform... =[Forms]![FormName]![FieldName] but how can I store this data in the table associated with my subform? I need this information for reference on the subform table to keep the relationship between tables, but don't want users to have to re-type this information each time they use the subf... 2 30.09.2006 00:38:02 automatically recording date In my form, I want to be able to have the date automatically entered for a record, after a change or modification is made to an existing record.... 6 29.09.2006 22:01:33 Find record in my form In my combo box I have 'Name' data field, in the 'Name' column I have First, Middle and Last name. When I select name from drop down list every thing works fine and also if I type first 2 letters it will find my record base on the firs word, but what I need is to able to also filtering second, third words from the same row. For example I have three records in my form 1 John Smith Mic... 2 29.09.2006 21:58:38 Make an OLE Object Read-Only and Undo any user changes programmatically. I am embedding an OLE object (it may be Word or Excel, I won't know) in a field using a Bound Object Frame. Since I won't know the size of the object, I've chosen to display the icon for the application on the form. I want the user to be able to double-click and launch the original application in a new window to view the object. However, I don't want them to be able to update it once the r... 1 29.09.2006 21:08:57 396 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  >>