Search results

Conditional formatting can be achieved via vba code when you design your report. You need to go to the section of your report where the label is showing and write a sub to make it visible or invisible.

Perhaps you should post your a small db with your forms/subforms. I'll have a better understanding if you do that.

Try searching for cascading combo boxes. There's quite a bit of information on this forum regarding this topic.

Try downloading CutePDF. Here's a link you can use: http://www.download.com/CutePDF-Printer/3000-6675_4-10206470.html

Access 97 has a 1GB capacity. Once you reach this, you can not add or edit records. You also can not compact or repair the database.

You can try linking the tables you need from the first db into the second db. Then create your form in the second db where you now have access to the tables from the first db. Now you can run your macros residing in your second db based on the form you created using the linked tables from the...

In the after update of the text box: If Me.MyText = "t1" then Me.MyText = "LHR - T1" End If This will only fire if the text entered is "t1".

I'm glad to hear.

Create a combobox in your subform. The data source should be the table that contains all your product info. In the after update event, place the following code: Private Sub cboProductCode_AfterUpdate() Me.Description = Me.cboProductCode.Column(1) Me.UnitCost =...

You will always lose some elements of your report if you export it using Access. What you need to do is convert it to PDF format by printing it to a PDF writer such as Adobe Distiller. There are also some shareware PDF writers available for free if you search the internet. Another way (more...

Can't understand why your conditional format code does not work. If you have placed an event code in the detail section of your report, in theory it will work. I've used it before, so I know it works. On the surface, it seems pretty straight forward. Perhaps you should post a small db with your...

Try to post a small db with your report specs. You have a better chance of finding a solution this way.

How about creating a select query with all your required parameters then via a msgbox, using Dcount() and the select query as your domain, pop up the number or records on the screen, then ask a question, whether to proceed with the maketable query? If the answer is "Yes", run the maketable...

You need to capture the values of your dropdowns in the first subform and use those values to build your SQL string to serve as the record source of your second subform. Go to design view of your second subform and bring up the datasource in the query grid. In the criteria of the relevant...

In the "on close" event of the dialogue form, try this code: Docmd.RunCommand accmdSaveRecord See whether that makes a difference.

No sure if I'm missing something here. You mentioned that you can send your report directly to a printer. At work, we convert Access reports to PDF by "printing" them to a PDF writer (defined as a printer). Could you not do the same with Crystal reports?

Now that I fully understand the nature of your problem, I must say that it is one of the toughest I have come across. I spent a good hour on it last night, but to no avail. Basically, what needs to happen is for the field contents of your subform to match the underlying query "on the fly" ie...

If you post your db with some test records, I will see if I can help you further. I need to know how you are changing your query/SLQ ie. what triggers the change or are you always manually changing it?

When you change the query, capture the SQL statement and store it in a string variable. Use this string as the record source of your subform. e.g. Me.subformName.recordsource = your string variable I believe this will work.

In the design view of the report do the following: - File - Page Set up - Margins Set all margins to a smaller number. You'll have to do this trial and error to get the right values. Margin settings is one of the causes of this behavior but there could be other causes.