Group:  Microsoft Access » microsoft.public.access

Geek News

Threads Replies Last Post
1410 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>  
SharePoint
Hey Everyone, I know this isnt a SharePoint, but I wasnt able to find a group that was acive enough for me to get a relatively quick answer. And I'm a bit under the gun. So here goes, We have SharePoint 3.0 installed on our server. I am feverishly working now to deploy multiple solutions for my company. However, as I'm not an IT person, I'm not sure I'm being told the whole truth he...
18 12/31/2008 5:42:08 PM
Photo object in Access 2000 has lost the plot in 2007
Having migrated from A2000 to A2007 The XP photo editor 3 images stored as objects in my DB now still show up as MSphotoed.3 objects. That app is not available on my new Vista machine and I get the OLE server isn't registered message. Apart from the obvious re-inserting every image as a package - ouch! Is there a way to unilaterally point them to Vista's photo gallery? The option to ...
1 12/31/2008 4:54:02 PM
query - max ID number
I have a query that returns all the records with today's date. Within the query, I also return all the record Auto ID numbers. What do I need to add to this query so that it will only return the max auto ID number. For example - I only want line 1235 to show as it is the largest ID number. ID Date 1233 December 31, 2008 1234 December 31, 2008 1235 December 31, 2008...
2 12/31/2008 4:26:35 PM
multi-source odbc to single table
I have two sources of data. Server 1 and 2 that have the same type of data but for different stores. Right now I have to pull the data seperately and then copy and paste in excel to merge into 1 file. Makes the process slow. Is there a way to link both sources and essentially have them one on top of another. Another words pull them at the same time into 1 single linked table. ...
8 12/31/2008 4:16:08 PM
Northwind 2007 database explanation?
Is there a good explanation of the Northwind 2007 Database anywhere? Something besides the Access help features? ...
4 12/31/2008 4:11:52 PM
Run-time database
I have cerated one bibliographic database using Access 2003. I want to make a run-time version for this. Office 2003 Professional edition is installed in my computer. What should I do? With regards, -- nandini...
14 12/31/2008 4:08:15 PM
grazie mille avv
Le auguro buon anno a lei e famiglia. Mi fà piacere che si sia preso una pausa dalla routine quotidiana , anche perchè il suo lavoro è tutt' altro che facile . Domenica 4 gennaio parto per la romania una settimana . Quando ritorno ci sentiamo . Un abbraccio a lei e Sonia e un grande bacio a Flaminia . BUON ANNO ...
1 12/31/2008 3:32:37 PM
DCount error
I have the following DCOUNT on a form: =DCount("[QA Score]","Conversation_Table",Month([Date of Audit])=Month(Now()) And [QA Name]=[Auditor]) Looking to get a count by QA Name of audits completed in the current month. QA Score is a field in Conversation_Table that stores an integer. Date of audit should be self-explanatory. QA Name is the field on the form and Auditor is the fiel...
8 12/31/2008 3:30:12 PM
*Filtering within a report*
Hello. I think that this is an easy one, but I'm stumped. I have a couple of reports. On one report I want to filter by the date. I want a box to pop up when I click to open the report and then I can input the date that I want to find. In the other case I want to search by an identification number and only bring up the records for that id #. How do I do this? Emily...
5 12/31/2008 3:20:52 PM
Update a record if it exist
Hello, I've been looking through these posting for days to find a particular code that will allow me to do the following. I've created a data entry form "frmProvider" from a table "tbleStorage". So, whenever a user enter a record in the form, it gets saved to the table. Now, when the user do the entry and enters the "LastName" and "BillingTIN" on the form, I would love to than search ...
7 12/31/2008 3:09:01 PM
click ?
hi , i have list thet receive the data (contract no)from query its can be jest one contract. i cant update the table unless i click on the list box. what i can do to pass it ? -- golani...
2 12/31/2008 2:46:11 PM
attend messages
...
2 12/31/2008 1:58:54 PM
Imbed a word doc in a report
Hi Can I imbed a Word Doc into an access report so the printer sees it as one report - which is what I need to make the whole thing run. I have a report and a word doc I can print the report - includes personal details address etc, I can print the word doc via a simple small module and call - I used Word due to better formatting I can print them in the right order But :-( We hav...
3 12/31/2008 12:22:04 PM
Company Phone Directory: Showing Relationships
I am making a phone directory for my company. It is currently set up showing information on every employee. For the salespeople, it also shows who their secretary is. Now I want to make it so that for each secretary, it shows the salespeople they support. Each secretary can support two or three salespeople. I created a query showing Employee table, and added another instance of the ...
21 12/31/2008 12:10:53 PM
Multiple Selections in Listbox Code Error
I have written a code to allow multiple selections in a listbox. I keep getting an error message which states " You have cancelled the previous operation". Does anyone have any idea what this may be? I have checked the code many times and compared it to one which does work and it appears to be the same, but just can't get my head around this particular error message. Any advice would be...
10 12/31/2008 11:32:11 AM
search
I am salvation Frenc and I looking for a French or a person who speaks English and French who ecrit to discuss thank you! ...
1 12/31/2008 10:45:20 AM
Corrupt Data Base
Running Vista and Office 2007. I deleted a Access Data base file by accident. It is gone. I restored it from a backup. Tried to open it and got this message: "Cannot open c:\users\name\documents\file list.accdb May not be an application that your database recognizes or is corrupt" Went throught the help sections and that did not help at all. Could not find a "Access Database re...
3 12/31/2008 4:16:52 AM
Select only most recent payment
I'm using ACCESS 2003. I'm trying to run a query to list a contributor's most recent payment of multiple payments per contributor. Following is the query that I used: SELECT DISTINCTROW Contributor.NamePart1, Contributor.NamePart2, Contributor.Status, Payment.PaymentDate, Payment.Amount FROM Contributor INNER JOIN Payment ON Contributor.ContributorID = Payment.ContributorID WHERE ((...
3 12/31/2008 2:35:02 AM
e-mail
...
3 12/31/2008 1:34:16 AM
User Accounts
Can someone please point me to a link that would help with setting up user accounts, and providing different forms to load based on the user login. I'm sure this is a pretty big subject, so I just need a place to get started. Thanks for any information you can provide...
3 12/31/2008 1:05:35 AM
Update check box using keyboard
I have a simple question. Is it possible to update a checkbox by using a keyboard stroke rather than clicking with the mouse? How could I do this?...
4 12/31/2008 12:55:13 AM
Time calculations
I want to add a start time and calculated minutes together to give a finish time for a production plan... Start time and mins are both on the report I then want to put the planned finish time for each line on the report. I keep getting an error. [Start time]+[Mins]= 06:00 + 83 = 07:23 thanks...
9 12/31/2008 12:42:02 AM
Workaround
As a temporary solution, I copy from Excel and paste it into a Notepad session (no need to save the Notepad file). I then highlight all the text in Notepad, copy it and then paste it in Access. It is a pain, but it works reliability since I cannot uninstall the patch. EggHeadCafe - .NET Developer Portal of Choice http://www.eggheadcafe.com...
1 12/31/2008 12:07:49 AM
MDB with only linked tables growing tremendously
I am working on a project that has 80 users working with an mdb file that only has linked tables in it. Via our gui the users query, insert, delete and update rows in the linked sql server tables. For some reason the mdb file has been growing to a very large size which has caused errors. We are accessing the mdb via DAO Any ideas how we can prevent this problem? Thanks! Simmy...
17 12/31/2008 4:04:20 AM
Top Query
Is there a way to set a parameter for the "Top n" in a query? I want my users to be able to enter a number and have it return the "top n" vendors....
13 12/31/2008 4:07:48 AM
1410 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>  

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net