Search results

That did not work either. However, I have noticed that the corruption appears after I run the form; as long as I do not run the form, I can keep doing changes. Moreover, it appears that it is the database the one getting corrupted. I imported the form from my backup and some comboboxes were not...

It did not work. Made a change, clicked Save, and immediately got the message "Microsoft Access has stopped working. Windows is checking for a solution to the problem...". So, I deleted a control and tried to save, but got the same message. This is frustrating.

Thanks! I will try that the next time I have this issue.

Hi, I am having issues with one of my forms. Occasionally, it gets corrupted after changing something. For example, I just changed the background color of one label and I could not save the changes. From there, I sometimes need to restore a copy of the DB I am working in. Other times, I just...

Check this link, http://support.microsoft.com/kb/88160

Try the KeyPress event. There, you can check the ASCII code of the character being typed.

Does it happen with other applications? If that is the case, you have your printer set with a 'Separator Page'

Yes, Access can print to thermal printers. However, it does not support receipt-length paper so you have to figure out the paper size that fits your needs. I selected a receipt-width with letter length paper

The code goes under the Detail_Format event. Forgot to mention that.

:confused: The code provided before accounts for that (me.detail.Height)

I am not sure how your program works, but I guess you would need to include the code in the <your dropdown>_AfterUpdate event, so when the user updates the value in the dropdown, the other values (non-bound columns) will get updated at the same time. By the way, this is not VB script, it is VBA...

here it is: If IsNull(Me.Image) Or Trim(Me.Image) = "" Then Me.Image.Visible = False Me.Image.Height = 0.01 * 1440 Me.Detail.Height = 0.75 * 1440 Else Me.Image.Visible = True Me.Image.Height = 2 * 1440 Me.Detail.Height = 2.75 * 1440 End If Note: * 1440 to convert to twips

<your field> = me.<your dropdown>.column(2) would be the value on the third column of the dropdown

In design mode, check the page setup. You should use the "Default Printer" so anyone can use that report.

Select * from <table1> where <table1>.<code> not in (select <table2>.<code> from <table2>)

Ok. I found out what was the problem. I had a variable, kind of a sequence number, that I used in the function that gets the data. When printing, Access 'runs' the report again, it does not use the preview. Since the value of the variable was already the max value, the data was not being pulled...

I have a report for which the user can select different options. For some of these options the report prints fine, but for others the report is a page with just the page header. In both cases the preview shows the correct data. I had some logic under the GroupHeader0_OnPrint. I moved it to...

Are ypu talking about a form or a report? because in your 1st paragraph you say "form". If it is a report you need to use the Sorting and Grouping option for the report and group by shift.

Great reference! Thanks so much Nigel. Jorge

Does anyone knows where can I find a complete API reference in VBA (either link or book)? Most of the references I have found are for C++, and there are only a few in VBA. Thanks.