Search results for query: *

This is all kinda what i figured. This is for a Delphi desktop app. So it sounds like this is going to be done the hard way. Its not really a huge issue, but we would like to make sure that the app will perform well, even if the recordset hits a large number. The biggest problem i had was...

I would like to be able to get groups of records in sets I guess. I dont know the proper description for this, but basically I want to be able to take a query and say, give me the first 50, then say, give me just the next 50 and so on. I figure I can pull this off with TOPs and INTERSECTs, but...

Has Anyone ever tried getting access runtime to work on a mac running virtual pc? We have 2 macs in the office, 1 running WinME Virtual PC and the other is WinXP Virtual PC. The WinME one is running perfectly, the XP one keeps giving an error that says it cant find the database file that its...

Using Access 2000. I need a query to do this.. Each rep has a number of schools. (treps, tschools joined on repid) Each school has an estimated quantity field. (04QTY) I need to count, for each rep, how many schools have quantities filled in. (ie john q rep has 5 filled in) I was able to pull...

We need to move our windows 2000 server to a new machine, and want to keep all the files and settings exactly how they are. What is the best way to do this. I have heard about the Files and Settings Transfer Wizard, but I think that only works if you import into WinXP. We just need the files...

I follow it all, one problem though. The date and time are in two different fields. How would i get around that? Thanks for the help. -Marty

Need help on a query here. I have a table that consists of an ID, a color(text), a date, and a time. The ID shows up mulitple times. I am using Access 2000. Sample: 17324 yellow 3/13/2003 4:55:03 PM I need the query to return a list of the ID numbers and the color of the latest change. There...

ouch. Thanks man, I looked over it like 12 times and didnt catch that. Works perfectly thanks. -Marty

This is my modified version: SELECT [t_orderlights].[schoolId]...

I have a table with 9 text fields that are either yes, no, or null. I need to count how many records have 1 no, 2 no's..etc. Is there a way to do this. Im using access 2000. -Marty Loftus

I have my users open a Access 2000 database and they all have the runtime version installed on their computer, none have full Access. I dont go through the packaging wizard because they have me change the database at least twice a week, and this way seems to work just as well. I recently added...

I think thats what i need to do. each rep basically gets the same query but filtered for their name. how do you set up temporary tables with a make table query? -marty

Im actually trying to send out the results of the query in excel format. The problems is that I need to send each of ours reps a list of their schools. so the main query needs to be split up a bunch of times. or am i not understanding your suggestion. -marty

I am using sendobject to email different queries. There are over 100+ different queries that will be needed so I would rather not create and save each query in the database. I can change the queries with loops and string manipulation, but I'm having trouble sending out that actual query. Is...

I figured it out. Don't completely understand what I did but I have buttons for filtering and sorting now on my form. Thanks for all the help. -Marty Mloftus@ybi.info

Thanks a ton. I already have the runtime up and working. Anyone know an easy way to program in filtering and sort ascending/decending? -Marty

My company has decided that rather than pay licensing fees for access, they would like to use something else cheaper. They designated me as the access guy about a year ago and I had to learn on the fly with little previous knowledge. So basically they would like me to learn from scratch...

Worked Like a Charm. Thanks. -Marty Loftus

I have 2 tables that I am trying to create and set up 1 to many referential integrity, by linking ID numbers. The problem is that not all the ids in table2 have a id in table1. How can I find out which ids in table2 do not have an id in table1? -Marty Loftus