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 derfloh 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: *

  • Users: glavster
  • Content: Threads
  • Order by date
  1. glavster

    Converting an MS Access Query to MySQL Query!

    Hello can anyone help me convert the following MS Access Query to a MySQL pass through query. INSERT INTO va_categories ( category_name, parent_category_id, category_path, is_showing ) SELECT First([va_c2k].SubCategory) AS [SubCategory Field], [va_c2k].cat1, "0," & [cat1] & "," AS...
  2. glavster

    Help with Access MySQL pass through queries!

    Hello all, I have an Access DB connected to a MySQL DB using linked tables. In access I've got several various update and append queries and a local products table that help populate the MySQL DB. Everything works fine but it takes forever to run the queries. I was told that if I use SQL...
  3. glavster

    Query Update problem.

    Hello I'm trying to do an update query by compairing certain fields. Here is the query so far, UPDATE [Enhanced-GB] INNER JOIN va_categories ON ([Enhanced-GB].SubCategory = va_categories.parent_category_id) AND ([Enhanced-GB].Sub_SubCategory = va_categories.category_name) AND...
  4. glavster

    Query 2 columns in a table and then change one columns entry.

    Hello, I have a table in an MS Access DB with about 12 columns. It has about 35,000 entries and I need to upload it to a MySQL database. Before I can do that I need to change entries in 3 Columns and all 3 columns are linked. The first column was easy but the next 2 are a little more difficult...
  5. glavster

    Calculations in reports?

    In my report I calculate VAT for Invoices In and for Invoices Out with this formula. =Nz(Sum([AmountExVAT]*[VRate]),0) There is an InOut Header and the calculation is in the InOut Footer In the Report Footer how do I calculate the differnece between Invoices In and Invoices Out. And if the...
  6. glavster

    Reports and textbox naming

    Hi a quick question. Is it possible to name a text box in a report based on other values in the report. Hope ye understand this question. If ya don't I'll try to explain better. Thanks
  7. glavster

    Continuous Forms Help

    Hello everyone. I need some help with forms. I have a Continuous Form with 4 Combo boxes in the Header. I need Data Entry set to YES. And I need the values chosen in the combo boxes in the Header to be entered into the table INVOICES for all new entries of the Continuous Form. And no other older...
  8. glavster

    From Form Headed to Table for all Continuous Form entries

    Hello to all. I am a newbe to this forum and to MS access. The problem I am having has to do with Continuous Forms. In the header of the form I have 4 Combo boxes. For now lets just work on one combo box. The combo box name is 'PYID'. The table name is 'Invoice' and the field name is 'PYID' and...

Part and Inventory Search

Back
Top