Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. doobybug

    Link a field in a form to a webpage field

    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...
  2. doobybug

    Link a field in a form to a webpage field

    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
  3. doobybug

    Create a form to filter records in a table

    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?
  4. doobybug

    Command button to overwrite a field with data

    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
  5. doobybug

    Get Data from a query and save it in a table by a button

    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 " & _...
  6. doobybug

    Get Data from a query and save it in a table by a button

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

    Get Data from a query and save it in a table by a button

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

    Get Data from a query and save it in a table by a button

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

    Get Data from a query and save it in a table by a button

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

    Get Data from a query and save it in a table by a button

    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])...
  11. doobybug

    Get Data from a query and save it in a table by a button

    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]), " & _...
  12. doobybug

    Get Data from a query and save it in a table by a button

    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...
  13. doobybug

    Get Data from a query and save it in a table by a button

    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...
  14. doobybug

    Help needed - database won't load

    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...
  15. doobybug

    Continuous form Total

    Another thing by data source what do you mean?
  16. doobybug

    Continuous form Total

    Should a total never be saved?
  17. doobybug

    Continuous form Total

    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]=" &...
  18. doobybug

    Help with full Join query

    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
  19. doobybug

    Help with full Join query

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

    Help with full Join query

    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...

Part and Inventory Search

Back
Top