Search results

If the end user putting the date does not folow the same format of date tgen things will mess up fast. Even if the date is placed to the field automatically and not by user input if the machine is set to USA date and the other machines using the application are a different date this will skew...

Thank you. Might sound that I am being too picky now but I want it to not be too slow when there is more then a year of data in the tables. BWT I have learned that no keyboard enjoys margueritas as much as I do and club soda will not rinse the sticky out.

Brilliant - thank you for that link. Saves me lots of work now and in the future.

This is extremely interesting because I have to make my programs all split up so that the data is stored separate from the user interface programs like BE and FE but it will become very complicated for the FE because each department in manufacturing needs a different screen. I also will need to...

Thank you - I am also trying to learn as much as I can because this seems to be something I can get my head around. Finding it a little deep but that is the learning part I guess.

What I called my unique number actually must be a text because I am informed that the workorder 'number' as I called it can actually be alpha-numeric. I was calling it a number in the 'generic' term but obviously I need to be more accurate in my choice of words. I suppose a numeric would be...

Thank you for those links, I passed the bottom part of the second one to the network guy. Hope I am not getting over my head in this. lol

The field I want to use as a key index is a 13 character number. This is a unique number related to batch numbers being run in manufacturing based on a compilation of work order number, workorder line number and a sequence number. If it uses a 1/2 principal to index will this cause a speed...

Thank you. That is making sense to me. Do I really need the autonumber key index that is offered with the wizard when I create a table or is it just same if I have a unique identifier that is part of the dataset? I did not notice a difference in performance when I said NO to the offer. Just...

Thanks I think I get it. So that means I have to look at the tables and make the indexes on the fields in the tables, they can have more then just primary, secondary, tertiary? I do not want to index all the fields but it is possible to have more then just a few fields indexed? Will the extra...

Someone mentioned to me that the speed pf a big query will be improved if I include the primary key index field in the query. Just I am wondering if any of the people that program lots know if this is right. Thank you.

I figured it out - I have my Column Widths in Combo2 set to 0";2";0";0" so I just swapped Table1.Field1. and Table2.Field1 in the Select and set the Column Width to 2";0";0";0". Now it shows what is selected and not just the first value on the list. Thank you for reading and suggesting.

Thanks - it did not change anything when I added that. In the AfterUpdate of Text1 I have this Combo2.RowSource = "SELECT Table1.FIeld1, Table2.Field1, Table2.Field2, Table2.Field2 " & _ "FROM Table2 INNER JOIN Table1 ON Table2.Field4 = Table1.Field4 " & _ "WHERE Table1.Field1...

I have a Combo Box on a unbound form that has its RowSource populated based on what is typed in a text box. The end user would be entering in a text and then select an item from the Combo Box which would populate other fields from other fields brought in to the columns of the Combo Box. The...