Hi All Professionals, In my program, a report contains multiple pages. Since I always need to view the last page first, I'm trying to set this process...
Hello Group: I have about 30 linked excel tables that I want to combine all the data onto one table/query. So new at this - what would be my best option and...
If you tell him to raise the hood on his car, will he know what to do? Maybe we should call that a quadrabaldy so they don't get confused? It makes about as...
Excellent. Thank you Steve. I'll do exactly that. I've actually used DTS, but frankly it confused me as to how I made it work. I've looked it over and over and...
There are several approaches I thought of that would work for this. I would set up a form with a button which will print your report. In addition to the...
There's a pretty good book on creating DTS packages on SQL Server 2000 by Rabeler. It's called SQL Server 2000 DTS. John -- John V. Ruff – The Eternal...
Guys, I have a combo box and is linked to a query. Suppose I want to choose an item from a combo box, is it possible for me to just type one letter or number...
Finance - Renante Mar...
Renante@...
Mar 1, 2006 1:46 pm
34419
Make a group query and instead of choosing sum in status column, try using count. ... From: MS_Access_Professionals@yahoogroups.com ...
Finance - Renante Mar...
Renante@...
Mar 1, 2006 1:50 pm
34420
I have a list of purchase orders in a table. I know how to find the last purchase order for each part by using the Total function with "Last". BUT, for my...
I am new to the group and am a beginner in ms access. I have what I think is a simple question and posted it yesterday but cant seem to find it. So forgive me...
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the MS_Access_Professionals group. File :...
MS_Access_Professiona...
Mar 1, 2006 2:26 pm
34424
I was always under the impression that 'select' queries did exactly that...select information from a table or other query based upon ceratin criteria. If you...
I uploaded the PlantingUpdatableQuery1 into the assistance needed file. Not sure why the form will not allow new records to be added, are my primary keys...
I am using the same form to enter data and to update what has been entered. I think that is a big mistake because now I'm running into all kinds of problems. I...
One asterisk to all this is that DTS is said to be changed radically in MSSQL 2005. I have it on the shelf, not installed yet, so I can't say from experience...
Rene, I had an overzealous firewall issue with my outgoing email for the last few weeks, and that is why my posts were not appearing in the group. All of my...
Okay. The data I'm using is coming from another program, I have just linked to the table in that program/database. If I can get a primary key defined - how...
Jim Maybe this will help clear it up... We as developers tend to use a standard terminology to help avoid confusion. I don't know how many times I've seen...
Irene Go ahead and upload a zipped sample to our Files>AssistanceNeeded folder. The combo box problem is because you don't have one of it's properties set...
Hi, nice to hear from you and always thanks for your help. I still remember (or maybe faintly) the firewall issue I had when I added service pack 2 to xp,...
Try putting the Last record in a subquery, and then an outer join with your original table: SELECT Last(Table1.purchase_order) AS SecondToLast FROM Table1 LEFT...
Joyce Here is one I use to get the 2nd and 3rd latest lab results for each lab item (LIS_Num) for each patient. The trick is to use count to generate a series...
Shanro, Sample code in form's code module as given below (in click event of the button used to open the report named "R_Test"), would ensure automatic...
Perhaps a UNION query: SELECT Field1, Field2 FROM ExcelTable1 UNION ALL SELECT Field1, Field2 FROM ExcelTable2 UNION ALL SELECT Field1, Field2 FROM ExcelTable3...
Many developers bind forms to queries, rather than directly to the tables. There are various reasons for this, often to restrict the records returned to the...
You need to create a way of uniquely identifying the records. It sounds like an easy way is to create a new field in the query that is the text without the...
I want to look up orders, by item number, on the main orders form. frmOrderSheet is based on tblOrdersMain. This form has several subforms. The one in question...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
