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  >>   Alternate input masks on a form I have a membership database with one [PhoneBH] as one of the fields. I have an input mask to ensure uniformity of presentation when printed. Recently members are using a mobile phone as their business contact number. I would like to present an option button: " Business number is a mobile " which changes the default mask. Default mask is: 00\ 0000\ 0000;0 and mobile mask is:... 12 15.09.2006 11:48:25 Unusually large database I have a 322Kb Excel spreadsheet. I have imported all the worksheets as tables into Access. The resulting MDB file is a staggering 90Mb. How on earth did this happen? Anything I can do to reduce the size of this file? I'm not going to make any friends sending it as an attachment. Thanks in advance...... 3 15.09.2006 10:53:01 how to hide design view in access how to hide design view in access. Thanks in advance... 5 15.09.2006 07:58:01 Syntax problem with [FieldNames] I have a form open with data in various fields - I have a field in a table called "PURL" - I have the value displayed in a control on the form - I can access the contents of this field in my VB code using something like; strFieldContents = [PURL] If the field contains "D:\MyProg\" then after the assignment my variable, strFieldContents now contains the same text and this DOES seem ... 2 15.09.2006 00:05:03 Tabbed forms I've been playing with tabbed forms as a way of sensibly designing forms that don't need to be scrolled but can't see a way of altering the tabbed background colours or the font of the tab heading. Also if I start dividing the form up with lines, these lines appear on the other tabs not just the one I have drawn it on. Any ideas? Any GOOD books or website links for forms design info wo... 5 14.09.2006 23:33:37 Help With Multiple Tables, Fields and 'query' - Hello, I use MS Access 2003 on Win XP (SP2). I am opening 'exported' (DTS) data from a Solomon DB that has about 1400 tables and from 10 to 50 fields per table (Yuk!). Several major tables have a 'field name' of NAME and within those columns (~140,000 rows) I have a 'last name' ~ 'first name' - importantly I also have a 'client ID' field that must stay 'related' to the NAME. I want to ... 10 14.09.2006 23:09:22 Filter by Form Issue I am running a database using Access 2003. There is no security in it as there are only four of us using it. Never thought there was a need. My issue is this, when we do a filter by form in tab 1 and then go across to tab 3, all the information has disappeared. Yet if I go into design view and then back, the info appears. How can I rectify this?... 4 14.09.2006 22:18:02 Deletions Hi, Just how sensitive is the data in a table? If while you are creating a query you change or delete something in the query will it erase the data in the main table? ... 7 14.09.2006 18:11:57 Sorting ranges of revenue and ranges of employees I am having no luck at all trying to successfully sort in descending order ranges of revenue s/a "$500,000-$1,000,000" or employee ranges s/a "1 to 50" or "1-50." Either the ranges turn into dates (with employee ranges) or both revenue and employee range columns don't sort in true descending order at all (where, say, $500,000-$1,000,000 would automatically be above $50,000-$60,000). T... 3 14.09.2006 17:43:01 Automatic running of a macro/code I'm in the beginning stages of designing an inventory db. One thing I'd like the db to do is to automatically "withdraw" quantities once a week. We have a spreadsheet of students that change every week and shows how many students actually graduated each week. There are items that will be issued to each weeks class so we know from the spreadsheet how much to deduct from inventory. So,... 5 14.09.2006 16:24:02 Why does Publisher substitute zeros for text when merging w/Excel No matter how I format the cells (number, general, text) it keeps putting a 0 in wherever I have anything but a single number. Specifically, I'm trying to print a label in Publisher ('03) using mail merge, with the data source being an Excel table. Some of the cells in the data source contain two numbers (4 & 6, typed just like that). In Excel it shows up the way I want it, but when I... 2 14.09.2006 15:04:36 How do I print index cards with microsoft access 2003 I want to print index cards from an access 2003 database but can't seem to setup to print to an index card - any help would be appreciated.... 2 14.09.2006 12:54:44 copy contcats form my laptop to my p.c iam not able to copy my contacgt form my laptop to my p.c... 2 14.09.2006 12:09:33 Converting a Data List into a table. I'm new to Access and not sure of what its capabilities are. I have an Excel spreadsheet that contains the following data (this is a simplified example): Event Location Date Name A Here 9/18 Johnny B There 9/19 Debbie C Over there 9/20 Johnny D Some where ... 2 14.09.2006 03:01:10 Simple Design/1NF question Dear NGs, I recently downloaded and read a bunch of material on normalizing your data and db design. Things aren't crystal clear yet! Part of the problem is that nearly every thing I read used the same customer invoice data as an example. I'm dealing with deer harvest data that will never need updating (unlike customer data!). One nagging question that I have deals with the 1NF ... 7 14.09.2006 01:55:02 Getting values from another table This is an extremely basic question. I am trying to use a lookup to get values from another table into my main data entry form. The other table has 2 fields - name and value. When I lookup name in my main form, I want the form to be able to perform a calculation on the related value so if my second table has values e.g. Apples 1 Pears 2 Oranges 3 When I do a lookup on Pears, I want... 4 13.09.2006 22:56:05 excel and access i have 3 excel workbooks that contain mulitpule worksheets. i want to convert these to access. my question is,,how do i create the tables representing the wb and link them to the ws's. for example, wb 1 is named model #, it contains several ws's called dept.'s. in the ws's, are parts and vendors. wb 2 is named prod., it contains several ws's called schedlues, in the ws's are different mo... 2 13.09.2006 22:26:16 Adding a new form I have a form with survey questions. The last item is a yes/no check box. How do I tell access to go to new form after that box is checked or tabbed over. Also I have a combo box that has multiple answers. When I tab into it how do I tell it to use the arrow kesy to choose the correct answer.... 2 13.09.2006 21:40:02 Query Assistance... In my query, I have 2 Columns: An "Assessment" column that has a single letter evaluations, e.g.,"C". How do I have the "Confirmation" Column to convert the "C" to "Confirmation", a "U" to "UnConfirmation", etc. Would I need to use an IF clause somewhere? Thanks for your help! ... 4 13.09.2006 20:02:22 Formulário_X_Tabela Em um formulário para alimentar uma tabela, utilizei uma das caixas de texto para somar os valores de outras caixas de texto do formulário, porém o valor da soma não está sendo levado para a coluna correspondente da tabela. Como devo proceder ?... 7 13.09.2006 19:27:02 Database Window Missing I am new to Access, and i have clicked the close button on the database window that has the Objects listed. How can i get the window back?... 7 13.09.2006 19:25:02 Validation Rules How can I create a validation rule that allows a user to only enter a date which is a Sunday? I have tried the following, but receive an error message: Weekday(PeriodStartDate)=1 I think that the problem is that I am not correctly referencing the field's name in my validation function. Any help would be appreciated. Thanks! ... 3 13.09.2006 18:33:04 What do i use to make business cards? I've made business cards before i just can't remember for the life of me how to can anyone help?... 2 13.09.2006 17:15:01 I MISSING RECORD BY AUTO NUMBER( HOW I CAN GET BACK ) I HAVE TABLE FOR CUSTOMERS WITH AUTO NUMBER SEQUENCE FROM 1969,1970,1971,1972,1974 BY I DELETE BY MISTAKE 1973 HOW I CAN FIX THE SEUQENCE... 3 13.09.2006 16:40:05 Update form field from query I have a form field that I want to be a calculated value. The form field in which the calculated value is to be stored is "Days Open". I have a beginning date stored in a table & have tried several ways of getting the data to display. I have the query to calculate the value working, but can't get the data to display in the field. I have created a macro that can be run, but that won't... 6 13.09.2006 16:21:02 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  >>