| Newsgroup Index | first | prev | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | next | last |
| Use of Max(), Display Form, update/insert fails (by dotcomsavant on 19 May 2004, no replies) |
|---|
|
I have been assigned to maintain an access application that uses macros that call queries and invoke two forms. At this point I am only concerned with one form. ... (more) |
| Urgent (by Noorali Issani on 19 May 2004, 2 replies) |
|---|
|
There are two tables Expense Table Amount date ... (more) |
| Runtime (by Bdkstag on 19 May 2004, 2 replies) |
|---|
|
Hi How can I make a runtime version of a database? It's an access 2003 database. ... (more) |
| Field Names (by Always Learning on 19 May 2004, 6 replies) |
|---|
|
Hi Guys, How do I get a list of field names used in a table. ... (more) |
| Next step (by Steve on 19 May 2004, 2 replies) |
|---|
|
Hi everyone, I just finished a mid-level Access 2002 course at a community college and wanted to put some of the ideas into practice. Can anybody recommend a book ... (more) |
| 2000 file format or 2002/2003 (by bdkstag on 19 May 2004, 3 replies) |
|---|
|
Hi, what should you choose?? And why? ... (more) |
| access 2.0 converter to access 2003 (by bdkstag on 19 May 2004, 1 reply) |
|---|
|
Does anyone know where I can get this? On microsoft it's not available, you need to contact Microsoft Product Support Services but how?? :S Does anyone know a site where I can download it? ... (more) |
| List of the tables (by Benn Vosloo on 19 May 2004, 1 reply) |
|---|
| How can I print a list of the tables in my data base? ... (more) |
| Multiple Users at Once (by Amy on 19 May 2004, 10 replies) |
|---|
|
Is there a way to have more than one preson entering data into a table or a form at once? I need a report to have information from 6 different people and they all will try and enter stuff at the last minute. ... (more) |
| Multiple Choice (by KP on 19 May 2004, 1 reply) |
|---|
|
Hi, I hope you are all doing well. Customer has which vehicle, choices being Ford, Chevy, etc. When the vehicle of choice is checked on the data ... (more) |
| Access History (by krei on 19 May 2004, 4 replies) |
|---|
|
Is there any way to get history of changes like it`s done in EXCEL(there it`s called "History worksheets"), without any programming efforts? ... (more) |
| PLEASE HELP URGENTLY (by Margaret Brady on 19 May 2004, 3 replies) |
|---|
|
I have a ms access 2000 db with 15000 records.. When I try to find a certain record an error message appears saying "invalid arguement", within this form there is a notes box (txt box) for extra notes - the notes for ... (more) |
| help access2003 with office2000 (by steve on 19 May 2004, 1 reply) |
|---|
|
I have office 2000 and need to upgrade to access 2003 to run a new program can i just upgrade to access 2003 and leave the rest of office 2000 alone. I tryed it but I can not open any of the old access files. ... (more) |
| 2003 Upgrade (by Confused on 19 May 2004, 1 reply) |
|---|
|
I'm running (or believe to be running) Office XP and tried to install 2003 Access upgrade. It could not find Office on my hard drive and stopped the installation. Do I need a different version of Access (i.e. not the ... (more) |
| Updating Record (by Joyce O on 19 May 2004, 1 reply) |
|---|
|
I have a database with over 20,000 records. Occasionally I need to update a single record. My users do not have access to the tables and only use forms. I want to create a form to update a single record, but my Mastering Access ... (more) |
| Creating a "Version 2.0" (by RKumana on 19 May 2004, 2 replies) |
|---|
|
I developed an Access database about a year ago (with much help from the MVPs - thanks!). After using it this year, I have come up with a number of different problems with the intial table and data structure and want to ... (more) |
| Data Access Page Help (by Scott on 19 May 2004, no replies) |
|---|
|
Is it possible to add a button to a data access page that sends and email when someone adds a new record? Thanks For the help. ... (more) |
| Access 2000 database Changes to Read-Only (by ChrisCEXP on 19 May 2004, 1 reply) |
|---|
|
Database sits on a network drive and for some reason modifies itself to be a read only database. No changes are made it just changes to read only. Has done so the last two days. ... (more) |
| text format to date format (by macamarr on 19 May 2004, 2 replies) |
|---|
|
Hello I import a file using the Import Wizard Advance. When I tried to make the date field Date/Time Format I recieve Type Conversion Errors. So I bring the date in as text. I use an input mask for date and that works. What I ... (more) |
| Creating a seperate database in VBA (by Ryan on 19 May 2004, 2 replies) |
|---|
|
I was wondering if there was a way to create a seperate database in VBA code. What I'm wanting to do is create the database, then populate it with certain items using the TransferDatabase method. Any suggestions are welcome. ... (more) |
| Separating Data In A Field (by Mark on 19 May 2004, 1 reply) |
|---|
|
I just started working for this company and they have this database that they use for their employee's files. In this database they have a field called "Comments" in which they have put all types of information in, like vacation ... (more) |
| Best Format to record time used in calc (by JB on 19 May 2004, 4 replies) |
|---|
|
What is the best way to capture time so that it's captured/entered as HH:MM:SS but it will be used in a calculation such as: [Mass]/[RunTime] ... (more) |
| LN5 to LN6 Emailing (by Joe on 19 May 2004, 1 reply) |
|---|
|
I have a number Access (2002) DBs that are set up to email reports in a .snp format. This works seamlessly (for over 2 years) with our Lotus Notes 5, but does not work with Lotus Notes 6. Our IT Dept says that this is an Access ... (more) |
| Access XP/2002 mail merge opens second instance of the database. (by Dean on 19 May 2004, 2 replies) |
|---|
|
I have a mail merge running in Access 97/Word 97 that works fine. It now has to run in an Office XP environmnet so I converted the database without issue and attempting running this mail merge in an XP environment. ... (more) |
| Notify user in Access (by djabra31498@yahoo.com on 19 May 2004, 1 reply) |
|---|
|
Is there a way to send a message to users that have an Access 2K db open that it is going to be shutdown ... (more) |
| Drive access denied (by Jerry on 19 May 2004, no replies) |
|---|
|
Unable to read/access the cdrom drive. Removed existing drive and installed a new one and still get "d:\ Is Not Accessible Access is denied" User has admin. rights and device manager shows no problems. "My computer" shows ... (more) |
| Please look at code. I think im missing something simple. (by Greg on 19 May 2004, 5 replies) |
|---|
|
Hi, Thanks for the help on my previous question, it worked very well. ... (more) |
| Setting Up Wizzards Message (by Joyce on 19 May 2004, no replies) |
|---|
|
With 1 particular database (Access 2000) I keep getting a message at screen bottom "setting up wizards...." The database will run just fine, however I cannot close ... (more) |
| Address Labels (by Mark on 19 May 2004, 1 reply) |
|---|
|
I am using the label wizard to create Avery labels of names and addresses I am retrieving from a query. However, I keep getting a blank label between every good one. It acts as though the data is too long and creating another ... (more) |
| Snapshot Viewer (by Cherly on 19 May 2004, 3 replies) |
|---|
|
I am trying to install Snapshot Viewer on my boss's laptop- I have installed this program in the past and have had no problems. I go through the installation process and everything looks to run fine- when I try and open a ... (more) |
| Linked Table Manager (by Eyespec on 19 May 2004, 2 replies) |
|---|
|
I am getting an error when I try to run my Linked Table Manager. It is "Invalid procedure call or argument". This just started happening. It was working fine. I tried restarting my computer but I am still getting the same ... (more) |
| MS Access Reader/Viewer for Windows (by Ewa Wdzieczak-Smering on 19 May 2004, 12 replies) |
|---|
|
Does anyone know of an application that would allow me to view the mdb files? Or maybe there is something offered by a third party that would do the trick? ... (more) |
| Trouble converting .mdb to .mde (by John Reichard on 19 May 2004, 1 reply) |
|---|
|
I have a front-end database that I'm trying to convert to a .mde file. When I try to save it as a .mde file, I get an error message that says "Error in Loading DLL". I am not using any Visual Basic code or Modules. Everything ... (more) |
| escaped HTML in table record (by Mike Stumpo on 19 May 2004, no replies) |
|---|
|
I have posted this question in the FrontPage newsgroups with no solutions. I have a javascript plugin that replaces the text area ... (more) |
| Line Chart with more than 6 fields (by MMD on 19 May 2004, no replies) |
|---|
|
Is it possible to create a Line Chart in a form using more than 6 fields? Thanks ... (more) |
| Remove decimal from number (by MA on 19 May 2004, 1 reply) |
|---|
|
What is the best way to remove the decimal from a number? Convert 123.30 to 12330 ... (more) |
| Books on Access (by John431 on 19 May 2004, 1 reply) |
|---|
|
What are the best books on this database program? I am particularly interested in understanding all the listed properties available for tables, queries, forms, reports and their objects. ... (more) |
| Viewer/Reader for MS Access (Wintel platform) (by Ewa Wdzieczak-Smering on 19 May 2004, 2 replies) |
|---|
|
Does anyone know of an application that would allow me to view the mdb files? Or maybe there is something offered by a third party that would do the trick? I am not interested in the app offered by MS... according to its website, "The ... (more) |
| auto advance (by cbmmed on 19 May 2004, 1 reply) |
|---|
|
I am trying to create a form that after a field has been entered the cursor automatically jumps to the next field (without having to use tab or enter). For example my first 3 fileds are 1) and 8 character text field, another 8 ... (more) |
| recieving no data, will not refresh (by GTP on 19 May 2004, 2 replies) |
|---|
|
Can someone help me with a refresh on my 3rd dropdown? When I go through all three drop downs and then want to go back through the dropdowns once again, only the first two will refresh and the third has no information. ... (more) |
| Print Design View? (by Mike on 19 May 2004, 3 replies) |
|---|
|
Hi All; Is it possible to print the Design View of a table? ie. Field Name, Data type, Field Size, Indexed, etc. ... (more) |
| newbie questions on Access (by Danny Ni on 19 May 2004, 3 replies) |
|---|
|
Hi, (1) Is there a way to use ADO to create "Link Tables"? Or is ODBC the only way to go? I went to File, Get External Data, Link Tables, I only saw ODBC. ... (more) |
| backend db (by ted medin on 19 May 2004, 7 replies) |
|---|
|
1. openrecordset( ... , table ) no longer works with linked tables 2. Keys no longer work like: rstMember.Index = "sheet1mem#" or rstMember.Index = "primarykey" ... (more) |
| newsletter (by Dieter Spix on 19 May 2004, no replies) |
|---|
| Newsletter abonnieren ... (more) |
| Expanding lists (by Danny J on 19 May 2004, 1 reply) |
|---|
|
Hi all, I am trying to create a basic CRM database which links customers to what they last ordered. To do this I would like to create a table (I assume) in ... (more) |
| error 3051 (by Hcoms on 20 May 2004, no replies) |
|---|
|
Hello, I have linked excel documents into an access 2k database . When the actual excel file , that has a linked table in access, is open in Excel it is not ... (more) |
| Help (by Ken on 20 May 2004, 3 replies) |
|---|
|
I have 4 drop down boxes with 7 choices in each box to choose from. I want our users to just choose one of the choices from each box, and not be able to add any information along with that choice. In other words just give them the ability to choose a selection and that is it. Not being able to add any ... (more) |
| Outlook user property (by John on 20 May 2004, 1 reply) |
|---|
|
Hi I am trying to open a new outlook message and add a user defined property to it, from within MS Access using the below code. I am getting an 'Object ... (more) |
| Default File Format (by =?Utf-8?B?TG9ycmFpbmU=?= on 20 May 2004, 1 reply) |
|---|
|
Access 2003 is installed with the default file format set to "Access 2000" format for compatibility reasons. Once everyone in our organization is on Access 2003, should this value be changed to "Access 2002 -2003" format? If so, is there a registry key that we can set or run the CMW to change it? I do not see anything in the CMW. Lorraine ... (more) |
| Eliminating duplicates (by =?Utf-8?B?YmM=?= on 20 May 2004, 4 replies) |
|---|
| I find that I can eliminate duplicates in a table, but I want to be able to tell Access which records to keep as the remaining duplicate. For example, I have a Field called Cust Number that has many duplicates that I want to wittle down so that a customer is not listed twice. But I want the customers remaining to be associated with another Field with a specific value (number) in it. I want it to keep all customers that also have a value of "3" in another field in the record. ... (more) |
| Access 2000 vs 2003 (by Ron Boetger on 20 May 2004, 3 replies) |
|---|
|
Is there a Data base file format change between Access 2000 & 2003? I have a customer that just purchased a new computer that came with Office 2003 pro. There other computers are running Office 2000 Pro. ... (more) |
| Access 97 on Windows XP: error in VBA running (by CW Chan on 20 May 2004, no replies) |
|---|
|
After installing Access 97 on Windows XP Professional, it cause application error in running VBA on modules. When click 'Modules' tab and press 'Design', it also shows this error. ... (more) |
| Access 97 problem on Windows XP (by CW Chan on 20 May 2004, 2 replies) |
|---|
|
After installing Access 97 on Windows XP Professional, it shows application error when running VBA or after clicking Design button on Modules tab. ... (more) |
| How to reference Combo Box ? (by =?Utf-8?B?Q2hyaXM=?= on 20 May 2004, 3 replies) |
|---|
| I have a combo box control with 2 columns. How can I reference to the columns? Is it the same as list box? Appreciate someone can show me the codes. Thanks. ... (more) |
| ending a macro (by =?Utf-8?B?aW1iYWNrZA==?= on 20 May 2004, 1 reply) |
|---|
| need help using the iif function....is it possible to end a macro in the true part or false within the iif? ... (more) |
| OLE Server error - ADP Access 2003 (by =?Utf-8?B?VGFpbGRyYWdnZXI=?= on 20 May 2004, no replies) |
|---|
| I get the OLE server error when working in text stored procedures (ADP - Access 03) Which Active X control should I be looking for - no Norton Antivirus installed ... (more) |
| Calculating number of workdays (by johnbg on 20 May 2004, 2 replies) |
|---|
|
Can anyone help me out? I want to calculate the number of workdays/businessdays in a certain time interval. The DateDiff expression only counts the number of calenderdays. ... (more) |
| How to detect whether a Form is Open... (by John F Kappler on 20 May 2004, 1 reply) |
|---|
|
I'm in FormB, which was called by either FormA1 or FormA2. I now want to close FormB (I know how to do that) and to Refresh (I know how to do that too!) either FormA1 or FormA2 depending on which ... (more) |
| Cannot view detail section of the form in form view (by =?Utf-8?B?dGVycnkuY29t?= on 20 May 2004, 2 replies) |
|---|
|
Hi I have designed a form but the problem is I cannot view the detail section of the form in form view,the header and footer sections are ok.I have tried every other option mentioned in the help but nothing has happened . ... (more) |
| change color of the stacked bar graph (by hin on 20 May 2004, no replies) |
|---|
|
Since there are two bars, how can I change the color of my last bar graph? ... (more) |
| Newsgroup Index | first | prev | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | next | last |