Search results

I've enclosed a screenshot as it tells the story pretty well by istelf. I would simply like to be able to click any item in the listbox (populated from a query simply showing all records in a table). Once an item is clicked in the listbox, I'd like the form to go to that record (this is to...

You're probably right...I think I too often trust Access's inbuilt way of doing things. I'll give that a go (I was half thinking of starting the form again anyway). Ta.

Hi, I've done a bit a googling and it seems a lot of people get this error after upfrading their versions of Access, whether they've upgraded the file type or not. Also, Forms!frmCaseList!frmsubProjCases.Form.RecordSourc e = strSQL I'm assuming the "space" between "Recordsourc" and "e =...

*bump* If anyone can help with this I'd be most appreciative. I'll strip the database down and post an example if necessary. Thanks.

Malcy, I plopped this code in this morning and it didn't work...took me an an hour to figure out what strScrNo was for, and that it wasn't relevant to me and needed changing! Works a treat now I've put my own field name in! Thanks again.

Quick Solution If I'm right (and I might not be), you can't have calculated entries in a table...that's what queries are for. You'd store "no1" and "no2" in table "sum" as suggested, then query table "sum", adding a calculated field within the query. Call the calculated field, "sum...

Thanks, Oldsoftboss. I think I'm going to go with Malcy's solution, but it's always nice to have several ways of doing the same thing.

Possibly. I just had a look and the source of frmCallLog is doing this; tblDesktops_SerialNo, tblDesktops.HostName, tblDesktops.TagNoID AS tblDesktops_TagNoID FROM tblPrinters INNER JOIN (tblLaptops INNER JOIN (tblDesktops INNER JOIN tblCallLog ON tblDesktops.AssetID=tblCallLog.Desktop) ON...

Yup, I can see how that'd work. Thanks for your (very quick) help! That's my problem half the time, I can see how coding works when I see it, I just don't know how to code... I can read but I can't write. :)

I have a few search forms that, when search parameters are entered, a continuous subform displays the results (summarised...not all fields show). I want to be able to double click a field in any given record, and have it open in a form allowing editing of the record. I know I need something in...

I have a database (backend - just tables), that stores data for an asset register/call logging application. The frontend is pretty much finished, but I'm having one or two issues that are annoying me. I have a form for logging requests...most combo boxes are filled in by looking at...

Just confirming that this worked a treat. Thanks, Fear Naught.

I'll give this a go later. Thankyou for the sharp response.

I know how to use DCount to count the number of occurences of a particular "thing" in a field of data, but how do you count the number of occurences of a number across a record? For example, I have a simple database to record golf scores (attached). I want to count in the statistics area of...

Can't answer this directly, but in cases of design and aesthetics, I've often used labels as command buttons to maintain a "flat" look and feel...might not be the best way of doing things, but hey, the have an OnClick event. :) You could also make a label look like a button by making it...

I thought it'd be something daft! Thankyou.

Nope...didn't work. Still getting all records, true and false. I'm gonna strip it down so I can post it here for people to have a look at because it should work...yet it isn't. EDIT: I've attached a stripped down version with just the necessary tables/forms/query blah. At the moment, the...

OK, I think you're trying to do something that I've just figured out myself, or at least it'll point you in the right direction. If you're wanting all records when the combo box is blank for example you need something like; [Forms]![Form46]![combobox] or like [Forms]![Form46]![combobox] is...

I have a query that shows banned users (I work in a school). When a student's ban has ended, a tick box is checked in a form linked to tblBannedUsers to show they are no longer banned. The query itself simply queries all records in tblBannedUsers with a username field (UserID) taking search...

A guy called Grommit (I think) posted this in the example databases forum. Helped me, and I think it does everything you want it to do. Regards, Ste