Search results

Each product has it is own number so I have to use that number not auto number. The first field is the first thing in the form and I want if they tried to enter duplicate to get message and to leave the record or enter the next product. I am not good with access so i hope this makes sence

I have table that I put in product information and it has these fields [ProdNumber] [ProdName] [FaceValue] and the table name is [TblProductInfo]. The ProdNumber is the key and i set up form to enter new products that comes in. How can I code it when someone tries to enter duplicate that...

Do you have any other suggestion basicaly this is form I will enter each day's phone card sales and it has thses fields (SerialNo, GameNo, EndingNo, SalesDate). There are about 50 diffrent typens for every day's sales. What I like to see is all cards yesterday's sales whit all the fields and i...

But I want to see the main form as continuous form and the subform as datasheet.

I have main form and subform is it possible to have them side by side instead of at the bottom of each other. there is about 50 lines for the form and I want to be able to see all of them on the screen. I'm new to access so I'm not even sure if this makes sense. Thanks

I have been working on it for while whit this database and I can't get it right this database is for Phone cards sales . I set up three tables one fro Phon card information and one for inventory and one for daily sales. Each phone card brand comes in 50, 100 or 200 in each book and the book has...

I have report base on subquery and I'm trying to subtotal in the report but I'm getting error, (Multi-level GROUP BY clause is not allowed in a subquery. (Error 3612) An SQL subquery cannot list more than one field in a GROUP BY clause.) please help.

I have Table with these fields (ProdNumber, ReportDate, EndingNumber, SerialNumber) ProductNumber is the key. Then I set up query like this [ProdNumber] [ReportDate] [EndingNumber] [SerialNumber] 123 06/01/09 50 999 123 06/02/09...

Pblady, I tried in Wor and it moves down to next line but when I tried in Access form it scans the data and the cursor stays in the control until I hit enter.

Hi I have form and barcode reader where I want to enter the data by barcode reader. I tested in Excel first and it works fine when I hit the barcode reader it goues to the next cell, but when I use the Access form it read the data and the cursor stays in the field. How do programm to go to the...

Pblady, This code in the form or in query. How do I post the formula? Thanks

I have form that we will enter data (Numbers) by barcode reader and we have to different kinds barcodes. What I would like to do is formula that says if the first three digits is less than or equal 899 delete the last five digits else delete the last seven digits. Is this possible. here are two...

Missinglinq, Thanks for your reply but I'm not sure how to place the label can you explain to me please. Thanks

Missinglinq, If you use the code you posted where do i post the message? Thanks

Is it possible to to have comment pop up when mouse is placed at top of field on form same way as comments on excel. Thanks

thank you you're always helpfull

Is this possible and how is it done. I set up tble where I keep track phonecards inventory. Each card has serial number. Is it possible to buy handheld barcode reader and scann each card and the data to go directly to the form or table. I also posted this under Form becouse I wasn't sure if it...

Is this possible and how is it done. I set up tble where I keep track phonecards inventory. Each card has serial number. Is it possible to buy handheld barcode reader and scann each card and the data to go directly to the form or table. Thanks

Thank you guys it worked and also I was able to understant how it works I'm learning a lot from this forum and I realy appriciate your help and sharing the knowlegde

Hi here is what I posted. And the control name is Report_date and control source is ReportDate. Still when I enter duplicate date to try I'm getting blank it is nor bringing back the original report but atleast is not excepting the duplicate so to put it is working half way. Can you tell me...