Search results

Hi, All, I just recently returned to the job market and my goal is getting 3+ years of Access developing/programming projects under my belt through an IT or regular agency before I even dare to approach an IT consulting firm. I'm going to target the IT agencies first, and if that doesn't pan...

Hi, Everyone, I'm trying to create a dynamic rowsource for my Combobox B, so that when a user makes a selection in Combobox A, B will give relavent choices. My environment is: - Access 2007 - .accdb file - Button code in standard module pointed to with event procedures using Call subs - Am...

Hi, Everyone, I'm sending an automated e-mail from an Access form button through Outlook. My environment is: - Access 2007 - .accdb file - Button code in standard module pointed to with event procedures using Call subs - Am in datasheet view when compiling/stepping through/running - Early...

Hi, Everyone, I want to click a form button and run code in a STANDARD module (not the "behind the form" class module). I noticed the name (not the Caption) of my form button was different than the name of my Public Sub, so I changed the name of my Sub to match the name of the button. I...

Hi, Everyone, I want to click a form button and run code in a STANDARD module (not the "behind the form" class module). Can I enter the name of that Public Sub in the On Click Property box? Pointing a button to code doesn't always have to be done with the "Event Procedure" option filled...

Hi, Everyone, I'm trying to send an automated e-mail from Access through Outlook with a form button click. My environment is: - Access 2007 - .accdb file - Button code in standard module (for debugging; will move to form class mod. when works) - Am in datasheet view when compiling/stepping...

My environment is: - Access 2007 - .accdb file - Button code in standard module (for debugging; will move to form class mod. when works) - Am in datasheet view when compiling/stepping through/running - Early binding w/Intellisense - Libraries (in this order): VB for Apps MS Access 12.0 Obj. Lib...

I'm not sure why this code is hanging up. When my user clicks a form button, I'm simply trying to check to see if Outlook is open, and if it isn't, display a message box reminding them to open Outlook. If it is already open, I (obviously) want the code to skip the error code and continue. My...

Hi, All, I'm getting an Error 462 "the remote server machine does not exist or is unavailable" with this GetObject statement. I'm trying to open an Outlook .oft template through a form command button with code in standard module (which I'll later move to class code-behind-form). My environment...

In my .accdb, DAO Db, I'm trying to use an AfterUpdate or OnLostFocus event procedure in a class module to populate a date on two tables. My form control is bound to the "MovieCodeSendDate" field on my master table, and I want the field of the same name on my detail table to be populated by the...

Hi, All, I'm seeing the light at the end of the tunnel with my movie code .accdb, and I'm hoping this is the last procedure of new code I will need to write. 1) I have a detail table with two fields, "moviecode" and "moviecodesenddate". I use the date field with null values in a query to...

Hi, All, Yet another version of the problem of invisible records in Form View. First, I have a .accdb 2007 form that... 1) Has a query SELECT/FROM record source and a "Dynaset (Inconsistent updates) recordset type. 2) Has controls that are bound to two tables. The two tables have primary...

Hi, Everyone, A little fire to put out -- I'm trying to simply populate 5 fields in a table from the same-named 5 controls on a form with vb OnButtonClick(). Four of the controls are sourced to another table, and one of them us unbound. My code is in an .accdb file in Access 2007. I have no...