I have a form that has a textbox on it. The textbox has code in the OnClick event and that code is firing when I click the textbox. The weird thing is that the textbox is disabled and the code is still firing when I click the textbox. I even put code in the OnClick event that displays the enabled status of the textbox and it shows that enabled=false.

I copied this form (in the same database) and the OnClick event doesn't fire on the copy.

Any idea what my cause the OnClick event to still fire on a control that is disabled?

Hi Experts,

I need to compare two files containing same data with different format.

They have following columns

Patients Name
Caregiver name
Visit Date
Visit time from
Visit Time to

would need to get a list of all unmatched records.
its only considered a match if all 5 fields are the same.

Attached sample of those files, where record in both files is considered a match.

Here are the differences, one of the files has the following
1- first and last name concatenated into one field.
2- has data in parenthesis after the names which should be ignored.
3- format of time is 1459-2304
Visit-Report.xls
V_TestHHASchedule.xls

I have a database (see attached) that has employees and tools. Each tool can be assigned to one employee but it can also be assigned to no employee. So there's an EmployeeID field in the Tools table that either has an employee ID in it or is null.

I have a query of Employees that has a field called FullName that is defined as [LastName] & ", " & [FirstName]

Lastly, I have a query built on the Tools table and the Employees query that displays the tool data and also the FullName of the employee the tool is assigned to. The query is set to show all records from the Tools table and only those records from the Employees table where the values are equal.

My issue is that if the tool isn't assigned to any employee, the FullName in the Tools query shows up as just a comma. I would have expected it to be completely blank since there's no record in qryEmployees that associates with this.

If I change the join in the query to only show only show records in both tables where the joined fields are equal, it leaves the records with no employee ID out of the query (as expected).

You can see this behaviour by opening qryTools in the attached database.

I don't know why it's showing the calculated FullName field for records that don't exist in the Employees query.

Any suggestions about why this is happening and how I can stop it?

Thanks in advance.tools.accdb

Hi

Our government customers are very angry with Microsoft, but I think this is nothing new as we know such problems with Windows 10.
I have to analyze this problem and advise our customers.

According to the Dutch organization that did the research for the Dutch government, we have the following infos:

-  Microsoft systematically and extensively collects data about the individual use of Word, Excel, PowerPoint and Outlook. Secretly, without informing the people. According to the Dutch organization, it is hard to find what Microsfoft collects as the data is encrypted.
-  Microsoft sends telemetry data to its own servers in the United States.

This is what I found that we can do for our customer:
- Disable Manage the privacy of data monitored by telemetry in Office
- Ban the use of Connected Services
- Not to use SharePoint Oneline
- Block OneDrive
- Lock web version of Office 365

My questions:
1) Did you deal with this case? If yes, what will Microsoft collect?
2) Is it enough to Manage the privacy of data monitored by telemetry in Office ?
3) Do I still have to go through the Report from rijksoverheid.nl  ?

Thanks

We use a back end / front end Access 2016 database.  The frontend contains the forms, whereas the backend stores all of the data.  This has been working well for the past 8 months.  Two weeks ago, we upgraded from a Windows 8 file server to a Windows 2016 domain environment.  All 10 workstations were added to the domain, along with 15 new user accounts.  All of the files were successfully migrated to the new server using robocopy.  We also implemented a GPO to enable Folder redirection for the users' Desktop, Document, Favorites, Photos, Music and Videos.  We also have a GPO to map network drives.

Since the move, users are receiving the following error about once an hour when using the FrontEnd, "Your network access was interrupted".  We applied the following changes to try and rectify the issue, but nothing appears to help:

• Turned off NIC Teaming on the server
• Copied the database to the local C Drive on each workstation (instead of the user's desktop, which resides on the server)
• Updated the Frontend so that it uses \\UNC instead of the Mapped drive

None of the networking hardware has changed.  All workstations are connected via RJ45 to a Netgear JGS524NA switch, and a Fortigate 60E router.  We have had no other network related complaints other than a few random instances where the office chat software could not connect to the office shat server (external server).  There have been no reports about access the share …

I need to use a datasheet subform's .filter property to generate filtered reports and other database actions.  However when I clear the filter using the attached code two things happen:
1) The actual subform is displayed with the filter cleared.
2) The subform's .filter property string still has the old value.

The same scenario occurs if I use the Ribbon icon to Toggle the filter and still the .filter string is not cleared.

 
I can clear the field in the Immediate Window just fine, just not with code.

Manipulating the datasource with programatically generated SQL is impractical.

Any ideas?

I am using the controls property of a report similar to :

  Set rpt = Application.Reports(MyReportName)
  For Each ctrl In rpt.Controls
      ' do something
  Next

However, i would like the rpt.controls to be sorted by ctrl.name prior to the For Next loop - is there a simple way to achieve that or do I have to load it into an array first?
Thank you for any help!
Regards Michael

Access 2003
I set Breakpoints, but when I run the Subroutine, the program does stop at the Breakpoints
Very simple question:  How does one enable breakpoints

Hi,
I would like help to amend a formula to speed up calculations with an INDIRECT function.
Please refer to attached spreadsheet.
Many Thanks
Ian
Indirect-Function.xlsx

I have a client who has an application which involves a combination of VBScript and Access to download data from an FTP site and then process that data into multiple Access databases. I'm not happy with the way this was implemented but I'm stuck with it.

I received an email this afternoon which indicates that about 15-20 of the files that should have been downloaded and processed on Monday did not make it into the Access databases.

Indications are that something occurred on there servers which affected their authentication service.  Any chance that this would have affected ADO communications between the VBScript and the Access BE databases?  I'm not a huge fan of VBScript or ADO and don't use either often enough to know what will or will not affect them.

Dale

Access vba

Using ian INSERT statement in vba.

What I need: sometimes the  " InProgress_or_Closed_at" value does not get inserted?
i'm i using the  "Now()"  correctly in the sql statement ?

Or is there a better way to write it to make sure a time stamp is posted correctly ?

ttt = Forms!dataentry.txtReOpened
                    strsql_sql = "INSERT INTO [dbo_t_nsc_trackcode_trans_time_entry](NSC_ID_Ref, [opened_at], InProgress_or_Closed_at)" & vbCrLf
                    strsql_sql = strsql_sql & "VALUES (" & Me.NSC_Id & ",'" & ttt & "' , now());"
                     CurrentDb.Execute strsql_sql, dbSeeChanges

Select all Open in new window

Thanks
fordraiders