Search results

Hi All... I'm using the code DoCmd.OutputTo acOutputReport, "Myreport", "Rich Text Format(*.rtf)", "C:\Documents\MyWordDocumentName.doc" to save my report as word document. The problem is that I open a form to filter a specific report according to IdNo and I want to save that report only and...

Hi All... This is my code: Private Sub Form_Open(Cancel As Integer) With CodeContextObject If (.RecordsetClone.RecordCount = 0) Then DoCmd.close Beep MsgBox "You have No Records for the mentioned Period", vbOKOnly + vbInformation, "No Records" End If End With End Sub...

Hi All, I have a module which converts No into figures. If the field containing the No is not a true field but containing a function to get any value like e.g. Sum([Amount]), it did not give the proper result. But the value I want to convert is a result of calculation of subform...

Hi All... I have a tabular form. I open this form by 3 different buttons Button1 = ReadOnly, Button2 = AddNewData etc... My point is how can I hide CmdDelete when OpenForm as ReadOnly.

Hi All... I have a form filling a data and then it saves before moves to subform ( Both joined by Bill No). The subform is tabular. It should contain data, otherwise when close the main form it should check: If NoData in subform .. MsgBox (No Data in subform) and focus back to first field in...

Hi All... A form is created by SQL Statement picking data from 2 tables From Date to Date is successful. I want to create a button in my Form Footer to sort the data displayed by Date (Ascending-Descending), by Bill No etc... Hope someone can help me.... :mad: :confused: :eek: :(

Hi All... I have a table with BillNo and amount. Another table for Payment Vouchers. Both linked by BillNo. In a query, I have Voucher Table Sum the amount. So if payment is in two different days, customer will have 2 vouchers etc. The query will calculate the difference betwen the Bill Amount...

Hi All... In main form, I have a ListBox picking data from table. I have a field in main form called IdNo. How can I link my ListBox to the Field... Here, I can't find Child-Master where we do link them I mean that I want to display the IdNo connected to the record chosen in the lstbox in a...

Hi All.. I have a combo box getting Bill No (Number Field) from a table, and another UnBound Control to display the name of the person having this Bill. In ControlSource of UnBound: =DLookUp("[tCustomerName]","tblSaleMain","[tBillNo]=" & [txtBillNo] & "") When I select the Bill No, it gives the...

Hi All... I have a main form which contains UnBound Field called ProductId and some controls for the quantity available linked to queries. When ProductId entered, I have a button which opens another form (Dialog) to add New Products for the specific Products. After close the Dialog form, how can...

Hi All... I'm using Dot Matrix Printer (Epson 300DX+) to print a Vouchers. The size of the voucher paper is 230* 90mm. When print, the first voucher appear perfect, while the second one (Tractor) comes little bit down in the papers. I tried to use defined paper Custom size, but still the minimum...

Hi All... I'm using Dot Matrix Printer to print a Vouchers. The size of the paper is 230* 90mm. When print, the first voucher appear perfect, while the second one (Tractor) comes little bit down the papers. I tried to use defined paper Custom size, but still the minimum setting is away from...

Hi All... In a switchboard, I have 2 UnBound Fields: DateFrom and DateTo by which it opens a form in a specific dates required. The form to be opened is not based on a table or query, but through a select statement. So, I can't use DCount Fuction not to open a form if NoData is there. Is there...

Hi All... I created a query to append and to delete data from my main table to the new history table. It's successful.. I have another headache point by which : I have a FieldName: MyDate in my main table Date() which stores date of record entry. If MyDate < System Date which is Now() -30 ...

Hi All... I have a form with a field Date(). It should check the system date and then inserts data into a tblMay2002. If system date is June2002 then it should create a table named : tblJune2002 and insert data in there. Any clue

Hi All... I have a table with many fields for Staff Details. It picks an amount to be paid according to their age.. e.g. For Employee, 300. For wives and children 300 etc.. Id Card fees is 50 if required, tax 2 etc.. These figures are stored in a tblFees. In a query I did a calculation which...

Hi All... I have a combo Box linked to a data in a table called tblCountry. If I select U then the first of my data starting with U like UK will be selected. I want to be able to scroll with the arrow up and down into my list and choose the specific country needed. Is it possible to do so Or I...

Hi All... I'm opening a form linked to Data in the server in a multi user environment. This form Lock set to : No Lock. If one of the Application linked to Data, if this form Lock set to : All Records, it'll not open if the same form is opened by other user. If Form Lock set to : Edited Record...

Hi All... I created my db and put the Data Backend in the server, and my Frontend in user's PC. The problem is that : Some of my forms are Bound, so only one user can enter, modify ... the data. Some advices is to create Bound Form and then Push (Insert) data by CmdButton into my table, to...

Hi All... I have a tabular form showing hundreeds of guest name records ordered alphabetically. I have a unbound field to restrict the search by letters. When open I want to show all the records. When I write in UnBound Field: H , I should get the records started by H**** etc.. and if I write Ha...