Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 25 of 35
Search took 0.01 seconds.
Search: Posts Made By: donevco
Forum: Access April 27th, 2007, 09:37 AM
Replies: 7
Views: 1,306
Posted By donevco
I saved the spreadsheet to a tab-delimited .txt...

I saved the spreadsheet to a tab-delimited .txt file. I imported the .text file with no problems.
Forum: Access April 26th, 2007, 04:52 PM
Replies: 7
Views: 1,306
Posted By donevco
I just successfully imported a previous version...

I just successfully imported a previous version that has ' in the name field. I had imported that version before, just wanted to check.
Forum: Access April 26th, 2007, 04:42 PM
Replies: 7
Views: 1,306
Posted By donevco
No quotes

No quotes
Forum: Access April 26th, 2007, 04:31 PM
Replies: 7
Views: 1,306
Posted By donevco
Hello, Kevin Found several Irish names, changed...

Hello, Kevin
Found several Irish names, changed the ' to a space. Still won't load.

Don
Forum: Access April 26th, 2007, 04:00 PM
Replies: 7
Views: 1,306
Posted By donevco
Unable to import from an Excel Workbook

T'm trying to import data from a spreadsheet, but get the "...unable to ... was not imported" message. I can import successfully from an earlier version of the spreadsheet. I've reviewed the help...
Forum: Access April 25th, 2007, 03:26 PM
Replies: 13
Views: 1,837
Posted By donevco
OK. Thanks for your help. Don

OK. Thanks for your help.
Don
Forum: Access April 25th, 2007, 03:03 PM
Replies: 13
Views: 1,837
Posted By donevco
I just realized that when you select "Queries"...

I just realized that when you select "Queries" and click the "New" icon, you get a different list than when you click "Create a New Query Using the Wizard".

"Verry Interesting" as Sgt Schultz...
Forum: Access April 25th, 2007, 01:50 PM
Replies: 13
Views: 1,837
Posted By donevco
Hey, more than I expected. Table: PeopleLoad...

Hey, more than I expected.

Table: PeopleLoad fields: EmployeeNbr (Key), First, Last
Table: People fields: EmployeeNbr (Key)

I want to select rows in PeopleLoad that don't match on...
Forum: Access April 25th, 2007, 12:19 PM
Replies: 13
Views: 1,837
Posted By donevco
[?]I'm trying to get to the right place. I start...

[?]I'm trying to get to the right place. I start the query wizard, select the People Load table, select the fields, select the People table, select the corresponding fields, click Next. I click on...
Forum: Access April 25th, 2007, 11:59 AM
Replies: 13
Views: 1,837
Posted By donevco
This doesn't appear in my Query Type dropdown...

This doesn't appear in my Query Type dropdown list. I find Select, Crosstab, Make Table, Update, Append, and Delete.

I'm running Access 2003 in XP Pro.
Forum: Access April 25th, 2007, 11:39 AM
Replies: 13
Views: 1,837
Posted By donevco
Yes. The primary key is email address, but...

Yes. The primary key is email address, but employee number is unique and indexed.
Forum: Access April 20th, 2007, 04:46 PM
Replies: 13
Views: 1,837
Posted By donevco
Matching rows in two tables

I'm maintaining a table that contains all the people in our part of the company, about 700 rows. Human Resources will provide a spreadsheet weekly that contains the latest data. I have a work table...
Forum: Access February 22nd, 2007, 02:30 PM
Replies: 1
Views: 1,581
Posted By donevco
Record is Inserted Twice

This is a form with a subform The main form displays rows from the "People" table. The subform displays rows from the Class Registration table, linked by the Email field, which is the primary key...
Forum: Access February 20th, 2007, 10:46 AM
Replies: 14
Views: 1,540
Posted By donevco
I seem to have moved this posting in a different...

I seem to have moved this posting in a different direction.

Here's a note on where I'm coming from: I first encountered SQL in Adabas, a sort-of-relational mainframe DBMS (e.g. it allowed...
Forum: Access February 16th, 2007, 07:02 PM
Replies: 5
Views: 1,170
Posted By donevco
I added a Yes-No "IsManager" to the table. I...

I added a Yes-No "IsManager" to the table. I opened the query in design view, removed the manager table, and add People, which appeared as "People1".
I drew a relationship from People1.Email to...
Forum: Access February 16th, 2007, 05:58 PM
Replies: 14
Views: 1,540
Posted By donevco
I went to http://msdn.microsoft.com and...

I went to http://msdn.microsoft.com and downloaded the Access VBA Reference. Detailed information on VBA, but nothing on VBA SQL. I'm still looking for an SQL reference. Searching SQL in MSDN only...
Forum: Access February 16th, 2007, 02:35 PM
Replies: 5
Views: 1,170
Posted By donevco
Thanks, that's very helpful. However, the import...

Thanks, that's very helpful. However, the import created a new table with "1" added to the end of the name, so I had Registration and Registration1. I deleted the old table, renamed the new one,...
Forum: Access February 15th, 2007, 06:25 PM
Replies: 14
Views: 1,540
Posted By donevco
Thanks, mmcdonal. Do you know of a source of...

Thanks, mmcdonal. Do you know of a source of information about events?
Forum: Access February 15th, 2007, 12:54 PM
Replies: 14
Views: 1,540
Posted By donevco
Is "On Current" the event that occurs when the...

Is "On Current" the event that occurs when the form shows a new record, like when I click the next record navigator control?
Forum: Access February 15th, 2007, 12:48 PM
Replies: 5
Views: 1,170
Posted By donevco
Copying Databases & Foreign Keys

I'd like to get advice on two topics.

1) What's the best way to migrate data between test and production databases. I tried having them open in two Access sessions, and dragging objects from one...
Forum: Access February 9th, 2007, 06:37 PM
Replies: 2
Views: 1,216
Posted By donevco
Thanks Loralee: You are correct about the...

Thanks Loralee:
You are correct about the parentheses. After I posted the message, I found syntax for INSERT in my WROX SQL Server book.

There's no WHERE in the INSERT statement. It's taking...
Forum: Access February 8th, 2007, 03:27 PM
Replies: 2
Views: 1,216
Posted By donevco
INSERT SQL

Does anybody know a good reference to Access SQL? Preferably online.

I'm getting an error message Syntax Error in INSERT INTO Statement.

Here's the code: it works down to the RunSQL statement....
Forum: Access February 1st, 2007, 12:14 PM
Replies: 2
Views: 793
Posted By donevco
I click on Form View, and get the same view.

I click on Form View, and get the same view.
Forum: Access January 31st, 2007, 12:08 PM
Replies: 2
Views: 793
Posted By donevco
Formatting a Subform

When building a form with a subform, I open the subform in a separate window, edit its format and close the window.

Then, when I open the parent form, the subform appears in a sort of datasheet...
Forum: Access January 31st, 2007, 11:56 AM
Replies: 2
Views: 960
Posted By donevco
That pins it down for me. Much thanks.

That pins it down for me. Much thanks.
Showing results 1 to 25 of 35

 


All times are GMT -4. The time now is 08:14 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.