I found this interesting and was wondering if it could be expended a bit.
My table of zip codes has Primary City Name [PrimaryCityName] and Acceptable City Names [AcceptableCityN ames]. I'd like for the code to change the [City] control on the form to an option drop down showing the alternative Acceptable City Names that the user could then select from. The acceptable city names are stored comma separated so sometimes they will have multiple...
terryechols1
Last Activity: Oct 28 '16, 07:27 PM
Joined: Jul 11 '16
Location: Oakland Park, FL
-
Can't Upload File
I sent you a private message PhilOfWalton. I can't upload the file here. It's under 4MB, smaller that the 5MB allowed but it keeps failing.
TerryLeave a comment:
-
If I had designed this DB from scratch I would have implemented a lot of changes but, since I'm working off of a pre-designed MS Access Template I didn't want to re-design it all over again.
Thanks,
TerryLeave a comment:
-
Not exactly sure what "details" you need. I can say that "Related Calls" in the table is defined as "Number" if that makes any difference.
Related Calls field:
General
Size: Long Integer
Decimal Places: Auto
Required: No
Text Align: General
Lookup
Control: Combo Box
Row Source Type: Table/Query
Row Source:
...Code:SELECT Calls.[ID],
Leave a comment:
-
Possible Coding Problem - Need Help
I'm having a major brain collapse on this issue. I have tried everything I can think of but it won't behave the way I want it to.
This problem, I'm hoping someone can help me out with, involves 2 forms and 1 table.
The first form (Call Details) has a tab for "Related Calls". The purpose of this is to relate calls to one another - for us showing a history of a service call for an appliance. We then group calls... -
OK. Figured it out, not the input mask part but the data entry part. If they type the numbers it works if the copy/paste them in the Customers database then the number doesn't display correctly. Not sure why.
Anyway around that? Anyway to make the SQL Select statement format the business number field IN the statement? This way it winds up displaying correctly everywhere?
OR
Is there a way to pull all the business...Leave a comment:
-
The problem with this one is there is no actual field to place a mask on as this is being written "on-the-fly" through a SQL statement.
I've created a search from to find customer details which is tied to a SQL Query as the record source. I'm using this query as the source as it combines the first name/last name fields into "Customer Name". What I need/want to do is use the same type of masking for the format of this...Leave a comment:
-
How to use Input Mast in SQL Statement
I'm pulling a phone number field in a form via SQL but it doesn't display as the Input Mask dictates in just this one form. All reports and other forms show it correctly so I'm wondering if there is a way to use the mask via format in the SQL statement?
The mask is: \(999") "000\-0000\ 9999;0;_ (as it is in the Customers table)
The mask formats a phone number field that shows, if there, an extension.
... -
Make search result records clickable
I have created a form to use for searching records in the Calls database. Under the forms controls/text boxes for search criteria is an Unbound display of the results (not a subForm). I'd like to make the records returned each clickable and open the Call Details form to that record.
The search form "Search For Call Details" has the Calls table as it's record source. In the "Search Results" (the Unbound part) I have... -
Good morning all.
I have this working, somewhat, but not as I'd like nor as, I think, it was intended to work.
Here is what I'd like to accomplish.
The way I read the code is that when the report is opened/selected (in the reports drop-down list) the parameters pop-up form is supposed to load then put in the dates - and here is where a bit of code is throwing me - once the dates are added then what? There is...Leave a comment:
-
Code found not sure how to use it exactly
I found a post with some code I thought would work for my needs but I don't know how to use it exactly.
The post (with the code) can be seen here:
Best way to prompt for report parameters in microsoft access
I have the form for the date inputs set up, I have the reports OnOpen using [Event Procedure] and the code pasted in there. When I generate the report, the pop up form is triggered but once I enter the dates... -
I had thought about that change but wasn't entirely sure if that would do it. Glade to know I was on the right track though.
Yay! Brilliant. I can't thank you enough.
I will be posting a new thread for a separate issue. I hope you'll chime in on it once I get it posted. Although, you may want to set up the Access Call Tracker template for this one.
I would compact and send you my database that we've been working...Leave a comment:
-
It's working but I do want to make one change. I want to pull the Mobile Phone by default so IF a customer has both I'd like to pull Mobile. It's working now except for those customers that have both. It pulls the Business but I want it to pull the Mobile (if one exist).
I had the column count as 3 to hide the phone numbers, I didn't know that that would block the VAB code from working on those columns. I have them all defined now and...Leave a comment:
-
I played around with debugging and it appears to me that the mobile phone is being completely ignored. Every value is NULL when you hover over the variable where mobile phone should be pulled. I don't exactly understand why.
TerryLeave a comment:
-
I tried both sets of code on the same 4 customers for testing. I selected customers with:
Mobile Phone Only w/company - pulls company but not phone
Both Mobile & Business Phone w/company - pulls business phone and company
Mobile Only no/company - pulls no phone number
Both Mobile & Business Phone no/company - pulls business phone
Both sets of code does the same thing - it won't pull the mobile number....Leave a comment:
-
Update:
I spoke too soon. All is working EXCEPT where a Mobile Phone is used. If there is a Business Phone no problems what so ever. The 94 error is thrown when either the situation I described above takes place, or, as I just found out, when I tried to update a call record to a different customers that, of course, has only a mobile phone listed, the error was thrown again.
So, as you say, you don't like using the IIF statements,...Leave a comment:
-
Update:
I was wrong about the error 94. It gets thrown ONLY when I add a new customer.
This form works by a pop up message when a name is typed in for Called In By that is not in the table asking if we want to add it. Say yes and the Customer Details form opens with the name prefilled. After adding all the customer details and closing the customer form the cursor goes back to the Called In By field, after hitting tab is...Leave a comment:
-
Thanks for the Debugging info I have tried to find good resources on that but came up short. I'll take an in-depth look at the info at that link when I have more time.
An update:
When I first implemented the code the first thing I need to do was search for an address, that is when the error was thrown. But I have been using the code for a couple of hours now and have not had another issue - YET.
I can't tell you how...Leave a comment:
-
Mr Forbes:
You are correct in that I don't want the "Customer/Customer Extended" table data changed only retrieved. The customer info should stay the same in those tables but the calls details written/stored in the "Calls" table can be different.
I tried the new code this morning "SaveAllDetails " but I'm getting error 94 and it stops on this line:
...Code:mCalledInByPhone = IIf(Len(Nz(Me.cboCalledInBy.Column(3),
Leave a comment:
-
I am so lost in trial and error. There are two instances of
One in the code for [cboCalledInBy_A fterUpdate()] and one in the [Private Sub SaveCurrentCall edInValues()]Code:Nz(Me.cboCalledInBy.Column(3), Me.cboCalledInBy.Column(4))
Do I change them both? I did but got errors. When I used the new IIF code in the Sub for SaveCurrent... I got runtime error 94, invalid use of NULL.
I have tried the new code in...Leave a comment:
No activity results to display
Leave a comment: