Search results

:D this worked... thank you!! Now I just have to work it into system. Appreciate the assistance

Dcrake, Thank you so much for the help! So what you are saying about the new table and indivudual records makes sense. Is there a way for me to automate the creation of each of these indivdual records? That's what I'm trying to get to. Thanks

So right now it is 12 fields hence the not really able to manipulate. The idea of 12 records in a seperate table is the direction I was headed but I haven't determined the exact set up. if it is 12 records, how is eached tied back to the Contract ID and then Month/year?

Let me see if I can explain. We have an access database that tracks contracts. On one of the forms is the below section. The fields for each month are manually updated, I'm trying to make this automated, and display the monthly cost for that contract in the current year. The example below is...

and just a note to the above, I maybe approaching this in the wrong way... I just couldn't come up with another option.:confused:

So, my apologize I wasn't clear. I have the monthly cost... but I need to connect that $$ amount with a month and year assignment, so I was thinking dynamic multi dimensional array. So the array would use something like the below data to com up with a cost per month in the appropriate year for...

Dcrake, That is something I need to look at with the users, but the occurance of these dates in the database are pretty few. Most contracts start /end begin or end of month. I'm really stumped on the code to assign the cost to month and year. I'd think that once I determine the code for that...

Hi all, Looking for some help with my access code. Hopefully I can explain this. I have a DB with some dates tracking contracts - ContractEffectiveDate and ContEndDate and then a dollar amount assigned to this for the year of the contract. I have worked out a calculation that determines the...

Bob, Thanks. I actually had caught and corrected the typo... had some issues posting the thread must have missed updating... Thank you the resolition worked perfect On the Chr(13) needs to be with Chr(10), why? or can you tell me some place to get a better understanding? I'm not getting any...

Hi All, I've done some searching and haven't been able to resolve this one, hoping someon ecan help or point me to a site. I have a Module that all my email automation code is included in I can send an email and all works great. What I'd like to do is include some details from the current form...

thanks for the link That worked for what I needed

so to use ContactID I'd need a relationship to the Contact table to make that work, at least I think I would... The issue is that my Contact table is set up very specificlly to be connected to Active directory to extract emails andaddress info for contacts. Everytime I try to make a...

vbaInet, apologize... you sent me to Paul's sight and I just jumped to that... lol :rolleyes: let me give this a try

So one additional note... I tried Paul's suggestion with DoCmd.OpenForm "frmContacts", acNormal, , "(Forms!frmContacts.FirstName And Forms!frmContacts.LastName) Like '" & Me.MonsterContact & "'" and the value of Forms!frmContacts.FirstName And Forms!frmContacts.LastName is null... so I'm...

gHudson, tried the code and strWhere remains null Paul, my question on the example on your site would be the syntax of the concatenation of FirstName and LastName I tried the below and get and Complie error 'Expected: end of statement' highlighting " &[LastName] Like '"...

Hi All, I'm trying to create a command button that opens a second form and when the second form opens have a matching condition. So basic code would be Private Sub cmdOpenfrmContacts_Click() Dim strWhere As String strWhere = "[Contact] = '" & Me.Contact & "'" 'Open the form...

Paul, yes, and thank you ... the first time I read the it made zero sense to me When I went back again and figured out the If Not IsNull needed to be changed to your test that put me onto a differnet thinking and I found the code and syntax I needed to keep it a text box... the textbox is...

DCrake, I'm not sure I understand what you mean by check your form controls? and, correct my fields in the form are not bound to a calced field on a table... they are a DLookup of a calced field on a query, so when the data on the form is changed I need the Query to rerun to update the field...

Paul, thank you for all your help... I did some google searchs on using a Multi select textbox and came up with what I needed So Mike to answer your questions.... I used 'IN' My code for the syntax If Not IsNull(Me.Month.Value) Then strWhere = strWhere & "(Month([ContEndDate])...

ok, so I completely didn't get the NULL thing the first time :rolleyes: But I change the code to If IsNull(Me.Month.Value) Then For Each varItem In Me.Month.ItemsSelected strWhere = strWhere & "(Month([ContEndDate]) Like " & Me.Month.ItemData(varItem) & ") AND " Next...