Search results

I've been away. Yes, to confirm, that works too. Thank you.

Ok thanks. I guess the concept of "outside" is hazy to me since I was using the query - or more precisely, stating the query - within the form object. But I think I get what you are saying. A query definition, even though defined within the form object, is still "outside," because the query...

Thx, I've used that link offten. But it refers to form-subform hierarchies. My issue occurs totally on the main form. The query that caused my problem is the value of the row source property of a(n unbound) listbox on the same form that contains a(n unbound) combo box whose value the listbox...

That actually worked. Thank you!! If you or anyone has a moment, I'd appreciate learning why it works. Are there rules about when you can and can't use the "me" reference when you want to access the value of an unbound control in a query? Does it depend on the context/purpose for which the...

I'm afraid this is a fundamental issue, but I'm rusty. I've got the following query as the row source for a listbox on a main form. cboShootName is a combobox on that same form. SELECT DISTINCT QrySbfShotList.CamerasFK, tblCameras.CameraNum FROM QrySbfShotList INNER JOIN tblCameras ON...

Doesn't change the output. But get this: if I reverse the sequence of the two fields SELECT DISTINCT QrySbfShotList.CamerasFK, tblCameras.CameraNum... then the results are ordered correctly!! It's as if having the text field first converts the numeric field to text. Is this some quirk of...

Thx but I get an error that the orderby must refer only to fields represented by the first select. When I do that, I get strange hieroglyphic type characters in the Dummy column, but I can tell from the values in the first column that the order has not changed. -Ron

Thanks, it did occur to me that the second column is behaving like it's now text. But how do I represent the null? The word Null (without quotes) and "" give same result. Same thing when I try an undefined variable and leave it blank when the query prompts me for it.

I'm preparing a query as the control source for an unbound listbox. The following code gives the desired results: SELECT DISTINCT tblCameras.CameraNum, QrySbfShotList.CamerasFK FROM QrySbfShotList INNER JOIN tblCameras ON QrySbfShotList.CamerasFK = tblCameras.CamerasID WHERE...

Another possibility: overlay a transparent text box with properties set so it doesn't permit data entry but whose value is blanked from the on click event of your date entry control. (Untested. Just based on an idea I read about somewhere.) -Ron

I'm not advanced either, and I hope someone who is will help. Meantime.... The syntax of your subform reference is wrong. Should be: Forms!frmZlecenieMarzena!frmGoraZlecenia!Form!Nazwa.setfocus See here: http://access.mvps.org/access/forms/frm0031.htm But aside from that, if both those...

You could set the form to 'Popup' in design view, but that may not give the overall behavior you want. Also, for the textbox.setfocus, be sure to use the formal syntax - ie. not 'me' - since on deactivate technically puts you out of that form's scope (I think; just throwing out novice ideas...

Try using the form's deactivate event to check whether that control is null. If it is, issue your msg and set the focus back to that control. -Ron

Based on thinking about a similar situation of my own (not tested), here's a suggestion: 1. Put the current rank for the record to be "moved" into a variable, and the desired new rank in another variable. I'll call them CurRank and TargRank. There are various ways to do this. 2. Put the...

Not to patronize, but there's also a foreign key field in the second table? To which you connect the primary key in the staff table?

Either I'm truly missing something, or I've failed to portray the scenario I'm addressing. I'll try again. It's precisely because I do understand that that I can't use it. (Not sure what part of "At present, they enter "records" line by line into a word processor, then use (archaic, IMHO)...

An alternative I've read about (not tested) uses LIKE keyword: Like Forms![parameter form]![combo27] & "*" -Ron

Thanks for the comments. Sorry if I gave impression I don't understand difference between the relational model and a flat file. I have a lot to learn about syntax, etc. but I do respect, and greatly admire, the power of the relational paradigm. As indicated in my OP, I'm trying to...

Thanks. Access only permits one auto-numbered field per table, and as mentioned, I already have the PK field autonumbered. So you're saying use *it* for the third degree of sort? Will try on a test table, but not sure that's sufficient. There can be discontinuous clumps of records with no...

Thanks. I already have an autonumbered primary key, and yes, it has many gaps, but I thought I read that it also can sometimes show up as a negative number. (Some access quirk?) Anyway, my "order entered" answer is too quick and simple. The user can insert records in places where those...