Search results

I am able to search on my form by entering all or part of the criteria and pressing return (as opposed to a search button) The textbox is unbound I would like to retain the text that I am searching for. This is useful for narrowing down the criteria. Any thoughts? I tried...

Minty....I want to have you babies !!! Thank you sooooo much Works a treat.

So anyhoo..... This is my onupdate code which I'm sure just needs tweaking. Dim strWhere As String strWhere = "Field1 = """ & Me.MySelection & """" And "Field2 = """ & [Forms]![frmHidden]![User] & """" Me.Filter = strWhere Me.FilterOn = True End Sub Could somebody please help to tidy this up...

This is the problem "Field1 <>'Completed'" And "Field2 = """ & [Forms]![frmSettings]![User] & """" Is everybody sure that this is the correct way to structure multiple filters?

Thanks guys this is great. Due to the filtering that I need when Im on my form, I need to find a Me.Filter solution. I need to create a multiple Me.Filter but Im struggling. Me.Filter = "Field1 <>'Completed'" And "Field2 = """ & [Forms]![frmSettings]![User] & """" Me.FilterOn = True The...

Could just do with the VBA form filtering a form (on load) that excludes one item in a field. DoCmd.OpenForm "MyForm", acFormDS, "", , , acNormal I want to filter WHERE [Field1] Is Not Like "Completed" Therefore: DoCmd.OpenForm "MyForm", acFormDS, "",WHERE [Field1] Is Not Like "Completed" , ...

I changed the windows spec to windows !! der !!!!

I have a DOS import however when I import my data some of the characters are incorrect. eg £ becomes ú I import delimited and as Short text. Could you point me in the right direction please. This has never happened on other imports!

Sorry that was a little ambiguous This is my code now. as you can the Form1 is duplicated. DoCmd.OpenForm "frmForm1", acNormal, "", "", , acNormal DoCmd.OpenForm "frmForm2", acNormal, "", "", , acNormal DoCmd.OpenForm "frmForm3", acNormal, "", "", , acNormal DoCmd.OpenForm...

However !!!!! It doesn't work when I change the Form view to acNormal. My solution was to just repeat the open form line for the form i wanted to get focus

Got it !!!! Forms!frmForm1.SetFocus

I have five datasheet forms that open autoexec. I'm trying to open them in order so they sit correctly at the top of the page but I then to set the focus to the first form that was opened. DoCmd.OpenForm "frmForm1", acFormDS, "", "", , acNormal DoCmd.OpenForm "frmForm2", acFormDS, "", "", ...

The solution to my question was (as I suspected) not referencing the query "feuqryCRTSK" This was simply solved by a ! infront of the references. therefore: Dim FileTarget As String FileTarget = !fileTargettext Dim Desktop As String Desktop = !networktext Dim filenametxt As String...

Easy one this !! I have encased my code within "DEPLOYMENT TEXT" My recordset is a query feuqryCRTSK I'm just not sure that everything within the "DEPLOYMENT" is referencing this query as it doesn't work. fileTargettext Public Sub trusteecreate() TSKGetFile = "S:\Access\DATA\TT\Front...

Thanks Guys Minty's solution has worked perfectly. Many thanks indeed

I have a list of clients with remuneration. This figure can have a percentage split which is housed in a linked table. Table1 001,Client1,£100 SplitTable 001,Benefactor1,60% 001,Benefactor2,40% How would I set a query that concatenates the SplitTable data into a notes field? ie. Query1 ID...

Thanks Guys I realised that I'd missed the () from Now. It works fine. Thanks for your thoughts and direction.

Its a syntax error but I'm struggling. I have a table that I insert a start time ( Now() ) and the text "Full System Update" int the TEXTCONFIRM field. What I want to do is update the EndTime of that record. In the meantime I am opening an update query but wondered what is wrong with the code...

Sounds like a plan !!! Thanks Minty I created an Append query using Insert into. I just open the Query

I have a series of Macros that import data. On error I want to insert text into a Table to record the errors. On error insert new into tblErrorLog ErrorText "This particular import didn't work" , go to next. Could you point me the right direction to build the Macro that will do this. Many...