Search results

Not exactly sure what is replication, but when I looked it up it was confusing to me so I guess we have never used it. Thank you. The question remains is if I continue to operate in Access 2010 but some people have Access 2019 on their workstations, can they open the DB? Or should I get a...

Apparently the outside tech convinced them to installed Office 2019 for Word, Excel, PowerPoint using the subscription based service. So I don't know if there were any problems installing Office 2010 on the new computer.

At our office we have 5 desktops running Windows 7 that are getting old and need to be replaced. One is used as the remote link from which I can connect to the server at work from home. The new ones will have Windows 10. The first one to be replaced had a problem installing Access 2010. Not...

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.