Search results

I have a form who's records source is just a one-row table. Many of the text boxes are calculated on other text boxes on the same form. How can I get the calculated text boxes to "refresh/requery " once their dependent value is changed? Of course, a manual press of F9 does the trick, but I...

Thanks everyone -- I've taken away a lot of good stuff from this thread! Granville

The following SQL is from the SQL view in the Access QBE grid and works OK. SELECT Count([date closed]) AS Total, (Select count(WinID) from (SELECT qryAdHoc.*, * FROM qryAdHoc WHERE format (qryAdHoc.[Date Closed],"mm")= "11" and format (qryAdHoc.[Date Closed],"yyyy")= "2008" )) AS Won FROM...

Thanks - both usefull information that helped me along.

I want to select everything in [Date Closed] with a date in the prior month. This would work for the month portion, but I'm having trouble deciding how to handle the year portion. I don't want all records for Oct in every year, just the current year, and since I'm looking for the prior month...

I just needed to add text boxes that exist on one form to another already developed form. I tried several times, and each time the text box names changed generically upon copying them. However, upon exiting everything, and rebooting, all is well. I guess it's one of those unexplained...

I have a large amount of labels that I want to copy from one form to another. When I copy them, the names for all of the labels revert to generic names (ei: txt123). Is there any way to copy these and retain the names from the source form? Thanks, Granville

Just bumping this once to see if anyone can answer this... Thanks

Just bumping this once to see if anyone can answer this... Thanks

Thanks Sportsguy -- I see that you live in Boston. I lived in the Wadsworth Hotel (dormitory) in Kenmore Square for one year while going to Franklin Institute in the mid 70's. Great town!

Is it possible to do the same types of chart in Access that it is in Excel? I want to create a bar chart with a line graph, and have two Y axis's. This is simple in Excel, but I haven't been able to find a way to do it in Access, using Insert/Chart. Thanks Randy

I'm not very familiar with Access charts, and have some questions. I have an Excel chart that I would like to replicate in Access. The chart has both a column and bar graph, and a secondary Y axis. So far I've found the chart tool (Insert/Chart) to be limited. Is it possible to produce more...

Thanks Banana, Bob and Pete. Let me give a bit more info about what I'm trying to do: I just output the multi-dimensional array DataHold(7,5) to the debugger: 36705500 87476000 12910140 137091640 49 2797789 33825500 81368000 3991856 119185356 47 2535859 63365500 61040000 3991856 128397356...

Bob, At Set rst2 = CurrentDb.Open("test") I receive the message "Method or datamember not found." I do have a reference set for the DAO 3.6 Object Library. Thanks, Randy

The array is (7, 12), if that helps. Thx - Randy

I am looking for a way to populate a table from an multi-dimension array. Any tips? Thanks, Randy

I have a table, such as this: State Count Gross Net FL 4 120 60 NC 3 90 45 NY 5 30 15 I am trying to query it so the state FL, NC, etc become Column names, with their Gross beneath them, followed by a 'Total Gross' column, etc... FL NC NY Gross Net Count 120 90 30 240 120 12 A crosstab...

Yes - it was what I was looking for. I had tried almost the same thing, but used Me. rather than Me.Controls. Thanks for your help. Randy

Thanks Banana - I was going bananas! I had tried almost the same thing, but without "Controls" after Me. Randy

I am attempting to populate some text boxes in VBA by using a common beginning for the name, and the month (such as Oct) in a variable. I have hard coded "Oct" into the code which works: Me.txtAMER_Oct = rst.Fields("cnt") I'm not sure how to incorporate the variable mth, tried unsucessfully...