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

    Insert Blank row in between each row of data

    Skip, No I just make my annotations on it for my own use. I used anotherhiggins snip and it works for what I need. Thanks Paul
  2. palgya

    Insert Blank row in between each row of data

    Thanks all for your help. I know that it's not usually a good practice to add blank rows but this import is just a listing of goods ordered. I don't need to go back and report on the data, I just want for my own records.
  3. palgya

    Insert Blank row in between each row of data

    I import a .csv of about 150 lines and have a need to add additional data to it. How can I insert blank rows in between each row of data? Thanks in Advance
  4. palgya

    Custom Outlook 2k3 form macro

    Hi, I created a custom form in Outlook 2k3 to be used with meeting requests for our catering dept. I have a tab next to the appointment tab that when clicked, opens my custom form so that users can order items from the food service dept. I need some kind of script or macro to run to...
  5. palgya

    Outlook 2003 macro's

    My problem is in not knowing how to write code to, for example, indicate that, when I type "Alt-R," then this would insert two lines of text that is in the macro. Outlook 2003 Exchange 2003 Win2k workstation.
  6. palgya

    Exchange forms vs Web forms

    Hello all, My organization is in process of implementing E2k3 this fall. We have about 75 eforms that we use on a daily basis that are in a mainframe environment that we are getting rid of. We want to recreate these forms but don't know what direction to take. Do we use exchange forms or web...
  7. palgya

    Run Time error 2427 with label program

    I might also add that I have a macro that runs OnClose for the form that runs a query that clears all of the checkboxes. UPDATE Individual SET Individual.PrintLabel = 0;
  8. palgya

    Run Time error 2427 with label program

    Bob, I'm sorry I was incorrect! SkipControl is an unbound textbox. SkipCounter is the control to tell how many to skip, and RepeatCounter is the control to tell how many to print. These are all in the header of the label report. The previous code is run on the On Print procedure of the Detail...
  9. palgya

    Run Time error 2427 with label program

    Thanks for replying Bob, [SkipCounter] And [SkipControl] are in the header of the report. [SkipCounter] is the control to tell how many to skip and [SkipControl] is the control to tell how many to print. Hope this explains. Thanks again. Paul
  10. palgya

    Run Time error 2427 with label program

    Hello all, I have a form that the user can update info on their clients. What they wanted to be able to do is print individual labels from this form, so I thru a checkbox on the form with a button that when clicked would print these labels if the box was checked. The other twist was that they...
  11. palgya

    How to change parameters in code to enable report to print

    Hello all, I have a form that the user can update info on their clients. What they wanted to be able to do is print individual labels from this form, so I thru a checkbox on the form with a button that when clicked would print these labels. The other twist was that they could also choose how...
  12. palgya

    Excel 97 spread sheet creates a shortcut on desktop

    Often used Excel 97 spreadsheet creates a shortcut on my desktop. How can I make this stop happening? Thanks in advance.
  13. palgya

    User wants to change the look of text on a form

    Great tool but not worth the price for this client. thanks paul
  14. palgya

    User wants to change the look of text on a form

    Thanks Mr. Johnson, Kind of what I thought. They are already contemplating the OLE direction. paul
  15. palgya

    User wants to change the look of text on a form

    Hello all, I have a client that has a form in their database that they enter account history on. They want to be able to change the font, font size, color, be able to bold, italicize and so on to emphasize certain entries/words. They enter this history in a text box that is a memo field in a...
  16. palgya

    Problem printing URL's on every page

    marcs41 thanks for the response, changing margins didn't help. I downloaded newer print drivers from hp and everything works just fine. paul
  17. palgya

    Need help adding date parameters

    Here's what I did to solve the problem of date's. In the query sql: SELECT Table1.date, Table1.school, Table1.town, Table1.trainer, Table1.bodypart, Table1.sport, Table1.inj, Table1.Source FROM Table1 WHERE (((Table1.date)>=[Forms]![queryform]![startdate] And...
  18. palgya

    Problem printing URL's on every page

    Hello all, I have a user that wants to print the url in the footer on every page. When we look at the page setup in IE6 it is setup correctly (&u&b&d), but when they print, it prints on every page except the first. Anyone ever come across this? I'm thinking that it has something to do with the...
  19. palgya

    Need help adding date parameters

    Thanks zemp, If I were to specify a startdate and an enddate would it be like this? Where <datefield.=between #&quot; & startdate & &quot;#&quot; and #&quot; & enddate & &quot;#&quot; And what if the field is left null by the user? Sorry for being incompetant but I'm new at this. Thanks...
  20. palgya

    Need help adding date parameters

    I have a form the user enters criteria on that searches a table for information with a query that I need to add date parameters to. I have an idea how to do it but can't quite get the syntax to work properly. Private Sub Search_Click() Dim trainerList As String, schoolList As String, townList...

Part and Inventory Search

Back
Top