Search results

You can put this code on Close form Event on form DoCmd.Open acForm, ("Main form") and close form on "x" or create "Back button" on each form to close this form and open main form

Is your form is based on query? If so try adding data on query to look whats wrong. If you can post database. I can check whats wrong

On Got focus Event of Delivery_Date put: If Delivery_Date.Value = Null Then Exit Sub If Delivery_Date.Value < Order_Date.Value Then MsgBox ("Wrong Date") 'Here you can put warning like I do or whatever you want End If

Go to Design, right click select Properties, on Format tab, scroll down to do Moveable and select NO. Hope this help

On form "Software Name" put subform (continous view) based on query. In query create criteria to "look" at txtSoftware textbox on form. Create After update event of txtSoftware to requery the subform. Hope this help.

Did you populate with data all required fields?

search this forum for cascading comboboxes

Checkout this link: http://www.mvps.org/access/forms/frm0024.htm

I forgot, for query formula is: 1Day: DateSerial(DatePart("yyyy";Now());1;1) :D

I put this formula to calculate "1st day of year": 1stDay=DateSerial(DatePart("yyyy", Now()), 1, 1) For calculating workdays between two days I have functions but I dont now if realy works: Public Function DiffWeekdays(datDay1 As Date, datDay2 As Date) As Long ' Comments : Returns the number...

I think DateDiffW is functions that cannot run from expression. You must crete function in VBA and call that function from code. Try with this link: http://support.microsoft.com/default.aspx?scid=kb;EN-US;207795

Somthing wrong with your Query (maybe too much filters) or relationships between tables. send me database if you want to.

did you get data in your "QRY_ALL" query? I mean did you see data in query?

try with this link http://www.candace-tripp.com/download/password2k.zip

first create a form for password input (modal to keep focus), and on button click first open this form and then desired form

Maybe your form is based on summarized or crosstab query?

Try with this combo box. when you select some Name from combo box form moves to that record

I think thats not possible in datasheet view. You must have a continous form and lots of coding.

I think no problem for Access I think thats no such problem. Try familiarize yourself with DateDiff and DateAdd formulas (this is for calculating dates, with this you can calculate witch reminder must go to history). Color coding in continous form is possible with textboxes for each color with...

Try this If I understand. You want to move OLE on record what you select on listbox. 1. Change form to bound, for this, you must have Control source is table with OLE, 2. Listbox: ControlSource is empty, RowSource is table with OLE 3. on Afterupdate event of listbox put this code...