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

    Print on a form

    Whats the command/suntax to print a line on the form? Thanks
  2. AmritPaulSingh

    Report Printing

    I have a command button that does many tasks on its on clink event. Apart from other tasks, it prints out 2 reports. The first report that it is printed comes to the defualt printer, but the second report prints to another printer and not to the default printer. Is there a report property or any...
  3. AmritPaulSingh

    List Box

    I have a multiple selection list box. How do I get the value of the selection of the list box in a text box? My lst box (lstPP) contains the following values: 1 2 3 4 5 If I select 1, the text box should get the value 1 If I select 1 and 3, the textbox should get the value 1,3 Help...
  4. AmritPaulSingh

    2nd Line in VBA coding

    If the VBA code has a very long line, how do i break it in 2 or more lines. I know there is something to do with & _ but am not able to use it. Thanks
  5. AmritPaulSingh

    Disk Or Network Error

    I have an access database that is used by mulitple users at different locations. The users use the database through citrix and they quite often get a "Disk or Network Error". There was a backend end and one front end to the database. I made multiple copies of the front end, one...
  6. AmritPaulSingh

    Disk or Network Error

    I have an access database with the backend at one location and mulitple copies for the front end for all users at different locations. The users use the database through citrix. They at times get a "Disk or Network Error". Earlier I had the forms bounded to the tables and so though...
  7. AmritPaulSingh

    VB vs Access

    Could anyone tell me what are the advantages of using Visual Basic over Access (if that's the case) ? Thanks
  8. AmritPaulSingh

    Open crystal report through access form

    To open any report created in access, all I need to do is code the click event of a command button as : docmd.openreport "rptName" How do I get open a crystal report using a command button? Thanks
  9. AmritPaulSingh

    Crosstab Query

    I created a crosstab query and would like to create a report with it. The problem is that the column headings of the query change as per the parameters. How can I make this happen in a report. Also, is there a way to open a recordset for a query. I'll appreciate help. Thanks
  10. AmritPaulSingh

    Static date

    HI I need to have the current date in one cell of an excel file depending on whether another cell is empty or not. I can do this with an if statement and copy the formula. The problem here is though that when I save the file and open it the next day, the date will update itself. I would like the...
  11. AmritPaulSingh

    Open a recordset fro a query

    Hi I am able to open the recordset for a table. But how do I open it for a query...a query that I created using another query. The code I use is: rs.open "[qryQueryName]", conn, 1 The above code works just fine if I replace the query with an existing table. Any suggestions?
  12. AmritPaulSingh

    Default value for Date Picker

    Hi guys I amnot able to set the default date in the Date Picker. I need Date()-1 to be the defualt value. Any suggestions. Thanks
  13. AmritPaulSingh

    Date Picker

    I need to create a control (probably a text box) with the calender popping up on it getting focus, something like a dat picker. Any suggestions?
  14. AmritPaulSingh

    To open a Snapshot File to its maximum size

    HI Programmers: My program send a report as an email to a distribution lis in snapshot format. I want the list to be opened in the maximized window when double clicked, but for some reason it only opens it a particular size. I tried going to Snapshot properties and select "maximize" as...

Part and Inventory Search

Back
Top