Search results

??? I think I did what you said but it didnt arrange the part #'s by manufacturer. You see what I'm trying to do is make a form and on the form I would like to have a combobox for manufacturers. And depending on which manufacturer is selected, all their parts show up in another combobox sorted.

Thank You Thank you for all the good help Diversoln I didn't expect such a good answer. THANK YOU AGAIN!

And How do I sort w/in a table? lets say i have a table that has: Manufactures Name Part Number How would i sort out all the Manufacture's Names and then sort the part#'s after that?

What's a query?

I was using Left() Right() Trim() in Office97 and i switched to 2000 and it doesnt allow the use of those functions unless you install those functions with 2000. I know there's another way of doing it becuz i've done it b4. But I cant remember how. Does anyone know?

Maybe I believe if you place the file path inside quotations in between the 2 commas. It will work.

;) i suggest you maybe looking into the switchboard form. You'll like it.

A snippet that i am currently using DoCmd.OutputTo acOutputQuery, "qrySupplierRating", "MicrosoftExcel(*.xls)", , False i use this and it worx for outputting to a spreadsheet.:D

Ok this is where im @ Sub OpenMainDB() Dim appAccess As Access.Application Dim frmAccess As Access.Form Set appAccess = Access.Application appAccess.OpenCurrentDatabase ("s:\Main Database\First_ American Main Database 082702.mdb") appAccess.Visible = True...

. will do

Cool

The way i see it You would first check to see what Letter day was inputted. Then if it is say Wednesday, you would add 2 to the serial date to make it friday. Then you can add 7 to it to make it next friday. You would do something like this: DIM NumToAdd as integer SELECT CASE...

HOW TO DO THIS IN 97 '**************************************************** 'Get the Name of the File Used (includes extension) '**************************************************** Sub GetFileName(ByRef theFile As String) flag = 1 Do If (InStr(theFile...

Im somewhat of a beginner. I know a little vb and im just starting to get my feet wet in OLE. Now what i currently have is working but it has alot of useless steps. I keep my data in access. I run a form that runs a query based off the inputed data from the form. Access then exports the data...

Well.... Since excel can open up text files and delimit tabs. Why couldnt you write a macro that opens the file and pulls data from the desired columns and apply the data where needed?

REPLY the question is: What is the code to write to a query that has already been ran. Say it comes back null. Currently my code is: DoCmd.OpenQuery "qrySupplierRating" DoCmd.OutputTo_ acOutputQuery, "qrySupplierRating", "MicrosoftExcel_ (*.xls)", ...

REPLY It seems like you know what you talking about and all and probably more than i do. But it just seems to me as if you would have to Find the Highest Value from the Sorted Company table and then extract out the Record Under that. I dont know how else to do it other than Find the highest...

Reply Well if you sorted the table Descending. Wouldnt the second highest fall the row under that one. :eek:

How do I write to a query using code? The query is based on suppliers. But if my query returns null and i output the query to a spreadsheet. My spreadsheet program will not know where to put the data because it doesnt know which supplier the spreadsheet refers to. So, i need to be able to...

Looks as if that would work... And thank you for your response. Which was an excellent one. But im a begginner practically to VB. I've taken one class of it. And it seems that the code you just showed me may work but i'm not necassarily wanting to use the open or save dialog box. I'm looking...