Search results for query: *

Hi, In fact that's what I want. I want the changes in the website to update my database. Basically this is a country form, where i am going to capture Rate of exchanges etc... and I want the database to automatically link with a webpage to get the data and always display to the user the latest...

Hi all, I am trying to make a form with data which is already existent in a website on the Internet. Thus I am trying to eliminate data inputting and linking each field to a part of a webpage. Any idea how I can go to do this? Thanks for your help

Hi, I need to create a form to perform a search in a table, with any fields found in that table. Can anyone help me pls?

Hi, I am trying to do a command button that when clicked, a certain field in my form will be overwritten with the value of a field in a table of my database. Is this possible? Thanks and goodmorning

This is what I did I did a query named d- SELECT Sum(CityMarket.[A Outlets]) AS SumOfA FROM CityMarket WHERE (((CityMarket.BranchId)=[Forms]![RegBranch]![RegBranch1].[Form].[BranchId])); Then In sql I wrote this Private Sub GetData_Click() Dim SQL As String SQL = "UPDATE Branches " & _...

Perhaps I need to use Update insert of insert as the record would have been already created?

Bdw in the table Branches the data is being appended but as a new record not with the record that has that BranchId

The unique keys are for table Branches BranchId and for table MarketCity MarketCityId with fk BranchId!!

Hi, Sorry for the late response. This is now giving me a key violation!

This is the debug message INSERT INTO Branches ([A Outlets], [B Outlets], [C & D Outlets], [Wholesale General], [Wholesale Semi/Conf], [Catering], [Table Top], [Others]) SELECT Sum([A Outlets]), Sum([B Outlets]), Sum([C & D Outlets]), Sum([Wholesale General]), Sum([Wholesale Semi/Conf])...

This is what I have: Private Sub GetData_Click() Dim strSQL As String strSQL = "INSERT INTO Branches ([A Outlets], [B Outlets], " & _ "[C & D Outlets], [Wholesale General], [Wholesale Semi/Conf], " & _ "[Catering], [Table Top], [Others])" strSQL = strSQL & "SELECT Sum([A Outlets]), " & _...

Hi, I tried this but still no luck. Basically if you can help me I want a button that when I click it would give me the totals of the sum of each outlet (Query must be by BranchId). The branchId can be obtained from the record that I would be clicked on on the main form (RegBranch1) Any...

Hi, I have 2 tables Branches BranchId, RegionId, City Name, Population, A, B, C, D, E, F, G CityMarket CityMarketId, BranchId, Market Name, A, B, C, D, E, F, G I need to get the totals of A, B, C,... by Branch Id from City Market and input it in the table Branches. All this is done by a...

Hi, I have a small database which had a main page. I wanted to remove it from a main page from tools and I did so. As soon as I tried to close the database, it asked me whether I should save class1 which I did not have any idea what it was, so I chose no. Now as soon as I try to open the...

Another thing by data source what do you mean?

Should a total never be saved?

Hi, I have a form having this format: A, B, C, D, E, F, G I need to produce a Total that adds A, B, C, D, E, F, G for each record I tried to create a query to sum these fields and then look up the value using this: =DLookUp("[Total]","[qryTotUniv]","[BranchId]=" &...

still the right hand side is giving more records than the left! In need some 200 records and it is giving me 9000! records on the right side are being duplicated

This gives me much more records that I have! It is repeating for sure the Orders! Any ideas why?

Hi I am trying to make a query to combine 2 other queries: I have 1 query JunOrd (Shows all the orders in June) OrderNo OProdCode OProduct OSize OSizeUnit OPack OCase OQtyNet OQtyFOC TOQty The other query is JunInv (Shows all the invoices in June) OrderNo SProdCode SProduct SSize SSizeUnit...