Search results

I had done that part right. I found that the issue was in my code which was calling the public variable. Thanks.

Hi Oldsoftboss, I have done this already. The issue I have is how do I change my original code so that it now stores the value in the Public variable instead of the Private one which it is currently doing (see first post above for code).

Hi Everyone, I'm trying to pass a variable called MyFilter between forms but am having problems. I have created a Module and declared MyFilter as a public string. The original code in my first form is: Private Sub Command65_Click() Dim MyFilter As String If Me.Filter = "" Then MsgBox...

Any further advice at all please?

You need to create a command button but exit the wizard it launches. Then for the OnClick event of the button enter the following code: DoCmd.RunCommand acCmdFilterByForm To remove the filter create another button as above but use this code: Me.FilterOn = False HTH

Ah ha. I tried what you said and it returned: (([Arts Query1].ArtistName = "Zao Wou Ki")) I put this in place of Me.Filter and when I click the button I get the following error: Runtime error 2465 Access can't find the field '|' referred to in your expression. Anyone know what is going on as...

Thanks Banana, I have changed my code to: Dim MyFilter As String MyFilter = Me.Filter DoCmd.OpenReport "Temp", acViewPreview, , MyFilter I still receive the parameter prompt. From what I understand Me.Filter should hold the results of my current FilterByForm which has just been...

Hi, I have read through a few posts but none seem to resolve the issue I am experiencing. I have a form with a FilterByForm button. This works fine. I also have a button that is supposed to display the results of the filter on a report. Everytime I click this button it prompts me to enter a...

Thanks! So simple. Still getting used to where things are. :)

Hi, I have a basic form which currently displays different information such as name, date, country etc. At the moment if I type anything into the fields it edits the data (allow edits is on). Is it possible that if can type in a name and it will find the pieces of work by that named person...

Morning all, I have created a report which is generated from a form. It displays all the fields relating to that specific record apart from the single image. I am using a linked image frame to a field which holds the path of the image. I have exactly the same on the form which works fine but...

I tried what I thought was right but it wasn't returning the correct results. Currently in my query, the criteria for the ArtistName field is: [Forms]![Artist1]![ArtistName] The ArtistName on the form is simply a textbox. Does that help?

Hi everyone, I'm having an issue with a query I created. When run the query requests an Artist Name. I enter this and it returns one result. However in actual table ther are two results for that artist. The only difference is that for the record that doesnt appear the field labelled "Gallery"...

It's just been one of those days! Complete stupidity on my part. Sorry :o

Afternoon, I'm having a problem with a form used to display table records as well as create a new record entry. The form has 2 combo boxes and the rest are fields. Combo1: Artist Combo2: Gallery I would like it so that when the form opens and displays the first record it will also populate...

Afternoon, I have been reading many threads but can't seem to find an example that works in my scenario, perhaps I am wrong? I have a Form with a Subform. I would like to disable the mouse scrolling option on the Form but not the Subform. I have tried several things including the Cycle option...

Got this working. Thanks for the help!

Thanks Bobadopolis, appriciate the help. I'll give it a bash and post back the results. :)

Hi everyone, Having a little problem, have searched the forums but have not been able to find an answer. I have a single db with 3 tables, artist, gallery and arts. The main form should show the work details for each artist, i.e. each piece of art they have done. The problem I have is I think...

I'm not sure if all the tables are in the server.mdb. I wasn't involved in the design or putting together of the db. It's just that the company that did do it for my employer is now not around and unfortunately someone caught wind that I did do some Access stuff so I got roped into it. I know...