Search results

I checked the backend that I did the C&R on that was on the server and there was no error log.

The DBGuy: Unforunately I did not look to see if there was an error log. Since I have copied and C&R various copies of the backend, I cannot seem to find anything that says there were errors. If it ever happens again, I will certainly look for it, but hopefully it won't happen again. Doc...

Thank you for your explanation of why the error might have occurred. I shall pass this on to the miscreants who possibly caused the problem and tell them to notify me of any lost connections while using the DB remotely. Since one user is doing this every day, it is possible that he lost...

Wow, that sounds very complicated. I'll try it, and I am sure coming from you it will be just fine. Just as a question, is there something wrong with the way I "fixed" it? Are you suggesting that doing a compact and repair on the back end is risky? I am asking this for future knowledge...

I have a split DB A table has a field named [ProgramNotes] where the designation "#deleted" has come up for two records. When I tried to reinsert the data from an old backend in this field it says that "Your changes cannot be saved because the field "ProgramNotes" has been updated by...

Got it!! Dim newCost As Double newCost = Me.OperatingCost.Value Dim myFrm As String myFrm = "frmMyOpenForm" DoCmd.Close acForm, myFrm DoCmd.MyOpenForm myFrm, acDesign, , , acFormPropertySettings, acHidden Forms!OpenForm.DefaultValue = newCost DoCmd.Close acForm...

I found this post: https://access-programmers.co.uk/forums/showthread.php?t=146183 As I want to change the default value programmatically with vba. Private Sub YourNumericControlName_AfterUpdate() If Not IsNull(Me.YourNumericControlName.Value) Then...

Sometimes you miss the very simple explanations. Thank you.

This is going to sound a little crazy, but I have an unbound form with 5 fields. When I open the form which is used to run one or more reports, there is data in the fields. I remember entering data there a long time ago, but I do not remember why this form opens with data. It says it is an...

Look at this: https://www.tek-tips.com/viewthread.cfm?qid=662297

I am using a modified version of code to open an excel sheet for viewing. The problem is that I need it be auto fit and text wrapped. The code is a modified version of https://btabdevelopment.com/export-a-forms-recordset-to-excel/ All is well except that three number columns are now only one...

If IsNull(Employee) or Employee = "" then Employee = 23 end if Not sure what you mean by Emloyee = 23 means.

Thank you. I will try to incorporate this.

Thank you for your response. Perhaps I did not explain it correctly. MonthOfInvoice is the full name of the month. That is, January, February, March, etc. Perhaps if it were a date merely formatted as "MMMM YYYY" I wouldn't have this problem, but that is the way the data is set up. When the...

I am trying to figure out how to formulate a multi-Iff statement for an invoice. The invoices are sent out a month in advance on the first of every month for billing one month in advance. Simply stated, if an invoice was sent out on February 1, 2019, the Billing Month would be March 2019...

Just put it in a Sub and then call it. I usually do this as the first event for the form so I know where to look for subs that I can call. Sub OpenMyForm() DoCmd.OpenForm "CustomerDetail", acNormal, , "[CustomerID]=" & Me.CustomerID, , acDialog End Sub Then call it on any of the events...

OK, put in the OnPrint event an works great. Thank you both.

There is no section on the report other than the main one and the header. So should it be OnLoad or OnCurrent, these seem to be the only two options for me? thanks for the other advice, I'll take a look at that later.

I have a report that prints my monthly invoices with the following code: Dim iCount As Integer Dim rpt As String Dim cond As String Dim db As DAO.Database Dim rs As DAO.Recordset rpt = "rptInvoiceToBeMailed" Set db = CurrentDb() Set rs =...

As a once heavy smoker and cold turkey quitter I just had to add my two cents on this. I smoked three packs of unfiltered Camels per day while I was enjoying a one year vacation courtesy of Lyndon Johnson. (RVN for those of you who are not of my vintage). Quit almost 50 years ago after smoking...