Search results

I have a form on a subform on a subform. The Master and Child Links are null. Filter On Load is off, as is the filter, and the filter is blank. The code below sets the recordsource property to a SQL string. I can copy the contents of strSQL to a query and one record is displayed. The...

I have this form in form_load to set the value list of a combo box Dim strList As String strList = "-32768,Form;-32766,Macro;-32764,Report;-32761,Module;1,Table;4,Table_ODBC;5,Query;6,Table_Lnk;-30000,WKSSet;" Me.cboObjectType.RowSource = strList I have code to display the rowsource for...

I have some code for refreshing links that I thought was working. I did make some minor modification to handle the case where the front end and back end names were different. Now for some reason the ODBC Connect strings are not getting refreshed, even on the tables where the names are the...

I have two different situation where I have not been able to solve the Error 3035 "System Resource" exceeded problem. I've looked for memory leaks, set the MaxRecordLocks to 1 million as suggested elsewhere, and tried various rewrites, all to no avail. The latest is a routine that moves data...

I use the following code in many place to open and print a log. I would like to let the User preview the report, then decide if they want to print the log, which seems easy, but the Preview view that shows always show a blank "LogText" control. If bolErrorsFound Then strReport =...

The following code always works if I set a break point, and traces through as I would expect it to. It never works the first, and only the first, time I click on the "BudgetYear" control IF the record is a new record. Anybody seen this? Am I missing something? Private Sub...

I have a function I have used for years that exports the Table Schema to a .xsd file for saving in subversion source control. One table of 162 gives me error 31532 when I try to export it. I can export it as a local table, and I can open the backend and export it there. I have relinked it...

I'm posting this in case it might help someone else tracking down weird 2046 errors, which there seem to be a lot of. I was getting an error 2046 at the lines With Me If Not NewRecord Then DoCmd.RunCommand acCmdSaveRecord DoCmd.RunCommand acCmdRecordsGoToNew End...

I have a form with 47 subForms, and Form.Controls.count is 351. The sub forms were originally text boxes, which got changed to ListBoxes because of customer requests, then to subforms because of conditional formatting needs that the customer wanted. Now, when it is open, other forms give...

I have a combo on a form whose rowsource changes in the Form_OnCurrent event. I discovered that if I am using the Navigation bar to step through the records and I go from the last record, to a new record, then back to the previous record, the combo does not update. Works fine if I am going...

As many of you know, you can set lots (Some say 32, some say 50) of Format Conditions in Design View by right clicking a text box and Selecting Conditional Formatting. But you try it in code and you will get errors if you try to set more than 3. (Internally, there is a Microsoft BUG, not a...

Access 2010 keeps changing the Capitalization of objects when I don't want it to. For example "Cancel" becomes "cancel". Later it will be changed back to "Cancel". There is also a table with a field "FULLNAME". Several Queries build a field "FullName". As a result FullName, even in places...

Sometimes this line of code works, sometimes it gives me error 3011. DoCmd.TransferDatabase acLink, "Microsoft Access", vPathname, acTable, vTableName, vTableName When I step through the code in the debugger the values have always been valid, and when I step through it it always works. But...

This line is in the OnClick event of a subform. I want to open stDocName read only. DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormReadOnly, , strCaller When the form opens Me.AllowAccess is false in both the Load event and the OnCurrent event. Yet I can edit all the data, close the...

I am trying to set event handlers on multiple controls in code. This works: Me.Controls("txtPosition" & Right(CStr(iLoop + 100), 2)).OnClick = "=UpdateTaskList(" & CStr(iLoop) & ")" This doesn't: Me.Controls("txtPostIt" & Right(CStr(iLoop + 100), 2)).OnGotFocus = "=PostItGotFocusHandler2()"...

I've found lots of post that say "don't use OLE Objects", but in this case I need to add objects to an existing database where the front end code is an .mde file and the orignal .mdb is no longer available. The field is PHOTO and field type is OLE Object I've tried !Photo =...

I have a form that opens a report in a button click event. DoCmd.OpenReport strReport, acViewPreview The report has code in the Report_Open event to read a value on the form and change the RecordSource. In the Report_Load event the following line Sometimes gives me a runtime error 2448. at...

I inherited an Access 2000 (2002?) database that uses a textbox behind another to change the background color based on two different fields. The Format property is set to: "ÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛ"[Green];"ÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛ"[Yellow], the Data ControlSource is set to...

Have worked with Access for years, mostly Access 97, some Access 1.0, 2.0, 2000, 2002, and now 2010. New to 2010, not having used Access much for several years. (C++ for the last 7) Discovered a few surprises with 2010. Some may be because I've got Ansi-92 switched on for SQL.