Search results

Kudos go to Jon K!!! Thanks!!!! I finally had some free time to review the queries you sent over, and create them in my DB...and it worked like a charm!!!! Once again this forum saves my posterior!! Thanks all who posted their suggestions. Ian

...and the report...

Wow!! Thanks for all the suggestions! I created two separate tables thinking that a separation of data was required because of the way that data is being entered (see attachement). But, now that I am thinking along the lines of one table, I think I can see how to design the forms and reports...

I apologize up front for the length of this post, I need the clarity in question formulation for my own sake :) I'm having some trouble, and having searched through the listing have not found a complete answer to my problem. The environment is as such: We are responsible for testing Out Of...

Another option, I stumbled across in my efforts, as I am trying to report the last date a dial-up access modem was tested, across 30 routers. In my form, I have the primary form capturing the router information, and then a subform (datasheet) to document pass/fail statuses for each week tested...

I originally had been testing for the "true", just as you stated. And, the debugger showed [printed] as equalling -1; that's what had me so confused. From previous actions in the code (setting printed to -1 when "Print" control button was depressed), I felt that the direction I took originally...

That did the trick, with some nuances. I set all the fields locked and disbled, then set the code to: If Nz([Printed]) = 0 Then Purchaser.Locked = False Purchaser.Enabled = True CustNo.Locked = False CustNo.Enabled = True...

Unfortunately, the debugger is not picking anything up...the code appears to be correct (that is why I am so baffled). This is a subform, and the code is against the subform, and the piece of code below to set the check box works perfectly (which is also in the subform). I am really stumped...

I'm having trouble finding the problem with the code below. It is in a subform, and I am trying to disable and lock fields based on the [Printed] check box (if yes (or checked) then lock fields). It seems that no matter what I do, the fields are either locked or unlocked, for both checked and...

That got it!! Thanks for the help with the syntax!! And I apologize for the double post. Just out of curiousity, what is the difference between the single quote and double quote in VBA? Ian

I've set up the dlookup command, but I'm getting a run-time error 2471: "...strings...not allowed as Public members of object modules. Again the code, revised with the dlookup command, and the if-then-else removed. The table with the OSLogonName and the UserName is tblOSLogonName...

I am not sure that this is the right subforum for this topic. I am having some trouble with code. In the following, I am trying to eliminate the lengthy "if-then-else" statement (which does what I need, but needs coding everytime employees change) by comparing the logon name to the names in...

How would I then equate the logon name to the appropriate row to return the username in the fOSUserName() string?

Thank you so very much. I made a slight addition to the code, as I am using the full name in the field rather than a truncated logon windows name. If interested, here is the code: Option Compare Database Private Declare Function apiGetUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal...

I need some help even further up front. How do I identify (or associate a variable) to the logon user name? Then I can set a filter to report against that field. Is this something I can write to a table in the background, something along the lines of CurrLogon as a text field that has the...

I have a report that lists current contacts for a sales rep. I want it to filter this report by the logon name of the individual, so that they only see thier contacts. Any thoughts on how to perform this? Thanks, Ian

Anauz, If it wouldn't be too much trouble... ian.cole@adelphia.com Thank you much in advance, Ian A. Cole

I have two forms. One for Customer information, including a subform for activity history. The second form is to allow AE's to filter the record set by RecordNumber, CustomerName, or AEName. Here is the code I have so far... Private Sub RtrvFormCmnd_Click() On Error GoTo...

Fantastic!! Thanks!!! Ian

Thanks for the help. The second if-then-else statement was to allow for the changing of the sales executives mind (or should they mistakenly select the wrong item). I apologize about the confusion with the 100% vs. the 5. Our scale on sales phase is 1-5, with one being the equivelent of 50%...