I.T. Discussion Community!
dynamic pool specialists, David Watson -Collapse +Expand
-Collapse +Expand
dynamictiger
-Collapse +Expand Profile◄╣
Member Info
Member Narration

POSTS:
MB Posts (62)

Search dynamictiger:

Advanced
Personal Account . . .
dynamictiger
Perth, Western Australia



Real Name:  David Watson
Primary Role:  Coder
Company:  dynamic pool specialists
Joined: Jan 2002 (18 years ago)
Visits: 65

Message Boards Activity

62 posts.
More...

Thread 6 of 6
Thread Starter or a Reply (but not last)  Group

dynamictiger
New Member
G'Day,, , Well Here I am. My speciality is Access I have been developing databases on a semi-commercial basis for about two or three years, although I started in computing prior to IBM PC's., , For work I am in charge of building / selling commercial swimming pool filtration plants., , Other than play with my computer, I have been known to sing a little opera, or according to my wife a lot of opera., , Anyways that's me, just a bloke who's learnt a bit.
18 years ago

Anonymous
Oz Pool Supplies are your online pool supplies and equipment store. Pool pumps, pool cleaners, pool accessories and more. Cheers!

http://www.ozpoolsupplies.com.au


--- John Brier
8 years ago
Nothing New Since Your Last Visit
4430
Hits

PrestwoodBoards

Thread 5 of 6
Thread Starter or a Reply (but not last)  Group

Chad
SetValue macro question
I am putting a subform into my main user tracking form. When the user fills in the first field of the subform I want the database to check that entry against a correlating field in another table. If the numbers match I want the rest of the fields in the subform to automatically update with fields from the other table. I also want information to be entered in the subform manually if there is no correlating record in the other table. Should I use macros or Visual Basic? How would I go about setting that up? Thanks in advance!
Posted to MB Topic: Access VBA Programming « Access Board
17 years ago

dynamictiger
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
2560
Hits

Microsoft Access

Thread 4 of 6
Thread Starter or a Reply (but not last)  Group

dynamictiger
Re: SetValue macro question
Chad, , I think that there is a better solution from what you have said in your post., , Subforms are powerful and applied properly can acheive amazing outcomes., , I think you are trying to create a classic lookup situation, and yes you could acheive this with code or macro. However, it is better without., , I think that there is a related record on your main form. This is the linking field for the parent child relationship in the subform., , I think most probably the subform data is related to the main form. So rather than auto complete on entering a value, we can autocomplete instantly on finding a record., , What I would do is change your subform from a table base to a query base. I would use the linking field as the criteria in my query, and remove the Links in the main form design view from the sub form., , This will mean that as the main form changes the subfomr will autocomplete with related records., , HTH
Posted to MB Topic: Access VBA Programming « Access Board
17 years ago
Nothing New Since Your Last Visit
2
Hits

Microsoft Access

Thread 3 of 6
Thread Starter or a Reply (but not last)  Group

dynamictiger
Re: Email out of Access?
Haven't thought a lot about this, but I think I would divide my query in code into lots of ten names., , I would loop through and assign the names to a string something like:, , For each i in intI, , strA=Name & ";", , strB=strB+strA , , next, , Eventually when strB was finished filling with the ten names I would repeat for the next str which we will call strD., , After running through twice I would join the strings together., , strZ=strB+strD, , I would repeat this process as many times as I need to until I am right through the query, expanding strZ as I go, , strZ=strZ+strF etc, , Then I would write a docmd statement like, , DoCmd.SendObject acSendNoObject, To:=strZ, EditMessage:=True, , HTH
Posted to MB Topic: MS Access Interactive « Access Board
17 years ago
Nothing New Since Your Last Visit
2
Hits

Microsoft Access

Thread 2 of 6
Thread Starter or a Reply (but not last)  Group

Occie
Email out of Access?
Hi,, , I have parameter queries that pull sets of customers. I want to open Outlook and have all the emails address from the Email field automatically in the To field of a blank email message., , I've used the SendObject on a Macro to send a standard email message, but this will not work in this case, as the message will vary, depending on the user and the parameter query they run. That's why I want to open a blank Outlook message and have the emails from the query in the To field. The email message can then be composed by the user., , I am designing this for users who have no experience with the Macros, and actually don't even see the database design window. I will run everything from a form, the user will choose the query they want, Outlook will open, with the emails in the To field., , Is this possible thru some kind of Private Sub code??
Posted to MB Topic: MS Access Interactive « Access Board
18 years ago

dynamictiger
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
2166
Hits

Microsoft Access

Thread 1 of 6
Thread Starter or a Reply (but not last)  Group

Larry C
Trap before leaving a record on an access form
Hi,, through VBA, I would like to trap certain conditions before leaving a record in the access form and if these conditions are not met, then disable the leaving (Cancel = True)., The Form_BeforeUpdate does not seem to work if there's not been a change in the data., The On Exit events does not occur on the forms level, only on the controls., Thanks in advance for any suggestions.
Posted to MB Topic: Access VBA Programming « Access Board
18 years ago

dynamictiger
I think Before_Update is the event you want, you could also use on_change, or Exit., , Before_Update fires as soon as you try and move out of the control and before the data is written, I think it has a cancel event, if it doesn't you can use Docmd.CancelEvent., , HTH
18 years ago
Nothing New Since Your Last Visit
2876
Hits

Microsoft Access
More...

Follow PrestwoodBoards on: 


©1995-2020 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech