Tag Info

New answers tagged

0

You can see the information how SQL tables are linked. Keep the mouse pointer on the link table. You can see all the information like DSN = (Data Source Name) Name of the connection UID = UserID APP = Applicaton DATABASE = name of the database in which the linked table is available NETWORK = SQL Server network protocol ADDRESS = Server IP,Port TABLE = ...


0

A simple union with an order should be enough to achieve your results. And this will give more consistent results if your source tables aren't correctly ordered. All be it possibly with worse performance. select c1 as Results FROM t1 union select c2 as Results from t1 order by Results asc


0

select c1 as c3 from T union select c2 as c3 from T


0

this should do the trick if you are using T-SQL select C1, C2, a.Chuck from testa right join (select C1 as Chuck from testa UNION ALL select C2 as Chuck from testa) as a ON a.Chuck = testa.C1


3

If the SQL server table is modified will it be automatically reflected in the [linked] table and when? Yes, on next refresh or requery. If I edit the linked Access table will it be reflected in the SQL server table? Yes; as before, these updates will be visible on the other end on next refresh or requery. Trusted Connection only controls how the connection ...


0

Have you opened the window in the Normal mode (instead of Dialog)? Have you tried explicitly changing the Height and Width properties of the form in the OnLoad event? You're correct about the selecting the main window and maximizing it. You could create an AutoExec macro that will select that window and then issue Maximize.


0

The Update statement you posted doesn't include any join to table_3. This leads to a cross join and all the rows will be set to the same (rather random) value. Here's the query that should perform the correct update: UPDATE (Table_1 INNER JOIN Table_2 ON Table_1.Acct_Name = Table_2.Acct_Name) INNER JOIN Table_3 ON Table_2.Acct_Name = Table_3.Acct_Name ...


0

Use the Party Model (uses Table Inheritance). Use Junction Tables (aka Many2Many). PostgreSQL syntax, as I haven't done Access in a while, but you should be able to figure it out: --Start with Single Table Inheritance as it's easiest: --I hold information for Organizations and Individuals: create table parties ( party_id int primary key, type text ...


2

The problem is most likely some NULL values. Unfortunately, NULL LIKE 'anypattern' will not result in FALSE but in UNKNOWN and NOT UNKNOWN is still UNKNOWN. So any row where one or more of the values is Null, will not be in the result list because WHERE filters all rows that the condition is anything but TRUE (FALSE and UKNOWN get rejected). Try this ...


0

For Microsoft SQL Server, MySQL, PostgreSQL, etc the wildcard is not * but is %. If you search for "wildcards" in your SQL documentation you should find your particular server's supported wildcards. EDIT: Post comment: Sorry, I have never written MS Access queries.


0

Perhaps rewrite the statement so Microsoft Access can more easily understand the requirements. Something like: SELECT T1.Product, T1.Color, T1.SEQMAX, Table1.Attribute FROM ( SELECT Table2.Product , Table2.Color , SEQMAX FROM Table2 LEFT JOIN ( SELECT Table1.Product, ...


1

Store the running time as an integer in total seconds. For display purposes you can convert the number of seconds into a string in hours:minutes:seconds format or whatever display format you choose.


2

You need to add: On Error Resume Next DoCmd.Close AcQuery, "QueryFromMasterSearch" On Error GoTo Run_Click_Err just before you open the query. So, your code becomes: Private Sub Run_Click() On Error GoTo Run_Click_Err On Error Resume Next DoCmd.Close AcQuery, "QueryFromMasterSearch" On Error GoTo Run_Click_Err DoCmd.OpenQuery ...


0

The DatePart function will extract a specified part of a date/time field. The following example extracts the hour from the current time. =DatePart("h", Now()) Here is a link with more information on the function.



Top 50 recent answers are included