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 out, regular job agencies. I have yet to look into online freelancing. I'm posting to ask your opinion based on how YOU started your Db building...
soule
Last Activity: Oct 16 '12, 11:05 PM
Joined: Jan 10 '12
Location:
-
What Has Been YOUR Access Career Path?
-
As it turns out, I decided to go back to HTML template, olformatHTML force in code and set my mail type Outlook option to HTML as well.
Miraculously, when I removed the graphic due to an administrative request, the mail is received perfectly to internal intranet or external internet recipients whether sent manually or through automation! -
Losing Formatting & Pic Position in Rich Text Template Automated Send
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 binding w/Intellisense
- Libraries (in this order):
VB for Apps
MS Access... -
Can Sub & Form Button Have Same Name?
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 started getting an error message.
1) Are both Subs and buttons considered objects in Access?
... -
Hi, Rabbit - thanks for looking at my post and code.
I changed the following and the population (partially) worked:
- Cleaned up my Replace function statements...na mely changed first parameter to message object and took out quotes of replacement text so it would be treated as a variable and not a string like you recommended. Thanks for that catch.
- Changed the send mail-type in my Outlook Tools>Options from...Leave a comment:
-
Hi, Rabbit -
Thank you for your time in commenting on this post. Your advice (and NeoPa's) on my VBA has been very, very helpful.
I can't seem to get two version of my replace function to work:
This version causes an error 94 "Invalid use of null" on the If IsNull line...
...Code:OlMsg.HTMLBody = Replace(OlMsg.HTMLBody, "KnownAs", Forms![A1 Onboarding Tracking Form].[KnownAs])
Leave a comment:
-
Replace Function Statements Subverting Automated E-mail
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 through/running
- Early binding w/Intellisense
- Libraries (in this order):
VB for... -
Outlook Automation Hanging On Address Book
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.
MS Outlook 12.0 Obj. Lib.
MS OFC 12.0 Access db engine Obj. Lib.
MS VB for Apps... -
Hi, Guido Geurs,
Thank you for replying! My actual statement doesn't currently wrap in the VBE and I'll be sure to use an underscore when I clean it up. Thanks for the concern.
FrankLeave a comment:
-
Error Handling Loop...Stuck Inside!
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 environment is:
- Access 2007
- .accdb file
- Am in datasheet view when stepping through
- Early binding
-... -
Thanks for replying again, Stewart.
I'm in a professional situation where I don't have the time or resources to learn the finer points of VB and it's making this project extremely difficult...I'm having to learn VB while I'm creating a Db with e-mail automation buttons and a table structure that demands two fields of redundant data. Thanks for the advice about bookmarking and your time.
To my understanding, my "DoCmd.RunComma nd...Leave a comment:
-
Hello, Stewart,
Thank you very much for taking a look at my LostFocus code. I really appreciate it.
Though I know it isn't good Db design, I need to store a value in two tables. I need to so I can update the "used or unused" status of alphanumeric movie codes that will be added to that table and that feed a queried listbox on my form. I have a master table and a detail table. When a user enters a "movie...Leave a comment:
-
Hi, ADezii,
Thanks for taking more time to look at my problem. I inserted the IIf statement in my If..EndIf statement and it worked great. I got an "exact match" message box. Here is my current version of my code. I moved the code from the form class mod to a standard mod in order to be able to compile it. I moved down my "Dim dt As Date" statement to the second procedure so it was closer to the code that uses it....Leave a comment:
-
Hello, ADezii. Thank you so much for replying to my problem. This task has given me 3 weeks worth of grief. Here's where I am now:
1. I don't understand about Bookmarks being supported. Isn't that a DAO library consideration? Why would my code have to verify this every time it ran? Could you please explain?
2. Do you think this arrangement would work instead?
...Code:Dim rs as DAO.Recordset Set
Leave a comment:
-
Run-time Errorless Bookmark/DLookUp Module Not Working
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 "MovieCodeSendD ate" field on my master table, and I want the field of the same name on my detail table to be populated by the event procedure. I
have the following code in place which neither produced errors nor works. It first bookmarks the relevant form... -
Ya'll were right on both counts. I decided to go with a calculated listbox and only 1 repeating field between two tables, thereby bidding adeiu to this thread and...
I discovered the joys of DLookup for myself. After reading the definition two months ago and seeing it pop up in code ever since, I see why so many people use it. :D
Thanks.Leave a comment:
-
I want to put data in a control from a different table field than the control is sourced to.
In my comment #17, I said I was going to take a new tack. I should have started another thread then. I'll do that now.Leave a comment:
-
Hey, Guys,
I'm sorry I can't provide table and form views, because my stuff is proprietary to a large movie studio. I really wish I could. I'll give you as much as I can. I can say that I have:
- (1) Form
- (1) Primary table named "A1 Tracking Table"
- (1) Secondary table named "A1 Movie Code Table"
I altered the structure of my two tables so that the only field they have...Leave a comment:
-
Hey, Everyone,
Thanks for giving the vb virgin's code hail-mary such attention. How and how much it is and will be appreciated you'll never know.
NeoPa,
It's good to know that I can make my form "movie code" control bound to a field and still be populated with data from another table. I think I should go the route of binding it to my main table.
Rabbit,
It's sort of B)...I need...Leave a comment:
-
I don't know if I want to use DAO. Ha. That's been my question all along. I can't seem to get a straight answer from any source on what version of Jet engine Access 2007/VB 6.5 uses let alone if it can process DAO, ADO, ADO.NET, ODBC, etc.. Anyways, when I try to add my latest DAO object library (also the MS DAO 3.6) I get a "name conflicts with existing module, project or object library" error msgbox (which I'm thinking isn't likely from...Leave a comment:
No activity results to display
Leave a comment: