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

    Set Validation Rule

    Hi guys! I'm working on a form that has 2 text boxes 1 for numeric values and the 2nd for strings, but I need to create a Validation Rule to prevent users enter strings in a numeric field. I also want to display a message to users that they must use the Comment box for strings. Any help on...
  2. Loui2005

    Export Access Report to an Excel Format

    Hi Guys! Thank you in advance for the greatest help you guys provide to Developers. I'm currently working on an Access report which I'd like to export to and Excel format/template. Is there any way I can do this by using VBA code? The query I use to run the Access report has 15 rows which every...
  3. Loui2005

    Import Excel file into a table in MS Access 2000 using VBA

    Hi Guys, I’d like to import an Excel file into a table in MS Access 2000. I need to keep the same fields name from Excel (Format) into the table. The data in Excel is on Sheet1. I’m having a big problem trying to achieve this process. I’d like to be able to keep the same format in the Access...
  4. Loui2005

    Can I use a pivot table in MS Access 2000?

    I need to create a crosstab report in MS Access 2000, but I'm not sure if I could work it. If not, I'd like to be able to create a dynamic crosstab report and write VBA codes, since the report will generate 2 or 3 or 4 or 5 different columns. Is this Possible? Any help in this related topic...
  5. Loui2005

    Use Crosstab subReport into a Main Crosstab Report

    I created a Main crosstab report on which I'd like to insert crosstab sub-report, and I want to be able to display the corsstab sub-report in the 4 different groups that main report holds. Is this possible? Any help in this related topic will be greatly appreciated. Thanks!!! Lou
  6. Loui2005

    How Can Update a Form with a query as Record Source

    Hi Guys!! Thanks a lot for your help. AppStaff, you are right. I've used a related table in the form. What I need to do is use this Form as data entry to capture data. I think I would for a make table query, and then put that table in the Form's Record Source. What do you think about this guys...
  7. Loui2005

    How Can Update a Form with a query as Record Source

    I trying to enter data in a form having a query as a Record Source. Can anyone help me please?
  8. Loui2005

    Total a unbound text box in the GroopFooder

    Hi Dear All, I have a problem with getting a total on a text box in the groupfooder section. Here the what the query looks like Field1 Field2 Field3 Rigion1 6000 NoKey Rigion1 6000 NoKey Rigion3 2000 NoKey Rigion4 5000 NoKey Rigion2 7000 NoKey...

Part and Inventory Search

Back
Top