Search results

So you have a form where the parent record is not valid until a child record is complete? You may have a problem in your table normalization. I would add a "add new" dialog box to collect the required information and then use a transaction with add new queries to add the data to the tables...

Create a new table in the shared database duplicating the other tables adding an employee ID column linked to you employee table. Temporarily link or import the 3 tables from the 3 databases. Execute 3 queries for the 3 tables filtering out un-needed data and adding the employee ID and excluding...

One thing to remember about exporting Access reports to Word is that any graphics lines, boxes etc. are lost in the transfer.

Single calls to domain functions for forms or reports are ok, but this in in a loop, and and noting a noticeable delay.

It's well known that domain functions are relatively slow which shows up in loops. Each time you use a domain function, Access needs to build a new query, create an execution plan and then open a new record set to get the result. It then needs to close and destroy the record set and query...

Use a parameter query, then update the index parameter in the loop. To make it faster, save the query. Dim qryNextValue As DAO.QueryDef Set qryNextValue _ = CurrentDb.CreateQueryDef(vbNullString, _ "PARAMETERS " & _ "JasonReceived Text (255), " & _...

If the activation is a problem, use the phone option (Microsoft clearing house). MS will normally supply a code for activation without a much fuss.

As noted earlier, "String" is the wrong type for response, MsgBox returns a long, though your original code runs on my computer. Have you tried calling out the enum with the value so you don't need to define the constant. This may not compile if something is wrong with those enum definitions...

Does the remodel include the water front view or do you already have it.;)

We are using Windows Authenticator. Use all possible security measure available to your license on 365 accounts. Limit remote access to corporate 365 accounts to only those users needing it. With conditional access and locations assigned to 365 groups, you can assign users to local only and...

A few other links https://go.microsoft.com/fwlink/?LinkId=627442 https://learn.microsoft.com/en-us/azure/active-directory/conditional-access/overview https://learn.microsoft.com/en-us/entra/identity/authentication/tutorial-enable-azure-mfa

If you are look for a all or nothing update, DAO does support transitions. If you have a recordset I presume you know the table and criteria for the selected records, why not write an update query?

I'm not using Azure so my users would see ODBC connection issues from Access FE to a Azure BE. That being said, if only some users have the re-authentication problem, did those uses check the stay longed in box? Also are the computers domain joined? To improve 365 security I used conditional...

We started with a Hybrid Join when we moved to 365. It did make it easer to onboard everyone but it did present some issues. The biggest one was security. Office 365 accounts are very easy to hack, even more so with multifactor authentication. If a user gives up there password, at minimum it can...

I know you rejected by previous suggestion to write the report to PDF and then present that to the user, but from the discussion I think that may be your best option. One of your issues with the PDF is that it is different from other reports, but this one is already different because you a...

With the use of a union query, conditional formatting and because the form is unbound setting the combo box value to 0 in Form_Load, I was able to get your affect. Private Sub Form_Load() mTboxWidth = Me.txtTemp1.Width Me.cmbUnion = 0 End Sub Added tblOne and qryOne for combo box source...

Have you considered always sending the report to PDF and presenting the PDF as the preview. Any attempts to reprint the report would reopen the saved PDF or creating a revision PDF to preview.

1) Confirm that each Citrix user is running their own copy of the front end. 2) Confirm that the all front end databases including Citrix are on the same WIRED network as the shared back end database. 3) Confirm that all network cards are working correctly i.e. no drops. 4) Confirm that the...

It's an Intel i7 about 5 years old.

I did the comment out and replaced your if because it didn't calculate true when perfect numbers were found. 2 to 33550338, I stopped it after 20 minutes. Access looks to be using multiple processors to run this code.