Search results

Perfect Answer Hi Fizzio, Really it's a pefect answer and it's a new thing to learn in Access. Everyday, I respect Access more and more and of course our programmers... Very thankful to you Fizzio:D :D :D

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 Ally, thank you for your help. Hi Fizzio, Actually, my UnBound Control is picking a data by DLookUp ... from a query. When I put the code: Dim varBookmark As Variant varBookmark = Me.bookmark Me.Requery Me.bookmark = varBookmark it gives me: tou entered an expression that has an invalid...

Sorry, Me.Refresh is not available now... I got this message:confused:

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...

Thank you sir, I'll try

Hi Pat Hartman, Wel, all the drivers are installed in the proper way. :mad: :mad: :confused: :eek: :( :mad: :rolleyes:

Sorry... this is the printer we are using in the company. It's Epson LX300+:mad:

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...

Well, the report margin is set up well. But the printer moves few lines extra in every new voucher. I can't find my proper Page Size in custom sizes... I'm sure that there should be a solution for this problem

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...

Rich... Your code is very Rich... I struggled a lot to do so, but failed. Very very thankful :)

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 Rich.. Creating 2 queries solved the problem. Thanks a lot.

Hi Rich, Ok, my strSQL is of 2 steps: 1. Append Query to append certain records to history table. 2. Delete Query which do the same. The problem is it appends and deletes a single record and not all the records in my main table.. So, the user has to open the main table record by record and...

100% right. and that what I did. But the point is I open my form filtered by expression to a specific record and thereby I want to follow the criteria of Date Difference, but this works only for a single record and not for others. It's impossible to open all records after 30 days so as to do...

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 llkhoutx,Pat... I think that you are right, it is better to keep all the data in a single table. Thanks a lot.

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

Thanks a lot.