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  >>   How do you handle name changes? In theory a person can have one or more names, surnames in marriage for example, and properly normalized there would be another table for this. But it's not real common. Do you go ahead with the second table, or do you stick the previous name(s) in a comment field?... 2 27.09.2006 21:41:46 Subform/Combo box Greetings gurus. Windows xp, access 97 I am having trouble with a combo box updating a subform. It doesn't make sense to me, because I have numerous forms set up this way and they work fine. I'm missing something. This is what I have: Main Form = frmOrderEntry Form Control Source = tblOrders Combo Box on Main Form = cmbShipperID Combo Box Row Source = tblShipper Combo Box Control Sourc... 7 27.09.2006 21:36:50 Requery sub-form from popup Hi all I strange question I know but….I have a main form with a number of tabs controls FrmMain TabOne - TabTwo - TabThree - Etc The main has a button that opens a popup with a number of controls. (one combo and a number text boxes) - Combo1 - Txt1 -Txt2 - Etc Is it possible to requery TabOne afterUpdate of Combo1 (on the popup) - so neither the main form or the tabs have focus... 2 27.09.2006 20:58:02 Creating a hyperlink to a specific page in a .pdf document in Acce I am using adobe 6.0 with windows explorer 6.0 and MS Access 2003. I am currently trying to create a hyperlink from a MS Access Text Field to a ..pdf document and a specific page. I have already tried using the hyperlink: O:\ACPO\Tracking_Database\Recommendation_Reference_Materials\DAPA_Report.pdf#page=19 ... 1 27.09.2006 20:56:02 Date format different in Access linked table than in sql I have a linked table that in SQL has a field with date format with 8 characters. The data appears as "4/11/2005". In access the same data appears as "2005-04-11 00:00:00.000". I cannot change this in my form regardless of using short or any other date format. I would like the dates to appear as mm/dd/yy. Why is this happening and how can I resolve it? Thank you.... 1 27.09.2006 20:07:02 ALL CAPS AGAIN Hi, You have all been very helpful and I really appreciate it. I learned alot today. THis is what fanally did the trick in the Update Query: UPDATE [MyTable] SET [MyTable]!MyField = StrConv([MyTable]!MyField,3); There is one more thing though. I have one field for the address that has numbers and letters. It doesn't seem to want to work. Any ideas??... 5 27.09.2006 20:04:12 How do I DLookup values matching dates in a table and form? ... 2 27.09.2006 19:38:09 First x entries of a query & copy or "append" those entries into a One of the databases I'm working with is a mailing list of 200,000 people. Right now only the people in the office that know access can effectively use the database. I'm trying to make a user form that 1) Runs our update query as soon as it's loaded 2) Has a textbox so the user can just but in the number of mailings they need for that time. (i.e. I already have the query to get the table,... 6 27.09.2006 19:31:23 DMIN In a query This is what I am looking for: I have a query that is built like this Month1 Month2 Month3 Month4 Month5 Month6 MinMonth 1 4 5 8 10 12 DMIN In a new column I want to find the minimum of the months. How would I build this in a query?... 5 27.09.2006 19:30:02 Access ADP with Images stored within SQL 2005 Does anyone have any code/suggestions/techniques/links for displaying images stored within a SQL 2005 database on forms or report and also how to get images into the database? I know a lot of people like to store just the path to the image in a file directory but I recently came into some new information about SQL 2005 at a Learning Tree class and it has excellent ability to handle large dat... 2 27.09.2006 19:23:51 Help with an account balancing database I have a database which I've built to store invoice data for customer invoices that could not be applied to the books for various reasons (i.e., the account was already closed, the vendor overpaid, etc.), and now I'm working on an account balancing for this database to tell me which invoices have been cleared off from this particular holding account (i.e., the closed account was transfer... 5 27.09.2006 18:34:02 Unable to enter data onto a query or form I am trying to add a field to a query from a table. There are approx 63 fields. When I try to enter the new field, I am then unable to enter information to the query or the form. The "Totals" field in the query all turn to "Expression" from "Group By". I have rebuilt the query, but the same thing happened. I am still able to enter the information to the Table--just not the query or ... 5 27.09.2006 18:29:02 periodically renumbering records after appending new records I have a large database (>100,000 records) of individual webpage views for on 100 different PCs on a network. The records include pageID, PC ID and a time/date stamp. The records are sorted first by PC ID then time/date. I need each record to be numbered sequentially. Though I managed to do this on the first set of records, when I append the database with a new month of records then re-s... 1 27.09.2006 18:22:14 ALL CAPS to PROPER Hi, I have inherited an access table in which all of the entries (270,000 of them) have been made in all caps. I need to convert the table to "proper" so that the first letter is capitalized and the remainder is lower case. Can I just update the field somehow?? Thanks... 14 27.09.2006 18:22:13 Employees - Still can't figure it out thanks for the help on my question on how to get the employee name to automatically come up after loging in using the statement that you ave me below: EmployeeName = CurrentUser() using the builtin function? Where do I put this, in the table or form and what heading do i put it under. I tried to put it in the table under the default value but it keeps giving me error messages The ... 2 27.09.2006 18:06:48 Help Needed Hello all, I am hitting a brick wall with this problem. I have 3 tables. Table 1 contains last name as primary key along with fields of skill level,mastery level and other fields. Table 2 contains last name as primary key along with memo fields. Table 3 contains performance standards along with fields of skill level,mastery level and other quality percentages. These are used in a quer... 2 27.09.2006 18:05:10 Help with update Query hi, I have two tables, same heading. I need to update the records in one depending the values on the other.I have an unique ID. I can´t work it out. Thanks ... 5 27.09.2006 17:59:03 How to create an input mask for e-mails Hi. I want to create an input mask for e-mails in order to force people to insert the @ and the . (dot). Any one can help me? Marco Silva.... 5 27.09.2006 17:57:57 How can I manage 2.0 GB mdb without problems? We make a db in Access but since the db increase the size almost a 2.0 gb is down, so we need to compact db every 3 days, there is a patch in order to Access can manage more then 2.0 GB of size ?... 9 27.09.2006 17:55:18 Listing the number of records in each table of a database. Dear All, Can someone guide me as to how I can write a piece of code which would enable me to do the following: 1. Display the name of each table in the MDB. 2. Count the number of records in each table of the MDB. 3. Display the name and its corresponding number of records in two different columns of a list box on a form. I have been thinking on the lines of ADODX.catalog and A... 18 27.09.2006 17:40:15 Query design I already asked this question yesterday, then thought I had solved it myself, only to find out that I hadn't. Bummer. I have 3 tables - Activity, Questions and Answers. Activity has the field ActivityID and some other fields. Questions has QuestionID and Question. Answers has ActivityID, QuestionID and Answer. All ID fields are number fields, the Answer field is a yes/no field. Table... 5 27.09.2006 17:36:02 Form design questions Sir/ Madam, I am relatively new to Access, and am in the process of designing an employment application. The table is setup, and I am putting the finishing touches on the form. I am running into the following issues: -How do I change a combo box(yes/no) to a toggle button? When I insert a toggle button for a control in form design, It gives me a label box and one toggle button. I need t... 2 27.09.2006 17:31:01 How can I add a message to all outgoing mail I'm sure I've seen this option but cannot find it.... 2 27.09.2006 17:10:27 Requery on Repaint? On a very complex form I have a couple of calculated (unbound) text boxes that are populated by a function called in the form's current event. The function is quite slow as it involved opening a couple of DAO recordsets and doing some calculations on them. This was slowing up opening the form and navigating between records, so I thought of having the function as the controls' ControlSo... 1 27.09.2006 17:05:18 Performance Issues I have been experiencing performance issues, on a billing database I am writing. I perused the post history, and found several good suggestions. One, in particular, was to open a dummy table, to a linked db, and leave it open so Access didn't need to create a link for each call. I can easily see a 50% increase in accessing speed, when doing this. I am curious, though, is there a wa... 2 27.09.2006 16:57:03 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  >>