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  >>  
Printing multiple pages
I am creating a database that will eliminate a current form. The form is a three part carbon form where we need to turn in each of the different color pages to different departments. Is there a way to print a form in access where it prints 3 pages each time with a different text box on each indicating the department?...
7 12/26/2008 6:16:04 PM
Trapping #Error on Query
Hi, I have a text field in a query. I want to separate this field to two different fields by using CDbl() function. (Double and Text separated). I get #Error when I run CDbl() on text field. I tried to use iif(IsError(Cdbl(textfield)), "Text Value", CDbl(textfield)) but the result is still #Error instead of "Text Value". Can the #Error be trapped somehow ? Thank you in advance. S ...
3 12/26/2008 5:09:32 PM
AutoNumbers in Access
I have created two tables that each generate a different PO number for us. One starts with a letter followed by number, ie, A001 the other starts with a 56-A001. After these numbers are generated, I try to append them into another table so I can have all the PO's in one table to create a report. Each time I do this, I loose my prefix, ie the "A" or the "56-A" and all I get are just the n...
4 12/26/2008 5:09:00 PM
Please Help
Hello, I am trying to figure out how i can make a form and enter info without it being displayed when i go back to enter more info....
5 12/26/2008 4:47:43 PM
Parameter Value ?
-- SDW...
1 12/26/2008 3:48:02 PM
Access Import - Strange Behavior
I've been successfully using Access 2007 to import sheets from Excel 2007 for several months. Last week, without any changes to my computer (that I'm aware of, other than MS automatice updates), when importing I get a message that the Excel file is in an Office 2007 beta format and cannot be used. I never had Office 2007 beta on my machine. After a systematic set of diagnostics, I fou...
5 12/26/2008 2:43:01 PM
Microsoft Vista
I have had an new computer since mid November running Vista. About 2 weeks ago I lost the ability to access the demo version of an Accounting package I was using. I've lived with that for the time being. About 4 evenings ago I sent some e-mail, and using Office Outlook, which I was not overly familiar with, having used Outlook Express for a number of years. After sending e-mails I ...
3 12/26/2008 1:12:19 PM
Limit to List Solution
In the past, I posted (although I can't seem to find it - perhaps in a different newsgroup?) a request for help on a "Limit to List" problem, where I wanted to set it to "No", but because my bound column (an auto number) was not visible (and therefore, the actual value of the unbound field), Access would not allow me to do so. No one was able to recommend a solution. However, I have since sol...
1 12/26/2008 10:40:40 AM
take part in the new group
I first take part in the new group,I feel very happy. ...
4 12/26/2008 7:21:41 AM
question on dlookup
If I have a table filled with records of days, say Monday Tuesday Wednesday Thursday Friday Saturday Sunday and I have a query that has a select that it only include records where the day entered exists in the table, i.e. by doing DLOOKUP, is that a valid way to validate data entered? For instance, so someone doesn't inadvertently enter "Sunderday", or Thuesday". Does that make...
4 12/26/2008 6:59:37 AM
how do i access my computor files whilst away
i will need to access my pc files whilst travelling and understand there are several reputable programmes that all ow me to do this. would be gratefull if you could let me know there names. thank you....
2 12/25/2008 10:11:09 PM
parlez vous francais
De: "David W. Fenton" <XXXusenet@dfenton.com.invalid> Objet: Re: Seek method after split database Date: mardi 23 décembre 2008 04:07 =?Utf-8?B?ZGhzdGVpbg==?= <dhstein@discussions.microsoft.com> wrote in news:44D9017C-A55B-4F5C-8AD6-765500837013@microsoft.com: > I know there's a way to use the seek method after splitting the > database. Don't. Really. It is n...
2 12/25/2008 8:45:29 PM
Custom Buttons
I have been playing around with using rectangles and labels as buttons. However, I was curious what others have come up with to create their own buttons. As my visual designs are changing, I'm hoping for something a little more up-to-date and jazzy - and being more able to control what the buttons look like, in spite of the users OS. Also, in playing with the rectangles and labels, there i...
7 12/25/2008 7:42:34 PM
Property information
I want to look up owners of properties using MD property search. the link I am trying to automatically enter the address is below. Can anyone help? http://sdatcert3.resiusa.org/rp_rewrite/searchtype.aspx?County=03&SearchType=street ...
7 12/25/2008 7:13:01 PM
Test
Ffg ...
2 12/25/2008 9:59:33 PM
incorrect office product key after xp downgrade
I just bought a Sony Vaio laptop that came with Windows Vista Business. The first thing I did when I got the laptop was downgrade it to xp using the downgrade discs. It seems like the downgrade to xp was successful. I didn't encounter any problems. However, I just opened microsoft word and entered the product key that is on the bottom of the laptop. It keeps saying the key in inco...
3 12/26/2008 4:26:02 AM
Security
How can i secure a form / query / table with password, or have logins? if the solution is logins, will there be a variable of who logged in? ty in advance...
7 12/26/2008 7:29:25 AM
Stripping characters
Hi How can I strip all non-digits from a string? Many Thanks Regards ...
3 12/26/2008 10:10:42 AM
Place DB on a Web Site
How can I place my Access 2007 Data Base on my Web Site so others can update and add data? -- Bill...
3 12/26/2008 5:06:01 PM
Parameter value?
When I open one of my forms, each parameter box comes up for the fields. It's more of a nuisance than anything but it takes time to go through all of these boxes before the form opens up. The other forms don't do this. Can anyone help me on this? Thanks! -- SDW...
2 12/26/2008 5:18:16 PM
Tabbed datasheet
Hi 2nd Question of the day for me, very grateful for any help. I'm using Access 2007 and discovered tabbed controls but Access Help doesn't answer my question on using them. I have a datasheet (formStatements) showing CurriculumStatements with associated supporting Documents . There are 600 CurriculumStatements in 25 CurriculumAreas. For ease of viewing, I would like to have each C...
8 12/26/2008 5:27:45 PM
Question response
I posted a question in the Access forum a few days ago and got an email that there was a response. But the link in the email doesn't work, I can't find my question (let alone any response) by searching, and the Contact Us at the bottom of the forum page points to a non-exisiting page. What's going on out there?...
3 12/26/2008 5:57:39 PM
query question
hi, i have 2 tables contract and payment under payment i have field pay_for(date). i want to see all contracts that dont pay for example 10/08. -- golani...
2 12/26/2008 6:05:18 PM
Opening files from within access
I would like to create a button which will open a windows browser to a specific folder and allow the user to select a text file and to be able to view the file. I know I can link to a specific text file but need for the user to be able to select the specific file they need. Is this possible? Thanks....
3 12/26/2008 6:07:54 PM
Syncronize - Remove old Paths from Options
I syncronize my databases from my laptop to my main PC. I recently moved my files from my main PC to a server. Now when I syncronize, the menu for syncronization shows the old location of the file first (they are in alphabetical order) and I have to click the drop-down menu and select the new location. Is there a way to remove the old locations from the drop-down menu? It is a minor t...
6 12/25/2008 7:06:45 PM
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