Recent content by SamDeMan

the problem is that Myworkbook = nothing, which means what?? i don't know. what is the value of variable when it is pointing to nothing. if i write "if myworkbook = nothing then etc" i get an error, basically saying "nothing" can only be used in the context of "set". so i am trying to figure out...

thanks brian, i just tried adding MyWorkbook.worksheets and it worked! sam

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

ok, i solved it. i created a dummy textbox that lies underneath the hidden control. now the color changes for the entire row. thanks, sam

thanks paul, i just read it in getz's book. however, i am having a problem with it which i hope to resolve soon. i am using in the Detail_Format a script which alternates colored lines. so one line is yellow and the next is no color (or white). now that doesn't work correctly. this is my code...

i am not sure if there is a way to do this without vba. but if you write vba, you can have a global variable store the data when it is produced on the subreport and then add it with the total of the report. i have not tested this, but it should work.

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

i use these all the time, did you try running each iif statement indepently? the main issue with running this in a query is that the error messages are not too descriptive. there could be many issues with this statement. try to run each iif statement indepentely and make sure you copy paste so...

a normalized database will have relationships. review the sample northwind database. so lets say you had one employee table with EmpIndexNumber(autonumber), EmpName, EmpBadge, EmpAddress, EmpHourly pay, EmpPayCheckAmount, EmpPayCheckDate. now you decide to normalize it, and you would make two...

just realized, there was a typo in my question, "I am trying to keep a subtotal in a table" is incorrect. i meant to write "I am trying to get a subtotal from a table" sorry for that confusion.

subtotals that you are talking about are after a grouping. but each entry i don't think that it would work. i think its pretty simple in a query, dsum() i guess your method can work, it just may be so efficient. sam

oooops, i found an article on MSDN. http://support.microsoft.com/kb/290136 thanks, Sam

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

i can tell you guys this much, that a while ago i was trying to use the DatePiker and i had a lot of problems with customizing it. i was told that i should rather use a good date picker that were made up by others. i am since then using a date picker i found on the internet and it works fine. i...

rural guy: on one table. please look on. BYTEMYZER: thanks a lot. i used it and it works. does the trick. i can't say i fully understand the sub, but it works. will work on understanding it later. i am happy that it works. thanks all, sam p.s. if someone has a more efficient way please share...