Search results

Hey guys, I’m going to throw this out here in hopes someone may be able to shed some light on this. Have an Access form with essentially 4 fields ASM Certification MPR Certification (Combo Box ) TMS (Combo Box ) QUAL Type Two, as you can see are combo box. There are some other filters...

hey all, I'm back to banging my head against the wall on an entirely different issue, the elusive ListView. Let me tell you what I have, and works, and what I'm hoping for, not working yet. Shipping Database that seems to never be complete. REGION TABLE: REG_ID (PK Autonumber) SELECT...

JHB and nanscombe, Yes it works, or for the most part. It was pulling the correct data into Carrier but it was not displaying, could not see it. So got that solved and moved on. The next problem that I ran into was having the form that the cascading combo boxes on was bound to a table. All kinds...

BINGO ! Thank you Nigel and thank you JHB. I just tried it and it shows up but still need to work with enabling it after Port Selected. Again, thank you both !

yes, just saw it. If I change from Column Count 2 to 1, then I get nothing. Before, it was working from code JHB gave me and I could tell by selecting a CARRIER and it show up in the table. But I could not see the value in the combo box, it was there, but you could not see it. I believe screen...

I'm about a day away from Filemaker PRO! So I finally get the cascading combo boxes to work, the last step to get the final one to pull from a Junction table courtesy of JHB even though the last box seems a little shy and doesn't want to show itself, but first things first. The goal here is to...

JHB, as far as the test data, just about to post that ....5 minutes.

JHB, turns out you were right. It worked for me, just can't 'see' it. Can't figure that one out for the life of me but now trying to get the selected values into another table.

Thank you Mihail, I'll zip and attach where I got before I more on to the more frustrating issue of cascading combo boxes with junction tables and having text boxes display selected data that apparently won't display as text (and displays as ID number) unless you change them to a combo box. I'm...

JHB, thanks for the effort but it didn't work. Before it was giving me the id numbers, now it's just blank when I click teh combo box, it's like the values are there but not displayed. Then oddly enough, when I try and close the form I get a Parameter Query msg box with the name of a carrier, in...

Mihail, Don't bother with the mileage rates, they are as you said incorrect with lots of duplicates and other errors. I was given a spreadsheet with a lot of tabs and over 8K records, Mileage Rates was just one of those tabs. my 'task', if you want to call it that is to go through this scattered...

thanks Mihail, In America and so a few hours behind Romania. Going to get some sleep and will check in first thing in the morning

hey all, I have either given up or taken a break, not sure with on table / relationship structure with considerable help from both gemma-the-husky and Mihail. Thank you both as much for your patience as technical help. I'm jumping to the forms development and going to try what I need via...

hello Mihail thanks for your reply, I will try and answer your questions. Except one more thing: From this sheet I don't understand that the rate depend from CARRIER. I see this in your SAMPLE DATA. Have I understand OK ? (The rate depend from the carrier, distance and unit) The data was...

jdraw and spikepl, thank you both for the quick replies. I'll try and explain with more clarity and steer clear of the DB-speak and keep it on a level of more what I am trying to achieve here. I could very well have the entire table structure wrong here to begin with, so I'll explain without...

To anyone who can help with relationship problems; I am trying yet again to create a Shipping Program here and about to pull my hair out trying to get the relationships right. I'll start by explaining what the 'process' is and trying to normalize a spreadsheet with over 8K records in it. The...

I'm hoping someone here might be able to add some insight into what I'm trying to do here. Getting ready to start on a project and want to use treeview and list in the project if possible. Lots of menu selections and sub selections. I came across the file that I am going to include which is from...

hey everyone, sorry for the delay in getting back and thanks to all of you for your input. The VB worked, took a little tweaking and learned some in the process but saved me more hours of frustration. Thanks again to all.

thanks, but this really does not help much nor have the last couple of hours on Nz searches. I have created three text boxes on my main form and pulled the totals values from all the subforms 29SUB, 33SUB and 41SUB to get the values on the main form without all of the levels going into the...

hey guys, I'm hoping someone here can help me with that elusive 'Nz" function. Here's what I am trying to do. I have a main form, called LIN_NOMEN. There are 3 subforms in LIN_NOMEN: 29SUB, 31SUB and 41SUB. each one of these subs has a total box that calculates a total. When the user selects a...