Search results

Thanks, Gasman, I've tried this - added in the OnError in the same main form which have the nav tabs. The result was the action in the tab where disabled/ignored in the sentence the form in the Tab's Navigation Target Name did not opened. But the app could run 'as normal' when select the Tab's...

Thank you for input, but believe I've found at least one of the reasons why I got this error. The main form, holding the navigation menu tabs cannot have any code behind it (that is - all form events must be clean). So I deleted and moved out all code there and selected the No on the Form ->...

Thanks anyway - I've read your post from earlier. I will try to put the code in the form into a standard module instead of macros which i also suggested as an solution, and will see if that 'curer' the issue. But also using macros could be of interest.

No probs - I do understand what you are writing. But the challenge is that the program app needs to connect to the backend with connection string, not linked tables. This because with linked tables from the server, it's impossible to be sure that no-one can get data they shouldn't. One example...

As I wrote to Arnel, it's not linked tables, it's referred to the BE via connection string. So I would have to link the BE, and then embed the tables, and then I have to recode all references to tables due to different connection type - i suppose - correct me if I'm wrong here...

Gasman: Thank you, I've tried these solutions and we all are using latest release of ms off enterpr. dalski: I've done everything on the same computer, Tested on another computer with same errors on both. Btw, the selected refs are following the program, at least I've checked that the same...

2: Badly named var's are checked with the compile in Tools, VBA Editor, and yes, all forms starts with the Options... set. The references I'm referring to is the references you set in Tools->References like Microsoft Outlook 16.0 Object Library etc.

Hi All. As the thread title says, after compiled to a accde file, I'm getting this error on certain tabs in the navigation pane. Background: Using a Navigation pane system (left and top tabs). On three of the Top Panes tab for opening certain forms, when clicked - I get this error. Immediately...

Yepp, it's included now... :) Geirr.

Thank you all, we where all focused on the wrong place... As mentioned initially, I select each record to be updated via checkbox on each row. Again, i loose sight on the fundamental issue: When clicking the 'Update' button, the last clicked checkbox (record) was not yet saved... The upside I...

Because the FE - even an completly locked .accde, it's possible to import linked tables (with defs) and queries to an another accdb - that's scares out the IT sec. department in my company... This is avoided using connections and 'hardcoded queries' approach. Geirr.

Thank you, I know - I meant to emphasize stored queries in my reply. By that, se my reply to isadogs below. Geirr.

Thank you for input, bud sadly it gave the same result here... Geirr.

Thank you for input. I'm not using separate/stored queries for the same reason I cannot use linked tables. I've 'transferred' several queries to vba code in form/report code, and maybe I should look into that approach - Nevertheless - I would really like to know where I went wrong because I'm...

Hi all. I could really need some help here... I just cannot figure out why the last record in a do while loop does not get updated. Background: Sql Server backend, connection string - not linked tables. The records I want to be updated are selected in a form with one check box on each row...

Thank you guys! Step one now works... The soultion where as arnelgp wrote using % and in conjuction with '%" & - - & "%' (placing the single and double quota). Now I have to find a new way to get around the Me.Refresh in the comboboxes After Update to update the .recordset which not working as...

Hi all. Found out that I want to go from linked tabled on sql server backend to sql connections within code. I've got a test up and running, but struggling with sql queries which are getting the Where criteria from the forms combo boxes. The actual SQL Query is: strSql = "SELECT...

Hi. I've seen your video and again I've checked everything here, in special if I've made any typo errors in any references or choices. The fun part I discovered late last night that for all three combo boxes, I can not use the 'build' option in the Row Source for the boxes, It's deactivated on...

No, not any events for any of them yet. Not any setup in On load or On open in the form as well.