Recent content by primerov

When i copy a text from the Word Pad ino a word document,sometimes the text doesnt fit properly into the whole page and i have to adjust the lines manually, each line separately. I am sure there must be a way to realign the whole text into the Word Document so as to fit the whole page. Can...

Is it possible to extend the text into an A4 format? I am scanning a newspaper column into Word and the word documents sets the scanned text into the left side of the page and i want to extend the text into a full A4 format.Is it possible to do it ?

I have a query that shows all the clients who have received an offer.It works excellent, it shows even the clients who have turned down the offer and those who have not. SELECT TblClients.ClientID, TblOffers.offerid FROM TblClients INNER JOIN TblOffers ON TblClients.ClientID =...

I need to use the following condition in the OnOpen event of the report If Me![TxtMyCategory] = 6 Or 12 Then ........ But i get the error " you entered an expression that has no value" I can evade the error if i put the expression in the OnFormat event. But in the OnFormat event i cannot...

I am updating and appending 2 idential tables. The functions work fine, but only in case the tables are identical.For example, if the in the first table Table1, i have added on more row which doesnt exist in the other table Table2. then i receive an error. I want somehow toi inform the user that...

I am trying to build a function that refers to the table instead to the form. I think i should use the DLookup function, i do not know any other way. However, i receive the error "Expected : end of statement" Can i refer to a table at all in the function mentioned below and where might the...

I need a help with the DLookup function. The control in my form has a DLook function to look up the value from the table TblOrderDate, the field OrderDate, where ID = 1 ID is the autonumber in the table. The control source has the following line DLookUp("OrderDate", "tblOrderDate", "ID=1")...

Could you help me find out the error ? I get the following error : Run time error 3075 Missing ), ] or Item in query expression ((([orders].[orderdate]])> '#' & Format(Forms!frmCutDates!CutDate, 'm/d/yyy') & '#'" Here is my whole coding Private Const CnstCutDate As String = " WHERE...

Thank you so much for your advice

I have a code that sets all dates before 01.01.2003, expressed with <#1/1/2002 like that: " WHERE (((orders.orderdate)<#1/1/2002#));" Is it possible to enable the user to choose the dates in a form ? For example, build a table called Table1 ,and a field called Fiel1 then a form called Form1...

I have a function that cuts off dates that works well. I want however to imrpove the function allowing the user to add on dates through a table and a form.The new form is called FrmUpdates anf the control CutDate. Instead of using the constant CutDate i want to use the control CutDate like that...

Setting variables In my modules made public, i have several functions where i must set the variables each time for each function. For example : Set chickens = [Forms]![Farm]![Subform].[Form].[Quantity] Set poultry = [Forms]![Farm]![Subform].[Form].[cartons] Set customer = main![Customerid]...

I cannot define the Null situation in my code. I need the condition when the quantity in the field stock is Null.But i cannot do it.I can do it only with <=1 but then it means that the presence of 1 piece is not taken into account. If i write If CLng(DCount("stock", "Products", StrCondition)) =...

Is it possible to delete all the modules in a form ? For example from the click event of one form to delete all the modules in another form.

Why i cannot update from another form? I have an update function called UpdateData that works otherwise,but not from another form. Why is it so? I am trying to update tables from the form F1.There i have the following code : DoCmd.OpenForm " F2" UpdateData I have also applied the OnOpen...