Threads Replies Last Post 153 Pages: <<  11  12  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  >>   How to Please ... 2 31.07.2006 00:29:21 Control does not work Hi, I copied this from a sample database. I am making a menu form for the user to decide if he wants to start a new record, edit an old one, or run a report. This is supposed to start a new record, and it works in the sample database, but when I click it in mine, nothing happens. Any suggestions? Thanks! In the On Click event of the control on the form I have: ... 8 30.07.2006 23:09:09 How to go from Excel to Access - pointers / methods I need a hint regarding how to proceed. I have an existing flat "database" of water customers in the form of an Excel spreadsheet. I need to move it into Access. I know how to do it simply - so that's not the question. There are two sources of data: The Excel spreadsheet of customer names, date, water use, charges for the period. A table of customer names and charging codes. H... 4 30.07.2006 22:24:53 filling a table based on data from another one? Hi i'm really new at this i've searched in a book i have and i couldn't find any thing and i need some help i'm working in my school we have 4 majors for each major a table with it's courses and a(NewStudent) table for the new students, this table contains their id ,names,the majir they want to be in ,and if they want to take the full courses or part. and another table (NewStuden... 2 30.07.2006 15:22:15 Using variables I am trying to populate a new table (Tbl_MyTable_Temp) with records from an existing table (Tbl_MyTable). The records to be included are determined by one of the fields in the existing table, the value of which is input by the user. First I create the new table using an SQL statement as follows: Dim StrSQL As String StrSQL = "CREATE TABLE Tbl_Mytable_temp ........ DoCmd.RUNSQL StrSQL... 3 30.07.2006 12:35:02 access 2002+forms+navigation lock-up Any advise on the above?... 2 30.07.2006 10:12:13 Working with tab control Working on a kennel database for myself. I have set up a form with owner info & subform with dog(s) information. Is there a relativily simple way to set up a tab contol form where each tab page shows a different dog. For instance I have my name as owner. I wanted the form to show Crickett, Ready, etc on the tabs. This way I can easily see the dogs an owner has & click on the tab & a... 4 30.07.2006 05:50:02 shutdown not in start up when i hit start it doesnt show shutdown or log off how do i get it back on... 3 30.07.2006 02:45:55 link many records within 1 table I have a table that contains many records which need to be linked to each other. For example, one record contains a fee for charge A, the next record will contain a fee for another charge, B. These items need to be linked so that all charges appear in one record. I download the info as seperate lines so I really don't want to have to change it 1 item at a time. How on earth do I do this... 4 29.07.2006 17:28:49 Subtotals I have a DB where I enter orders, OrdNumber, CustNumber, InvoiceAmt, and various other fields. To simplify my question, If I have three customers: A, B, and C and have several orders for each in varying amounts, I need to add the order amounts (InvoiceAmt) for each of the three customers, in much the same manner that the Subtotal feature in Excel would accomplish for me, and put them i... 3 29.07.2006 17:03:02 Why "no current record" on a DLookup function? This is the first line of a function that I execute repeatedly throughout my app. But now I have a situation where it is giving me a "no current record" error. How could that be with this line? The context is that I have a form that collects data and then opens a report. If I close the report and then re-execute the form, to print another report, I get the "No current record..." error at ... 3 29.07.2006 14:56:10 iam interested to get data from excel file and store in MS-Access i have 5000 records in Ms-Excel and iam interested to import in MS-Access pls help... 2 29.07.2006 12:39:14 How 2 command button that'll call up hyperlink stored in a table c I have several hyperlink already typed into a column of cells I want to create a command button that will on selection pull up that hyperlink. Thanks, ... 2 29.07.2006 06:01:01 How do i link same named records from Access in Excel I have an acces database and would like to update it with records that are in excel.These fields are names.eg.Continent,Country and Town.The updated record sets are in the excel file(e.g.Geocoodinates)... 3 29.07.2006 05:02:36 How do I use totals for one page to create a year-to-date total pa I created a simple spreadsheet with a page for each month, and a page to show a running total (year-to-date). How do I get the total for each field, in each page and add them up to create a running total in the year-to-date total. The only formulas that I'm using in the other pages is the SUM for each column. thanks lac... 2 29.07.2006 01:46:04 Finishing my project? It's been a learning process, but I am almost done with my first Access 2003 project. Now, I wonder if someone could please give me a brief rundown on what exactly I have to do to get it ready for others to use? I know I have to make an intro screen. I am assuming I make a new form and put buttons on it for finding a record in the table, edit, save, etc. Do I need to make ... 3 28.07.2006 22:44:25 how do you convert paradox 4.5 to MS Access We are currently using Paradox Version 4.5 and it is failing and we need to know if we can convert our files to Micrsoft Access.... 2 28.07.2006 22:40:26 Corrupted "Forms"? I have a split DB and I'm getting a file corruption error. I checked my BE and the records seem to be okay. I created a new FE and recreated my table links and exported my Querys and Reports (all but one). One report and ALL of my Forms (including my screen menus) won't export due to "file corruption". Can anyone shed any light on this problem. Will I have to recreate from scrat... 2 28.07.2006 21:39:01 alternatives for newsgroup reader and notifications At work, I've been using a web-based interface, because that's all that seems to be allowed and functional. At home, I've been using Outlook Express, which is fast. However, the notifications sent by Microsoft almost always time out with a "Sorry, the page you requested is not available" error (they've worked only twice, both times at home). 1) any idea of why the notifications don't wo... 2 28.07.2006 20:26:04 Misspelled Form Name OK, I admit that I did a really dumb thing! I realized after my project was almost done that I had used bad naming conventions, so I went through and renamed my form, table, and all references to the form in my macros. Now, every time I open something I get the "misspelled form name" error message. Is there an easy way to find my mistake? I have looked and looked and don't see i... 5 28.07.2006 18:39:56 I miss .mdb I've been handed an .adp database; It is secured, so I do not have rights to change the tables, etc. I've created some forms, but when I try to test it, I get blocked. Usually it says "Cannot insert the value NULL into column..., table...column does not allow nulls." The primary key in these tables are AutoNumbers. I seems as if I can't get the system to start up using those AutoNumb... 1 28.07.2006 17:17:01 multiple choice selection from pick list Hi all, I need to know how my users can pick multiple options from a drop down list in DB. I have tried combo boxes, value lists, changing the list width to 1.4 etc but to no avail. Do i need to create another table & link the two as one to many relationships? I'm a newcomer to Dbases so the simpler the language the better! Much appreciated Uzi... 3 28.07.2006 14:55:02 Show only Current Year on Report I was wondering is there a way to show only the current year (YYYY) on a report??? Thanks in advance cw -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200607/1 ... 2 28.07.2006 14:27:02 Creating "standard" GUI for Access applications Hello, I have written an Access application. I basically have my data stored in a mdb file and the UI and VBA code in another mdb file. The UI I am currently using is a switchbox that launches some forms. I would like to rewrite the UI part and have it look like other "standard" Windows applications (Word, Excel,...): a menu bar with options like "File", "Edit", "Insert", and some cu... 3 28.07.2006 14:02:01 Count unique records in query I've created a query that lists the student ids for students who were enrolled in particular courses (along with some other data). However, some students are enrolled in more than one course so the query contains some dulicate student ids. I want to get rid of the duplicated student ids so that each student appears in the list just once. I tried creating another query to count the valu... 5 28.07.2006 12:35:58 153 Pages: <<  11  12  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  >>