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

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

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

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

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

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

I have a report with several subreports which run agains a very large table. If I decide to print the report after examining it, all of the underlying queries must run again. Is there any way around this to avoid this delay, other than exporting as rtf or snp? Thanks, Randy

I'm trying to figure out how to link a text file to my database with VBA. I know how to do this for other types of data sources, using the DoCmd.TransferDatabase acLink command, but need guidance using this with TXT files. Thanks, Randy

I have a linked table and want to change it's data source to another table entirely -- ie: different file name. Can this be done with linked tables, or can you just link to another file with the same name but in another directory? If linked tables have this limitation, how would you accomplish...

A custum toolbar that I have had for years dissapeared -- it won't open, and it's not on the list. But when I tried to recreate it, I can't use it's name. I get a message that the toolbar exists! Any help will be appreciated. Randy