Threads Replies Last Post 153 Pages: <<  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  43  44  45  >>   MyAccess doc got too large!!! hello. I am new to Access, but I've learned a lot during these past two weeks - slowly building a form, which is ending up to be a tabbed form, since I exceeded the "vertical limit". Anyway, so I've been designing and deleting, and re-designing... I'm curious: whenever I re-do something, am I creating code somewhere in the background, and making this whole big mess? My document is now... 6 19.07.2006 19:29:10 Newsgroup notifications I have never gotten the links provided in email by this newsgroup to open the related message. On one system I use just the web and do not have email. On the other (at home, Windows XP Home) I have Outlook Express, which I use for newsgroups and email. The links start to open a Microsoft site, but the web page has always timed out before showing anything of value. On my home system I us... 2 19.07.2006 19:27:02 Date formatting Is there a way in Access to enter 6 digits, and display them formatted as mm/dd/yyyy? I've done this programmatically before, but it seems like there should be a simpler way. Thanks in advance, -Ned. ... 2 19.07.2006 17:28:01 Form styles Although MS Access has several form styles, are others available? Is it possible to create custom styles? (Some of those Microsoft includes seem a bit hokey.) Thanks! ... 3 19.07.2006 16:23:15 filter a control when form opened by command button? The following code, created by the Command Button Wizard on my frmClients form, opens my frmOrders form filtered to show orders for that client. What is the best way to extend the code so that when the orders form is opened from this command button you can carry on adding new orders for the same client without each time having to reselect the client (from the order form's cboOrderedBy... 3 19.07.2006 13:39:02 Use the value of a field in the previous record to populate the fi I want to populate a Patient Number field in the current record with the value of the field in the previous record. How do I do this?... 2 19.07.2006 12:55:01 Check number of records in subform according to listbox Hi everybody, I solved the problem I had yesterday and I am bothering you again (I hope it will be the last time for a while!). I have a form listing orders + subform listing products for the same order. When I enter the order in the form I have a listbox for selecting the number of different products the customer is buying (I don't need to record how many copies of the same products I ... 1 19.07.2006 11:53:27 Count in report footer I am very new at this. I have added a text box to my report footer and changed the control to =Count(*) to get a total count of the records in the report, however when I run the report I get an error ..... #Error.... 2 19.07.2006 10:56:02 Sum a column every time a record is created I want to sum the Quantity field each time I create a record. I am defaulting a 1 in the Quantity field and I have created a sum in the footer section. The sum works whenever I manually enter a value but it does not work if I use the default value of 1. In other words, if I simply press enter and accept the default 1 for quantity, the sum does not update when I commit the entire record. ... 3 19.07.2006 10:45:10 Calculating the league age based on an end date Hey group!! I need some help. I've been tasked to calculate the age of players from 1/1/2006. I created a field in my registration table called "enddate" and gave it a default value of "1/1/2006." During registration, the user enters the Date of Birth and it calculates the players league age. The formula I'm using is: =Int(DateDiff("m",[DOB],[EndDate])/12). The problem I'm having is... 4 19.07.2006 10:35:42 Selecting Unique Records from Child Tables Hi, I'm quite new to using the Access interface although I've worked on bespoke databases before. I have data on trainees (trainee table) with a child table holding their career information - all the posts they undertake during their training, with start and end dates, location etc (career table). I'd like to select all trainees with a particular criteria and include some info from t... 4 19.07.2006 07:46:01 How can I set up a Works Database file into Microsoft Access? I have just purchased Microsoft Office Pro. and want to move my Works Database files over to it, as I can not get them to print. (error message: not enough memory). Is there a way to do this?... 2 19.07.2006 00:38:04 Database window won't open HELP! All of a sudden my database window won't open and I can't finish the design. I have held down the shift key to open the database window upon startup. Otherwise it would go to the Main Menu. But now, holding the shift key down does not give me the database window. I get nothing. I can open it without holding the shift key down but I have no access to my forms, etc. The Help f... 2 18.07.2006 23:41:01 I have a document in Access. I want to "un" archive it. How do I? My Access document was archived. I want to have it not archived. How can I change this? Thank you for any help!... 2 18.07.2006 22:38:35 NEED HELP,(SQL) Displaying data in a form based on selection from combo box Hello Experts, I need help. First question: I have a main form (Clients) which allows user to select from a list of client ID's. A number of textboxes or fields get filled up. Now one of these textboxes is called Condition or the condition field. I now press a command buttopn which opens the orientation form. In the orientation form, I want to display records based on the text in... 1 18.07.2006 22:22:25 How do I take new records from a CD and get them into Access I have an existing database in Access and another employee has been working on Access at home inputing data. Now we have her mdb files on a CD and cant figure out how to get them into the existing database.... 2 18.07.2006 21:11:02 Duplicating record and double table check Hello everybody, I am stuck with an append query and I need some advice from expert. I have a database with three tables. Table_Customers (PK Autonumber) TableB_Orders (PK Autonumber) TableC_Products (PK Autonumber) The three tables are linked through a common field (CustomerNumber). Now, my problem: sometimes I need to duplicate an order from the Orders_Form. The duplicated orde... 10 18.07.2006 20:23:03 Expression in Query A question about Expressions in Queries. I work flexible hours and want to use Access to find out if I have worked too long (> 8:30) or too short (<8:30) on a given day. My simple table has three fields: EnterOffice (e.g. value 8:15 AM) LeaveOffice (e.g. value 3:40 PM) StandardTime (value 8:30) In a Query I have this Expression: LeaveOffice - EnterOffice - StandardTime The ... 4 18.07.2006 19:51:50 How do I print 50 envelopes with just the return address? I want to print just the return address on up to 50 envelopes at a time and can not figure out how to do this. ... 4 18.07.2006 18:14:02 If then Statements Can someone please help me I have a query with the following fields Min Weight, Actual Weight, Vol. Weight I need to workout what the Excess Weight is depending on which is greaterbetween Actual Weight and Vol. Weight Something like this: If Actual Weight > Vol. Weight Then Excess Weight = Actual Weight - Min. Weight Else Excess Weight = Vol. Weight - Min. Weight End If. How... 4 18.07.2006 16:48:09 Queries for a report I have a database that I would like the user to select an item from a dropdown list and then run a query on a different table to generate a report for the user, does anyone know how I can do this? -- keameyer... 3 18.07.2006 15:46:38 How can I get auto sum of column when new figures are added I have put in formula to total a column of figures, it has empty cells for new items to be entered as they occur. It used to total in new items automatically, now it will not total in new items. It is a Monthly spreadsheet. I used" create a copy "to make blank copies to use for following months. I made changes to existing sheets as I needed to by using CTRL key and clicked on each future... 2 18.07.2006 14:36:08 Conditional visibility Hi, I have a text box in a form called "tracking database" and another called "document hyperlink", how do I design a form so that when tracking database is set to "no" document hyperlink is invisible and when tracking database is set to yes it is visible? Cheers Mike -- Mike Mc1981... 2 18.07.2006 12:17:32 DOWNLOADING MUSIC TO IPOD FIRST TIME USER APPLE IPOD WANTING INFORMATION ON DOWNLOADING MUSIC FROM NET... 3 18.07.2006 06:59:06 cannot install office student teacher edition 2003 I insert the Microsoft Office 2003 Editons CD; and then nothing happens. There is supposed to be a help button or setup dialog. But nothing. I have tried reinserting the CD but still nothing. Please, please help, I'm not too swift w/computers anyway. Frannie O ... 2 18.07.2006 06:40:21 153 Pages: <<  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  43  44  45  >>