Search results

Sorry Rob, still not having much luck. It doesn't seem to like the =OpenA part. Any ideas?

Thanks, I'll try this when I get home. how could I modify this code if I wanted to open more forms like "A" from the same form. for example... If I have a form with four command buttons, each of which opens a different form, and I want the visibility function to run regardless of which form I...

I'm having a couple of problems with these methods... Firstly, I can't get the OpenArgs method to work, but I think that is because I am using it already for another purpose. Second. I'm struggling with the Public Function. I keep on getting an "argument not optional" mesage when I run it...

I have a form (a) that can be opened through one of two others (b or c). I want the operation to work such that whichever form is used to open (a) is hidden / made invisible when (a) opens. This I have managed to do. Now when I close (a), I want the form that opened (a) - either (b) or (c) to...

Could someone please help - I'm having a no-brainer!! I have a continuous form containing basic information regarding articles. The fields are: ArticleID - unique ID Title - article title Yr - year published Print - a check box What I want to do is to have a command button that when clicked...

Thanks Rich. I'm now having problems with the code. I get the report to open, but it only shows a error message where the data should be. Can you help with this one?

sorry, I'm not familiar with this - could you tell me more?

I am trying to build a continuous form that allows me to check off which records I want to print. However, I can't get the check box to work - it is an unbound check box and if I check one record, I check them all. Any ideas?

am I right in thinking that this then means that there may be gaps between controls, or some text may not fit, if the number of characters within the control changes?

hi does anyone know if it is possible to format part of a concatenated field so that it appears in italics, while the rest of the concatenation is in normal font? Thanks

Having finally resolved what I thought was the more difficult issues concerning concatenation, I am once again bemused. Here's the basics... I have an unbound textbox that contains concatenated information from several fields in a table. Didn't see this as a major issue as I've done it before...

Thanks :)

I need help in creating a reference list. I have a main 'Articles' table which forms a many-many relationship with an 'Authors' table, through an 'ArticleAuthors' table. Generally speaking, I'm not too bad with the workings of reports, but I need to create a concatenated field that will hold...

Just found that the code does work provided your control supplies numeric and not text data. Any help with getting it to work with text would be greatly appreciated.

Nah, it's not working. Maybe I should have been clearer, but the Or search will only be conducted within the results contained in one control. The first code works fine from this respect, if only it would stop asking for the parameter again.

Wayne, I actually got it to work by placing & Chr$(34) either side of the & Me!KeyCodes &. However, the form I copied this from had the control working as an OR search rather than an AND, which I seem to be stuck with. Any ideas here?

I'm not sure I understand!

I'm building a multi criteria search form. All is well, but I now want to make one of the controls, one containing multiple selections, an OR rather than an AND variable. Does anyone know how to do this? Thanks

I have the following code: If Not IsNothing (Me!Keycodes) Then gstrArticle = "[ArticleID] IN " & " (SELECT ArticleID FROM " & " _ qryArticleKeyword" & " Keyword IN (" & Me!KeyCodes & ")" Else gstrArticle = gstrArticle & " AND [ArticleID] IN " & " (SELECT _ ArticleID FROM " & "...

Ok I've got a form that shows whether an article belongs to a book or a journal. However, when you move records the option remains on the previously selected value. Does anyone know how you could get the option to change automatically as you move through the records depending on whether...