Recent content by xicana

i've been trying to work around some issues with windows task schedulerer in windows 7 as well. I have found that for a network drive, I need to put the entire pathname "\\server\folder\db.mdb" and creating an Autoexec macro to run when the dB is opened. I hate doing that, but that's the only...

I think I may not have clicked on the confirm link within the pop-up last time. Thanks! Sandy

Thanks dhookum - I did thank (clicked on the link) PHV and TheAceMan for their valuable help. I'm working on a time sensitive project and didn't have much time to explore too much. I do attempt to search for the answer first as much as i can prior to posting and asking for help...I really only...

this is what worked - thank you both! Sub UpdateMarkup() Dim db As dao.Database Dim rst As dao.Recordset Dim strSQL As String strSQL = "SELECT * " & _ "FROM 2_PriceListDetail " & _ "WHERE [PriceListID] = " & _ [Forms]![TST UPDATE COST DECREASE]![cboPriceList] Set...

thank you both for your help! I'll take a look at it this evening and post back results. Sandy

Thanks PHV...the thing is I'm actually going to do a lot more to each record...i was testing that I could actually get to open the recordset and change the value of the field for all the records corresponding to that foreign key. For each record, I will need to look up to 10 fields until I run...

Hello, I'm attempting to update a field in a table where the foreign key is equal to the value of a combo box in my form. The table could hold many records with that foreign key (if that makes a difference). The code being used is this: Sub UpdateMarkup() Dim db As dao.Database Dim...

I'm actually going to request some SQL training so that I may create my own stored procedures...I already create custom views to help me out...but need a little more education on Stored Procedures. Thank you for your suggestion - one more reason to push the company into getting me that...

Thanks for those ideas - I had thought about putting the lines in a group footer... but that and putting the subreport in the header as well as in the footer would make this report run for a really LONG (like hours) time...we're looking at 8500+ customers...each with 3 subreports to run...I...

That'll do it too! Sandy

No..I actually need the entire group to not show. See, I usually can use the group selection area to specify only showing those customers with more than $xxxxx.xx in A/P. The total $xxxxx.xx is calculated at the group footer of the customers ID...normally works fine...but since I'm passing a...

Have you tried using the display string property of that field? You could do something like if isnull(Max(@debugtime)) then '0' else cstr(Max(@debugtime))?? I didn't actually test this, but I use display strings all the time for different reasons. Sandy

I have a report that has the following layout: GH#1 GF#1A - SUBREPORT1 GF#1B - SUBREPORT2 GF#1C - SUBREPORT3 GF#1D - DISPLAYS SHARED VARIABLE TOTALS In each report I have a shared variable which stores the total of a Running Total Field. The three shared variable have different names...

I've had this message come up with other missing .dll's...one of the solutions was to place the .dll in the same folder where the access database is located. You can try that... Sandy