Search results

I have determined that the .attachments within the Appointment is just a read only property so that is why I have been getting the error. However, I haven't been able to get an attachment to pass through.

Hi- I've created some VBA to add appointment information contained in my database to a user's outlook calendar. The code works perfectly until I tried to include an attachment in the appointment using an attachment field in my database. I've scoured Google and these forms to try and find a...

When I double click a record in search results nothing happens with that code. I also removed the brackets around SearchResults and still nothing. However, I changed the Debug.Print to MsgBox() and the message box pops up. I am getting no values for the hidden fields. AH HA! pr2-eugin - I...

pr2-eugin - Thanks for the reply. I tried the change and it is still not working. I also looked through my OnCurrent, OnLoad, and OnActivate code for the "Prospect/Client Entry" form and I don't see anything that should affect the values I am trying to pass through. The only code in there...

Hi- I have a listbox containing a large number of potential prospects. When a user double clicks on one, I am trying to pass information contained in the list box to the new entry of a form that launches on the double click. What is weird is that the first field populates in the new form, but...

Ok, it had started to seem that way. I think i might have an excel file with a pivot linked up to my Access table and use GetPivotData to pull what I need into a formatted table.

Hi- I am running into some issues when trying to create a summary report. I have a table called PipelineDB which contains sales leads. I am trying to create a report that will have three fields for different groupings. Attached is an excel file of the template i'd like to create. I am able...

My apologies John. I am at an airport with spotty wifi service and had not received the email alerting me that someone had responded to my thread before I deleted it. I had not referred the thread's page either. When I spent more time with my code I figured it out and didn't want to clutter the...

Hi- I have been building a customer & sales lead database and was hoping I could get some help with a NotInList event. I have a menu form where the user will select a prospect from a combobox. The combobox is currently set up to not allow them to add items to the list. When a user types in a...

This is what happens when people ask an Access newbie to create a database from scratch. This website has been a godsend.

I appreciate you patience. I just double checked and somehow my coupon field was set to Long Integer. That would be the problem. You've helped me solve all of my issues! Thanks a bunch.

It looks like Me.Coupon.Value is the only field causing the issue. New Business Revenue is now calculating correctly and saving down.

Gotcha. The issue I have been running into is that my VBA calculates the amount correctly, but always writes down $0. I put in message boxes to test the calculation of values, but it always seems to lose the value before writing down to field. Private Sub RunCalcs() Dim CouponCalc As Double...

I calculate these fields in my forms, but Access was not letting me save down these values into the table. When i posed that question on the Forms board, people told me never to save calculated fields down to my table. I would prefer to just have these calculated fields saved down into my...

In which control source? I tried it in my "Stage Header" textbox control source and it results in a #error. I have also tried using the same control source here and change "Running Sum" to "Over Group", but that is not working either. Stage 1 has two entries $79,000 and $0. Putting the same...

Hi- I have a calculated field in my report called "New Business Revenue". I used the expression builder to calculate this value for each item in my report. I subtotal my report using a field called "Stage". In the "Stage" footer field I am trying to sum my calculated "New Business Revenue"...

I get that I can do that, but then I have a large gap where there is no data being presented. Is there no way to have this item overlap into the next field? It would only come into play in the header area which will be blank in the next field anyway.

Hi- I am making my first access report and I have subtotaled by report by a field named "Stage". In the "Stage Header" section my stage name is getting cutoff. The text will not overlap into the next column. I would like this Stage Header to be one line and overlap the next column. Is this...

Hi- I am working on an Access database where people will be entering & editing potential sales leads. Currently i have made two forms, one for entering a new lead and one for editing existing records. The difference between the two comes down to which record the form launches to and the New...

Paul, I'm not quite sure yet if it will be absolutely necessary for me to store this value. I am going to be creating reports based on this information, and I have never written a report in Access. For now i'll keep the field in my underlying table, but change my form to be unbound for that...