Recent content by DianeG63

Hello Everyone, I have had small successes in getting this to work using the .SeriesCollection; however, it changes all the colors within the series to the color I am specifying. I need to just change one category. I have tried these different options listed below...

Hello everyone, I have not been a programmer in over 7 years but have been given an assignment to create an access routine to create a report with a chart. The chart will serve as somewhat of a dashboard. I need the bars of the chart to change color depending on how well or poorly the department...

that worked!!!! Funny, I always used the DBEngine(0) in the past. Oh well, thanks for all your help.

I can step through the code and it hits all the fields, and I can see the data moving from each field, but after the .update, nothing appears in the other table. All tables within the currentDB update correctly. It is only the ones that are in another db. The routine completes with no errors.

Made change as suggested, still no joy.

Nothing out of the ordinary. strpath is a constant that is set in the globals module and I have used extensively in the past. set db = currentdb set dbs = dbengine(0).opendatabase (strpath) set rst = db.openrecordset ("Table 1") set rst2 = dbs.openrecordset ("Table 2") if not rst.eof...

yes, I didn't write the original database and it is using the autonumber. I'm wondering if that has something to do with it. Although, I am writing that autonumber to a local table and it is coming in. Thanks,

I have an access database version 2003 that when I run it locally, it runs fine, but when I attach it to live on the server it will not write the records. I have set a boolean return on my sub routines and they are coming back without any errors, but the darn thing will not write the records. I...

Thanks Banana and Bob, I placed the function and it works great!

Hello, I have not coded in sometime, but need to find how many occurences of 1 character happen within one field. Example: The contents of Field1 = V20.2, 786.50, 250.02, V06.8 Is there a function that I could use to tell me that there are 3 ',' in that field. Something like VBAFunction(1...

Wahoo!! Thanks RuralGuy! I looked at the recordsource and a 2nd parameter was added for some reason. I removed it and JOY! Now to find why the other param was added. Thanks again!

Hello All, I have a form that has several (3) subforms attached to it. I have another form to add new records. I then filter the previous form with the PK from the other form. This worked for several years, but now what is happening is the main form, with the subforms loses all its controls...