Search results

Thanks for contributing to this thread, missinglinq. I used bound controls mostly just because I am about 100x more familiar with using simple queries than by using any other method for this kind of purpose. So I am really comfortable with it. Question: What advantages are there in placing...

I have changed my code to: Me![Assignment Form].Form!CboEmployeeSelect.Requery Me![Assignment Form].Form!CboToolSelect.Requery Me![Assignment Form].Form!CboVehicleSelect.Requery This looks to be more correct, but it did not make any difference. One solution is to put text boxes on the forms...

I have three comboboxes on a subform that are synchronized with the first combox on the subform (four comboboxes total). I have the three "dependent" comboboxes synched by way of individual queries that read the PK of the first combobox. The AfterUpdate event of the first combobox requeries the...

jdraw, Thanks for all of the advice. GPS is not yet an issue I wish to confront in the near future. Might have to deal with it as a necessary "evil" down the road a ways. As for the nuts and bolts of getting to where I want to be regarding Order taking and including all of the info I would...

Maybe it would easier to understand my question if I put it like this: In what ways would you suggest altering the Northwind db if we now required the following: [1] The PK in the Customers table must now be formatted to Autonumber. Would accomplishing this necessitate altering any other table...

Suppliers are shippers or brokers that handle shipper's shipping requirements. Work Description describes specific shipments such as: weight, dimensions, special equipment requirements, special tool and hardware requirements, special permitting requirements, special endorsement requirements...

Some conceptual questions regarding db design similar to Northwind I am currently working on designing a db that requires tables similar to Northwind for Suppliers, Products, Orders, and Customers; except that in my case the tables are: Suppliers, Work Description, Orders, and Contractors...

thanks again, sneuberg. If taking all of the spaces out of all of the indexed fields in this project is all that I will need to do to get around this issue, than that is no big deal. Just really glad we might have our solution. I will make "repairs" throughout the file, and then see how that...

attached one file

sneuberg, In 2016, I have in the query design tool under Join Properties three options. For example, the third option is 'Include ALL records from "Service Description" and only those records from 'Destination States' where the join fields are equal. I'm guessing this is what you are...

ok here goes.... SELECT Employees.PersonnelID, Companies.BrokerID, [Service Description].ServiceID, [Service Description].BrokerID, [Service Description].[Gross Fee], [Service Description].Weight, [Service Description].Distance, [Service Description].[Origination Address1], [Service...

ok just tried an experiment by putting six of the tables involved in the problem into a new db by themselves. After putting the relationship joins together, I tied to replicate my query. Saved the query and then reopened it. The join lines for the two State tables went weak and simple on me. The...

Thanks for the input, guys. I did try to make the query work with two tables and then three and so on. The same set of tables caused the same problems regardless of "complexity" while the subject table and the Company and Employee tables worked well together. The fields that I am joining on in...

Hi everyone, I'm having some trouble with a select query. I want it to function like a "products", or an "orders" query. So I have relationships between the "subject table" and other tables like Company and Employee and States and Status and ShipVia. I'm pretty sure I have the tables designed...

well..... I've decided to stop worrying about this and just make copies of the existing "Correct" command buttons and doing the code using the macro builder. So far, seems to be working ok, and it's also pretty simple.

Under the Format portion of the Property Sheet for both the Correct and Incorrect command buttons, Use Theme says "Yes". While still giving different results.

MarkK: Changing the selection under Options/Current Database/Use Windows Themed Controls on Forms, did not effect any of the command buttons currently in use; which means, the inconsistency that I would like to eliminate is still there. However, it did make the next command button that I...

Markk, Thanks for helping out. I took a good look at 'Use Windows-themed Controls on Forms' before posting about this. Just trying to figure out why the change if no one did anything to the Options under Options/Current Database. This is why this is so mysterious. I'm using 2016. I'll see...

I've used the Command Button Wizard several times for making Close Form and Open Report type command buttons. Until now, all of the command buttons produced this way had one consistant theme. Now that theme has changed. How could that happen if I didn't make any changes to any options...

I have a question regarding lookup tables and how one would best set up relationships to them. For my current project, I am using a tables called 'States' to use for lookup purposes. I also happen to want to use this table with four other tables due to the fact that contact info is a...