Search results

Woops, found I had selected no Boarder.

I have found this on a number of occasions, when I run a report the external boarder to the window is missing so closing the report is difficult.I can zoom and change to design mode so it appears just to be a display issue. Is it a property setting I need to change or what?

great Thanks, this is just the help I needed. I will go off and have a go. Cheers

Thanks. I am unsure how to do this. I have read all the posts I could find but they haven't helped in this example. How do I import it so that the multiple lines (4) all end up in the same record in access. I thought if I could use the labels to define the data some how then I could import it...

I have read lots about importing files but can't find anything on how to handle importing data that repeats itself in blocks from with in a txt file. Note that I intend to run the import as an event each time the db is opened. the data is an audit log that looks like this: Date: 12-01-2004...

I have a POS system that uses access databases, It has one mdb that stores copies of the reciepts for history. I can view and edit the reciept via the software but unlike all the other mdb's (it has 11 all up) I can not view or even find the data from the reciepts although I know the database...

As I have failed to find the answer in existing posts so I'll ask it.. I have a make table query which is pulling two Autonumbers from two tables, which it doesn't like. Can I format them into general numbers and add a new auto number as the primary key? If so how? I assume its using the...

Happy to help Chimp, I noticed your post while killing time waiting for local Soccer Premier Results to be phoned in. I manage a number of databases for a number of different sports and manage about 500 teams so understand your issues. If you are still stuck then I may be could help. I looked...

I have spent 2 hours reading the posts with no solution to this. I am sending SMS messages via email to an SMS server and need to insert data into the body of an email as text. The data is in a temp table but could come direct from the query. Note it must be text in the body otherwise it will...

Sound like thats the answer RichO, yes I have had a friend suggest the same thing, I will have to look at the post on recordsets from queries. Thanks

I am sending SMS messages of team league results, my current query give me a record for each game, how can I get all the games in a single string so that I can send it to the SMS server via email. Current results show like: CombineTeams: GISB 2 Vs REDSOX 2 WANGANUI 0 Vs TARANAKI 3 NCR 2 Vs...

error occured Pat, got the error 'the expression you entered has a function containing the wrong number of arguments" I tried to use: =Sum(IsNull([address2]), 1, 0)/Count(*) in the group footer I have attached a sample of the report. Cheers

I have a report that shows members details, I want to add a KPI measure (%) showing members with null values in various feilds. Say if there is 10 members and 5 have no address details so 50% are complete. Can I do this as the report formats? If so whats the best way? How would I "count" the...

I am getting the error message " table TempMsysaccessobject already exists" on my close of my database. I have the database compact it self on exit so may be related to this. Anybody tell me how to fix this problem? Cheers

no that doesn't help the main problem I have converted this into queries instead of temp tables (which works fine) and then tried to merge the two results via another query but come up against the major problem. Below is the SQL the "home team" query runs, the away team is simply the same...

I see what your saying, the tables are temp so yes I could just use another query. Will try.

I have a query that looks at sports teams that are scheduled to play today and members that are attached to these teams so I can print team lists. The Calendar has away and home teams in each record so I need to run two seperate queries one for away and one for home teams.(I have tried to create...

Yes, As I have discovered the results where inclusive of some incorrect data. I'll go and read up on Max(). I agree Help was not a useful discription, I'll do better next time. cheers

got it got it, as easy as using "last", after hours of frustration!

I need help with this little problem, I am trying to write a query which returns players in a team that have not played for 30 plus days. (Inactive Players) Each player plays about once a week and have multiple records, some for many games/weeks. I can get my query to the stage where it...