Search results

Microsoft, SMB protocol (via Google)

thru

I created the button on my mainform, had the Continuous form showing in the subform and clicked my button. It works in my app.

Me![FPresupuestos].Form!TxtQuantityAProrratear.BackColor = vbRed From a button on the mainform, to a continuous form

try: Forms![FPresupuestos]![FPresupuestosSubformulario].Form.TxtQuantityAProrratear.BackColor

If you open from the network, it could be latency.

Did you try to put together some code? it can be 3 lines of code in the proper way. the not proper way is one line of code. People try to help and create a solution when others get stuck. The best way to learn is try, make mistakes and retry.

try using an If-loop and try to find your msgbox code hereMicrosoft

Ctrl + P

First; your table will mean trouble on the way! you must split. to get you on your way: you can create a combobox with a rowsource that is derived from you data.

and another satisfied customer (y) Sometimes it is just the solution that counts! (even when it is not to standard)

It could be a good use when you have to handover an application to a client. I did some work for a client, where the contractor left the plant, and the databases would stay alive. In my world contracors tend to hire people for jobs like building a database. It is a big thing going through code...

Agree, I gave a solution for this question, keeping in mind it could be to prepare a new table from old info. This is 'a no go' in a live application.

this decision is under scrutiny

UPDATE tbl_ItemWardrobes INNER JOIN tbl_PartItem ON tbl_ItemWardrobes.Doors = tbl_PartItem.PartItemName SET tbl_ItemWardrobes.PIID_DOORS = [tbl_PartItem]![PartItemID] WHERE (((tbl_ItemWardrobes.Doors) Is Not Null));

yes sorry for that.... I am "looking further then my nose now..."

Ok, point taken. From this day on I will use the modulename in my coding!

I use an event class for textbox.backcolor and a final check for missing/wrong info in required fields (like @The_Doc_Man ) Must notice that I allways use a button to add a new, single, record to a table.

@Pat Hartman is fiercely ;) teaching us to use 'Me.' when adressing a control. I started doing that, most of the time. My question now: is it also common use to refer a module when calling a procedure or function from somewhere else? I sometimes use it, mostly not.

maybe you can use this remark in a SQL query as Rowsource for the combo? Active = 1, notActive = 0 SELECT Services.Service, Services.Price, Services.ServiceID, Services.Active FROM Services ORDER BY Services.Active DESC, Services.ServiceID