Search results

If I have an XML file that contains the following branches: grandfather table, father table, and son table, I have linked the grandfather table to the father table as shown in this code. However, I was unable to link the son table to the father table because there is no linking number PK in the...

Can you please convert this XML to XLST to get PK with FK with all tables to use with the transform command when importing XML or give me your feedback about this XML can be done? is this XML fit in access to create relations between tables after importing

Hello Is there a code to import XML file and pass transform file also then convert the file to tables I want to convert import XML wizard to code but must access transform files Thanks

friends a client sent me xml containing a lot of tables When used this method Application.ImportXML every tag created on a separate table my question: when opening access tables after importing form XML not see shared fields between these tables. is this error or Is there something...

Thank you CLIENT gave ME A set of 10 text files with ambiguous data and no field descriptions, I uploaded them and discovered that each converted file had a repeating foreign key but no primary key. The task was to join these files together. I proposed two solutions: 1. Linking all foreign...

Hello friends; I'm using this code to search in Excel Table and display the result in LISTBOX On USERFORM but I think this code is complex do you have another code? Can you suggest an easier code? Private Sub TextBox1_Change() Dim Data, Arr, Crit As String Crit = TextBox1 With...

I have 2 Tables in attached DB Imported And AllDataSource I want to create query append data from Table Imported to AllDataSource but if the the record is exist in AllDataSource Update the record in All Data Source Table 1- Append Data from Imported Table To AllDataSource 2- if record exists...

First Query SELECT Year([MyDate]) AS YearfromDate FROM TransactionTable; Second Query SELECT Query1.YearfromDate FROM Query1 GROUP BY Query1.YearfromDate; Why does this error appear Invalid procedure call When run query 2 and what is the solution Thank you so much

Hello SQL SERVER not access Table Structure / employee name Department Salary City the table will be full of data ------------------------------ Pivot Table Result will be like this: department Alabama Arkansas Georgia IT 100000...

how can I show show queries by vba show queries list (Properties) Navigation

How to add power query to specific table by code I failed on all my tries Thanks

how can I delete one of my posts Thanks

1- How can I use the sequence as the default value for a field? or as a computed field 2- Is sequence must be bound to the field by using SQLcode only when creating the tables by using the create table statement

if I create a field with this size decimal[ (38,2) is this affect the performance? maybe I will use a small number or not use the all 38 number

friends Is there any VBA code to append all existing queries Bard Code Is Sub CombineAllQueries() Dim query As WorkbookQuery Dim combinedQuery As String For Each query In ActiveWorkbook.Queries combinedQuery = combinedQuery & " " & query.Formula & " " & Chr(13) & " " &...

friends Is there any developer create free code (Application) to import files to power query? the file have the same structure and same data types we can use I mean he put this code in the public library code

why does this message appear every time or every day when opening SQL server management studio

How can make Back-Up Azure SQL SEVER DB From SQL SERVER M S Notes: The backup option not listed when using the shortcut menu

Why does this code not accept the parameters inside SQL create view from the stored procedure? I want to pass the value of stored procedure parameters to create a view Create PROCEDURE MyProcedure @ID int AS BEGIN -- if object_id ('myview' ,'v') is not null DROP VIEW IF EXISTS myview...

friends If I have an online SQL server Db and I have 10 users for example Should I create one user for all these users and they all login by this username and password or create for every user ( username and password)