Search results

https://www.connectionstrings.com/sql-server/ There are many great links, this is one of my shortcuts that has been useful.

The GoTo argument - that is what was expected. Yes, spaghetti code, what programmers use to keep a maintenance job to put starchy food on the table. In my past years of instructing VB and VBA, there were those who objected to using On Error GoTo The use of a Flag (boolFlag) is something I...

In this case, can't exit the Do (loop) because the Loop is at the Record Level. The Conditional Exit is at the Field(s) level. In the real code, there are 15 fields with different conditions. If any conditions return False, then there is no need to check the remanding fields. It is all so...

Thanks, I had one of those in the current Demo and it worked fine. Just wondered if there was something different than a GOTO statement. Other than Error Traps, the trend is to try and avoid them. But, it is simple and it works. But, its a working prototype. Well, let me GOTO your post and...

This question is really about exiting early if one Field receives an "Eliminated" status. Having started with a Do Until - there doesn't seem to be a way to exit midway in the Field evaluation. This example only has 2 fields while the real one has many more. Each field has a different formula...

Does anyone have ideas if Nami is worth pursuing? Please share the good, bad, and ugly. In a few weeks, I plan to start a WordPress development course. The database of choice is MS SQLServer, Azure might be a good start. The idea would be to keep MSAccess with Linked Tables for high volume...

When you have Excel (your primary WB) open - does the Internet open 3 workbooks inside your existing Excel or each in their own Application. Press Control+Alt+Delete how many instance of Excel are running? My bad and I should have known better. Since my code spawns a new workbook in the...

Have been working on it for the morning, same conclusion. Created a local table - use a query to add the first record from Listbox1 The rest of the records 0 to many - are candidates for the target. From that point, some nested Select Case statements evaluate row by row, column by column...

Would a custom VBA function on a Recordset be best or is there another approach such as a SQL Statement? See Attachment: The user chooses a customer Order in listbox1 and 2nd Customer in Listbox2 The Order1 is compared with similar Category and Inspector for the records of Custtomer in...

http://www.chicagobusiness.com/article/20160401/NEWS07/160409989/could-this-news-fool-you Some are worth looking at: Election Insurance - if the wrong Presidential Candidate gets elected - then your insurance lets you move to Canada for 4 years (the term of the President). Read to your Cat...

That is such an oversubscribed term. I conduct them in the world of Regulatory Compliance. it is not the same as for example bookkeeping or inventory. Transaction management for audits is another system commonly used. Please do expand on your thoughts.

for the Attached file, change the .PDF extension to a macro enabled .xlsm Open the dashboard.xlsm Make sure the Design mode is Off - Click on the simulate Web opening Excel button three times. The Workbook1, 2, 3 will be on top of each other, cascade them. you can open up the code window and...

Thanks for outlining the Excel creation, I think arnelgp suggestion will work. Once you were able to explain the process and result, a solution was possible. Pleas let us know either way what your solution was! B.T.W. it wouldn't be difficult to add a Save As and include something like your...

Sorry to be too busy yesterday to get back to you. This is good information. Need More: When the Internet application opens 3 new workbooks: 1. I assume the workbooks are opened on your workstation (not on a remote session). 2. Do these workbooks have a naming convention? e.g...

Sharing a network copy with multiple people at the same time is a problem. Before compacting on exit or other things listen to the experts on how to give each user a front-end each time they start the application and that will solve your problem. 1. Split the front-end from the back end. 2. Make...

Reporting trend in Access 2013 that creates a catastrophic App Crash (AppCrash) in the VB Module. It leaves the Locking DB open. There is no error trap for an AppCrash. Around 10 Weeks ago, a very small group of Access Programmers converted a 90 MB Front-End (SQL Server Back End) from Access...

current workbook (Lets call it MAIN) opens 3 workbooks - does some process with internet, then closes 3 workbooks. Main then opens 3 more for processing, and repeats the cycle again. Is that correct? Update this as needed. I will try to send code later today. Basically, MAIN needs to...

Sure. Now, the question back to you is can it be done in a Macro-Free workbook? Do you know how to make the drop-down part of a Named Range? Do you know how to make a Link from a Named Range to a query on a linked table? It was around 2003 when I did that for many users application. Is this a...

Queries that have summary can not be updated, you seem to have eliminated that possibility. Tables that don't have an index (e.g. an autocounter) are read-only. You seem to be aware of that too. Can you update data on each single table that makes up the query? Just trying to confirm that each...