| News Index | first | prev | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | next |
| appending multiple tables (by anonymous on 1 Jun 2004, 1 reply) |
|---|
|
. Reply (E-mail) Forward (E-mail) Subject: Appending multiple tables From: "anonymous@discussions.microsoft.com" ... (more) |
| Jetcomp.exe Command-Line switches - Won't work. (by Wayne A on 1 Jun 2004, 4 replies) |
|---|
|
With Jetcomp.exe (vers 4), I used the "-?" (no quotes). It displayed a window showing all possible switches/params. But it doesn't show any examples. I've tried many combinations and still can't get this to work. Searched MS ... (more) |
| Bug in query (by Dana on 1 Jun 2004, 7 replies) |
|---|
|
Hi, SELECT Forms!form1![form1 subform].Form!CustomerID AS Expr1 ... (more) |
| ACID Compliance (by Emma on 1 Jun 2004, 4 replies) |
|---|
|
Is Access ACID Compliant? Thanks Emma ... (more) |
| Outputto and Excel (by Ricardo Coelho on 1 Jun 2004, 2 replies) |
|---|
|
Hi, I'm building a small code to export 3 queries to an excel file. I need it in 3 separate spreadsheets (and in a ... (more) |
| using Access on Palm OS (by David Langan on 1 Jun 2004, 2 replies) |
|---|
|
Hi, I'm thinking of running a small Access d-base on a sony clie nx80. I intend to have about a total of 30-40 ... (more) |
| report stop collecting data (by =?Utf-8?B?c2NvdHQ=?= on 1 Jun 2004, 2 replies) |
|---|
|
last night i added some new data and then printed my report, but the new data did not show up. I went in to the report to see if i could find it, but it wasn't there. its in my table, form, and querie. The only thing i havd done is make a backup of my data the night before. any and all help is thanked. scott ... (more) |
| Just upgraded to XP and having problems with Snapshot viewer (by =?Utf-8?B?SnVsaWVH?= on 1 Jun 2004, 4 replies) |
|---|
|
I have user that has just upgraded to Office-XP. He has created a report from a MS-Access database and wants to export into Snapshot. But he gets an error ' will not create, insufficient disk space to create temporary work files' clear some space. But he never got this error before? I think he has upgraded from W98. We have tried on another PC with 13mb of space and got the same error ... (more) |
| Fields in a Table (by =?Utf-8?B?TGlzYQ==?= on 1 Jun 2004, 1 reply) |
|---|
|
Hi, I am having trouble. I am trying to add more fields in my table and it is giving me an error message that I have too many fields. I found it on the Microsoft website were it said the max number of fields in a table is 255. But I don't have anywhere near that many! Can someone help! ... (more) |
| Email - Sending a Form (by =?Utf-8?B?S0Jlcms=?= on 1 Jun 2004, 1 reply) |
|---|
|
Is there a way to send a Form that has been created via email and to keep it in the same general format? Thanks!!! ... (more) |
| Structured Conditional Statements (by =?Utf-8?B?SmVycnkgVy4=?= on 1 Jun 2004, 2 replies) |
|---|
| Am having trouble with the correct syntax for "If...Then" and "Select Case" statements. Am not using correct punctuation somewhere. Example: Select Case [Usage] Case Is <=0 (0) Case Is >=90 (90) Case Else [Usage]. Any suggestions? ... (more) |
| Highlight text color does not allow text to be read (by =?Utf-8?B?SGFycGVy?= on 1 Jun 2004, no replies) |
|---|
|
Hi -- For some reason when I double click to select text in a text block the highlighted color is dark blue and I cannot read the text. It then changes to an empty looking box. After I start typing (blindly) the cursor and text appear. Have I accidentally made a setting that would cause this problem to occur and if so what can I do to fix it? ... (more) |
| Help! How to convert a math function (string) into a number (by JM on 01 Jun 2004, 1 reply) |
|---|
|
Hi, str = "exp(5)+sqr(4)" ... (more) |
| Password for folder (by =?Utf-8?B?SmFtaWU=?= on 1 Jun 2004, 1 reply) |
|---|
|
Hi, I have a folder in my program files on my c-drive. I am tryng to protect this with a password, but having some difficulties. Can anyone help me please ... (more) |
| Jerry W. to John Vinson (by =?Utf-8?B?SmVycnkgVy4=?= on 1 Jun 2004, 1 reply) |
|---|
| ThankU, ThankU, ThankU. You have saved me much headache from copying in XS, pasting to XL and importing back to XS. (XL was the only format I could use, using the "If" structure to do my calcs, as I wasn't having much luck in XS.) Whereinhell did you come up with the "Switch"? My 1300 page book "Using Access 97" by Que, with Roger Jennings, didn't even mention word one about this. Maybe now my hair will grow back again. Again, thank you. ... (more) |
| Access (by =?Utf-8?B?R2VvZmZU?= on 1 Jun 2004, no replies) |
|---|
|
i am using access 2003 and have started getting the folowing error message when trying to open a database = "set dbs=CurrentDb()" Compile error - Error in loading dll Anyone got any ideas? ... (more) |
| mdb file locked (by =?Utf-8?B?UmVuYXRv?= on 1 Jun 2004, 2 replies) |
|---|
|
Hi all, I've got a problem with a mdb file : everytime an user open it , another user who wants to open that db can't do that; the error message is 'impossible to lock the file'; I thought it would be because the first ... (more) |
| Processing (by =?Utf-8?B?TWFyZ2U=?= on 1 Jun 2004, 1 reply) |
|---|
| I have created and Access adp using a SQL Server backend. I know the queries are processed by the Server but what about the code behind the forms ? where is this processed my guess is client side. If so should I be using queries where possible and just using the RunSql command from the forms or how should I optomise performance.? ... (more) |
| sql server and jet in same project (by =?Utf-8?B?bWFkaG91c2U=?= on 1 Jun 2004, 2 replies) |
|---|
|
Hi using access 2003 adp mode. want main sql server database for central common data. want a separate MDB file (jet database) for each project. there maybe many hundreds of projects. ... (more) |
| Combo Box Using Queries (by =?Utf-8?B?TWF0dA==?= on 1 Jun 2004, no replies) |
|---|
|
Fred, Thanks for your help, but I keep getting a Syntax Error on (((Left([Name],1))<>"~") AND ((MSysObjects.Type)=5)) ... (more) |
| Use listbox value to open record in another form (by =?Utf-8?B?Q2FybmVnaWUyMw==?= on 1 Jun 2004, 1 reply) |
|---|
|
I have a listox called TenantList on a form called SelectAparment. I want to select a name on TenantList and click on a button that will open a separate form called TenantsForm where the name on the TenantsForm record matches the name in the TenantList listbox. Thanks. ... (more) |
| How can I clear the control Source property by code? (by =?Utf-8?B?SmVmZg==?= on 1 Jun 2004, 4 replies) |
|---|
| Does anyone know how to set the property? thanks ... (more) |
| Unbound controls on a form (by =?Utf-8?B?TWVnYW4=?= on 1 Jun 2004, 6 replies) |
|---|
|
I'm trying to create an invoice for my project. I need to look up prices on a price table before I can pull them into an invoice details table. I have to create a multi-table query which makes my fields not editable and/or doesn't display an area for me to type in if it's a new/blank invoice. I tried to use the Northwind and other samples, but I need to go back to my price table each time for the price, not the one in the invoice details table. Can I create an unbound form that only pulls in products and prices from a query, have an unbound contol for qty and another for extended price -- after all, just do an update query to populate invoice details? i'm open for suggestions. my two issues are different prices for different customers which have to be editable but always pulling from the original price and not overriding it. ... (more) |
| Help! How to evaluate a math expression (in text format) (by JM on 01 Jun 2004, 2 replies) |
|---|
|
Hi, I have an string with a math expression, example str = "Log(5) +3 " ... (more) |
| Re: ADMs again. (by Eric Fleischman [MSFT] on 1 Jun 2004, 1 reply) |
|---|
|
The best place for this sort of a question is with the Office guru's. I've added them to this thread. Office guru's, can you give us a hand with this one? ... (more) |
| Lanzar pantallla de aviso ante una fecha (by Gonzalo on 1 Jun 2004, 1 reply) |
|---|
|
Hola! Tengo una BD con datos de facturación. Me gustaría (ya que hay empresas a las que emitimos facturas "N" veces al año en fechas concretas almacenadas en la BD), que al llegar esa fecha, o un día antes, me avise de que ha llegado la fecha de facturación. Así me evitaría crear/lanzar una ... (more) |
| password related question (by SomSallyX on 1 Jun 2004, 1 reply) |
|---|
|
Hi I'm trying to write a simple viewer to display the tables and records in the MS Access database. ... (more) |
| Subforms-Intriguing question (by Chris on 1 Jun 2004, 1 reply) |
|---|
|
I need to display on the same A4 page more pages of the same report, and, after the A4 paper sheet is over to continue on the next A4 paper. Can I insert it more times as a subreport setting it for every insertion to display another consecutive page(and not to appear anymore if there are not ... (more) |
| Multiple parameters in Query from ASP? (by George Hester on 1 Jun 2004, 1 reply) |
|---|
|
I have the Query in the database it works. I get two windows that come = up; the first asking for the first paramater the second asking for the = second. The "SQL" looks like this (ADODB OLEDB Provider Jet 4.0 Access = 2000 format) ... (more) |
| Using Excel functions from within Access (by opeyemi1 on 1 Jun 2004, 1 reply) |
|---|
|
I posted this earlier, but I think I posted it in the wrong forum. I have the following query set up and it works well so far: SELECT Count([B&B No Negatives and Processing Time].[Processing Time]) ... (more) |
| Mathmatical Errors (by Scott Duncan on 1 Jun 2004, 4 replies) |
|---|
|
Basic Question, how can 566.3 - 565.5 = 0.7999878 ??? Underlying Tables are Singles and Form Control Format = "General Number" ... (more) |
| Events such as a Query (by George Hester on 1 Jun 2004, no replies) |
|---|
|
I have ASP which uses a stored Query in a Access 2000 database mdb to = update a table. I am only adding records. No changing information in = http://support.microsoft.com/?scid=3Dkb;en-us;198466 ... (more) |
| popups (by Daljit Singh on 1 Jun 2004, 1 reply) |
|---|
|
Can any one will guide me how to tackle with popups. unneccassary popups are coming into my system. Thanks for the help in advance. ... (more) |
| sorry - just one quick qn (by Andy Levy on 1 Jun 2004, 1 reply) |
|---|
|
My form has two IDs, a main ID and a secondary ID The main ID is an autonumber - so i can be sure that the number will always be unique. Even if the last entered record is deleted - its ID number will ... (more) |
| Record-Locking Error (by Matthew DeAngelis on 01 Jun 2004, 2 replies) |
|---|
|
I am experiencing a problem with a particular record in Access that is extremely persistent. I hope someone in here can help me. The database is split into a front and back end, although everyone on ... (more) |
| HELP!!!! Report with more pages on the same paper page (by Chris on 1 Jun 2004, no replies) |
|---|
|
I need to do a tabelar report with header and footer. For every change of each one of 2 of the parameters from the header, it is requested a new instance of the report on the same page (not on a new page, so I ... (more) |
| URGENT plz help - compact db w/ pass from command line (by John Smith on 1 Jun 2004, 1 reply) |
|---|
|
i try this " C:\>"c:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" /excl /pwd pass123 ... (more) |
| How do I move or copy my Contacts/Buddie List's ...what is the POP address for yahoo???and Hotmail??? (by Andrew on 1 Jun 2004, no replies) |
|---|
|
Andrew Is it possible to move my yahoo contacts/from an old screen name to a = new one on a new account???and is there a way to add them into my = windows mssnger address book? ... (more) |
| IE 6 question.... (by R Palino on 1 Jun 2004, 1 reply) |
|---|
|
What would be the proper newsgroup to get some support for ie 6? Most of the "iei" newsgroups seem to be for other countries/langauages. (I am in the US) ... (more) |
| Import Excel into Access 97 (by Brenda Hutton on 1 Jun 2004, 1 reply) |
|---|
|
I can't get an excel file to import into access. It takes me to a screen that says "Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience." Then it gives me the option to repair my open database and restart access. ... (more) |
| can't access outlook express (by choyaquinojr on 2 Jun 2004, no replies) |
|---|
|
I am a new user in outlook express and i don't know how to use and to set-up. When I beggan to use outlook express their always a message in the box saying....... "the host 'SMTP' could not found followed by some messages and on the second paragraph, it says.. "the host 'POP3 could not be found ... (more) |
| Newbie: Code to loop through all forms (by CJM on 2 Jun 2004, 6 replies) |
|---|
|
I need a simple bit of code to loop through all forms in a database (in excess of 150) and change some properties within those forms. I'm more a VB/Web developer so doing this in Access is all new to me! ... (more) |
| LDB file and locking (by Jan Kronsell on 2 Jun 2004, 5 replies) |
|---|
|
According to an earlier posting, I've found this: "It is only a small part of the LDB file that can be opened in Notepad. All of the locking occurs as locked byte ranges outside the physical dimensions of the file, sp ypu will never see it in notepad- Such apparently strange behaviour is made available ... (more) |
| check modified dates (by Richard on 2 Jun 2004, 2 replies) |
|---|
|
Hi Is there a way to check files modified date through access? ... (more) |
| outlook express (by john on 2 Jun 2004, 1 reply) |
|---|
|
I have a problem that just came up with outlook express it is only when I try and send myself an e mail. The e mail goes thru but it goes direct to the deleted files folder. I have no other problems sending and recieving e mails. ... (more) |
| HELP!!!!! Subreports (by Chris on 2 Jun 2004, 1 reply) |
|---|
|
I need to display on the same A4 paper sheet more pages of the same report, and, after the A4 paper sheet is over to continue on the next A4 paper. Can I insert it more times as a subreport setting it for every insertion to display another consecutive page(and not to appear anymore if there are not ... (more) |
| complications (by Thomas Lioces on 2 Jun 2004, 1 reply) |
|---|
| I can not get thru the jargon . New internet too technical ... (more) |
| Queries in a Dropdown (by =?Utf-8?B?TWF0dA==?= on 2 Jun 2004, 3 replies) |
|---|
|
Hey, I was wondering if there is a way to have the titles of the queries appear in a dropdown box, and then run a command button/report from the selection of the query. I tried the following code but it gives me every report, query, table, etc etc in my dropdown box. Is there a way to pick which queries I want in my dropdown? Thank you very much. ... (more) |
| Using a Mod Function in an Access query (by Ant on 2 Jun 2004, 2 replies) |
|---|
|
I am trying to calculate the remainder of a number after dividing by 12 e.g. 26/12 = 2 remainder 2. To do this in Excel is easy using the Mod Function but I cant seam to find the Mod function or similar in Access. Can any one help me out with how to do this in Access? ... (more) |
| 116dl.exe. (by mike gherkin on 2 Jun 2004, 1 reply) |
|---|
|
Help. window pops up saying " cannot find 116dl.exe. and later shuts down on its on. ... (more) |
| SQL SERVER migration wizard (by big on 2 Jun 2004, 1 reply) |
|---|
|
Hello I'm working with ACCESS97. In tools menu I have not SQL SERVER migration wizard. Is it natural ? How to install it ? If it is not possible ( only available in ACCESS ... (more) |
| Blobs in Access (by John K. on 2 Jun 2004, 2 replies) |
|---|
|
we have a DB field of type OLE Object. We are storing bytes of data (blobs).. we are running into the situation that everytime this field is updated, the DB grows.... I ran the experiment where I was saving 8,000 bytes to this ... (more) |
| Keeping Autonumber on re imported file (by Chris Tanti on 2 Jun 2004, 2 replies) |
|---|
|
I have had to address clean a table using software that required the file in XL (or csv) format. I exported the file from Access as an XL file and then ... (more) |
| Table: Conidtions Fields (by nl on 2 Jun 2004, 1 reply) |
|---|
|
In a table, how can I make a field accept/or not accept if theres a condition. Example: Field Adm=1, Field End=06/02/2004 (in this field the data is accepted only if Field Adm=1) If Field Adm=2, ... (more) |
| Design View (by I am stuck on 2 Jun 2004, 4 replies) |
|---|
|
I have a field with the below data:(Data Type Text) $2,000,000. ... (more) |
| Design view (by Rich on 2 Jun 2004, 2 replies) |
|---|
|
Which has the below values inserted. $2,000,000. ... (more) |
| 3075 error (by anonymous on 2 Jun 2004, no replies) |
|---|
|
I am using Access 97 with a major query/report/macro database written by someone 5 years ago that has disappeared from the face of the earth. It generates sales reports from Solomon software each month. ... (more) |
| Need MVP - (Error Report) (by Jim on 2 Jun 2004, 5 replies) |
|---|
|
I have a single file custom *.mdb database that was built in Access 2000 (along with Access 2000 VBA - laboratory application). We have several data entry persons and we upgraded their machines to Access 2003 to improve their ... (more) |
| Error Code -1504 (by -1504 on 2 Jun 2004, 1 reply) |
|---|
|
-1504 Field 'Description' could not be found. MS Access Version 2000 SR-3 ... (more) |
| Missing or broken reference (by Paula on 2 Jun 2004, 1 reply) |
|---|
|
I received the message "Your Microsoft Office Access database or project contains a missing or broken reference OLCH2X32.OCX version 6.0." I opened this in Office 2003 and the database was created in an earlier version. ... (more) |
| News Index | first | prev | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | next |