Search results

Ok, Tested it again. error No is : 3131 Syntax error in From Clause. This is what I have so far that comes with above error. Can you show the modifications? INSERT INTO tblpks ( pk, userfk, frm )...

No unfortunately. I'm away from my PC and can not give the exact error. Later I will.

That was my initial thought. But I've seen some members here (@MarkK I believe) use a different way of writing queries. The bellow is an update one. I thought maybe someone has a way around this with a select query. Const sql As String = _ "UPDATE Leave As t SET t.Comments = p0 " & _...

That function receives several parameters and goes through some tests and eventually returns the sql. For the convenience, let's imagine it simply returns the exact sql of the saved query: Function CreatSql() As String sql = "SELECT s.InquiryPK, s.InquiredOn, s.InquiredBy...

Since @NauticalGent suggested your blog in one of my questions, I've been fascinated with your works. I've learnt a lot from you and never had the opportunity to thank you. I really appreciate every single thing I learnt from you. Thank you.

OK, I give up. Tired of trying and hitting the wall. I have this insert query. INSERT INTO tblPKs (PK, UserFK) SELECT InquiryPK, 1 FROM qrySentInquiries_Orders WHERE InquiredBy=1 AND ReplyReceivedOn IS NULL I have a function that returns the exact same sql as...

What does it mean?

Social media went crazy with people's reactions while reading A Little Life, a Novel by Hanya Yanagihara. (Though the author name is Japanese, but she's actually an American Novelist) Some quotes from Insta: @freaky_soul29 : every single time I hear this name, my heart breaks. This is the...

According to Greek City Times, a Greek woman has filed for divorce after asking ChatGPT to interpret leftover coffee grounds—an AI-assisted reading that allegedly revealed her husband was fantasizing about another woman. The incident followed a rising trend known as AI tasseography, where...

Ok. I think I understand where my wrong beliefs had came from. As I explained, a new form with a large dataset was very fast (as you explained), but when I changed our search result form's recordsource to tblOrders, it's drastically slower than the numbers I gave in #26. I think Conditional...

@GaP42 The result came out sooner than I expected. We decided on if @The_Doc_Man's Me.Requery or @arnelgp's "Select * From tbl" can do the job, we prefer not to change the table's design at this point. Of course, the suggestion was added to the to-do-list and will be thought over again if it...

Yes, they do. No. Of course there are rules around. For example the total price of the order, the total quantity of the order, the delivery date, ..... But it's hard to program something that not even a human can decide. Even users at times have to consult with others to decide. The records...

Just a correction. I just added a continouse form bound to a table with 1,277,585 records. Opening the form took less than a second. Going to the last record took around 4 seconds. Seems you're correct. (as always.) I don't know what made me think it would take a long time for the form to be...

The form is not based on temp table or memory. It's based on a table. My terminology may be wrong when I used "Clear". When a form with "Data Entry" set to yes is opened, the recordsetclone.recordcount is equal to zero. When we add records, the recordcount is changed to 1->2->3->4-> By "clearing...

While I'm reading your link, then why we have to wait for ever for the form to be opened? (when the record source is set to a table with a large amount of records)

Another benefit to above: Searching a record and norrowing down the result is a husstle. Going back and forth between search form and result form makes me crazy. All of our continuous forms, have several textboxes, combo boxes, checkboxes etc. in the header. Users have been given a way to open...

Most of our tables in sql server has more than a million records. During developing process, what happens if a developer double click a form in navigation pane when its recordsource is set to someTable or Somequery? The form opens and we have to wait a long time for the form to pull all the...

That's how I'm managing it now. Not a dictionary, but a hidden unbound textbox. I was looking for a simpler way. Assigning new PKs to a dictionary, and then checking if the PK exists in the dictionary Vs Me.requery I'm sure you understand which method is simpler. Thanks again for your concern.

It's a long story, with a lot of conditons and problems. The purpose is not to go to a new record. The purpose is to clear the form. It's a purchase form, the users start entering data and then click a button to send the orderd items to the suppliers. The "Send Mail" button loops through form's...

The more I receive your suggestions, the more I hate myself. How didn't I think of that?