Search results

I've got one of these with a 'header row' (stupid PeopleSoft). A2:M30000 works well in Access 2010/2013, and only pulls in the rows with actual data (12-14k) rather than having 18k blank records at the end.

Awesome, glad it worked out for you. It was a fun trick to learn for myself, too... (as Mihail said, it looks badly normalized at first, but there is a use for this sort of behavior in just such a situation as this)

Is this actually a 'number' that you will be doing math on? Maybe you should convert it to a string, then it can be as long as you like.

Sure, but I need you to be a little clearer about what " I can view the record in datasheet view, but I need to be able to edit the records selected by the query using another form" means. Right now I am assuming that you have some FormDatasheet that actually shows your data for editing, and...

I never use Macros, so I'm going to be of limited help here. Can you post a screenshot of your Macro as it stands now? Particularly the part where it builds the Body, if it's a long macro...

Can you give an example or two? Draw it in MS Paint and attach it if you like, or just walk us through with some 'real world' examples. Don't worry about using MS Access language, we can translate that pretty well. What we can't translate is things like 'it doesn't work'. :p i.e. "I need my...

Oh, I forgot to mention... if you're using a split database (shared BE on the server, desktop FEs for each user) with linked tables, tableSplit should NOT be moved to the backend. You want it to be local, so that when a user starts a split process, they don't collide with someone else's process.

I'm guessing the ItemID field is behind a combobox, that shows ItemName from a later column? You can reference the unbound columns with syntax like Me.comboItems.Column(X), remembering that X starts at 0, not 1. Test in the VBA Immediate window to make sure you've got the right column number...

You can .Filter the form by the same criteria as your query uses, without changing the RecordSource. That will be much safer/more foolproof.

1) The commas leading up to acDialog tell Access to ignore/take the default value of those parameters. If you put your cursor amongst them and move left/right I think you'll see what the default values are - things like acNormal, etc. 2) Option Explicit is good coding practice - it'll check...

What is the normal recordsource of the form? You can switch it on the fly, though it's not without risks. http://msdn.microsoft.com/en-us/library/office/ff821093.aspx

goddangit plog

I don't fully understand your question. How does Trimester: Int(Month([DateField])/4) not do what you need?

I have no idea WHY you're doing what you're doing, but you want the Left() Mid() and Right() functions... probably just the first two, in this case.

I don't understand your question. Maintenance should be tied to the item, not the cabinet, right?

I've never seen that before, but it's very elegant. :cool: Added two references to it to Code Repository, in the hopes of remembering it for the future.

http://www.pcreview.co.uk/forums/different-margins-odd-even-pages-t3031371.html has some theories about right/left margins, you might be able to leverage that into changing P1 only. I have NOT tested it.

Sorry, took me a bit longer than I expected to get the bugs worked out. See the attached and read over the code carefully... any part you don't understand, ASK because you'll have to adapt this somewhat to your database (form names, field and control names, etc). I tried to use queries more than...

Did you see the one about the diners who might be outside your system? Right now I am proceeding as if that cannot happen...

One more question - are you working in .mdb or .accdb format?