| News Index | prev | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | next | last |
| HELP!! Error1004: "Application-defined or object-defined" (by jj on 6 May 2004, 4 replies) |
|---|
|
Hi, all. I try to write to Excel from Access 2000 Form. The Excel locates in network, and the Adp application ... (more) |
| Pivot tables in Access - Conditional Formatting? (by Tim on 6 May 2004, 4 replies) |
|---|
|
HI I'm currently converting a spreadsheets that over grown, into an Access database. Ont he old XLS, there was a ... (more) |
| Whats the score with Concurrency? (by Tim on 6 May 2004, 2 replies) |
|---|
|
Hi How many users can Access handle? Everyone I work with is convinced its 1 - therefore if you need a database for ... (more) |
| Sharing database on network (by Kathy on 6 May 2004, 5 replies) |
|---|
|
When I try to split a database to share on network (a shared folder on my computer) the other users get a message "(filename) isn't a vaild path. Make sure that the path name is spelled correctly and that you are connected ... (more) |
| Exporting txt files (by len on 6 May 2004, 4 replies) |
|---|
|
I am having an issue with exporting a date field to text. The date field in access is set to mm/dd/yyyy but that is for display only. when exporting the date I get the date and time. ... (more) |
| Start access by asking for sql server login (by Tina on 6 May 2004, 1 reply) |
|---|
|
I have a need to start access by having users login with their userid/pwd (this should be authenticated against sql server database). ... (more) |
| Disable Internet access for users (by Zob on 6 May 2004, 1 reply) |
|---|
|
How can I disable internet acces for only one users on XP? Tx ... (more) |
| Lost Focus/Last Key ENTER ? (by Dave Ruhl on 6 May 2004, 2 replies) |
|---|
|
Hello, I want to know how I can tell if the ENTER key was hit to make a control lose focus (as opposed to TAB or a mouse click). I've tried the OnKeyPress event, but it doesn't get triggered by the ENTER key. I've also tried ... (more) |
| Getting source path of a linked OLE object field (by Elena Yudovina on 6 May 2004, 1 reply) |
|---|
|
Does anybody know how to obtain a path to the linked document which is stored in an OLE object field? ... (more) |
| Search for two fields match in two recordsets?? (by Jen on 6 May 2004, 2 replies) |
|---|
|
Hi All, I have two recordsets behind a button, one(rsttbl) is for a table: tblData, which has SubscriberID,ReStateDate, and FinishedFlag. another(rst) is for a query,which has ... (more) |
| corrupted database (by clifford zivi on 6 May 2004, 3 replies) |
|---|
|
My database is corrupted. It will open and I can un-hide the database window, but any attempt to open and of the tables, forms, modules, etc fails. I have tried a compact and repair. I have also tried to copy the individual ... (more) |
| Re: Very Very Urgent *** (by Tara on 6 May 2004, no replies) |
|---|
|
David, Thank you. -Tara ... (more) |
| Update Record (by suzie on 6 May 2004, 4 replies) |
|---|
|
I want to disable one field (e.g Identification Number) from being editing. When user has entered data and they want to update the other field, the can do so..but when they click at Update button, other field can be edited ... (more) |
| Access (by Richard on 6 May 2004, 1 reply) |
|---|
|
when I enter data into the Access 2003 database - it does not always show up - ie. it does not always add the new records. ... (more) |
| SUM times > 24:00 (by an on 6 May 2004, 2 replies) |
|---|
|
Hello! Please, How can I Sum times in Textbox of the Form, if sum>24:00? ... (more) |
| MSOhelp.exe causes error in Access only. (by S.B.H on 6 May 2004, no replies) |
|---|
|
I've been struggling with getting the help files in Access 2000 Premium to work. When you try to display help it returns the error "MSOhelp has generated errors and will be closed by windows." I've gone through the steps in ... (more) |
| Error: MSAccess has generated errors. (by =?Utf-8?B?aGFyZA==?= on 6 May 2004, no replies) |
|---|
| When I try to close a table, form, query, open a switchboard, I get this message. I have tried to uninstall and reinstall office to no sucess. can someone help me? ... (more) |
| Access Runtime Licensing (by PeteD on 6 May 2004, 2 replies) |
|---|
|
We purchased a runtime version of Access 2000 to be used for one of the access application developed in-house. What is the licensing usage for this product? Can I use this runtime for other access apllications developed? Can ... (more) |
| Table to collect information (by Dick on 6 May 2004, 2 replies) |
|---|
|
Can anyone tell me how construct a table that collects and retains annual imformation like dues without overwriting the previouse years entry. I'm lost - and can sure use the help Thanks ... (more) |
| OLE support for my old access data tables when converting to the new software. (by Carl on 6 May 2004, 1 reply) |
|---|
|
I run our college database on access and have recently updated the software. The problem is that I cannot view the jpegs that I have in my table with the new system. HELP!! ... (more) |
| Access 2003 & 97 on one PC (by tsanzone@mn.rr.com on 6 May 2004, 1 reply) |
|---|
|
I use Access 97 at work, I have 2003 at home. Can I have both versions installed on one PC so I can use 97 to develope and make changes to my work databse? ... (more) |
| Run Code with Shortcut Keys (by Byron on 6 May 2004, 4 replies) |
|---|
|
Using Access 2002, the old method for assigning a keyboard short cut to run a macro that inturn runs code does not seem to work, or I am just not doing it correctly. ... (more) |
| Mail Merge Form and Data (Word XP) (by Sharon on 6 May 2004, 3 replies) |
|---|
|
Hi, I have created a mail merge in Word with a DataSource. I would like to transfer this form and data to others ... (more) |
| ODBC (by =?Utf-8?B?TWFyaw==?= on 6 May 2004, no replies) |
|---|
|
Hello all, It has been a long time since I have setup a ODBC on my local machine. I am trying to get my local machine setup so that I can test and not have to do it on our web host site. I have XP Pro, and IIS running. ... (more) |
| Re: Access 97 (runtime) crashes on first run (by Sean on 6 May 2004, no replies) |
|---|
|
Are you firing up the MDE';s using a shortcut that gives the full path to msACCESS.exe (the 97 version) ??? "Pieter Wijnen" <wijnen.nospam.please@online.no> wrote in message ... (more) |
| Record Locking Error (by FroGG on 06 May 2004, 1 reply) |
|---|
|
I have a database running on Access 2000 and it is utlised by several users. The record lock is used on the form (edited records) to prevent users updating data on the same item. This was working fine for a week however, today the users were finding records locked that no-one was editing. It ... (more) |
| HELP PLEASE (by =?Utf-8?B?U3RlcGhlbg==?= on 6 May 2004, no replies) |
|---|
| 86 ... (more) |
| Remove the 'SPLIT' from a database (by =?Utf-8?B?RGlhbm5l?= on 6 May 2004, 2 replies) |
|---|
| Is it possible to 'rejoin' a database into one file after it has been successfully split? ... (more) |
| Disabling Shift Key (by =?Utf-8?B?U2FyZGFyIE1vaGFtbWFk?= on 6 May 2004, 1 reply) |
|---|
| Plz any clue for the subject problem ... (more) |
| Email links (by =?Utf-8?B?Sm9obkx1dGU=?= on 6 May 2004, 1 reply) |
|---|
|
I have an Email field in a form that is set to a text data type. How do I make this behave as an Email link so that clicking it will open a new mail in OE? Thanks! ... (more) |
| Service Pack 8 (by =?Utf-8?B?Qm9i?= on 6 May 2004, 8 replies) |
|---|
|
I just got Access 2003 and it says I need to install SP 8. Fine - I try to install with open - it seems to work but it doesn't. I download, turn everything off (virus protect etc) and the same thing happens. Please tell me what I am doing wrong. ... (more) |
| Possible? -- Multiple references to same footnote (by =?Utf-8?B?YWlnbmFjaW8=?= on 6 May 2004, 1 reply) |
|---|
| I'd like to refer to the same footnote (or endnote) more than once. That is, I cite a statement from a book and then site a different statement from the same book. Is this possible? ... (more) |
| How do I combine multiple names w/same address? (by =?Utf-8?B?c2J1cnJvdWdocw==?= on 6 May 2004, 1 reply) |
|---|
|
John Q. Public Jane Q. Public 123 Ace Drive Anywhere, TX 11111 ... (more) |
| Accessing Access from the network (by =?Utf-8?B?SmltIEQ=?= on 6 May 2004, 2 replies) |
|---|
|
We have Access 2000 running on a speedy XP Home "server" that is able to pull up a 400 MB database in about 2-3 seconds. When we access the database from workstations running 100Mpbs it takes about a minute to open up a query. This doesn't seem right to me. Anybody know why it takes so long to open it up from the workstations? I have 768 MB of RAM on my machine but it still takes way too long to access it. The server has 1 GB of RAM. Thanks for the help! Jim ... (more) |
| Completed Project Tracking Database (by =?Utf-8?B?TWFyY3VzIEhhcnRsZXk=?= on 6 May 2004, no replies) |
|---|
|
We like to have an MS Access database that allows us to track already already completed projects. While we could spend a bunch of time trying to figure out how to set up such a database, I'm certain such database have already been developed by users (or companies) more adept than I. Does anyone out there have any recommendation. 1) client information 2) project specific contacts for the client, ... (more) |
| Query/Table Update (by JGM22 on 6 May 2004, no replies) |
|---|
|
I am looking to design the following and would like any assistance. I have 4 tables. Vendors, Paper Size, Paper Weight and Price. The first thing I want to do is when the customer chooses the Vendor from ... (more) |
| Returning Record Numbers (by JoeGriffin on 6 May 2004, 1 reply) |
|---|
|
I have a table of records with client details. I am browsing this data through a form I created. I would also like to be able to include the record number of the record I am currently viewing in my form. Does anyone have any idead how this can be done. ... (more) |
| Refresh Links in code to database with Password (by Doug on 6 May 2004, no replies) |
|---|
|
Ok, I'm stuck. I have a main Access database with links to another. I have a routine that successfully resets the database link below. ... (more) |
| Access multiplying SQL data x 100?? (by Jerome on 06 May 2004, 1 reply) |
|---|
|
Hi, I've still got this problem that Access 2000 multiplies the decimal and currency values from my SQL Server database x 100! Both in the linked ... (more) |
| Re: Link table in code doesn't "take" (by Van T. Dinh on 6 May 2004, no replies) |
|---|
|
Hi Doug I think the Help topic is wrong. I have been using RefreshLink Method (in A2K2) to change the Connection String / Connect Property on ODBC-linked ... (more) |
| custom menu bars & switchboard don't work in access XP (by Silvester on 6 May 2004, no replies) |
|---|
|
I have developed an A2000 split & secured app. While testing it on A2000, it works fine. On Access XP however, none of the custom menu bar buttons or switchboard ... (more) |
| Re: Doing a query based on input from user (by Taffy-Taff on 6 May 2004, 3 replies) |
|---|
|
Thanks for the assistance. I obviously did not fully express what I I have a form that is populated with information based on a filtered table. The query to filter the table is working fine. The form is now populated with the first record in the filtered table. What I want to ... (more) |
| Search & replace (by TomStevenson on 6 May 2004, 1 reply) |
|---|
|
Does anyone know of an Access pluggin or a stand-alone program that will search & replace multiple databases? If not, is there an Access expert out there who could, for a mutally acceptable fee, write a script or an applet or whatever to achieve this? ... (more) |
| Printing PFD files (by Max Moor on 06 May 2004, 1 reply) |
|---|
|
Hi All, I'm wondering if there is a "best method" for making PDF printing available from within an Access 2002 application. By best, of course, I really mean relatively simple and free, or close to it. Can anyone give me ... (more) |
| Convert Access into ... (by Collegue on 6 May 2004, no replies) |
|---|
|
I have developed dictionary in Microsoft Access. Now I want to make this Dict in C++ or Visual Basic Does anybody have search engine source who can send to me. ... (more) |
| SELECT MAX(...) returns 0 (by Pascal Biston on 6 May 2004, 11 replies) |
|---|
|
Hi, I've the following problem : with Windows 98, MDAC 2.8, a program write in VB 6.0, used ADO recordset when I execute the following instance SELECT ... (more) |
| How is ADO/DAO affected when splitting a db? (by Julia Boswell on 6 May 2004, 4 replies) |
|---|
|
Apologies if this is a duplicate post. I've had a look through postings and found quite a lot on this subject but have ended up more confused than before! ... (more) |
| html in reports (by Mettá on 6 May 2004, no replies) |
|---|
|
Hi I have a memo field with html in it as say ... (more) |
| Adding a table to backend (by Silvester on 6 May 2004, 1 reply) |
|---|
|
Hi, I distribute my app as a secured mde fe and mdb backend. ... (more) |
| Input Masks for email and websites (by JMMach, MCSC on 6 May 2004, 1 reply) |
|---|
|
I'm trying to define an input mask form email data capture and website data capture. Using <\w\w\w\.AAaaaaaaaaaaaaaa.AAa for the website works OK, but the @ symbol in the email address is messing me up. ... (more) |
| Accessing an Exchange shared folder from Access (by LuKe on 06 May 2004, no replies) |
|---|
|
Hi, I'd like to know if it is possible to store an access database (and accessing it from an access application) in a shared folder on a server ... (more) |
| Re: Link table in code doesn't "take" (by Terry Kreft on 6 May 2004, no replies) |
|---|
|
Personally I would do it like this strConnect = "ODBC;Description=" & strDesc & ";DRIVER=SQL Server;SERVER=" & gstrSQLServer & ";UID=sa;PWD=" & strPWD & ";APP=Microsoft Open Database ... (more) |
| Help please with conversion (by jw5 on 6 May 2004, 5 replies) |
|---|
|
We have emailed Access 2000 to another computer running Access 2000 where we have had problems trying to use it for a merge. When we right click and under properties it say under 'Type of File' 04 File where I would have thought it should say MS Access. ... (more) |
| Price Variables Dependant on Quantity Purchsed (by jagstirling on 6 May 2004, no replies) |
|---|
|
If I have a table of customers and the prices they are charged for a product depending on the quantity they purchase (such as); 0-10 Items $1.00 ... (more) |
| Background Graphic (by Sean on 6 May 2004, 1 reply) |
|---|
|
I would like to place a picture on the ACCESS background. By Background, I mean the Access window that is visible when all other windows have been minimised. I acheived this in Access97 by using a fair bit of API code. ... (more) |
| Re: Link table in code doesn't "take" (by Terry Kreft on 6 May 2004, no replies) |
|---|
| I'm sorry Doug that is not the case. ... (more) |
| Viewing users accessing DB (by anon@hp.com on 06 May 2004, 3 replies) |
|---|
|
Hi There, I manage a few Access2000 databases over a corporate network and I was wondering if there was some sort of tool I could use to monitor who was ... (more) |
| Retrieving a Hidden Query (by Wendy L on 6 May 2004, 2 replies) |
|---|
|
Windows XP Office XP I'm new to using Access. I right clicked on one of my Queries and chose ... (more) |
| auto number in table (by Maileen on 06 May 2004, 1 reply) |
|---|
|
Hi, One of my fields in a table is based on Auto number (Auto Increment). After deleting, this field value can start on 6 or 2545. ... (more) |
| Date of Birth field anomolies (by Support on 6 May 2004, 2 replies) |
|---|
|
I have a table of over 81k lines. One field within this table is for date of birth (DOB). I'd like to set this as a date/time type (format: dd-mm-yyyy) yet when I do this it tries to delete some records (28k). I'm allowing no entries so I ... (more) |
| News Index | prev | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | next | last |