Search results

Nevermind I just made an extra field(In : yes/no) on the tblItem

I am making an inventory database which I will have every single item in the database with its own serial number. The items will be shipped out, some will be returning by RMA. Is it better to have all the items in one single table? or have two table , tblItemIn abd tblItemOut.

For those who will search the forum for an answer <Before> SELECT tblProduct.Id FROM tblProduct WHERE (((tblProduct.Id) Not In (SELECT Id FROM qryProductOut))); <After> SELECT tblProductDetail.ProductId FROM tblProductDetail LEFT JOIN qryStockOut ON tblProductDetail.StockId = qryStockOut.Id...

That is too slow. any alternate ways?

For those who might search the forum looking for an answer Me!ItemId = GetItem Dim OldId As Long OldId = Me!Id Me.Requery Me.Recordset.FindFirst "[Id] = " & str(OldId) I do not like messy codes. so if that code can be simplized please help. :D

Me.Requery now....... I have to look for a way to store and load current postion

normally, when you type something into a datasheet it would add a new record. how ever I am using a pop-up dialog to input a value in to the datasheet. then the datasheet does not add a new record. how do i make this happen? I don't have any fields to dirty. all the fields are locked so...

Thank you :D

if it is a form then you can filter the form Textbox_AfterUpdate() me.filter = "[Firstname] LIKE '*" & nz(Textbox.value, "") & "*' AND " & _ "[Lastname] LIKE '*" & nz(Textbox.value, "") & "*'" me.filteron = true End Sub EX : [Firstname] LIKE '*jeff*' AND [Lastname] LIKE...

Q. was that text box placced on the same form that has the information to display? A. My information was on a Listbox and the text box was on the same form Q. Did you use any kind of command button. A. Nop Q. Where does the code go. Does it go to an onclick or on enter event? A...

First of all, make sure the TextBox Format is set to General Date then Private Sub TextBox_AfterUpdate() TextBox.Value = TextBox.Value + Time() End Sub

You can try DLookUp. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/acfctdlookup.asp

Just in case, What if there are several records with same OrderDate?

I thought SQLs were easy and clean, but today I found out it can get messy. :( anyway, :D Thank you for your help

What I have done is I just made one TextBox and whatever the user typed in, Search it in both First name and Lastname Sample Code Private Sub Search() ListCustomer.RowSource = _ "SELECT AccountNo, Company, Contact " & _ "FROM tblCustomerTemp " & _ "WHERE...

account manager name from a combo box and have the other two fields auto populate from tblCSBRoster. Please help!!!! Make a Event AfterUpdate on the combobox Private Sub ComboBox_AfterUpdate() Textbox1.Value = "xx" Textbox2.Vallue = "bb" End Sub

I have a Query with three fields StockId Date OrderId I want to Max(Date) and Group StockId and get the OrderId However, it is required to do GROUP BY OrderId in SQL and this will return every record. I just need that OrderId, and this thing won't let me. :mad: By the way, StockIds...