Recent content by FizzyFish

You might want to try doing that in a module instead of a form.

How do I group weekly data by a MonthEndDate? Ie. WeekEndDate are 2007-02-10, 2007-02-17, 2007-03-03, 2007-03-17 I need to somehow group these so they show the data as sums for 2007-02-29 and 2007-03-31 Thanks!

Maybe this will help. Dim OutlookApp As Outlook.Application Dim MailItem As Outlook.MailItem 'Create Email DoCmd.Hourglass True Set OutlookApp = New Outlook.Application Set MailItem = OutlookApp.CreateItem(olMailItem) DoCmd.Hourglass False...

Note sure if this will work but you might want to try .SenderEmailAddress = "Someone@Somewhere.com"

Try this code, it seems to work for me: Private Sub Notes_AfterUpdate() Dim sNotes As String Dim sEolPos As String, sLastEOLPos As Integer Dim X As Integer Dim NewLines As Integer sNotes = Notes.Value NewLines = StrCount(sNotes, vbCrLf) 'First add the bullet...

I think the easiest thing to do is check that the Condigo field length is less than 1 and the idordenes fiel length is greater than zero. The NZ converts null values to whatever you tell it to, in this case it converts the null values of both condigo and idordenes to zero so you can check if...

Using the IIF structure, you are on the right track, but the syntax is a little off. Replace the quotations around your fields with Square Brackets. If the values you want returned are just text values then putting quotations around them is fine.

There is no need to unlock the field before populating it in code, all you have to do is set the field to locked and save it. Add code similar to the following and it should automatically populate when the user clicks on on, but only if the field is not already filled in. Private Sub...

You can add a new record via a recordset by first grabbing the recordset into a recordset object, then useing the .AddNew and .Update functions of the recordset. Below is an example (using an ADP rather than mdb, but it should be similar). 'First connect to the curren project and Dim strSQL...

Okay this was just plain silly. Seems like SQL Enterprise Manager and MS Access don't recognize changes in Active Directory groups unless you reboot your PC. If you look at the groups in Active Directory the changes are there but for some reason they are not picked up until after a restart...

Hi I have a statement that checks if a login name belongs to an Active Directory group. The group is set up exactly the same way as all the other groups, which work fine, but it is not returning a positive when a login is part of that group. Any ideas why the return is a zero instead of a...

Okay it's solved! First thanks ajetrumpet for attempting to help. I got it working finally. I was very puzzled because I have created many unbound forms that function exactly as this one does, with listboxes and comboboxes and never had any problems with it in the past. Out of desperation, I...

You could also modify the code to run a query and check the resultset to see if anything returned in the BeforeUpdate event. Here is an example of something that might work. Private Sub Form_BeforeUpdate(Cancel As Integer) Dim strSQL as string, rst as new adodb.recordset, cmd As New...

Yes they are in the listbox in columns 6 and 7. I'm actually trying to force the selection from the listbox to be what is selected in the combo boxes. I'm attempting to use a generic unbound form to allow users to maintain data. How it works is I pass the ContactID and the type of data being...

I've created an unbound form with a list box and two combo boxes. The list box is multi-columns and contains the Primary Keys of the two combo boxes row sources. First column in each of the combo boxes is the primary key and has a zero width so they don't show. So here is the problem, I have...