Search results

Hi How do i query an open recordset. currently i have a query and then i have another query that queries it. i will post the query and the recordset SQL thanks, sam this is the query: SELECT DISTINCT PPYearlyIndex.PgpPayGroup, PPYearlyIndex.PgpPeriodStartDate...

Hi I figured it out. i am just trying to minimize the code. is it posible to combine these two lines: rRange.Offset(0, 2).Interior.ColorIndex = 7 rRange.Offset(0, 3).Interior.ColorIndex = 7 Thanks, Sam

Hi again a simple question, just not so familiar with excel vba. I am looping through column b (the loop happens after another condition is met, i will leave this out of my snippet) so i my range is column b and a 5 rows. i would like to format cells in column d & e if a codition is met. how...

yeah, basically i thought about it...after i added trim() it worked. must have gotten some space, don't know how. thanks, sam

Hi I don't use excel much, but my access vba calls on excel to excute some code. how do i test for an empty cell? i tried using isnull, = null, = "" all of which didn't work. thanks, sam

That was a pretty good explanation. now it makes sence to me. thanks, sam

Thanks Roy, It worked...This Worked: MyExcelInstance.ActiveWindow.FreezePanes = True i sought of knew that the referencing is a problem, but i still don't quit understand it. the explanation you gave doesn't really explain it to me, since i close up the excel connection entirely each time i...

Hi I was successful with freezing the panes with my code. my code is in a module which is called a few times by a sub. the first time the module creates a new spreadsheet and then every other time it opens the existing spreadsheet. on these subsequent iterations, the spreadsheets opens and...

Hi I am modifying an existing report. basically, i have data for multiple dates for multiple facilities in temporary tables. I then ouput a report to word/excel files. I would like to add a filter to a report. I am using the docmd.output to export the reports. the following is what i have been...

how about you creat a table that has FormID, and subFormID. have the main form bounded to this table, and make sure that the form and the subform are linked. sam

users usually enter information through a form, do it on the form. tables should be used to store information, not the process them. sam

you are trying to get the result of the SQL statement in your Textbox? if so, you need to execute (run) the SQL statement before you asign it to the textbox. Try something like dLookup or maybe docmd.runSQL (i don't think this later one will work for you). sam

i am not sure of your method, i don't use this type of coding. i am not sure, but it may be that your qurey isn't constantly open. i think you make a few calls to it, but it doesn't stay open. maybe somebody better than me can correct me on this. however, i don't know why you don't use ADO to...

in general you want to use VBA instead of Macros, because the errors reported are much easier to understand. in order to get an answer in here i think you should somehow explain whats goin on. good luck, sam

cdawley4 -> Thanx for the code when i saw your question i was thinking more along the lines of linking the excel spreasheet. i am not sure what your project looks like, but you may want to consider it. once you like your excel spreasheet, it will behave like an access table. sam

depends what type of query and the purpose is. i can think of a few scenrios. you can use a QueryDef to run a query or a docmd.runsql to run some sql. sam

in the same sub that calls the query, you can end it with a docmd.close sam

Hi How do i pass parameters to a query from a VBA. I am looping through a few sets of parameters. a bit more of what i am doing: I am using two CrossTab Queries, and then I use a union to combine them (the value are different, so i need to use two crosstabs). Then I group them, and sum them...

Hi all, I posted this question on Microsofts Discussion Board and i got an answer. i would like to share it with you. if you would like to see the follow ups on this, please go to Microsoft Access Disscussion Groups and go the Query section, i posted my question on 9/18/2006 titled: Which comes...

Hi all, its been a while since i have posted. I hope y'all doin fine. I have a query which can be constrained two different ways. it can be constrained by the join, or it can be constrained by criteria. i was wondering which one hapens first and which one is prefered. here are the details. i...