Threads Replies Last Post 901 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  >>   update feild based on combo box value Hi, i have a newbie question. How would i update a feild based on the slection of a combo box ? I have a "status" combo box that represents the status of work. there are 3 diffrent steps, and i want to record the dates of when the "status" combo box is udpated with a partiuclar value, or step. For exmaple a new record is created and the the "status" combobox reading "step 1" when the f... 2 27.09.2006 00:37:31 Automate Linking Table Manager I have a database for multiple users that has the Allow Full Menus, Display Database Window, and Allow Toolbar/Menu Changes unchecked. When I install a new front-end, I always have to go in using the passaroud key so I can see the regular toolbar so I can run the Linking Table Manager. I've added this feature to a Maintenance Bar that comes up only for specific people when they click o... 5 27.09.2006 00:35:45 Summing a calculated field and evaluating it before report is shown? I know that you cannot sum a calculated field in a query, and you can do so on a report, but can you evaluate the report field to decide which records are included? I have a field that is counted in a query and it needs to be evaluated at before the report is created. Only the records belonging to a person with over a certain number of violations need to be shown. However with my report I ... 2 27.09.2006 00:28:35 Compile error? Help! I'm stumbling my way around trying to automate email from a database. I cribbed the code below from an example DB I downloaded. The code works perfectly in the original DB but the exact same code gives me a Compile error 'User-defined type not defined' ? The debugger highlights the following line: appOutLook As Outlook.Application The whole code is: Private Sub cboOpenOutlook_Cl... 2 27.09.2006 00:06:42 lock mouse scroll How do I lock the mouse scroller so it doesn't change record on the Form. -- Thank you for your help... 11 27.09.2006 00:03:48 New Record not pulling through? I have a form (frmMain) for the adding of new records, which also contains a button which lauches a form based on a query. The query looks at the 'EnquiryID' field on the frmMain & pulls related other fields from that record into an email template. However, if a new record has just been added to the form & the query/form lanched straightaway with the command button, that 'new' record i... 2 26.09.2006 23:59:45 Select only the last 10 occurance in a query of each Component No In a query I need to show only the last 10 of each component No in a selected field. The field has different component No: Components have occurrences from 1 upwards. I only want to see the last 10 of each component No in the field (or less where less jobs have been made) There is another date field in the table, and the table is grouped by component No the sorted by date so I just need the... 2 26.09.2006 23:33:01 transferring a check box from form to report I have several check boxes set up in a form and now I am trying to create a report. On the report I have some of the same check boxes but I want them to fill in automatically if they were checked on the form. How do I tell the report to do this? ... 4 26.09.2006 23:27:09 Upgrading money 2006 small business to 2007 I am now using MS money 2006 small business paid and downloaded purchased Microsoft Money 2007 Premium. I get a message when trying to open stating that i have downloaded ms money home this is not a business edition. Now how and where do i get the relevant upgrade. This the e mail i got from support Dear Anjan Malapaka, Our records show that you have purchased Microsoft Money 2007 Premi... 2 26.09.2006 23:15:47 File Moving Using Access Hello All, I have a question about moving files from one folder to another using MS Access. Here is the Scenario: Our company has a database that is tracking tests run by several departments. Test requestors are required to place a test writeup file (ms Word Doc) in a folder on the network drive called " Submit Tests Here". The database, when opened, looks in this folder and puts ... 3 26.09.2006 22:58:00 Version updates I have a customer who uses a .mdb database I wrote. How should I structure my project so that (code and structure) updates can take place without changing my client's data? TIA -- AP ... 5 26.09.2006 22:47:11 Access Is there a way to retrieve a file that has been saved over? Some changes were made and accidently saved. -- Linda... 2 26.09.2006 22:43:23 Converting from Access 97 to 2k3 Hello, I have looked up and down the forum but I can't find a thread that helps me. My company have hundreds of DB created on Access 97, but guess what they just desided to upgrade to 2k3. Ok, the easy way to go and do it is opening one by one all the databases but in reality that is not an option to me. So I was searching for tools to do this convertion, will doing my search I found ... 18 26.09.2006 21:21:02 Option Compare Database Hi, On looking up the help for Option Compare Database in access, it says that : Option Compare Database can only be used within Microsoft Access. This results in string comparisons based on the sort order determined by the locale ID of the database where the string comparisons occur. I dont understand what does "the sort order determined by the locale ID of the database where the str... 3 26.09.2006 21:20:11 Numbered Text appearing in Scientific Notation I tried importing an excel file. One of the fields is a product number (alphanumeric) which can be all numbers or combination of letters and numbers. I've defined it in Excel as text and made sure that all the data are in text. However, I still keep getting this 4.00000e+06 when it should be 4000000; I specified this field to be text. I've even tried appending to another table with t... 1 26.09.2006 21:18:02 Making many rows in one table out of one row from another table I have one table that has a quantity value in it. I need this quantity to have its own row in another table that is autonumbered. If the quantity was 5 I would need 5 rows with a few columns of data pulled into the other table. How can I make access autogenerate x amount of rows in another table? ... 4 26.09.2006 21:14:20 how do I populate another field by selecting data in a combi box I have a form with a subform attached. In the sub form I have:- Product Info (combi Box), Unit/Metres Price (Text Box), Qty Used (Text box) and Total (Text Box, with calculation). Product Info and Unit/Metres Price are also used and populated in another Table. I can select data in the Product Info field using the Combi Box, but I cant figure out how to automatically input the Unit/Met... 2 26.09.2006 21:04:09 stats page I have set up avery simple database (instrumental pupil list - includes what instrument they play , when they started etc..) Can I create a page that will return general stats? like how many kids in the database / how many at each school. A query returning say, each instrument is easy - but just the numbers seems harder! John UK ... 6 26.09.2006 20:59:28 Known issues with replication? Are there any known issues with the replication of Access databases? Our netadmin group has implemented dfsshares and is replicating our Access dbs. They tell me they have pointed all the users to a single site for accessing the db, and the replication is for backups. ... 8 26.09.2006 20:59:23 Inbed data into the message of an email I have a form with a text box that uses visual basic to create a new email message. Is it possible to extract information from a query and a table and have it appear in the message section of the email in text format that can then be editied. I realise I could attach a report but I want to avoid attachments as the data is relatively short. Any ideas? I am using Access 2003 and as eve... 3 26.09.2006 20:54:02 Bad character in a database field - finding and eliminating Hi, I have a table with a character showing up occasionally in one of the fields. It shows in the table view as a little square (tab maybe?). I'd like to be able to find it and delete from each record in my table. By the way, the field is an Address field. For example: 7083 Hollywood Boulevard Sixth Floor ((interesting that after copying it it pasted the field just like above... 2 26.09.2006 20:52:19 Type mismatch When I tried to run this code, the message "Type mismatch" came up. I have been unable to figure out to problem. If anyone has any ideas, I'd appretiate it. Option Compare Database Option Explicit Dim strSymbol As String Dim intRef As Integer Dim strSQL As String Dim dteLineDate As Date Dim rst As Recordset Private Sub CopyData() On Error GoTo Err_CopyData strSymbol = InputBo... 2 26.09.2006 20:34:31 Change button caption on click... I need small help.. I have cmdButton with caption like 'Hide form' so when user clicks on the button it hides the subform and button becomes sunken... I want to change the caption to 'display form'.. and when he clicks on 'display form' the caption would become 'hide form' and form would appear. I got form part hiding - diaplying just don't know how to change the caption. any hints or ... 5 26.09.2006 20:26:21 Access 2000 and SQL Server 2005? We currently are using mostly Access 2000 as our frontend to our SQL 2000 servers via .adp's and are looking to go to SQL 2005 but want to wait until Access 2007 to upgrade our Access. I was able to change the Access 2000 .adp connection to an sql 2005 database but can't go into design view of tables or views and sp's all have ;1 after the name and when try to open them, it says can't f... 2 26.09.2006 20:26:01 Form Header I created a form in design view and added a page and form header and page header. I can view the headers in design view but when I go into form view the headers are not showing. I go back in design view and they are there. The headers on the view menu are checked. Could anyone tell me what the problem is? I am using Access 2003. Thanks in advance for any help. Best regards, Dee... 4 26.09.2006 20:21:46 901 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  >>