Recent content by Marcel2586

Hello all, Is there a way in vba to automatically correct incomplete data? When we get new parts we scan the bar-code and within a query i chop it up with this in the field CertNumber: Trim(Right([PartCertNr];[space]+2)) Example good scan: 20 MAY 2004H149-082-79 A4147011A05...

Thank you for the quick answer but i get an error when i run it. error on objxl error 424 :confused:

Hi, I need help with this one. I use some code that looks at cells, when not empty draw borders around it. My dato runs to column G and i need also a border around H as well. Column H will be a remark box. This is the code i use. 'border all cells With...

I know that the business process is horrible, there i cannot change one thing. A company with 45000 employees, all working their own way and there you get a lack of structure. This is a project that i was given. The man before me used a excel sheet and just typed all the data by hand. I try to...

Thank you very much, i will test this as soon as possible. Here is a example with certificate number and one without. With: 13-MAR-2007H101150002-604-010 220920 Without: 014-11-2000H14137-00-277-69FS Also my database with error on 014-11-2000H14137-00-277-69FS

No, we can't, this are all Boeing parts that we need to keep track of, even the parts without certificates. and with thousands of parts it is hard to check

Hello, I have a question about errors on null value. I have made a small database for tryout, it has to be implemented in another one. And the small database is working. I have one table where there is one field called BatchInput. I scan a barcode into it and let two query’s breaking it apart...

It has al to do with warehouse. We have retrievers running through long corridors. There are two of them A-B and C-D. A and C are the left side and B and D are the right side. One corridor has 3960 boxes, and they have smaller sub boxes inside. 01A01 trough 44A45 on the left and 01A01 trough...

I try to validate the input in a form combobox. In my table it works okay with a validation rule validation rule: Like "[A][B]" validation text: The input should be two numbers with A or B with two numbers Example: 01A01 or 21B43 But when i go to my form i can still input other letters than A...

Dear Uncle Gizmo, Thank you for your replay, but there is a miscommunication going on. i had to have mentioned that i was building this in Excel. But your information is handy for my second project in Acces.

Hello, How do i combine two results from a form into one cell. What I want to do is this, I have a form populated with a textbox named quantity, where I can fill in a number. And I have a combobox named measurement with EA, Centimeter, Meter, Foot, Gram. I like to combine the two results into...

Hello all and first of all, Sorry for the question. I have been looking for days on the net for my listbox problem. It is there and found a few, even on this forum. but when i try the solutions mentioned i am in a total loss and do not know what to change to make it work for me. I have a form...

Merci, danke, thank you.

So i can remove the declaration Set rs = db.OpenRecordset("tbl WVL customer only")?

Hello, I have a problem with my code. It works, but it starts with row number 15, field number 2 then it go's to row 16, field number 1. then row 16, field 2 Why wont it start at row one, field one then print that record. row 1 field 2 and print that record....... :confused: Option Compare...