Search results

Probably not the best suggestion as it won't identify what is causing the issue but..... Have you tried setting the 'Views Allowed' property to Datasheet? HTH, Patrick

Hi, It works both ways - you can declare a Public variable in your subform & reference it from your main form in the same manner. (YourSubForm.YourVar) Regards, Patrick

The alternative is to SetFocus on a field to the right of your form after clicking on your record selectors. I personally would go with tabs though as ColinEssex suggested.

Hi, If you declare the variable as a Public variable in your main form it will then be available as a property of the main form. I.e. A Form is an instance of a class, Public variables within classes are treated as properties. So if you have a public variable called myVar in your main form, you...

Hi, I'm not really a user of Excel objects so I can't really answer your second query. But thinking logically, if the code runs the first time around without error, then in order for the code to run correctly the second time, the machine must be in the same state as when the code first ran. Am...

Hi, I'd say this is bacause you don't clean up your Excel objects. Maybe if you set these to Nothing in the Clean up section it'll sort it out. HTH, Patrick.

Bloody attachments!! Oops

Thanks for the response Fornation, I don't think it's going to be worth the effort involved to write a big function (And I don't have the time) For anyone interested, here is a (Very) Quick & Dirty example of a Rich TextBox & the RTF tags produced. If anybody else is interested in pursuing this...

Nightmare.... I spent a couple of hours writing one this morning only to scrap it later on. There are too many tag combinations to cover & too many pitfalls - For example Searching & Replacing for a bold tag (/b) can result in other tags being affected: i.e. attrib/ gets messed up as the /b is...

Open FileName3 For Append As 3 HTH, Patrick.

Thanks pdx_man, After doing some research, it is a Microsoft bug. It's down to the control being painted before a handle is assigned. It still works great in Forms though (If you arent going to be using reports to display the data..) I think Access could do with an intrinsic control which...

Oops Example attached

Hi Nebon, Firstly: "'" & YourTest & "'" Concatenates apsostrophes into the text string i.e. YourTest becomes 'YourTest' When passing string values in SQL they should be surrounded by apostrophes. Secondly: I've posted a sample database which I downloaded from this forum some time ago. Can't...

Hi Nebon, I'll be a bit busy with work for about the next hour, I'll take a look then & do up an example of some sort for you. Regards, Patrick

The problem with your DLookup is that you need to pass in apostrophes around the paramater you are passing in to it. Try: Dim vTest As Variant vTest = DLookup("status", "query1", "[show_id] = " & "'" & Me.SHOW_ID & "'") MsgBox vTest Now the DLookup works correctly. Does this fix all...

Hi, The download is access Xp - could you save it as an earlier version & repost? (Access97 & 2k wont open it)

Can you post a compacted example of your database?

Hi, I've replaced a couple of my standard textbox controls with RTB controls to allow formatting of individual lines of text etc. This is all working fine in Forms. Due to the way RTB controls work (they store formatting tags within the text in the database) I also have to replace the Textboxes...

Sorry I've answered my own question: Screen.PreviousControl Thanks, Patrick.

Hi all, In my database I've replaced my usual text boxes with RTB controls so I can apply extra formatting. I'm creating a set of buttons or a menu item to control Bullets, Bold, Italics etc. The problem I'm having is determining which control has focus. Ie. in order for my buttons to work I...