Search results

Mr. Hartman, sorry for the delay in my response. I like to thank you for your explanation of PK's sequencing in relational databases. I'll make the necessary changes in my Application to accommodate for PK sequencing. Thanks again for you time, help and insight!

I would like to thank everyone who took time to help me find a solution to my Linked SQL Table being out of sequence.

Thank you GinaWhipp for your response, much appreciated.

Thanks so much for your reply. I understand your answer with regard to a “bucket of data”. So, that means that every time a record is added by the Customer Form, I’ll need to sort the Table before the records are displayed by the form again. Would you suggest Sorting the table with VBA Code...

I’m not sure if I’m posting this in the right place. I Migrated my Access 2016 Application to SQL Server Express using Microsoft SQL Server Migration Assistant (SSMA) for Access, Version 8.16. for the first time. It migrated my successfully. No errors. I linked the tables and the Application...

ridders and pbaldy: Gentlemen, thank you very much for helping me. ridders, thank you so very much for all your efforts and working through all the correspondence to to finally come up with a good solution that meet my needs. The Conditional Formatting works well and the linking the tables...

pbaldy, thanks so much for responding. Really appreciate it! People have asked that question? I'll repeat what I have said before, but I'm no expert. And no one has told me, yes or no, you are right or wrong! Since there are 14 Controls that each would require DLookups and there are as much...

ridders, I'm really sorry that this is taking so much of your time. The reasons why I exhaust all my efforts to fix my problems is the 'Lost In Translation' aspect of communication via messages. It sometime hard to get one message across. As I stated before, doing 14 Lookups and have as many...

ridders thanks for your Time. I'm so sorry that you are struggling with understanding what I'm trying to do. I though I explained it properly, but obviously I did not. Sorry! That was the result of having the Lookup code in another Sub. Since I was having trouble passing the value that was...

Attached is a Test Sample of my Form. Thanks for your help.

ridders, thank you for responding and for your patience! My Code isn't much different than what was posted in #5. Although #5 post is obviously Hard Coded in the Event. I'm just doing a Lookup to the ProductType Table in front of the FormatCondition code and placing the lookup value found in...

If anyone can help I greatly appreciate it. I switch my form from Datasheet view to Continuous view. Right now, the first record of my Continuous Form is colored correctly and all the records below are not correct. I'm getting the same results as when the Form was a Datasheet. After some...

ridders Thank you for your response. Your opinion is very helpful. "worth changing to a continuous form to achieve what you want" I had the FormatCondition code in the Form_Load event of my Datasheets. Thanks for confirming that it goes in the same place on a Continuous Form. I have had...

Missinglinq Thanks for your response. Just out of the gate, may I say that is a very nice Form and Report! "Sorry to disagree, but that is definitely not true for continuous forms for which this is an example where CF is set using code:" I would not disagree at all. I was just repeating what...

missinglinq One thing I forgot to mention is that I have 14 Columns to color per record. If have to do a Conditional Formatting DLookup on all 14 Columns, won't that make the Datasheet Form very slow. I'm just asking! If it would be slow, is here another solution I could consider. Thanks

missinglinq , thank you so very much for responding. What you wrote about FormatConditions regarding the Form_Load event and Form_Current event is exactly the experience I have encountered. I guess if I want to continue to use the coloring philosophy, I have to accept that there is no way to...

Thanks in advance for your help. It is greatly appreciated! Two part question. But the first question needs to be addressed before I can move on the second one. I have a bound Datasheet Form. Technically, it’s a Subform in a Form that just holds a Heading Label. I use FormatConditions to...

I’m using Access 2007 I’m attempting to apply a filter just one Control on the Main form, such as Date I have a Main Form with 2 subforms. Everything works fine until I try to use Filter by Selection. After filtering the Main has the correct information and has the correct number of records in...

plog, thank you very much for helping me and giving me great advice. I did exactly as you stated and of course, it worked. Thanks again, you saved me countless hours of frustration! Regards, Rhino999

I hope someone can help me. I have spent a lot of time on this and yet I have not been able to find a solution. I’m trying to execute a VBA SELECT, FROM, with a WHERE Clause. I first created this in a Query and thought I could just move the Code over to VBA and I’ll be done, NOT! Firstly, VBA...