Search results

Thank you, but this only limits the total number of characters. It counts the line feeds, but does not limit them. I need both the characters and the LF's to be limited because the report that is derived from the data the user inputs in the form must be only one page. It's a political thing...

I have a data entry form with a memo control physically sized to match the allowable space for this information when printed on a report. Basically, I need to be able to stop the user from further input when the cursor reaches the lower right corner of the memo control. Beeping when reaching...

I checked for typos and found none. The form that I put the command button on calls a parameter query when the user is "finding" an "Item Code". The report that I am calling with the command button uses the same parameter query. The report is on a reports switchboard. Do I need another...

Yes, the Item Code is text. As before, I do get the report for the Item Code requested, but the code is still prompting me to re-input the Item Code when clicking the command button, which is not what I want the users to have to do. Is there any way around that? Thanks for the tip on not...

I've replaced my bad code with yours and I get a "Type Mismatch" error. Trying to follow the popup syntax example: By adding 1 comma, I'm prompted for the "Item Code" again. By adding 2 commas, I get a "Compile Error: Wrong number of arguments or wrong property assignment. By removing 1...

Pat, Thank you for the reply. I'm closer, but not there yet. The following is the code associated with a "Print Preview" button on the form. The data is populated on the form from a parameter query. To this form I added the "Print Preview" button created using the command button wizard...

I've created a multiuser DB with a tabbed form interface. There are separate forms to (1) find a record, (2) create a new record, (3) edit an existing record, (4) duplicate then change a record. I need to print a report based upon the current record in any of these form. I've read many other...

Should the Security Wizard be run to create the user rights before or after splitting the database? If it's run before splitting, does that mean that the .mdw will control both the front end and back end, versus running it after splitting it will only control the front end? I'm planning on...

It was so simple, I'm embarrassed for not thinking of that. Thank you.

I am very new to Access and am designing a multiuser database with tabbed forms. One of the tabbed forms has 7 tabs; the first tab contains the part number and other information about a product and the remaining 6 contain additional information about that product. Is there a way to have the...