Search results

I attached the data file. I have form for data entry to table and it is continuous form and every day we enter about 60 items, what I like to do is enter all the data and then have the option to save yes or no "Do you want to save yes or no". Right now when I enter information to each field it...

CUH, I think I right know I'll store the barcode and I have one more senerio to avoid duplicate on serial number can you tell me how to code for this change. 8 digit barcode 12345678 should be this. 123=[ProductNumber] and 123-45=[SerialNumber] with the - in between ProductNumber and...

Mike 375, How should I code this if I want to post in AfterUpdate? Thanks

I have table that has these fields [ID],[SalesDate],[ProdNumber],[SerialNumber],[EndingNumber] Each product has barcode number and there are two kinds of barcode one with 8 (12345678) digits and one with 9 (123456789) digits what I like to do is scan each product by barcode reader which will...

Mike I have one more question. How can I store the final format only in the table. For example I want to scan the item in the form and the codes you gave me will change the format and then store only the final format not the original barcode. In another way the field for the the barcode...

Mike375, Thanks that is exactly what I needed. I really appreciated. Thanks

I have barcode reader that I use as data entry and we have two different barcodes one has 8 digits and the other has 9 digits. I set up form where I scan items and it puts in the table as 12345678 or if it is 9 digits as 123456789. whit these numbers I like to change as follows. 8 digits =...

I have form bas on Table that has these fields [ID] [Salesdate] [SerailNumber] [BookNumber] [EndingNumber] and the table name is TblSales. How do I code for a form that will show me all [SerialNumber] where there was [EndingNumber] on the perivious date but there is no EndingNumber entered on...

Hello, I have form where beforeupdate I have the following codes for preventing duplicate report date data entry, but i want to add one more code in case someone skips daily report to give them warning pop up message telling them they are skipping report date and if it is OK let them proceed if...

Monthly report subtotal weekly I have report that I want to group monthly and then weekly where the week starts beginning of each month. For example for the month of June I want to subtotal in the following 1st-7th 8th-14th 15th-21 22-28 29-30 And the next month the same way. Is this possible...

I'm sorry but the code I'm having problem is the form name FrmDailySales in the field name Prev Ending Stick. Thanks

Hi I attached here my data where I'm having problem with dlookup sometimes I'm getting the previous day's number and some times I'm getting nothing. Please help

ReportDate is the key and there is report every day

Hello How can I sum the details in the sub form to the main form

Galaximo, It is still doing the same. Some times I'm getting the previous day's record and sometimes nothing .

Galaxioma Thanks you are right it was getting confuse you saved me lot of times and I will remember this in the future. I have been struggling with this few days.

I have table name TbleDailySales and Form name FrmSalesEntry and i have these fields in the table [ReportDate], [EndingStick], [Amount] Reportdate is Key and date and EndingStick in number and amount is currency. In the form I'm using Dlookup to bring the previous EndingStick and here is the...

I have form that I enter daily sales and I have field where I have dlookup to bring the previous day's data and here are the codes. Table name is [TblDailySales] Form name [FrmDailySales] =Dlookup("[Stick]","TblDailySales","[ReportDate]=[ReportDate]-1") The problem is sometimes I'm getting the...

Hello, I tried it but I got error in "Dim rst As DAO.Recordset" the error says "Compile error User defined type not defined" Please help. Thanks

Hello, I have table name TbleProductSales and it has these fields [IDNumber], [SerialNumber], [EndingNumber] and [SaleDate]. What I like to do is prevent duplicate SerialNumber whitin each day's SaleDate for example SerialNumber 123 can have ending number only once a day. IDNumber is the key...