| Discussion Groups Index | first | prev | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | next | last |
| Max # of records in Access 2002? (by Dwayne on 18 May 2004, 1 reply) |
|---|
|
All, Does anyone know what the maximum number of records that are allowable in the Access 2002 environment? I have often created sample sizes that have exceeded Excel ... (more) |
| Merge with Word (by Maxine on 18 May 2004, 2 replies) |
|---|
|
Access 2K to Word 2K. Using a command button to open a word merge document whose record source is an Access query. How can I prevent the database from opening twice? ... (more) |
| Master- and detail-form (by Patrick Döme on 18 May 2004, no replies) |
|---|
|
hi there After constructing the form with the form wizard, the master-detail form is here, but the detail form shows all its lines: ... (more) |
| =normsinv(%) (by Joe on 18 May 2004, no replies) |
|---|
|
Is there a simple way, when querrying or reporting, to perform a function in Access similar to Excel's "=normsinv (%)" function? ... (more) |
| access and network performance? (by es on 18 May 2004, 1 reply) |
|---|
|
I have 10 inspectors that are inspecting. Everytime one of them does a server access the performance on the server spikes to max. ... (more) |
| Access 97 records deleted in error (by tsmith@hpbs.org on 18 May 2004, 3 replies) |
|---|
| How can I undelete my records? Is there a way? Thanks. ... (more) |
| Corrupted Database (by Dale on 18 May 2004, 1 reply) |
|---|
|
I cannot access my database - will not accept password. I believe there is a way to get the tables (some are hidden). Please can you help. Many thanks ... (more) |
| email upon entry (by brigid on 18 May 2004, 1 reply) |
|---|
|
Is there any way to send an email when an entry is made in a table? ... (more) |
| Programmatically creating and filling a database (by anonymous on 18 May 2004, 2 replies) |
|---|
|
I was wondering if anyone knew a way to have access create and new database based on information from the current database. I am wanting to import this created database into ACCPAC so the information is in a certain format. I ... (more) |
| Dlookup (by adriany on 18 May 2004, 2 replies) |
|---|
|
like to use Dlookup! can anyone direct me to website or example of Dlookup i can take a look. thanks ... (more) |
| Jet Database Update (by Brent on 18 May 2004, 1 reply) |
|---|
|
I have a fresh install of Access 2003 on XP Pro. I have run the Jet database update for XP three times, but I still get the error message saying I need to update. Any suggestions? ... (more) |
| Need help with code and query (by Greg on 18 May 2004, 1 reply) |
|---|
|
I am trying to dynamically populate three dropdowns. The first 2 dropdowns work fine. Here is the 2nd query I am using for the 2nd dropdown. ... (more) |
| Conditional Formula (by Bill on 18 May 2004, 1 reply) |
|---|
|
I am using Access 2000 I would like to create a multi-conditional (=IIF) type statement for a rating system. ... (more) |
| MOUSE OVER (by Ray on 18 May 2004, 3 replies) |
|---|
|
I would like to be able to mouse over and object to open but when mouse is past the object it closes the window. I can currently open the object with mouse move but cannot find a way to close it. ... (more) |
| Properties Window (by PeterM on 18 May 2004, 3 replies) |
|---|
|
I'm running Access 2003 with a Access 2000 formatted database. Because of things I cannot control, all forms displayed ... (more) |
| Return price in a specific date (by Claudio Bogado Pompa on 18 May 2004, 1 reply) |
|---|
|
I have a table where I store the variation of prices of product and I have another table where I store the sales of the products. The prices of products can change as often as a month or a year and I only store the dates where the change is made. ... (more) |
| Run time Error '7': Out of memory / Run time Error '91': Object variable (by Teddy on 18 May 2004, no replies) |
|---|
|
I'm developing an Access 2000 application on a German Access 2000. There all is running ok, without errors. My client where the application has to run finaly is running Access 2000 in English. And there I get some Errors I don't have on my mashine. ... (more) |
| Problem deleting a record in a SQL Server linked table! (by Nuno Almeida on 18 May 2004, no replies) |
|---|
|
Hi, Sometimes, when I try to delete a record in a SQL Server linked table, through a Microsoft access form, I get the following error message: "The ... (more) |
| Access 97 vs Access 2003 (by bdkstag on 18 May 2004, 1 reply) |
|---|
|
Hi, when I save a database in access 97 it's around 500kb but when I save the same database in access 2003 it's get ... (more) |
| access DB from web (by micky5009 on 18 May 2004, 1 reply) |
|---|
|
Hello, I have just finished an inventory DB for use at work and wondered how I would now go about accessing it from a browser like IE 6. ... (more) |
| Remove the "add or remove buttons" on custom menubars (by Silvester on 18 May 2004, 2 replies) |
|---|
|
I have an A2000 app with custom menubars. Testing on Access 2002 and A2003, there is a small arrow at the base of each custom menubar button.Clicking on it gives users the dimmed ... (more) |
| Shell() or Windows API question (by gxdata on 18 May 2004, 9 replies) |
|---|
|
I have a DOS or command console program that was written in FORTRAN, and accepts piped input when run from Windows 2000 Pro command prompt (or Windows 98 DOS prompt) - ... (more) |
| changing height of listbox based upon number of records (by Hcoms on 18 May 2004, 2 replies) |
|---|
|
Hello , How can you change the height of a listbox based upon the number of records that are in the listbox? This is to try and avoid the scroll bars. ... (more) |
| *-**FORM HELP **** (by sha on 18 May 2004, 1 reply) |
|---|
|
I have an access database that holds all the student results and I want to create a report that would allow me to group/sort student exam results using instruction for second year and calculate the total. I am able to do this without a problem each year alone and print this on 1 page for each student. ... (more) |
| windows xp (by harry bowling on 18 May 2004, 2 replies) |
|---|
|
I RECENTLY INSTALLED THIS NEW OP-SYSTEM AND I AM HAVING PROBLEMS. FORST OF ALL IT IS SLOW. THE ADVANTAGE OF HAVING MULTIPLE USERS WOULD BE FINE BUT IT TAKES SO LONG TO GO FROM ONE TO THE OTHER (NEW SCREEN FOR EACH) THAT I JUST GAVE UP AND WENT BACK TO ONE USER. BUT ... (more) |
| JEANETTE STRANGWAY (by jeanette strangway on 18 May 2004, 1 reply) |
|---|
| HI ALICE LET ME NO IF YOU GET THIS NOTE ... (more) |
| closing a page and IE (by Dave Troughton on 18 May 2004, no replies) |
|---|
|
I can no longer close a page by clicking on the cross in the top right corner, or through file and close. Only a problem on internet explorer. Any Ideas on how to remedy, at the moment I have to turn machine off to exit! Please help ... (more) |
| master-detail-form (by Patrick Döme on 19 May 2004, 1 reply) |
|---|
|
hi there After constructing the form with the form wizard, the master-detail form is here, but the detail form shows all its lines: ... (more) |
| Re: how to run an Access 2003 db on an Access 2000 environment? (by Van T. Dinh on 19 May 2004, no replies) |
|---|
|
If the database file is actually in A2003 file format, A2K0 software won't be able to recognise / read the file. You will need some one with A2K3 software to convert it back to A2K0 file format. ... (more) |
| Blank page (by Fadoyo on 19 May 2004, 1 reply) |
|---|
|
Why does a blank page appears at the end of my report? How could I delete it? Thanks ... (more) |
| HELP!!! VIEWING REPORTS IN NORMAL WINDOW (by Chris on 19 May 2004, 3 replies) |
|---|
|
I HAVE A FRONT END DATABASE WHERE I SETED UP THE FORMS TO MAXIMIZE AT OPEN. THE PROBLEM IS THAT THE REPORTS ARE ALLWAYS OPENING IN THE SAME WAY (MAXIMIZED), WHILE I NEED THEM IN A NORMAL WINDOW. IF I MODYFY THE SIZE OF THE REPORT WINDOW, THE FORMS ARE DOING THE SAME ... (more) |
| reports in access 97 (by MStrider on 19 May 2004, 2 replies) |
|---|
|
how the hell do I change the back colour of a textbox on the fly using vba? I am trying this, but the property of backcolour doesn't seem to work in reports ... (more) |
| Relationship stuff (by =?Utf-8?B?Um9iYnZheW5l?= on 19 May 2004, 1 reply) |
|---|
|
Albums - containing the album title and the artist name (combined being the primary key) Artists - containg the artist name Tracks - containing a field called "Track Title", the artist name and album title (which are linked to the table "Albums"). ... (more) |
| Sum and Count (by =?Utf-8?B?YmRlaG5pbmc=?= on 19 May 2004, 2 replies) |
|---|
|
I use =Sum([CountOfScheduled Service Month]) to show total number of calls for month in a report with a sorting by Month. How would I have to structure the above to be able to count number by months to be able to show numbers ina report in columns? Like I said I do have the count forr each call by a date already. I just need the right statement that I can change to count or sum for each month in a report. ... (more) |
| Drop down calendar? (by =?Utf-8?B?S2F0aGVyaW5l?= on 19 May 2004, 2 replies) |
|---|
| I've looked up a number of sites that produce different calendar products but I need some way of making an easy to use drop down calendar on Access so that people can enter a date in a combo box or select it from a drop down calendar. Ideally, I need a calendar object that lets people customise which dates are available and which aren't by colour coding them on the calendar. Can anyone help with this? I'm desperate to solve this because this is the crux of the whole program needed. ... (more) |
| Re: instable (by =?Utf-8?B?TWFhaWtl?= on 19 May 2004, no replies) |
|---|
| yes, I am using memo-type fields ... (more) |
| Find records doesn't work (by Judy on 19 May 2004, no replies) |
|---|
|
Access 2000 db. Finding a record doesn't work consistently on my form. In the dialog box I select the database, any part of field, and search All. It will find the name only if it is on the open form page. ... (more) |
| Upgrade (by =?Utf-8?B?VmlzaW8gQ29uZnVzZWQ=?= on 19 May 2004, 1 reply) |
|---|
| If I have Viswio 2000 and want to upgrade to 2003, do I need the upgrade or a full version? ... (more) |
| OLE DB Data Provider and ADO Service Provider (by =?Utf-8?B?Q2hyaXM=?= on 19 May 2004, no replies) |
|---|
| I read some books mentioned about Microsoft-Supplied OLE DB Data Providers and ADO Service Providers. What are these providers? Do we need them for MS Access 2002? Appreciate some information. Thanks ... (more) |
| Help!!! Hyperlinks making me crazy (by =?Utf-8?B?VGVyZXNh?= on 19 May 2004, 2 replies) |
|---|
|
Does anyone know how to get rid of or work around the hyperlink error message? (The message displays whenever I click on a hyperlink that opens another database. The message is "Hyperlinks can be harmful to your computer and data...". Both the originating database and the database that I'm trying to open have been digitally signed by a trusted source.) ... (more) |
| paths in shell call (by bozdog on 19 May 2004, 2 replies) |
|---|
|
I am trying to use the contents of a text box on a form ,that returns the path of a drawing file after a search, as the path for an application to call after a button click. The button works fine when I manually type the path string, but would like ... (more) |
| Symbol for "Centerline?" (by =?Utf-8?B?S2FyZW4=?= on 19 May 2004, no replies) |
|---|
|
Anyone know what the shortcut key is to inserting this symbol? Or...how I might be able to create it??? ... (more) |
| How to sort/filter or use a formula (by =?Utf-8?B?R2Vvcmdl?= on 19 May 2004, no replies) |
|---|
| I am trying to filter multiple reports for the top 5 selling models in the surrounding counties. I can't find the right expression to use and make this work properly. The models are not limited to any certain number or type so I can filter for number of specific models ... (more) |
| redundancy of repeat data info into fields (by =?Utf-8?B?Q2Fyb2wgSG9yY2hsZXI=?= on 19 May 2004, 2 replies) |
|---|
| I am working in the Public Defender Office and do the yearly expenditures of all vendors we use. If I am filling out a form and I am repeating a vendor but not necessarily the same amount how do I format it so that I don't have to keep typing the same info over and over. The fields I used was Vcode, vendor name, and vendor number. Can I work the vcode sothe once it is typed in it automatically gives the needed info into the vendor name and vendor number ... (more) |
| DLookup in ADO codes (by =?Utf-8?B?UGV0ZXI=?= on 19 May 2004, 3 replies) |
|---|
| I use ADO to open a cursor. Can I use DLookup to find the first record in the cursor? ... (more) |
| access and frontpage (by =?Utf-8?B?Y3M5N2pqbTM=?= on 19 May 2004, 1 reply) |
|---|
|
help..............please SELECT Results.* FROM Results ... (more) |
| How to reference to subform rows? (by =?Utf-8?B?RGF2ZQ==?= on 19 May 2004, 2 replies) |
|---|
| I have a main with subform form. This form has no record source. That means it is not attached to any tables or queries. I want to use code to handle all fields validation and records update. How do I refer to rows and columns of the subform? ... (more) |
| I don't have a RepeatSection option Report Group Headers with Accell XP??? (by BigG on 19 May 2004, 1 reply) |
|---|
|
I am trying to get my report entrys to print out one page at a time WITH the header on each page. The online help tells me to click the header properties then set the RepeatSection to Yes. Well I have searched and searched and I cannot find this option anywhere. It is not an option ... (more) |
| Field Types (by =?Utf-8?B?U0NITllERVM=?= on 19 May 2004, 1 reply) |
|---|
| Is there a way to automate field type changing when importing excel tables into Access? I know you can set up specs to import text or delimited files, can excel importing be done the same way? I've automated table importing, updated, and appending, however changing the fields is still manual, any help? ... (more) |
| Locking record problem ... (by =?Utf-8?B?V2VubGk=?= on 19 May 2004, 1 reply) |
|---|
|
Hi, Recently I find a strnage problem. The database has a lot of records, several hundreds. I locked most of fields on the form to prevent it being modified. There is a check box called "locked", everytime, I check the "locked", it locked the most of fields of the form. ... (more) |
| Edit Memo Field? (by =?Utf-8?B?ampvNDEz?= on 19 May 2004, 2 replies) |
|---|
|
I've just converted my Alpha5 filrs to Access 2003. In Alpha5 I was able to see the entire memo field by clicking on it to create & edit it. In Access I haven't as yet found any way to see the entire contents of a "Memo" field so I can edit it. Is ther a way to do this? ... (more) |
| maximum records (by =?Utf-8?B?Y3k=?= on 19 May 2004, 2 replies) |
|---|
| What is the maximum number of records one database can hold? I need to know this because i have just bought a small business which runs mostly databases!!! ... (more) |
| Selecting Data (by Always Learning on 19 May 2004, 2 replies) |
|---|
|
Hi Guys, This is my first posting here. ... (more) |
| VIRUS-VIRUS-VIRUS (by harry bowling on 19 May 2004, 2 replies) |
|---|
|
NO ITS NOT A WARNING, DOES ANYONE HAVE A LISTING OF VIRUS'ES BY NAME. I CAN FIND AND REMOVE THEM IF I KNOW THEIR NAME. HELP BEFORE THIS DAM BUG WINS. HARRY ... (more) |
| Problem Occured while "DATABASE" was comunicating with the OLE server or ActiveX Control (by Rusty Shackelford on 19 May 2004, 1 reply) |
|---|
|
I have gotten this message twice now on an ADP and would like to know how to fix it!! It was working yesterday but not today. I cant think of any information other that it is happening with Access 2000 and 2003. OS is windows 2000 and XP. ... (more) |
| Application originally in Acc2000 format, when converted to AccXP format, keeps growing... (by Nuno Almeida on 19 May 2004, 1 reply) |
|---|
|
Hi, I have an Access 2000 application, that when is converted to Access XP Can someone help? ... (more) |
| Access in two offices (by Lev Seltzer on 19 May 2004, 2 replies) |
|---|
|
My client just spent several thousand dollars to have an MS Access (2000) database developed. The database is now finished and working, but now they realize that they need to have complete access from two different workplaces. Both ... (more) |
| Question (by Tonyaa on 19 May 2004, 1 reply) |
|---|
|
Does anyone know how to have only certain fields display on a form depending on a condition of another field? I have a field that has one of two choices. I only want the three fields under this field to display on the form if a condition is true on the other field. Please ... (more) |
| MSFlexGrid (by Fiskmiddagen on 19 May 2004, 1 reply) |
|---|
|
Hi, To be able to have a timesheet on a form, I want to use a grid control and I have tried MSFlexGrid. But, I can not input/edit values in the cells. The ... (more) |
| Access2000 IIF -STATEMENT (by jack-geronimo on 19 May 2004, 2 replies) |
|---|
|
Why this will not function in Access2000 IiF ( [bei_aktiv_datum] <=Now() and [bei_archiv_datum] >=Now(),1, ... (more) |
| Discussion Groups Index | first | prev | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | next | last |