Search results

As one would with Word: I am trying to insert a tab into my string of text

The data in Field1 is "Before Tab" The data in Field2 is "After Tab" Result is "Before TabAfter Tab" I'm expecting to see "Before Tab After Tab" (I couldn't use the tab button in this text box to illustrate which leads me to the conclusion that tab does not have a universal length and...

SELECT [Field1] & Chr(9) & [Field2] AS Expr1 FROM Table1;

This is within a query

I was trying to concatenate two fields in my query with a tab. I assumed: [Field1]&Chr(9)&[Field2] But to no avail. Am I missing something ?

plog The purpose of this "Jerry Rigging" is to allow people to search an correct the data. If the data was correct in the first place then I wouldn't need to do this. Perhaps I should have preceded my question with a full explanation as to why I need it doing !

Dealt with it I open a form hidden to get the Left 8 characters. Me.EightCompName =Left([CompanyName],8) Then reference that in my search form query Like [forms]![Form1]![EightCompName] & "*" in my query

I have a list of companies where the name may be incorrect (eg Ltd instead of Limited) without ID's [CompanyName] on my Form1 I have a table [tblCompanies]of companies with the correct names and their ID's I want to select the first (say) 6 characters of [CompanyName] and (along with a...

Brilliant Ridders !! works a treat. Many thanks

As it says on the tin really ? The database is a Tabbed Documents with Display Document Tabs ticked style database. At present I have my opening list of clients on the summary form then (on double-click ) open a Client form (Called "Client") with the specific data in it. Just wondered if...

Found the answer after writing but thought this might be useful for others: The referencing of the text field was indeed wrong. I needed to remove the "Me." Solution DoCmd.RunSQL ("INSERT INTO tblSettings ( UserName )VALUES (TXTPATHUSER);")

I have a splash screen (unbound form) that determins the name of the folder that the application is in (this is used to establish the user). On Open Me.TXTPATH = Application.CurrentProject.Path There is a text field on the Splash form called TXTPATHUSER with the following to clean it up...

So that's a no then !!! The reason for this query is that the + detracts. My main Split Form is based on a query (that involves calculations) and is not updateable. I have replicated the updateable fields into a sub form and attached this to the detail area of the split form. everything works...

Just to get this right then. Create a split form based on a table. "frmTable1" Select Design view. Drag and drop a sub form "frmsubForm1" linked by ID onto theform. "frmTable1" now has a little cascading "+" in the datasheet area. It is my contention that you are not able to remove this !!

Hj there Arnelgp I have tried to do that on the underlying tables. The option is not available in the properties of the query that I'm using for the form

I'm struggling with this. I have tried to follow other solutions be I'm getting nowhere. I just want to disable the subdatasheet '+' on my Split Form. I have tried going to RECORDS then MORE then Remove subdatasheet but it's always greyed out. My form is based on a query and is un-editable...

Thanks you guys

I'm struggling to concatenate the data where two or more lines are blank. I have an unbound text box on my form with the following. =[Address_Line_1]+Chr(13) & Chr(10)+[Address_Line_2]+Chr(13) & Chr(10)+[Address_Line_3]+Chr(13) & Chr(10)+[Address_Line_4]+Chr(13) & Chr(10)+[City_Town]+Chr(13) &...

Thanks Ridders. Your last line was really useful to know. Will a database run quicker over a network with pre-defined relationships or is it much of a muchness?

I rarely build my databases with relationships specified choosing to make the relevant relationships within forms or querys. Am I committing a heinous crime ? Can I get your thoughts please ?