Search results

Yes ? I didnot understand... witch setting in the trust center?

Hi, and thanks for your replies, Yup, I've tried to expotr all objects to new file, the relevant forms will not pass, when tring to I the same error. the data seems to be in tact, witch is a great relefe! I would like to recover VBA code. is it posible?...

Hi all you experts! I have some work Iv'e done on an Acc2003 format file (*.mdb), working in Acc 2010 environment, on a Win7 OS. the project is Testing some data, if suitable for other project, so I havn't split to FE and BE. a table of some 150000 Records contains a few text fields, witch...

Great! should have bin: =Nz([PerUnit],0)*[Quantity]

http://answers.microsoft.com/en-us/office/forum/office_2007-access/what-are-the-integer-values-for-acformatxls/ed02364d-69fa-4d29-a59a-8b6a15652025

Hi, Try putting it in a SUM function: =SUM(IIF(...))/ Otherwise: try a text box on each record in the details section, value =Nz([PerUnit],0*[Quantity]), have it's Visible=False and have the control in the footer sum it: =SUM(txt). ATB

A form is not assigned to a button, a button has an OnClick event handler, there you can insert code to do something, such as open a specific form. you can, if you wish, have other code call this Command226 event handler. It should look like : Private Sub Command226_OnClick () ... End Sub

IsOpen - Seems this is expected to be an Object. If it is, it is not set with a value. What it it?

I thin the format is "PDF Format (*.pdf)" not "PDFFormat(*.pdf)" (note tha spaces). If your file extension is *.accdb, just use acFormatPDF constant. All the best!

Hi, I had this problem with 4 sub-forms, they are similar, and seem like the 3 were originally copied from one of them. This one form could have bin corrupted. I have recreated them, if display gets disordered again, I will re-post the question. Thank you all!

Hi, and thanks all for your replies! I was Offline for the weekend... I've started recreating the forms. smig - it is a mdb file, running in Acc 2007 under Win Server 2008 R2 Standart SP1, and in Acc2010 under a newer Win Server (has the looks of Win 8). Simon_MT - the disorders happen after...

Yup, it happens on all client BEs too.

Hi JHB, thanks for your Reply! Tried that before. it seems corrupted to you too?... Should I go on and recreate this form?

Hi All you experts! I have a subform in Continuous Forms display, in a tab contorol of the main form. When I put focus on Controls of this sub form, the sub form's display gose bad, I attached an screen shot. Could anyone help me understand what could couse this?:confused: how can I get over...

Hi, You can export a query too: http://msdn.microsoft.com/en-us/library/office/ff192065(v=office.15).aspx

Hi, First, I'm not sure user B's form will requery, unless it is requested to. Second, And I'm not soure this is best practice, but it should work: Forms have TimerInterval Property, and OnTimer event. By default TimerInterval is 0, therefor OnTimer never occurs. However, if you want you can...

Glad I could help:)

Hi Isolec, The date data type has a specific value for each date and time, no matter what format you display it in: it is a numeric floating point number, the value left of the point represents the number of days after Jan 1 100, and the value to it's right is the number of 3 Second intervals...

Hi, You can use string manipulation functions in a query field. something like: right(str,2) & "/" & mid(str,5,2) & "/" & left(str,4) in a query field. (str is your date String

Hi, Just a guess: when do the Fields get populated by code? maybe the sum function works on non-populated textBoxes? In that case, could you somehow make code run earlier? if code runs in a form event, maybe have it run as a query field, and bound textBox to it? Just a guess...