| News Index | prev | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | next | last |
| EMAIL COSTS (by Rohan on 08 May 2004, no replies) |
|---|
| Get A lycos Account for free ... (more) |
| autonumber weirdness--help (by Xenophobe on 08 May 2004, 7 replies) |
|---|
|
I have a table with a unique autonumber ID column. The table contains about 1000 records. Recently the autonumber column value got changed to something less than the highest value. This generates a runtime error when attempting to insert a new record because the ID column value must be unique. ... (more) |
| PATH NOT FOUND, AND THE FILE IS PHYSICALLY THERE (by =?Utf-8?B?SzI=?= on 8 May 2004, 2 replies) |
|---|
|
I'm running a program that writes to the database and is used extremely heavy each hour. The database is being updated 24 hours a day and is starting to get very large. About once a week the program will pop up an error message that says that the path to the .mdb file cannot be found on the server. The file is physically there though, i've checked. I've heard from people running similar programs that the database is not supposed to handle the amount of traffic that is being put through it. Therefore it's crashing the program. They've said that by deleting a large number of the records will help solve the crashing problem. Has anyone else heard of anything like this or know anything like it? Anything would be greatly apprecitated. ... (more) |
| counting unique values across multiple worksheets (by =?Utf-8?B?R29yZG9uIFdhbHNo?= on 8 May 2004, 1 reply) |
|---|
|
I am trying to count the number of occurances for a unique value (0) in the same column/row (F12) across multiple worksheets within a workbook but cannot find a formula that works. Any help would be appreciated. Thanks in advance ... (more) |
| Watermarks in Access? (by =?Utf-8?B?R3JlZWJv?= on 8 May 2004, 1 reply) |
|---|
| I know it can be done, but how? ... (more) |
| Help Creating A Table Structure (by PR on 8 May 2004, no replies) |
|---|
|
I am trying to create a table that will allow me to structure a knockout tournament. So what this is I am starting with 64 entries going to 32, then 16 etc. I do ... (more) |
| Count in Joined queries (by Draya on 8 May 2004, no replies) |
|---|
|
I have the most puzzling problem Using Access 97 (my client wont update to a newer Access Version at this time) I have the data portion of my database on a win2000 server. I have the interface which contains my queries on several different machines ... (more) |
| receiving e-mail (by Lynne Medders on 8 May 2004, 1 reply) |
|---|
|
When I receive e-mail in Outlook - I reveive two of the exact same e-mail. How do I stop this? Thanks for any help. Lynne ... (more) |
| Install Access 2000 Upgrade to New PC (by Lloyd Levy on 8 May 2004, no replies) |
|---|
|
My old PC had Office 2000 Basic. I added Access 2000 Upgrade. My new PC has Office 2003 Basic which doesn't qualify for install of Access 2000 Upgrade. Is there a way around this? I have the Office 2000 disk and the ... (more) |
| Occasional Lockup problem (corruption?) (by Noel on 8 May 2004, no replies) |
|---|
|
Hi. I posted something similar to this recently, thinking it was corruption, but I got no response. Things have clarified a bit now, so I hope someone can help. The problem occurs as an occasional lockup when I try to ... (more) |
| Exporting multiple objects (by Noel on 8 May 2004, 4 replies) |
|---|
|
Hi, further to my earlier post (Occasional Lock Up Problem), Ive been reading some old posts and links that sometimes recommend creating a new blank mdb, then copying all the objects from a suspect corrupt one into ... (more) |
| can i use an if then statement? (by anonymous on 8 May 2004, 1 reply) |
|---|
|
i want to do a calculation that works out a percentage discount but the customer will only get the discount if he/she buys X amount of goods, i know i could do this with an if then else endif statement but i dont know if i ... (more) |
| Updating project/db (by Mike J on 8 May 2004, 2 replies) |
|---|
|
Is there an easy way to update the project at a "customer" site with the newly updatedn project I worked on at my sit? IE. My customer has the db but there were a few bugs that I fixed on my computer. The only way I update it now is ... (more) |
| new computer (by pat mckinney on 8 May 2004, 2 replies) |
|---|
|
I have a registered copy of access on my laptop. I bought a new one and cannot find my disk. I have the registration code. How do I get another copy so I can load onto my new computer ... (more) |
| Error (48) in loading DLL when opening switchboard (by Caa on 8 May 2004, no replies) |
|---|
|
My file is a 2000 Access database. I have MS Windows XP Professional, uses Access 2002. I created some Macro's and a Switchboard from my database file and when I attempt to open my switchboard I get an error 48, in loading DLL ... (more) |
| Could not find installable ISAM? (by A. Barabus on 8 May 2004, 1 reply) |
|---|
|
Hi all, I got this error msg when my program read some data from the text file. I have followed the solution in the page. ... (more) |
| ** Help with queries or reports (by GabrielG on 8 May 2004, 2 replies) |
|---|
|
Hello everyone , I have a little issue to setup a database. I created a table with approximately 20 columns. The columns have an entry of Yes or no base on a questionnaire from survey. What can I do to get a result of my table I would ... (more) |
| Command Button Wizard (by Burl Stafford on 08 May 2004, 1 reply) |
|---|
|
I am running Access 2003. I cannot get the command Button Wizard to work. Any suggestions. Thank you ... (more) |
| help! need y-axis name (by on 08 May 2004, no replies) |
|---|
|
Hi I have a chart in my report. ... (more) |
| relating tables generated from a make table query (by rguidice on 8 May 2004, no replies) |
|---|
|
I've written a database to track information in a casino gaming school. There are times during the year when all 1000 people contained in the database must be enrolled into a class. I want to avoid having to enter a class designation to each student, but would rather do it all ... (more) |
| Convert list to string for text control (by Dawn Pensiero on 08 May 2004, 1 reply) |
|---|
| How can I create a text control the lists a recordset comma-delimited? ... (more) |
| Trouble installing firewire card (by Charles Chattell on 8 May 2004, 1 reply) |
|---|
|
I'm having trouble installing a PCI IEEE 1394 Adaptor card in windows xp, get the message New hardware found, followed by new hardware installation wizard, I follow instructions, then get the message " There was a problem installing this hardware IEE 1394 Controller an error occurred during the ... (more) |
| ajuda (by Manoel de M leite on 8 May 2004, 1 reply) |
|---|
| nesesito de ajuda ... (more) |
| problem with custom toolbar & switchboard in A2002 (by Silvester on 9 May 2004, no replies) |
|---|
|
I have an app developed with A2000 which I am now testing on different windows platforms and access versions. My app has a custom toolbar and a standard access switchboard created with ... (more) |
| Getting a value from a table to display on a form??? (by Peter Taylor on 9 May 2004, 3 replies) |
|---|
|
I have a form called frm_bookings and on it is a subform called frm_sub_clients. I have 2 tables called bookings and clients (each form associated with each ... (more) |
| IE LINKS ON MAIL SERVER SOME TIME WONT OPEN (by =?Utf-8?B?Q09GUkVTSQ==?= on 9 May 2004, no replies) |
|---|
|
IF I TRY TO CLICK ON A LINK IN MY E/M PROGRAM, JUST THE PAGE AND BROWSER OPENS BUT NO CONNECTION LOADING UP THA PAGE.... IN OTHER PROGRAMS IT OPEN CAN YOU TELL ME WHAT'S GOING UP ? GRACIAS ... (more) |
| Importing (by skip on 09 May 2004, 3 replies) |
|---|
|
Hi, I need some help and even some guidenes to where I can find some information. I have approximatley 250 files that were develped form a program tha made the files into "csv" files. My supervisor wants me ... (more) |
| Re: Error 429 (by =?Utf-8?B?TWFyayBI?= on 9 May 2004, 2 replies) |
|---|
|
Hi, I am having the same problem only using Acess 2002 in a Windows xp version. Can you please help me as well. I have tried to register the DAO dll using regsvr32 using tools and xcontrols but the dll file was not listed. Please help!!! ... (more) |
| Simple things but getting stuck on. (by StargateFan on 09 May 2004, 9 replies) |
|---|
|
It's been so long since I've used Access that it's been rough going <g>! I've been using the Northwinds example and over last few days I've ... (more) |
| How to format a date. (by Julian Milano on 9 May 2004, 4 replies) |
|---|
|
I have a database which has dates in all sorts of formats, 2-digit, CaseStats: IIf(IsNull([DateClosed]),"[ CASE OPEN ]",[DateClosed]) It looks for a null date field and replaces the nulls with "[ CASE OPEN ]". ... (more) |
| Printing the names of the records (by Frederik Goerlandt on 9 May 2004, 1 reply) |
|---|
|
Hello, does someone knows how I can print a list with all the recordnames of a specific table? When I now open a table and press the print icon, he prints ... (more) |
| background color (by JIM.H. on 9 May 2004, 1 reply) |
|---|
|
Hello, In a tabular form, how can I change the background color of the current record on the fly? With this I am trying to highlight the current record in the form, if there is ... (more) |
| Linking Tables across DB's (by Mike J on 9 May 2004, 2 replies) |
|---|
|
I was told to seperate my tables from my forms, queries, from the copy and deleted the tables from the original. When I go to 'get ext data' and try to link, no tables show up in the copy. If I try to import from the copy, no ... (more) |
| Converting To Stand alone Runtime? (by anonymous on 9 May 2004, 2 replies) |
|---|
|
Is there any place I can download the files *Legally* to convert my Access database to a stand alone program? Do I have to buy the entire Developers package just to do ... (more) |
| Set date range in report (by talib on 9 May 2004, 2 replies) |
|---|
|
In my access 2000 database i have a report that is run quarterly. It has numerous fields that to calculate based on different date fields, e.g., referral date, admission date and discharge date. Every quarter I have to go in ... (more) |
| Parameter query (by Ray on 9 May 2004, 3 replies) |
|---|
|
Is there a way of creating a pull down menu of specific paramaters (ie names)that are already in the adta base so that you do not have to type in the query string you want all the time? ... (more) |
| Database Splitter (by Oli on 9 May 2004, 5 replies) |
|---|
|
Hi I have splite our database into front end and backend. The backend has been placed on a remote server (as we have multiple locations) which I am an ... (more) |
| Combo boxes (by Ewar on 9 May 2004, 2 replies) |
|---|
|
I have a form with a Combo box (Customers) then a Sub form with another Combo box (Clients). Each customer has its own set of Clients. Problem how do I get to show only the Clients for the Customers selected. ... (more) |
| Import access to another access (by Tung Dang on 9 May 2004, 7 replies) |
|---|
|
Hello, I have 2 users working on the same access database, some how they are not getting the same information they have entered. I wondering of how to import the work she has done to the original file so all the work she has done can be import to the same database. Thanks ... (more) |
| Page setup reset to default (by hlam on 09 May 2004, 1 reply) |
|---|
|
I have a report that is set to 3 columns. It is reset back to its default each time after the 1st time is run. Does it matter that a query was executed before the report is run? What is the work around method? ... (more) |
| coversion error table and user defined functions (by Richard Rosell on 09 May 2004, no replies) |
|---|
|
I am using access 2003 and Excel XP. When I import or link into access from Excel I get a conversion error table for fields that have user defined functions. Is there a way I can remedy ... (more) |
| Salam Dear (by Mr.Tehseen Mohmand on 9 May 2004, no replies) |
|---|
| Helooooooooo dear n sweet Tehseen Mohmand ... (more) |
| Another newbie question (by Maggic on 10 May 2004, 3 replies) |
|---|
|
Hi again ... I'm mad at myself because I should be able to solve this myself <sigh> I have a date field on an input form called "DateEntered" defined as ... (more) |
| Re: MY QUESTION (by fredg on 10 May 2004, no replies) |
|---|
|
Well I doubt if you will get it here. 1) Posting in newsgroups in ALL CAPS is considered shouting, and most of us don't like to be shouted at. ... (more) |
| Comparing two Access tables (by =?Utf-8?B?THlu?= on 10 May 2004, 9 replies) |
|---|
|
My project requires double data entry - stipulated in the protocol. How can I compare two tables to check for any differences? Is there a neat way of doing this without having to produce a horrendous query? Any suggstions? ... (more) |
| Copy Unbound OLE Object to New PowerPoint Slde (by David G. on 10 May 2004, 3 replies) |
|---|
|
1. Prompt the user for destination PPT 2. Insert a blank page at the end of the presentation 3. Copy / Transfer the chart to the new slide ... (more) |
| splash screen (by =?Utf-8?B?UGFuZ28=?= on 10 May 2004, 3 replies) |
|---|
|
I have created a splash screen for my database by creating a bitmap file .bmp ,giving it the same name with my database and storing them in the same directory. Now whenever the database is open, the .bmp file opens first. My problem is that i want to delay it to 1 or 2 seconds before is vanishes, Is that possible? ... (more) |
| Please Explain (by =?Utf-8?B?a3dfdWg5Nw==?= on 10 May 2004, 3 replies) |
|---|
|
To All When is it neccessary to complie your code in Access? ... (more) |
| Duplicate query (by =?Utf-8?B?SmVubmlmZXIgTGVlbg==?= on 10 May 2004, 1 reply) |
|---|
|
Hi, I used a Find duplicate query to find students with the same address. Is there any way to assign the students with the same address a unique family number. So in other words, once it finds the students with a duplicate address could I run a script that would give them a unique family number ... (more) |
| Mixed formatting in Access text field (by =?Utf-8?B?Um9iZXJ0?= on 10 May 2004, 2 replies) |
|---|
|
I have been using Access for over a decade and have suggested repeatedly that it should be upgrades so that one could at least apply limited mixed-formatting within a text field. So far no luck. Although I have Office XP I using Access for Office 2000. Does anyone know some way that one can add limited formatting, such as italics, bold and underlined to specific words within in a memo field? Now, one must format everything within a field uniformly. However, for my research, I am often inserting data in which selected words are should be written in italics. Any suggestion would be appreciated. Thank you. ... (more) |
| "Lost" Contact Data (by =?Utf-8?B?Sm9obkx1dGU=?= on 10 May 2004, 1 reply) |
|---|
|
In the course of adjusting table relationships my Contacts became "detached" from their relative Suppliers. I've corrected the relationship problem. How can I reattach my Contacts to their Suppliers? Thanks! ... (more) |
| Showing last record (by =?Utf-8?B?UGFuZ28=?= on 10 May 2004, 1 reply) |
|---|
|
I have a form named Notes and has a field named [NoteNumber] .when it opens it takes the user to add a new note. But I want to have a testbox where i want to display the last note number. What sould be the code for that? Any help is appreciated? ... (more) |
| difference in months (by =?Utf-8?B?bWlrZQ==?= on 10 May 2004, 3 replies) |
|---|
| can anyone tell me how to calculate difference in months (interval) down to the fraction of a month? ... (more) |
| Combo Box (by =?Utf-8?B?Sm9obkx1dGU=?= on 10 May 2004, 2 replies) |
|---|
|
My primary key is a combo box in the table and form. In the form, how can I select an item from this combo box and have the complete record appear? Thanks! ... (more) |
| Help menu (by Paul J Weber on 10 May 2004, no replies) |
|---|
|
When I click on Help in Access 2000 instead of the Help Menu opening up, only the title bar shows up. Of course when I double-click the title bar, the full menu opens up. ... (more) |
| netdde.exe (by =?Utf-8?B?QnJlbmRh?= on 10 May 2004, 1 reply) |
|---|
|
I'm getting and access error and don't know where this file came from..It started when I download panda..I run novell and have WIN 98..here is my win.ini file can you help me get rid of this? [windows] load= run=C:\PROGRA~1\INTERN~1\NETDDE.EXE;C:\PVSW\BIN\NETDDE.EXE;C:\NOVELL\CLIENT32\NETDDE.EXE;C:\WINDOWS\NETDDE.EXE;C:\WINDOWS\COMMAND\NETDDE.EXE;Z:\PUBLIC\NETDDE.EXE;Y:\LOGIN\NETDDE.EXE;C:\WINDOWS\SYSTEM\NETDDE.EXE ... (more) |
| Need to Query totals (by =?Utf-8?B?R2FybGluZw==?= on 10 May 2004, 2 replies) |
|---|
| I am developing a database and need to do calcs. on table values. For example, Table 1 value (400) Table 2 vaule (600) need to subtract these and enter them in Table 4 value. I have tried using differant explressions and get back either 0 as totals across the query or nothing in the query results. Any ideas on what I can try. ... (more) |
| One More Question on Parameters (by =?Utf-8?B?U0NITllERVM=?= on 10 May 2004, 1 reply) |
|---|
| I have an access database with multiple forms and queries. Almost all queries use a parameter to view information on what they have. Without using data access pages and cookies, is there a way to continuously have the parameter stick on all paramter queries until the user requests a different parameter? This would solve the issue of typing in the same paramter multiple times, any thoughts? ... (more) |
| IIF Statement (by =?Utf-8?B?YmRlaG5pbmc=?= on 10 May 2004, 3 replies) |
|---|
|
How would one write the IIF statement for the following? If a check box is selected on a form and tied to a field cancel and I would like to produce the words cancel in a report. ... (more) |
| Calculating Reports text fields (by =?Utf-8?B?SmFzb24=?= on 10 May 2004, 1 reply) |
|---|
|
I'm having difficulties doing something that should be simple, and it may be I just am missing something. Any help would be appreciated. I have a report with various subreports on it, all with different queries as the control source. In the main report I would like to calculate the totals stored in a text box for each of the subreports. ... (more) |
| News Index | prev | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | next | last |