Recent content by Susilowati

If you have Adobe Acrobat installed on your machine, you can output a report to a PDF file for viewing and easier electronic distribution to users. Follow these steps to get the various pieces together. Buy and install Acrobat on the machine(s) where the reports will be created. In...

Hi, What you can do is, use the Refresh method to update the records in the underlying table/query for the form whenever the form receives the focus: Private Sub Form_Activate() Me.Refresh End Sub otherwise try to do refresh everytime you move to next record or any other event as...

Hi there This sounds really strange. Have you checked your relationships between the customer and order table? Unfortunately I have not got enough information from your explanation. I believe this is just a simple bug that everyone always encounters every now and then. If you wish me to have a...

In order to do this, you have to create a filter form which should execute on your query. The filter form should be unbounded. Now, in the query, instead of putting like (a* or s* or whatever) in your criteria, put "Like [Forms]![FrmCriteria]![CustomerControl]". Try that for only one control at...

Hi There, First, check if you got the variable name correctly. You said you called the status as "Customer Definition". If so, then in your code you gotta have If Me.Customer_Definition = "Silver" Then cmd3_Letter_Definition.Enabled = False Else cmd3_Letter_Definition.Enabled = True End If...

hi thanks for the reply. I have just figured out the problem though. I deleted one of the relationships [actually a shadow relationship] that caused a circle!! And guess what, it works!! Jeez can't tell you how excited I am!! Still, thank you thank you for the suggestion cheers Susi

hi all, I got a problem with my form this time.. this is extremely bizzarre!! I am setting up a project log database. Every project has a few implementation process. Every implementation process has a few issues [one to many relationship], and some processes have a few subprocesses [another...

Most probably that you also have rectangles or lines in your form?? if so, click on the rectangles and lines, and right click on each of them, and select Format, Send to Back. Good luck

Yes, you can by using the OnNotInList event. I found this code for another website as well. This code adds the new entry to the underlying table and refreshes the available list in the combo box. Private Sub cbxAEName_NotInList(NewData As String, Response As Integer) Dim db As Database, rs As...

hi Anauz, Can i have the file too? I really need it for this project that i'm having. Thanks so much cheers