Search results

Hi, could anyone share code will print all files in a specific folder the folder could contain, workbooks, PDFs and word documents - i need all printing to default printer thank you!

Hi is the following possible, thanks in advance ; So i have two tables Table one list of names Table two list of tasks I want one table to have the list of names, then record in the table is expandable with a list of tasks So Table 1 Michael Roger Tim Table 2 : Headers: Tasks | Date...

Hi I only wanna return what ive highlighted bold before, so top one, g ea Excel i use this IFERROR(TRIM(REPLACE(SUBSTITUTE(L2,"" x "",""""),1,FIND("" "",SUBSTITUTE(L2,"" x "","""")),"""")),"""") Qry_Range_File_Master Sales conversion text 1 x 1 x 24 x 250 g ea 1 x 1 x 1 x 2 Kg ea 1 x 1 x 30 x...

=REPLACE(SUBSTITUTE(M2," x ",""),1,FIND(" ",SUBSTITUTE(M2," x ","")),""). to be =REPLACE(SUBSTITUTE([MYFIELD]," x ",""),1,FIND(" ",SUBSTITUTE([MYFIELD]," x ","")),"") hi could someone assist with the above? thanks in advance

Hi could someone advise on how to set parameters for the date being last monday to last sunday so Paramaters = Date then i need ParamatersWeek = the last monday to the last sunday thank you!

hi in my query im doing the following to pull all records for the previous week Total Completed: Sum(IIf([Date Completed] Between Date()-(6+Weekday(Date(),2)) And Date()-Weekday(Date(),2),1,0)) what i need now, is one for just Last monday, last tuesday last wednesday last thursday last friday...

Hi please could someone assist i need to open Shell("C:\Program Files\Network Designers\Bin\Wscman.exe" & " Reflex.prw", vbnormalfocus) then send two keys "m" and "f" then return focus back to access is this possible? thanks

Hi i have a database thats open all day, i need a macro to run from it at 9pm 12pm and 3pm is this possible? thanks

Hi i have a main form users enter info into then submit, which adds it to the table being displayed in the subform one of the options is a "Urgent" tick box, if they tick this box, once it has submitted to the table, i need that row to highlight red is this possible? thanks

Hi i have a form, with a subform, when a user selects a record from the subform i use this to view the record in the main form Private Sub Txt_Support_Name_Click() DoCmd.ApplyFilter , "ID =" & Me.ID End Sub however when i select the record from the subform, it populates the form as required...

Hi i have a form, where one field is a combo box the combo box is two columns linked to at table, task and sla you pick the task, and it displays the task what i need is, another field, to equal the SLA part of that task make sense? thanks in advance

Hi i have a query with an inputbox for numbers [Enter Number] if i want the query to return multiple numbers how would i do this? so the user could have 3 5 and 8 to search for, currently the [enter number] allows them to search for one at a time thanks

Hi im trying to embed a picture in an email, code below any ideas? thanks Dim MyOutlook As Object Dim MyMail As Object Set MyOutlook = New Outlook.Application Set MyMail = MyOutlook.CreateItem(olMailItem) Application.Echo False With MyMail .BodyFormat = olFormatHTML .Display Signature =...

Hi i have two tables, one list contract numbers as a unique number, and fields assoicated with that contract then another table, list the same contract numbers, with sales by that contract number each day, so Contract sales Date 225 1 01/09/2014 225 4 02/09/2014 225 2 03/09/2014...

Hi in my query i have multiple tables, one table just has one field called product thats joined to another table the other table displays a list of all products, if the product is in the other table i want a "X" to display in that field both columns are text the IF im using is...

hi could someone get me started on the below please If todays date is the 3rd of the month then Msgbox “hi” Else Msgbox “bye” End if thank you

Hi i have a database that runs updates from within itself. what i need is, this database to then open a another database run a update query, then close it thanks in advance

Hi i have a form, where a user inputs a account number inputting the account number, then populates all the relevant table fields, into the form for the user to edit. however if there is more than one account, with that account number, how do i get it so they can cycle through on the form...

Hi i have a CopyFromRecordset into excel 2003 one column is a set of dates, but when the code runs and copies the date column over, the format is as it should be but alot of dates are showing in american format Cant seem to figure out why, but its not every date, id say 50% of the 1500...

Hi i have a form with a drop down that links to a table where a user can select or type a record, if they type a record that isnt in the table, the form goes completely blank is there a afterupdate event i can do so that if the record doesnt exist, then a msg prompts and the form isnt...