Search results

Hi all, This one is really making me want to throw the PC out the window, ao I hope there is someone who please can help me here. Here's what I'm trying to do: I have a search form where the user enters criteria to search for. I create the search strings based on the users selections, and...

Thanks for your help Pat! Makes life so much easier :) Have a nice day!

I have a form that when in design view, shows the properties window, when I switch to form view, the properties window disappears automatically. In Every other form I need to click on the button to show properties window in design view, and switch it off in form view. Quite annoying. I've tried...

Thanks for your reply. I used your first suggestion, and it works great. Thanks!

I have a subreport in the details section of the main report. This means that for every record in the main report, a subreport is shown. I have calculated a sum in the sub report by placing a control in the footer section of the sub report, and have placed a new control on the main form...

Hi, Does anyone know why the analyzer tool suggests to make a relationship to it's own table?. If I do this optimization, the table is added once more in the Relationship window, and gets the MyTable_1 extension? Thanks in advance

Thanks Mile-O-Phile I'll take a look. I'm probably headed against a continous form.

Thanks for your reply Rich. There are very little formatting capabillities in a listbox. So this is no good solution. Is'nt it possible in A2k to show a query in a form directly (I've tried dragging a query to the form design window but no success). Think I've seen this somwhere, but I might be...

Can I show the results of a query in a form, without using a subform control? I'm using A2K. Thanks in advance

Ok, I've made the queries and it's BRILLIANT in it's simplicity! Works Perfect. Thanks again Pat. Now to the process of making this a dynamic query to work with my search form......

Thank you both for your replies. Pat Hartman, you've understood my problem correct. I'll try it out first thing when I get back to my projrct. Thanks for your help (once again). Very much appreciated.

Thanks for your help and link. Now I know how to use the null as a criteria. Thanks

I have two tbles with a 1 to many relationship. Lets name them...tblOne and tblMany. The fielf they are linked together with, is a long numeric, I'll call it LinkField in both tables. I've set up a form to enter criteria for a query I'm going to run. The query is created, using the...

I have a query which is a source for a listbox. I have a criteria in this query. The criteria is set from two controls on the form. After setting the criterias in the form, the query is re-quyered. This work fine, except for when one or two of the criteria controls are blank (Null). In this case...

Thanks again Meltdown! Very much appreciated! I'll look into it. BNice to have good places to start with! Thanks again.

Thanks very much for your reply Meltdown and the links. I'll study this, but I think I'm going to use ASP. Where can I find good info on how to set up/make asp pages for my task? Thanks again!

Hi, I'want to 'publish' the results of a query to the Internet, so the customers themselves can go and check status of production data. I've looked a bit into Access Data Pages, but feel I'm getting nowhere, as it creates more questions than answers. The db collects productional data from...

Thanks for your reply and help Pat! Worked very nice. I would never managed to come up with this neat solution! Thanks again

Hi all! I need to 'subtract' a recordset from another recordset. Let me explain.... If I have a recordset A which has the following records: 1,3,5,6,7,8,9,10........ and a recordset B which has these records: 3,6 ,9 I want to get this recordset: RecordsetResult: 1, 5,7,8,10..... The...

Thanks for your idea and reply Col. I managed to make a function that I can use (I think). I haven't figured out all the return values yet. The function looks like this: Function DocumentX(NameOfForm As String) As Long Dim dbs As Database Dim Doc As Document Set dbs = CurrentDb With...