Search results

DoEvents did not help.

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'm only exporting the schema, and the only reason for exporting it is to have a copy of changes in Subversion. Exporting a query does not solve that problem. Right now the only solution seems to be to remove the calculated field and do the calculations in the form and report source queries...

Brain dead. Yea, it's the calculated field. (working too many hours.:() But what I meant to ask, Is there a workaround? (I've done a lot of searching and have not found anything that confirms the problem, or gives a work around. As this is one of the best forums around, I thought I'd try to...

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

The users don't know the back end exists. They never see a table, queries, or any of the behind the scenes stuff. Error trapping, and logging, is used, and I examine the logs from time to time for hidden problems. In this case, the only symptom was you couldn't add a new record via a subform...

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

Why do make assumptions and post wrong conclusions? You don't know what the combo is doing! In this case it does NOT lookup a record. It is a standard selection combo which changes a list of values depending on other records. In my opinion you should never have posted a reply, because you...

Did you read my post? I'm doing that already.

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

Seven year old thread, 20 year old product, and there is still not a good solution for Access Documentation and/or Help!

I use Windows Update to keep my Office/Access 2010 updated. To me it seems sp2 is more stable than sp1.

This will get the html and save it to a text file Sub CopyHTTPFile(strURL As String, strLocalPath As String, strLocalFileName As String) ' Create an array to hold the response data. Dim arrDownloadedBytes() As Byte Dim WinHttpReq As WinHttpRequest Set...

Depending on what you are wanting to do several things might work. Assuming Table1 has an Primary Key lngPriKey, and Table2 has lngPriKey2 UPDATE Table1 INNER JOIN Table2 ON Table1.lngPriKey = Table2.lngPriKey2 SET Table2.SumsFromTable1 = [table1].[FirstField]+[table1].[SecondField];Or an...

Use something like this lngRet = aDialogColor(Me.txtCtrl("BackColor")) lngColor = Me.txtCtrl.BackColor ' Loop through the controls, use With ctrl, whatever ... me.MyLabel.Backcolor = lngColor

Dim db As DAO.Database, sSQL As String Set db = CurrentDb() sSQL = "UPDATE [Dive Crew]" _ & " Set [Dive Crew].InitInvConf = -1" _ & " WHERE [Dive Crew].InvoiceNumber = '" & [Forms]![frmInvoice]![cboInv] & "'" db.Execute sSQL, dbSeeChanges ' Single...

Your question is way too vague. Do you want to concatenate two fields and store them as one field in the second table? Or do you want to select a record in one table by doing a join to fields in a second table? Or something else?

While a lot depends on the situation, you might start by checking for interactions in the Form_BeforeUpdate event. Something like: if DrugInteractionCheckFails() then MsgBox "You got a problem." end if