Search results

anybody? many 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...

thank you could you tell me how to do the below, but use weekdays? =Now()+[Txt_Category].[column](1)

Hi thanks for the reply yes so in my field which i need to reference to the second column in the combo box what do i put?

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 just get a box with a red cross inside, 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 =...

anybody, thank you.

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

got you, put it in the field line and it works, thanks :} Product : IIf([Tbl_MMP]![Product] Is Null,"","X")

Hi Yes in the criteria line

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

sorted with Dim ObjAccess As New Access.Application With ObjAccess .OpenCurrentDatabase ("filepath") .Visible = True .DoCmd.OpenQuery "Qry_" .Quit End With

thanks for the reply there is too many tables etc if possible i would prefer just to open and run the query thanks

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

i have a unbound combo box called "Txt_Store_No" where the user inputs a store number then the form, its record source is SELECT Tbl_Test_Closed_Accounts.Fld_Store_Number, Tbl_Test_Closed_Accounts.Fld_Test_Account_Number, Tbl_Test_Closed_Accounts.Fld_Request_Date, FROM...

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

thanks, still pulling through some with the month/date wrong way round fine in the table, just not when copied to excel