Search results

hi i have two questions. first is regarding my errors. i am trying to close the excel spreadsheet if sub errs. I am not sure how to test the variable MyWorkbook or MyExcelSpreadsheet (something like MyWorkbook = null, or IsNull(MyWorkbook)). Exit_GenerateInvoice: Exit Sub...

Hi all, I am trying to get the first control (employee Name) to appear on the report on the same line as the first detail, and then on subsequent lines it shouldn't appear. if i use an ordinary grouping then i would put in the control (employee name) within the group header. this would skip a...

Hi I haven't been on for a while. so hello everybody. I am trying to keep a subtotal in a table. there is an index (actually its formatted text, but its a number and i can converted i.e. cdbl()). I was thinking that i should create one query with dmax in one column and and then use another one...

Hi all, I am trying to perform the find/replace function using VBA that i would do when i open a table. so when i open a table in regular view i can go to the top menu and select Edit | Replace and then i get a dialog box that i can either search the whole table or just one field and other...

Hi again, wow. has been a long time since i last wrote to these boards. here is my issue (read it on MSDN: http://support.microsoft.com/kb/823222) i have an access report to export to excel. i am doing it a bit different than whats described in the article above. basically i have a report, my...

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 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...

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

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...

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, 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...

Hi I am trying to duplicate an Excel spreadsheet. i have one problem, i don't know if there is a way to have some columns reprint on each page. thanks, sam

Hi I was wondering if anybody has some ideas. i need to create a report that has three years of history. it is hard to describe the entire project, but i will describe it breifly. the user enters a date range (usually would be jan 1 until some date within the same year). i then want to show...

Hi i have some solutions but i am looking for more ideas on ho to go about it. I have a form that is a Claim. each claim involves an employee. the employee should be entered if there were no other claims for this employee. so employee is related to claim one-to-many. the main form's datasource...

Hi I remember seeing it. i just don't remember if i need code for this or not. I would like to the combo box to open and show the full menu upon entry. thanks, sam

Hi does anybody know how to get text to show over a textbox. until the user doesn't enter the text box it will show instructions or a label perhaps. i have seen it on some samples and now i can't seem to locate it. i think this is an easy one. i need to save space on a continues form. i would...

Hi Can i save an SQL statement to an existing Query. what i would like to do is have a crosstab on fields that will be determined at runtime. so i would have the pivot on a field that is chosen at runtime. I can run a sub that will generate the correct SQL, i am just lost on how to save it to...

Hi i set all my databases to auto compact on exit. i came across a huge problem. (i think i once read some solution to this problem). there was an existing db1 in the same directory. i think that it was there as a result of an error that happened during compacting. so MyDatabase1.mdb shut...

Hi i open a query as a recordset in VBA. i then need to use the split function to split up a few fields. how do i do this for the entire recordset. for example: MySplitVar = split(rst1("Field1")) now i need rst("Field2") = MySplitVar(0) rst("Field3") = MySplitVar(1) keep in mind i can't write...