Search results

Okay Guys - First off, thanks for the help. I have added the procedure heading to the code so you can see which event I am in. I also moved the SQL query out of the For Loop, but now my list box is not recognizing that there is a record selected and it is skipping setting my variable...

Hello All - Have any of you ever had an issue where your code will work on a double click Event, but not a single click event? The code listed below is doing this to me and for the life of me I cannot figure it out! The error that I am getting is "Object Variable or With Block Variable Not...

Thank you so much! I was able to use your first link to resolve my issue! Tallman

Hey All, I am having a horrible time trying to get 3 unbound text boxes to insert into one list box with three different columns. I am essentially setting the information in the unbound text boxes to strings and then trying to add the strings into the value list, list box. For example...

Perfect! Thank you!

Hello, It is showing Datasheet view. Thank you,

Hey Guys, It has been a while. Hope all are well. I am working on trying to get a date field on my subform to turn red when the date that the field list is > 30 days. In the expression section of conditional formatting I have tried: DateDiff("d",Date(),"Dt_Approved")>"30" Any...

Good Morning, Has anyone ever had issues with a AutoNumber field duping on them? I have a table that every morning about 200 records are inserted into the table. I noticed that I actually have dupes in my auto number field. I did not think that was possibble? Has this ever happened to...

Interesting. I learned a lot on this thread. Thanks guys!

Hey Guys, I have an auto email that is sent using Access 2007 VBA. I am trying to add a header and a footer image to the top and bottom of the email to make its appearence more professional. I have heard there is a way to convert an image into an HTML code then use a function to bring it...

Perfect! I will try this. Thanks Pbaldy!

Good Morning, I am working on my first list box. Currently an associate selects an acct number and clicks a button. The code below fills the list box. it is only one field. [SELECT DISTINCT Test1.ID FROM Test1 WHERE (((test1.acct_nbr)='12345678')); What I really need to happen is to have...

Ah ha Thank you, HTML Anchors was the term I was looking for. I just Googled it and found what I needed. Thank you much!

Good Morning All, I have an Access 2007 database that associates will be sending emails from. The email is going to be rather lengthy. Basically it will say: This issue has occurred because of "reason". I am trying to figure out how to make it where the reader of the email can click on...

Hopefully one last question. Is this something that you have to manually color everytime or does your system recognize that word and code it green? I cannot get it to recognize the word for future notes. Looks like the associate would have to manually update that. Thank you.

David, I changed the notes field to a memo field with rich text and the whole field is still highlighting in green. Is there something else I need to change to have just the word highlight? I am using the statement below and the Expression is [Notes] Like "*Approved*" Currently is...

Great! Thank you both for your time and help!:)

Bob, Worked like a charm! It is infact a text field as this typically not a "wordy" field. Thank you for your help!

Good Morning All, I have a subform that is linked to a "notes" table. What I need to happen is if one of the notes is like "*Approved*" then the notes_field on the subform turns green. I have tried the conditional formatting setting that Access 2007 provides but I am thinking I may need to...

DCrake, I just learned something. Thanks for the info. I have to say I think it is sort of a waste though. I formatted the report with a print button so that all the associate has to do is click print and they are done, seems a little more professional then preview mode. I dont like the fact...