Search results

Hi , here what i've try but getting an error. order date field on my subform is in format dd/mm/yyyy and my combo box on my main form only holds years in yyyy hoping to filter Order_date field on the subform via year. see below what i tried. guessing i need to change the Order_date field format...

Hi , cant work out why #error is still showing on new record line i thought Nz() would supress it ? =Nz(DLookUp("sumoftotal","[Query1]","[CV_Order_ID_TXT] = " & [Forms]![Manual_Order_FRM]![CV_Order_ID_TXT]),0) thanks in advance shane

Hi All, i have query that calulates the month spend in one column [Month_total] then i Group it via the month using a field called [Month_] then use a sum on form to call the values like =DSum("[Month_Total]","[Monthly_Cost_parts_QRY]","[Month_] = '3'") which shows the total spend for march...

hi, I have DB with a form contain 4 Text Boxes the data from the Text Boxes populate the web page controls. Which Works great i'm not the greatest coder surprised myself it worked lol. Now the problem i have it always opens a new internet explorer session every time i run the code. i know its...

Hi , i have some code to import Excel Spread sheet to a table call tblExcelimport i then add just the file name to tblexcelfilename here the code probably could be neater or better lol Dim SelectedFile As String Dim FilePicker As FileDialog Dim SQLdelete As String Set...

hi all i have some code that i use to import data from excel Dim SelectedFile As String Dim FilePicker As FileDialog Dim SQLdelete As String Set FilePicker = Application.FileDialog(msoFileDialogFilePicker) FilePicker.AllowMultiSelect = False FilePicker.Filters.Add "Excel"...

all, it really long shot can't seem find any code spinets to get me started or if its even possible. Right..... i have 3 tables Main table "Main table holds the current data " History table "history table holds old data from main table " excel Import table "temp table that holds data import...

hi , currently have some code on (database A) to open a form in (database B). cant seem to work out how to return from database B to Database A without having to click the task bar to open the db window is their any way i can have some code on say database b form to return to database A ()...

hi ,all i struggling to check a directory see if a file exists current the code i have the user selects the file from the file picker it then copies the file to another folder to stop people linking it to there personal drive, but the issues is i need to check that the file they are selecting...

hi , all i have google' d the hell out of this haven't manage to find an answer here what i'm trying to do. i have window media player on a form i wonder if its possible at certain time say 20sec in to the video @00:00:20 call a procedure to open another form or PDF etc... just curious if...

hi , all i have check box called invoice. if the user makes invoice check true then i would like to show all the blank records with invoice date field is null If Me.[invoice] = True Then If strWhere <> vbNullString Then strWhere = strWhere & " AND " End If...

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...

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...

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 , 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...

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...

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...

hi , I have some code that loops the clone recordset of my subform and generates a email with attachments. I have mainform and continuous subform within the subform I have field called address this holds paths to files and another field called send and this is a yes/no field now what...

how to add attachments to email using a subform field for the attachtment paths hi ,all I m wondering how to add attachments to a email using a sub form were I store the attachment paths e.g I have a main form called frmteaminfomer with various fields and continuous subform called...

hi, all I just wondered is it possible to add my dateadd calculation to my findlast calculation using dmax in one column in my query here's what I hoping to put in one column as at the moment it takes 2 findlast: DMax("[ServiceDate]","[PlantServiceTbl]","([ImpPlantItemID]= " &...