Search results

No each book is just one and it may have 50 to hundered cards from 01 to 100.

I have been struggling how to approach this and I'm not having luck. I have table I keep track phone cards Inventory and another table to keep track phone card sales and here are the fields. TblInventory has these fields (CardName, BookNumber, BookSerialNo, QtyinBook, Active) Serial number is...

Here. Private Sub Date_BeforeUpdate(Cancel AS Integer) Dim rs As Object Dim NewItem As Date Set rs = Me.Recordset.Clone If DCount("ReportDate", "TblDailyManager", "[ReportDate] = #" & Me.ReportDate & "#") > 0 Then NewItem = Me.ReportDate Me.Undo rs.FindFirst "[ReportDate] = #" &...

Hi Missing, I was able to put the VB codes and it worked but when i tried to enter duplicate it is not taking back to the original record.

Should I post this VB in the beforeupdate or afterupdate events.

Where do I put this VB code.

The link took me to Dlookup. I'm nit sure how to about DCount

I have table [TblSales] that I keep sales data and it is entered once daily with all the details. I have field [ReportDate] that is key. Also I set up form where the data is entered daily. What I want to do is set up codes in the Before Update event that will give me message if I enter duplicate...

Hi I have form I enter data to the table is there a way to set up so when I'm entering the data in the form it doesn't get save automatically unless I hit save. Thanks

I have table (TblInventory) for inventory with these fields (RepDate, ProdName, EndingInv, QtySold, QtyRcvd) Also I have query that will give me the begining inventory for each day which is the EndingInv of the previous date so I set up this DlookUp but it is coming back blank...

I have two tables that I keep track product sales. Firs table [TblProduct] has these fields. ProdID, ProdName, ProdDate, ProdPrice. and ProdID is the key. The second table [TblProdSales] is where I enter product sales and it has these fields. SaleDate, ProdID, ProdQty, ProdPrice. Also I use form...

Can you change the background color for the parameter pop up window. I have query that asks the beg date and ending date but I was wondering if I can change the color of the parameter

Thanks this is very helpfull.

I have two tables one to many relationship that I keep Phone card sales. The Parent table has (PhoneName, SerialNo, FaceValus and QtyinBook) some books has 50 phone cards and some has 100 and others may have 25 in each book. The other table I keep daily sales for each day and it has these...

Please help, I can't figure out why sometimes when I open my database my switchboard is blank and look like blank and white background. If I close and open again it works sometimes but this happened few times since yesterday.

I have continuous form the I enter about 50 items daily that has these fields (SDate, PNo PName, Qty and Amount) is it possible to see on screen the form this way in two lines SDate, PNo PName, Qty and Amount SDate, PNo PName, Qty and Amount 4/1/09 123 ABC 34 $20.00...

Help with this form I have two tables I keep track Phone cards. One table has the list of all inventory (SerialNo, BookNo, QtyinBook, FaceValue and DeliveryDate) also I have another table where I keep track daily sales and I have form st...

I have form that is based on table I also have field to look up product name from another table =DlookUp("ProdName","TblProducts","ProdName= & nz([ProdNum],0)). What is happening sometimes with same product I'm geeting the name and sometimes it is coming back blank

When I set up the query I got yesterday's numbers but when I set up form with this query to update the table it overrides the yesterday's numbers. I want to keep yesterday's numbers and enter today's ending number aswell..

I have table I have been changing but this is how the table is and I keep track Phobe cards sales that come in books of 50 0r 100 or 200 per pack. and each book has uniqoe serial number and number of each card for example book serial will be X123 and if it has 50 in pack each phone card will...