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.
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
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...
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.
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...
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;
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...
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
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...
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...
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...
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...
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...
Thanks zemp,
If I were to specify a startdate and an enddate would it be like this?
Where <datefield.=between #" & startdate & "#" and
#" & enddate & "#"
And what if the field is left null by the user? Sorry for being incompetant but I'm new at this.
Thanks...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.