Search results

Thanks ranman Do you have sample of tconfig table or website with info to make tconfig table. Thanks a lot Shane

Hi, All I found some code on this forum. That uses DLookup to find the field default value on a form. Is it possible to use this on muitlple fields? Other than copying this code twice and renaming getdefaultTID to getdefaultTID2 for another field Thanks in advance Shane Function...

i have now worked it out thanks guys this is my solution =IIf(Not IsError([PaymentSearch subform].[Form]![total]),[PaymentSearch subform].[Form]![total],0)

yeah this works on the sub form. but the calculation is being carried on to the main form i still get #error :confused: working on subform IIf(FormHasData([Form]),Sum([Job Cost]),0) thanks shane

issues with #error can't seem to suppress it =[PaymentSearch subform].[Form]![Total] tried =nz([PaymentSearch subform].[Form]![Total],0) get !#size error hi ,all i wonder if someone could help me. I'm trying to suppress the #error when the total is null. see above is what i have tried...

Thanks doc man This is what I have ending up doing using vlookup with environ and check a table see if the user exists in the table. Thanks again for the advise Shane

The slients is deafing

Hi , all i have been given this domain for a LDAP CN=AsbAdminGroup,OU=General Groups,OU=Security Groups,OU=RF-CUSTOM,DC=RF-CUSTOM,DC=CO,DC=UK i wish to be able check if the current user is apart of "AsbAdminGroup" and if they are then allow them to open form "admin" To be honest i don't...

hi , Thanks Mole123 for the help :) i have manage to get the result using a query and then using DLookup to get the result i was after BUT is a very messy way of doing it. Arnelgp i like the idea of this way but got one issue i'm get error on the line shown in red say invalid use of Nulls...

Hi , all wonder if any one can point me in the right direction to be honest not even sure i'm using the correct function. :confused: I'm currently trying to check if a value exist in a field in my sub form by taking the value i have entered in a text box on my main form this is were i am so...

Backupdate is the field that tracks the date the record was entered could i use DLast find the last entered record check if the backupdate field has passed the actual date but havent got clue how to do this! thanks shane

Thanks Plog! Is there away then i can check last entered record date. If the date has passed the actual date run the code thanks shane

Run code If date Passed issues!!!!!! Hi , you lovely lot i have some code that checks the last date in a table. The code is : DateOfBackup = Nz(DLookup("BackupDate", "Newsdate", "BackupDate=date()"), 0) If DateOfBackup >= Date Then DoCmd.OpenForm "Teaminformer"i want the form...

Thanks again Plog I have made the change :D

thanks!!! plog what a silly mistake :banghead: thanks again shane

hi, plog I tried what you have said doesn't make any difference Dim txtLogoURL As String 'this is for your logo txtLogoURL = "C:\Users\Dell\Pictures\oie_transparent.png" strHTML = strHTML & "<p' align='center'>" strHTML = strHTML & "<a...

how to center logo in html code in vba hi, all I'm try to centre a logo image in the middle of email but I having issue doing it doesn't seem to matter what I try I can't seem to get it to do what I want . The code below works but doesn't centre the image here the code : Dim txtLogoURL As...

thanks alot!!!! Cronk and VbaInet for help this going to make my life so much easier!!!!!:)

surely you need to use a filter as its continuous subform with muiltiple records attached to the main form record ID 1) filter through records in sub form that are true 2) Attach only the records that are true to the email I had another go at the code Dim olApp As...

To be honest I'm no way shape or form a VBA programmer I muddle by to make my life easier. BUT I NEVER GIVE UP !!!!:D if say one record the send field was false then I would send the email but with out that attachment but the next record maybe true so I would want to attach the attachment :)...