Search results

Here is a method that you can use. HTH, -dK

Here is an example that I use ... Dim sFileName As String Application.FollowHyperlink Environ("USERPROFILE") & "\Desktop\" & sFileName In this particular case, I have assigned the variable sFileName the name of a file that is located on the user's desktop and concantenated the...

Yes. Store the directory name as one variable and the file name as another (or standard control reference). Then simply append (concatenate) the file name for the hyperlink using '*'. HTH, -dK

Hello and welcome to the forums! So what you are wanting to do is for the user to utilize the combo box as a 'find a specific record' feature? That is, when the user selects the combo box, the form leaps to the correct record for editing? -dK

In the AfterUpdate event of that control, you can use the DLookup to locate the supervisor's name and place it in the locked control It should look something similar to the following (after correct substitution) ... Private Sub txtControlName_AfterUpdate() Me.txtLockedControlName =...

Great! Aye, the OnCurrent works nicely considering how you are operating there. I've not seen issues with 16k+ (about 20 fields) records using this method so you should be in clear. Glad I could help and good luck! -dK

Sorry for the delay ... I am glad that those helped you out. For your current issue, if I have it right - you should be able but use the dot reference. Forms!FormName!ComboBox.Column(n). Don't forget that the columns start at 0 for the first one, 1 for the second one, etc. If I have it all...

Hello and welcome to the forums! I see the difference between your two situations is one if for a new record and the other is not. I would suggest performing a logical check and and depending on the outcome of that check to modify the control source of your combo box. This can be done by using...

Hello ... you can take a stab at it by looking here and here. There should be enough information to get you where you need to be. If it doesn't please post back with any problems so that we may be able to help you further. HTH, -dK

Try this. -dK

Here is an idea that I incorporated once into a system. The users didn't need a formal journal entries so I created a simple method so that users of different shifts could 'post each other notes'. I created memo and yes/no fields for each relevant section of the system whereas they could post...

Glad it worked first off and thanks for posting back your final solution. Good luck! -dK

Dates are used with the "#" symbol. Try something like ... stStartdate = "[servicedate] >= #" & Me.Text10 & "#" Although I don't think you can use the ampersand to properly 'and' to logical concepts. You will need to use the AND operator with each element having their own criteria. Do a...

My initial proposal would be you only need to create the 2nd one (for the columns). This would hinge on the underlying query driving the main report. If it has the MemberID that you want to use for the linking of the column report then you should be good to go. In this manner, the main report...

I think for columns in reports it's an all-or-nothing sort of deal, so I would be prepared for subreports. It would be alot to type, but I will offer this link as a reference. There is a sample I put on there which may provide some insight ... well, as to how I would approach the problem...

Good to go. You could have used a text control, but then you would have to set more properties to make it look like a simple message on the form in your pop-up simulation. Glad to see it working for you .. good luck in your project! -dK

If you aren't learning then you aren't growing ... there is always something new or better. :) I am glad you figured it out and posting your solution. Good luck! -dK

You could use the .Requery property for the subform to refresh. The question is, do the users keep the form open all day? Or do they update it, close the db, and reopen when they need to update it again? I think the problem might lie in the condition of the .Requery. If it is the former, there...

You're welcome. Glad I could offer a solution. Good luck on your projects! -dK

Hey lzfy ... I think your problem is you are trying to establish a primary key as the many side of a relationship. To my knowledge this can't be done - only a non-primary key can participate on the many side of a relationship. I would think that your design structure may contain a flaw or you...