Search results

Have you single-stepped the code to find the line it errors on?

Indeed! Simplest solutions are always best. Thanks for your help guys & gals

Okay. I rarely use loops, but I've used Do-Loop. How do I get it to move to the next digit in the string? Will it error when it passes the last digit? Can i turn your code into a While statement after Do?

I have a text field that has a value in it something like this; PACTS11233 or FED11233. I need to display the letters in one textbox, and the numbers in another textbox, both in a form and report. It is always 3-6 letters and 5 numbers. I can use Right() function for the numbers. But since...

Oops:o I found that in Access Options, for the Current Database, I had unchecked Allow Full Menu's. When I checked that Export reappeared on the shortcut menu

In my case it's a one page report with no sub-reports. I just want to export to a pdf

I have some reports that have 'Export" on the shortcut (rt-clk) menu. On other reports the option isn't on the shortcut menu. This is with all the reports in print-preview. What might cause this?

Thanks guys! Doing that once a month will be a regular task from now on:)

I got an error message that approximately said that one of my backend data files was in an "Inconsistent state..." and was going to repair it. After it did the repair the file had shrunk in size by 75% (as reported by windows explorer). Needless to say this really concerned me. I had made...

Also, I went back to your link for the Bob Larson code tag post and if I had scrolled down a little bit, Uncle Gizmo had posted a good link for it. I see how to use them Alan

I noticed that after I hit Submit. When I pasted the code into this editor it was properly indented and spaced. As far as the report goes I think leaving it in acViewPreview will work just fine. Thanks for your help

Hi, 1st, I followed your link to a Bob Larson post and I do not find anything. There's no text, no link to anything explaining the code tags. The post is marked as Closed. 2nd, there is another sub that opens the report with; Docmd.OpenReport MyReportName, acViewPreview, ...

Here is the code below. This report is configured a number of different ways depending on values in a table field, and responses from the user right before printing. It also is a rarely used report. It works fine as-is as long as it's opened in Preview and I'm thinking of just leaving it that...

I have a report that runs code in Report_load, and based on the value of a field it sets some objects Visible=False and others Visible=True etc.. Now I'm trying to move away from acViewPreview and print direct to the printer with acViewNormal but the Report_Load event doesn't run. Is there a...

I agree uncle. Zak 14, are wanting these tabs/buttons to open this second form on top of your original? as a dialog? non-modal so that you can still see or access your original?

well I asked for simple. I thought it would be far more complicated for some reason:)

I like the second way too. I've created a new textbox in my form and in the On-enter event I have it writing the Date, Username, and a vbcrlf into it, and then using SelSart to position the cursor. After the user enters their text I'll probably use a button to append. What is the simplest &...

I did it by creating a generic form called subform1 in the detail area of the main form. Then on the command button that you're using as a tab, enter code for the On-click event to something like this; Private Sub Tabbutton_Click() Me.Subform1.SourceObject = "frmNextform" End Sub where...

Not sure if this makes sense, (I'd rather not create a comments table) A user enters text into a memo field for an existing client, then it's closed, the same record reopened and more entered into the memo. The problem is when it's reopened the existing text is hi-lighted, and it's really easy...

Duh! I just knew it was something obvious & simple. Thank you