Search results

Could someone help me please? I am trying to open two tables for comparing values. First table contains a number of records and I need to count how many records there are, depending on a field called QuoteID. Second table contains a field specifying the maximum number of records I can have on...

Hi jeremie, Okay, you do need a junction table. See the attachment, easier than explaining it with words. Have a look at the relationship window, you will see how they are connected together. The way you connect the two tables together is by their Primary Key fields (NCPKey and ID), not NC...

Thanks for the discussion guys and the links. I have read some of what Microsoft says on the topic but I can't bring myself to trust them completely, they don't often point out the pitfalls etc... This forum is usually my first port of call if I want to look up something, it is always a learning...

Here's a little sample I believe Pat Hartman posted sometime ago. It takes a bit of studying to understand what everything is doing but I have found it immensely useful in the past. Pay special attention to the queries underlying the forms and the combo boxes. I'm sure you will understand how...

Hi guys, This is just for discussion really. What does Compact and Repair actually do? If I was to set my database to compact and repair on close, am I in danger of losing any data, formatting on forms or anything? What are the pros and cons? I would really appreciate some replies. Thank you...

Check your field names and make sure they are the same. The database I posted above is a modified version of the one you have posted a little bit earlier. "Number"in this case refers to the Primary Key of the table where the data is being collected from. I have just unzipped and checked the...

Hi there, I have finally managed to find some time to fix this, it was a simple thing in the end (sigh). I hope this is useful to you now :)

Hi, Yeah, I know it does give an error message, I have tried that code on another form I have with a similar search facility and it works fine, but somehow it doesn't on yours. That's why I am puzzled. Fairly sure, it's a teeny weeny mistake somewhere. I hope someone can find it for us lol...

I feel I'm close to solving this - but it is sorta doing my head in at the moment. I tried the code below on another search form I have and it works but it doesn't on yours.. Mmm, very puzzled! Private Sub QuickSearch_DblClick(Cancel As Integer) DoCmd.OpenForm "queryform", , "[Table1].[Number]...

You'll need a second event for that on the On Dbl Click of the listbox. Open the Properties of the listbox on Design view - Event tab - On Dbl Click - create a new Event Procedure And write something like: Private Sub QuickSearch_DblClick() DoCmd.OpenForm "FormName", acNormal End Sub...

You're welcome! It's nice to be able to help for once instead of begging for help since I've joined LOL I can't take all the credit though, I got the search facility from someone on this forum :D

See the example - the code is slightly different to yours but I think you should understand it fairly easily. I have based the listbox on a query and within that query, specified what values to look up as you're entering data into the search box. You can search by all three criteria you have...

Yep, had that problem too - had a discussion with someone about it just today http://www.access-programmers.co.uk/forums/showthread.php?t=110870 If your forms are based on a query that requires finding data and you have no data in your database, that's when it happens. Can you give more detail?

Do you mean to display the number, account name and date in the list box? If so, all you have to do is to change your listbox to have more than 1 bound column and have all the fields you require in the record source of the listbox. I hope this makes sense and I have understood the problem...

Aww, I wasn't suggesting it was guesswork at all! LOL Thanks for the example, it is certainly a useful thing to remember in the future. I just didn't get why my form was blank even after I set the Allow Additions to Yes... I think it was because of the way the query is set up on which the...

Great suggestion - but Allow Additions were already set to Yes and the form was still blank. I just realised that when doing this, there needs to be at least one line of data in all the fields the form is opening with (it is based on a query). Once I have done that, the form is opening up...

Hope someone can shed some light on this. I have imported the contents of my database into a new database, as all the testing is completed and want a clean start without any dummy data in it or anything. My main form which is where most of the interaction with the database goes on appears...

Ok, I suck at coding! lagbolt's suggestion sounded great up there, but I have not been able to write the code successfully - no idea where everything goes! I'm just taking stabs in the darkness at the moment :( In the original code, lagbolt suggested that there may be missing OralIDs that...

Easy! In your query, inthe pc number criteria field write: [Enter pc number] This will bring up a popup window where you enter the number you want.

I still haven't figured this one out. Can this even be done?