Search results

Bladerunner & KenHigg, this is just a fun thread. Please do not make it a political one or something different.

Hello Stu22, Welcome to AWF :) Create an Form to get this going. Or use VBA.

OUCH ! Lol. :p

Hello bilcic, Welcome to AWF :) You need to make use of the Where Condition on the DoCmd.OpenForm method. Something like, DoCmd.OpenForm "Form_2", WhereCondition:= Me.IDControlName

Use a SELECT Query on the manufacturer table with the Product code as the WHERE and ORDER BY Price and Quantity. You might need a bit of VBA to achieve the Ordering process.

Is it weird, that I am slowly drifting away form Access and might never take another project using Access?

Hello Karyn, Welcome to AWF :) I hope you find the answers to your questions, and I wish you good luck with the job from everyone here at AWF :)

Hello Ifshaanm, Welcome to AWF :) To help us help you better I suggest you please have a look at the following threads : Please use Code Tags when posting VBA Code How to Show your Table in a Post

You sure you are referencing the right control? The rowsource might be an issue?

You are absolutely right on that. Yes, it was a typo. I think this is the reason, I introduced the Last Day of Previous month logic to make sure this problem does not happen, but it seems that that is what is throwing it up anyway. While might be a bit problematic on older dates, although my DB...

Sorry about that plog. Here is another shot (putting it in words). Peter borrows a loan from me. He plans to repay it Monthly, his first installment being 22 February 2015. If I open his record, I need to see when was the last payment due/paid. So today (24 March 2015), I would have got his...

Hello all, I am having a very bad brain freeze day today. I am unable to lock down dates. I will have to pass to a function a Date and a Term and the result would be the Date that is a previous installment of the passed date and term. The following are the examples. Date (In) | Term...

As I said the code is only a start, you could always modify the code to make it suit your needs. Also, would you not be better of using a ComboBox over a ListBox?

I would suggest you do not rely upon the after update event, but have a button that will do the filter in one go. As specially with this date field, how will you be able to apply the two conditions? You will not, it would either be > or < not the two together.

You are most welcome. Glad I could help ! You can always share how you modified the code to suit your needs, so others could benefit from it. Good Luck !

Moved thread to General category form "Sample Databases"

Have you tried to look into John Big Booty's - Dynamically search multiple fields, that should give you a start.

Hello chrisjames25, you can use the same form to get this sorted. There is a property called as "Data Entry", which if set will only allow the Form to be opened to add new records, setting the same property will allow the form to Edit/Add/Delete data. Although all of this could also be...

You could make use of the Find Non Matching records from the Query Wizard and then use the result of the result to be updated.

Hi, Please use Code Tags when posting VBA Code Regarding your Query, you need to generate the Filter using the two fields combined.. Me.Form.Filter = "StartDate >= " & Format(Me.txtStartDate, "\#mm\/dd\/yyyy\#") & _ " AND EndDate <= " & Format(Me.txtEndDate, "\#mm\/dd\/yyyy\#")