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!

  • Congratulations Mike Lewis 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. LionSkyWalker

    Sending parameters to a query

    Thanx, it worked with "between [Enter start date] and [Enter end date]" And it wasn't so complicated. See u
  2. LionSkyWalker

    Sending parameters to a query

    Hi there, I have a little doubt: I have a report, it works with a query, But my doubt is, how could I send parameters to that query from a form??? or How could I request for those parameters before I open the report??? I hope u can help me.
  3. LionSkyWalker

    ListBox from Form to Report

    So if I can't place the list box, how could I place those values into a report??? I already have the values I need on a table like this: Area HR HM MR MM 1 4 6 5 3 2 2 7 8 2 3 3 4 3 7 4 2 5...
  4. LionSkyWalker

    ListBox from Form to Report

    Hi there, here is my problem: I have a List Box type value list, and I fill it on-the-fly. But I need to place the list box from the form, to a report exactly as it is on the form. I've tried to place a List Box control in the form, and the data source is the List Box in the form, but it...
  5. LionSkyWalker

    Troubles with update

    That update works fine in SQL, but does not in Access. In access just says that it must use a query updatable... Or how can I do it in a Form in access instead than a query???
  6. LionSkyWalker

    Troubles with update

    Hi there. I'm having troubles with some updates, but here is the first: How can I update a Field, that get the value from a Count statement between 2 tables? Here's what I'm trying to do: Update TableX Set Field1 = ( SELECT Count(*) FROM Table1 INNER JOIN Table2 ON Table1.ses_id =...
  7. LionSkyWalker

    Need help with Update

    I have this SQL statement, and it works fine in SQL Update Table1 Set Field2 = (Select Count(*)from Table2) But it doesn't work with Access. Can anyone help me with this??? Thanx
  8. LionSkyWalker

    New Access user, need Help with UPDATE

    Hi there, I'm new with the Access, I have some experience with SQL, and this is my problem This run correctly in SQL: Update Tabla1 Set Campo2 = (Select Count(*) from Tabla2) But it doesn't work with Access... How can I make it in it?? Thanx

Part and Inventory Search

Back
Top