Recent content by nofar

Thnak you for your help but I made the form when I enter the new MFG data entry = YES et it solved the problem thx:)

Hi all, I have a form that has a subform called "Work order" in this form I have a combo box that looks in the table called "MFG", so for every MFG that I choose from the combobox I can enter many information in the subform. The problem now that if I have a new MFG that does not exists in...

Thank you so much for your help, it works!

Thank you so much for your help, I have one last question: In the form "number" I want all the serial number that I add using the command button, in which I added the code, to have the same PO REC and SKU but this is not working Let's say when I open 2 blank fields and I enter two Serial...

I copied your code in the on click event of te button in the form "Year and WW1" but I keeps giving me an error on the .update line. I attached the Database If you want to see it . Thank you, I appreciate it

I also need the form to be a data entry form so the old records will not appear. In this form I just have one field which is a primary key (it s a serial number). Thank you for your help

where can I out this code in a new module or in the on load event of the form?

Hi, I don't know if this is possible but iam trying to build a form in which I enter a number for example 10 (in a text box) and then it gives me 10 blank rows so that I can write a new record in each row. Is it possible? or I just forget completly about this idea Thank you so much for...

Maybe I didn't explain well but in my form: for the serial number I need to enter 2 fileds for exemple 100 and 200, and the rest of the information and I want that form to save in my table a 100 records with the same information except for the serial number that change , Ex: 100, 101 102...

Hi, I have a form that the users have to fill but the problem is that sometimes they have to fill the same information for many serial numbers for example: the computers with the serial number 100 to 200 have the same product model, inspection date, etc. Is there an easy way to do the data...

Re: How do you convert week # back to date? Where do you put this function and how do you link it to your database to see the results? thank you

here is my data base

I tried this function but it keeps giving me an error message I think because the fields are not dates fields. I attached my Database so you can see what I am talking about. In fact, In my query "Year and WW" i want to calculate the number of working weeks between the fields : Today WW and...

Hi, I am working on a new project now and I need some help. Here is the situation: When we enter the serial number of a battery, we have to check if it will be rejected or not. For example if the serial number was SP044000056: the third digit is for the year this means that the batteries was...