Search results for query: *

Thanks for the confirmation. What gives with Microsoft. Is it really that unreasonable of me to expect that access report would work with word? Isn't Microsoft Office 2000 professional a mature software product? They certainly tout it as though it all works together. Is it really by design...

[ponder]Am I dreaming or is it true that I have to build a fancy vba output program to export a report as a word document? This is killing me....

Ok then.... How about any suggestions on how I might try and debug something like this. What should I isolate? armstrong

this the code I'm using and when I try it, it sends out the first email and then says there isn't enough memory to perform this operation. Any ideas would be much appreciated Private Sub Email_Everyone_Click() On Error GoTo Email_Everyone_Click_Err Dim Db As Database Set Db = CurrentDb...

INSERT INTO [team-assignment] ( playerid, teamid, playyear ) SELECT [index-player].[playerid], 57 AS teamid, 2001 AS playyear FROM [index-player] LEFT JOIN [team-assignment] ON [index-player].[playerid]=[team-assignment].[playerid] WHERE ((([team-assignment].[playerid]) Is Null)); THAT WORKS...

Sorry, INSERT INTO [team-assignment] ( playerid, teamid, [year] ) SELECT [index-player].playerid, 57 AS teamid, 2001 AS [year] FROM [index-player] LEFT JOIN [team-assignment] ON [index-player].playerid = [team-assignment].playerid WHERE ((([team-assignment].playerid) Is Null)); This is a...

Mike thanks for taking the time here's the statement INSERT INTO team-assignment (playerid, teamid, year) SELECT index-player.playerid, 57 AS team_id, 2001 as year FROM Table1 LEFT JOIN team-assignment ON index-player.playerid = team-assignment.playerid WHERE (((team-assignment.playerid) Is...

Hi, I have two tables one is team-assignment it consists of teamid playerid year. This table was started when I originally setup the database. I have another table called Index_player. The index-player has been getting updated as I receive new registrations. Everything is ok so far. Now...

Quick question. I can't find the keyword me anywhere in the online documentation. Where is it?

Fantastic!

I have a form that is made of 3 forms from 3 tables. I want to changed the background color of one of them if there is a check box checked off. I can't seem to find the correct syntax for changing the forms color based on the this check box. Also when the records are changed or just looked at...

Ok thanks, I have been using this product for about 3 weeks. This is a database for 500 little league kids. I've got alot accomplished but believe me nothing has come easy. Many nights up late... I need to figure out their playing age for this year and check that against the league they...

Thank you Terry I'll read the faq first and then on to my problem armstrong

Hello! I have a table that I added a field to and I would like to fill it with ages. There is a birthday field in the same table. So what I was wondering was whether I could make a query and pull the new field in [players_age] and using expression builder and a function for age populate the...

DataBase Design Philosophy.... I seemed to have read somewhere in here that its better to somehow divide your database into two separted files. One Just the tables and (queries?) and the other all the forms and reports modules etc. I'm not sure about anything I just wrote but.. If anyones...

I have made a query of the objects in the database using (msysobjects) and have narrowed them down to a select group of query names. These queries have the list I want to loop through. Access won't allow me to use the query of queries for input into a combo box. anyway around this?

acSendNoObject instead of acreport never mind [smiley]

sorry the green line should be replaced with this that does work DoCmd.SendObject acReport, "Report1", "MS-DOSText(*.txt)", EmailList, "", "", "Minor League Tryouts", "Minor League Tryouts a glove.", False, ""

I have a form where I have 2 text boxes accepting subject and title for an email. this is what i have in my code Private Sub Email_Everyone_Click() 'EmailSubject, EmailMessage On Error GoTo Email_Everyone_Click_Err Dim Db As Database Set Db = CurrentDb Set Rst =...

I have built a query that pulls out certain people with their email addresses. I get some in there that do not have email addresses(and won't) I am trying to get them out of the list but to no avail. I use fieldname <> &quot;&quot; or fieldname <> null and there is no difference between that...