ms-access-2003
Filter a form using a command button on another form
I have a form with a cmdbutton that at the moment opens another form and shows all records for several types of PartitionStyles and TrimFinishs (486 at present), I need to be able to filter the second[详细]
2022-12-25 06:28 分类:问答Open Excel file from Access and copy a picture to the Access form
So I have an excel workbook that has a nice global map of shaperange objects. With some very simple code I can change the colors, group and ungroup collections of countries into arrays, etc...and it w[详细]
2022-12-24 16:27 分类:问答MS Access 2003 - Formatting results in a list box problem
So I have a list box that displays averages in a table like format from a crossyab query. It\'s just what I need the query is right, there is just one thing. I had to set the field properties in the q[详细]
2022-12-24 11:55 分类:问答"'PK_dbo.TableName' is not a valid name" with Access ODBC linked table to SQL Server
I am trying to link an Access 2003 DB to tables in a SQL Server 2008 database using ODBC. When I try to link to tables that have Primary Key established I get the following error message.[详细]
2022-12-24 07:32 分类:问答MS Access 2003 - VBA for altering a table after a "SELECT * INTO tblTemp FROM tblMain" statement
I use functions like the f开发者_JAVA百科ollowing to make temporary tables out of crosstabs queries.[详细]
2022-12-23 06:04 分类:问答How can I bold the font in Lotus notes when generating an email from Access 2003?
I am running Access 2003 and have created a module which sends an email to recipients from the database in Lotus Notes. It works just fine, but now I have been asked to \"Bold\" specific text in the e[详细]
2022-12-22 19:32 分类:问答MS Access ADP Disconnected Recordset Reverts
I have an Microsoft Access 2003 ADP, which uses a bound \"main\" 开发者_如何转开发form with several bound continuous-style subforms.They all utilize disconnected Recordsets via a helper class.[详细]
2022-12-19 05:49 分类:问答Why do my Access linked subforms not display correctly when refreshed?
I have a form (Quote) with an auto-number ID, on the form at the moment are two subforms that show different items (sub 1 shows partition modules sub 2 shows partition abutments) both forms use the sa[详细]
2022-12-18 22:50 分类:问答MS Access 2003 - Opening a report without it printing
I used Docmd.OpenReport \"Report1\" from another form and it seems to just want to print the report w开发者_开发问答ithout actually displaying it. I want to display the report, not print itSet the[详细]
2022-12-17 11:46 分类:问答MS Access 2003 - VBA for Parameter box that open after code is run: auto "ok"?
So there is a parameter box that open after a button click event runs an sql statement in vb for a list box to populate data. something like:[详细]
2022-12-16 15:59 分类:问答