Threads Replies Last Post 153 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  >>   Trend Data I have a database that has a table named Summary with the following data fields and others that are not relivent to the question: [Upgrade date] [CR #] [CR Reported Data] 2/12/2006 235556 5/18/2006 I am trying to trend the [CR #] weekly for a period of time 30 days prior to the [Upgrade Date] Is there anyone out there tha... 1 31.08.2006 12:49:02 Opening and printing from Word from Access 2003 I'm new at this and am stuck....I am working on a document program that starts in Access entering data that will be printed with mail merge. I would also like the documents to print in a "batch" (approx 5 different forms). How can I go from the entry form in Access, open Word and print the forms? I would also like to be able to print individual forms as needed. Thanks for your help.... 4 31.08.2006 03:08:02 Linked to Locked File? I know I can't import or create a link to a file when it's locked by another user. However, once I create a link (when it's not locked), will I be able to get in or a will I get lock error if if the file is locked? Thanks! ... 2 31.08.2006 03:06:21 printing problem My reports preview with the check boxes showing but they will not print - they did up til recently! I'm using access 2002. thanks... 1 31.08.2006 02:05:01 Seem to have a file missing now Hi I am using A2000 on WINXP I platform plugged in a small amount of VB Code to mark an old address as onsolete when a new one is added and it all worked fine. A couple of days back I had my system hang unexpectedly and much later I noticed that now when I call the VB code I get an "Error accessing file. A Network connection may hgave been lost error message." Everything looks ok though... 2 31.08.2006 01:53:21 Overflow Hi, I am trying to import a table and before it is finished saving I get a pop-up saying "Overflow". What is that and what can I do about it? Thanks... 2 30.08.2006 21:41:32 on-screen keyboard i can not resize my on-screen keyboard, it stays big... 3 30.08.2006 20:34:15 I need to populate a Word table from an Excel spreadsheet. I have a standard Word form with a table that is currently populated by typing. I have a spreadsheet in Excel that contains the information needed. I want to be able to type in a number on the table that will activate the whole row in Excel thus populating the same fields in the Word document.... 3 30.08.2006 18:01:59 Search I m using the search command code to find a record, when I type in a record ID. the code seem works well to find the certain record ID. Like for e.g. I have 15 records, I m able to find those > 11 but fail to do so for those record <10 . Can I know why? How to solve this problem? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-getti... 2 30.08.2006 11:07:35 info on every record in access database.. .....I'm having some trouble in designing an inventory database...hopefully someone can help... I'd like to create an inventory database where there is one record for each item, then I would like to have the name, address etc., appear the same on every record for that database. What is the simplest way to do this? also...what is the easiest way to put pics in..i need 4 pics for each ... 6 30.08.2006 06:18:02 Form Coding?? I am trying to establish a code to make 6 "bound" check boxes (A,B,C etc) appear as checked when an different "unbound" checkbox (Full) is checked on a form named sensitising. I have tried this If Sensitising.Full = True Then Sensitising.A = True Sensitising.B = True Sensitising.C = True Sensitising.D = True etc Else Sensitising.A = False Sensitising.B = False Sensitising.C =... 3 30.08.2006 02:24:10 Visual Calendar Capability? Does Access allow you to take events and export it into a visual calendar, similar to Project, but with more flexibility? Example: Season Event Date Spring Dance 5/1/07 Fall Ball 8/15/07 I would have a list such as the above, and I would like to somehow differentiate between spring and fall, such as make them different colors. I would like to... 3 30.08.2006 02:22:18 Many to Many Issues I am new to Access and am trying to produce a database for bidding. I have created a table called "Suppliers" with simple name contact person and telephone info, and another table called "Product Summary" that will include a list of common materials that we use for our bids. This latter table includes that material name and will hopefully include the lowest current price, and the curren... 3 29.08.2006 23:31:41 print specific reports I have a report - that gets its data from a query - and I have a form that lists the results from the query. I would like to put a command button next to each record, and which ever button I click, it will print only that data, not the entire query. Can anyone help me please? I've been working on this all day and I'm going nowhere fast.... 3 29.08.2006 19:16:02 Performance Tanks after Splitting Database I've been working on a database project for a few months, and now that it's nearly complete I have split the database so that the tables reside on the server and all other pieces are at local computers. While building it, I had everything on my own computer. Problem is that now the performance is terrible. What used to take about the time it takes to click a mouse button now takes 5 t... 10 29.08.2006 14:17:35 hyperlinks vs command buttons I went to a class in access 2003 and they suggested using hyperliks to navigate to reports, forms etc...it seems really simple and worked well. What would be the drawback from doing this? Thanks, Linda ... 5 29.08.2006 12:43:45 New Data Base I am building a new Access database. Can someone give me the first step? I only want the first step right now. Thank you. -- Butterfly90... 9 29.08.2006 12:43:02 select which table reports go to from form I might have already posted this question, but I can't find it, so here's to the ignorance again. I have a form based on results from a query. The query basically gives me a "bad boy" list of people. I would like to have two button options next to each name in the form. One sends the name to a "waived" table, the other sends them to the "prosecute" table. Since the form is based off ... 5 29.08.2006 05:50:02 correct procedures to use access I know basically you can start with creating a database > by create tables, then create query , then Form, then report. But can I know that what is the correct process or procedures to from starting to the end of a database project? I still dont know about the overall concept about access. Can I know that any information or examples which teach people from start to completing a data... 6 29.08.2006 05:12:42 Need help with the telephone number Hi I would like someone to help with the "Find and Replace" option.Is there any chance that this option would find any phone number of my customers. I have the customer calling me and ask me if I can find him by the phone number in my data base.I am a newbie to this program and could not find him that way.My database is based on the fields like name, phone number.So far I can only fi... 2 28.08.2006 18:45:55 From one dropbox of tables to another Dropbox of that choice... How do you set up a form with a dropbox or listbox of choices that automatically switches to another form with a dropbox or listbox with choices of that original selection. For example: I would like to choose from a list of sports, the sport of baseball. After that selection I would like for a dropbox or listbox to offer selections of baseball related records to be available, i.e., e... 5 28.08.2006 18:24:02 How to do add my own lable and control in a form? I am creating a form for customer database, I dunno how to add an item like, "Speak Basic English: Yes/No" <-this is one of the data that I would like to add. Thanks!... 5 28.08.2006 16:10:11 ValidationRule for upper case Access 2003. How can data entry for a field be restricted to upper case, or automatically convert lower case letters to upper case? ... 3 28.08.2006 15:33:02 How to insert a field in Access when field is not in chooser? ... 3 28.08.2006 15:28:20 Checklist in database I have created a Lease Management database for my employer. This database houses lease and rental information for over 100 retail stores. I have been asked to include a table/form which will list the landlord and tenant responsibilities of the Lease (i.e., who is responsible for repair of roof, plumbing, etc.) There are approximately 25 standard "responsibilities" in each lease, but t... 9 28.08.2006 13:35:19 153 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  >>