Search results

I need to take a field that has data such as 1/13/03 and group it on a report. Such as I would like all the January 02 information under Jan 02 with all the corresponding information summed up. I have a query with all the information summed but it won't group on the month instead of the month...

I am needing to write some code to print a report to the default printer and also to the PDF distiller to save to a PDF format. I don't know if it would be easier to make the Distiller the default and then print that and then print to another printer. Any suggestions are welcome. Sam

It does put the notes first, but it copies all the notes again. So if I have 5 notes plus the new one I am entering it makes that 11 notes. Any suggestions.

Thanks everyone some of the suggestions work great. The only thing now is that when I use the last suggestion it copies everything in the notes and places all of that on the top of the others. How do I stop the duplication and just place the new notes on the top?

How could I use the above code, which works great by the way, to start at the beginning if I have the field diabled? Instead of starting at the end I would like to start at the beginning. Also, I have the field set to Enable=no because when I had it locked, when the user enters a note it is not...

That is not working for me. I am needing it to say if it is not null then perform those functions to undo the change. Any suggestions?

I have one field that I need to disallow users to change. Here is the code that I am using, but it if I put it after Change() then I can't enter new stuff and if I put it AfterUpdate() it won't stop them from changing it. Any suggestions? Private Sub Notes_BeforeUpdate(Cancel As Integer) If...

That's a great idea. Could you suggest some code to get me started. Kind of new to VB. THanks in advance, Sam

I am needing to disallow deleting in a notes field. Is that possible?

I am needing some help on a graph. I have some points that I need to graph and I am not sure how. Here is my code that I am trying, but have been unsuccessful. Private Sub Form_Load() Dim mx As Double Dim n As Integer Dim x(0 To 1000) As Integer Dim k As Integer Dim wd As Integer Redraw = True...

I am needing to make a graph using VB and I have some of the code, but I am getting a few errors and hoping someone could help troubleshoot. Here is what I am being asked to do: 1. Open the file. 2. Read the data a line at a time into an integer array for N total items. All of the numbers will...

I have an assignment that I am needing help with. Here is the problem, I have to compute the least squares best straight line fit to the points and plot both of them. Here is the formulas we were given to work with: dist=ABS(m8x0+b-y0)/SQR(m*m+1) To fit the data points to a straight line we...

I use some code to add a small header to each note I put in but it is not working very well. Here is what it shows. Dim intStart As Integer Me.[F_INotes] = "***" & CurrentUser() & "***" & Now() & Chr(13) & Chr(13) & Chr(13) & Chr(10) & Chr(10) & Chr(10) & Me.[F_INotes] intStart =...

I tried looking at the SendCommand but it still says that "There are too many columns to output, based on the limitations specified in the output format or by Microsoft Access." It is an extensive document, is there a different way that I should format it or certain format that is should send it as?

I have an unbound OLE object and after filling it in I am needing to email it with the information in it. It is a Loan application that was made in MS Word and copied to Access. It tells me that there are too many columns or it will just send the data table. Is there a way that I can send...

I have one report that won't pull up on other computers because it says that it was made for a specific printer. Why is it doing this and how do I change it? Thanks in advance.

Is there a way to set a message box so that even if someone doesn't click the button it will continue with the code? I am trying to set up my dbase so that if I want to log them off I can but I am running into a problem in that if they are not at their computers and click "OK" it will not finish...

Hey, it works great. Thanks for all the help.

Thanks for the reply Jack. I did try the code and it is now putting the cursor at the end of the existing notes and I would still like it to have a space below it and it's focus just under the name, date and time. Like this ***Name***Date***Time Message (Space) ***Name***Date***Time Message So...

I am trying to use this code to automate note entering by allowing the correct spacing and adding user name and time and date. When I use this code all it will do is add one space and two boxes under the user name and time and date. I need at least 2 spaces under the name, time and date and then...