Search results

Haha, fair enough. I'll see if I can get that done today. Thanks!

Hi everyone, I need your enlightening suggestions again! I can't quite figure out the cause of the issue I'm having, and the result that I get doesn't quite make sense to me. So, here goes: I'm using a navigation control to switch between forms. In one of those forms, I have a continuous...

Hmm okay, fixed it. I just made a copy of the subform, and without touching anything else, the values in that one appear correctly. I'm glad I found a solution, but disappointed because I don't get why it's working now, doesn't make sense... Anyway, if that even happens to you, just make a copy...

Update: Tried creating a new, blank form with the same query as the source, put a single text box control and tried the calculated value, and it works... So, does it mean it has something to do with my form? I don't really want to have to recreate it... also, I'd like to know what's wrong and...

@Frothingslosh Yep, the field is in the query all right. The thing is, all the fields work if I assign them directly via the drop-down menu in the Control Source property. If I select DatePlannedDelivery in there, I do see the proper value in the control. But, whenever I try to transform the...

Hi everyone, I've tried to understand and fix this error for a while now, and while it seems I'm not the only one to have run into it, I couldn't find any solution online. What I have is: A form containing a subform (continuous). The subform's Record Source is a query. The subform contains a...

Fair enough :) I just think I'm already pretty wordy as it is, so I guess I chose to skip some of the details!

Never mind, I found the solution to my problem. Basically, in the query designer, if you add a table multiple times using the "Show table" window, it gets added multiple times as well, with "_X" appended to the name each time (X being a number). You can then manually link the related fields...

@pbaldy Thanks! I'm still fairly new to Access, and didn't think a JOIN query would help me with that. It does! Now, I'm still having an issue with that though: Two of the fields in the main table I'm querying use the same kind of information (language), so they take their data from the same...

Hi everyone, I finally managed to find how to display things how I would like them but I was wondering what you think the best practices for that are, and if I'm not overdoing it. Basically, I would like to have on my continuous subform fields from my table but only as a non-editable list (I...

Hi Privateer, Thanks a lot for the help. I tried all the solutions you mentioned, and unfortunately, none of them worked. The good news is though that one of your suggestions led me to the answer to my problem: What I did (and how it was set in the template as well, which I hadn't noticed) is...

Hi, I'm running into an issue with my forms. I have a form that contains a subform, that contains a list of projects. This list is read-only. To update a record, you can double click on it, which opens another form filtered on this record, and which contains the fields in the first form as well...

Sure, here you go: (nb: I'm not the best programmer there is, but it works :)) Private Sub cb_taskType_AfterUpdate() Dim resource As Long resource = cb_resource filterResources (True) 'run the filtering routine again Dim i As Integer For i = 0 To cb_resource.ListCount - 1 'Loop through the...

This seems to be working for me, thanks again CJ_London! I just added a quick check in the code, before putting the value of the cbo to nothing (0) in case there's any change upstream. I just added a re-filtering in the upstream cbo AfterUpdate event, and checks if the currently selected value...

Thanks CJ_London and spikepl. I quickly tried your solution CJ_London, but it doesn't seem to work at first. I'll have a closer look and try different implementations (GotFocus, MouseDown, etc) when I have more time and will let you know. spikepl, I've actually heard about this trick, but...

Hi, I'm having some issues using the cascading combo box technique on my form. I have a form, which contains a subform in continuous view, which contains a few combo boxes. One of those combo boxes (available resources) should be filtered depending on the value of 3 other combo boxes (task...

Hi everyone, I currently live in the UK and work in a translation agency. I'm new to Access, but know my way around Excel and VBA (not to a professional level, but did a few utilitarian macros for my company, some bigger than others) I'm currently working on a database/project management tool...