Search results

Sorry duder ... I can't get past the names bit, yet. It normally isn't an issue but it could be creating some havoc because of scope - so trying to eliminate that part first since it is easy. You have ... Private Sub Import_Click() On Error GoTo Err_CmdImportExcel_Click ...

I am not sure if this will help - here is something I wrote and used in many databases that I've thrown together. Although it uses filtering (and not query driven), it might help clue you in where you are or provide an altogether new solution. Even though it doesn't do any true fuzzy...

I would think that the bits about ... On Error GoTo Err_CmdImportExcel_Click Exit_CmdImportExcel_Click: Exit Sub Err_Command8_Click: Resume Exit_Command8_Click Are at odds with one another. That is, if error go to cmdImport... and it has nowhere to go because the other reference is for...

Use Or instead of And. -dK

Okay ... here is something ... validate the logic tho ... Dim dEarning As Double Dim dPaye As Double dEarning = Nz(Me.txtEarning, 0) dPaye = 0 'is there anything in earnings? If dEarning > 0 Then 'assign first 30000 @ 5% (if less than compute) If dEarning >= 30000 Then...

Complex, indeed. :eek: Updated: Removed entry because I realized the fallacy in my thought process until I saw it typed. Will work on this a bit more before posting final proposal ... Apologies, -dK

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...