Search results

Thanks for the tip about putting global variables in standard modules. I'll keep that in mind. Yes, I was aware that subforms load first. But since they worked fine before the upgrade I figured there must have been some other small change to the order in which a form loads up. Problem solved...

I see. My option group didn't even have any options - I was just using it for the frame (I liked the nice rounded edges on the box better than the Rectangle object.) Perhaps I'm asking for trouble. So, thanks for the help! With the other issue, there's hardly any code to post: In the...

I'm using SP2 MSO (12.0.6529.5000) - I think it's the latest. ------------------ I think I figured out what is going on: It's not about 2003 or 2007. It's about whether the check box was created inside an Option Group. I can get this to happen every time by doing the following: 1) Create...

Same thing: BeforeUpdate, AfterUpdate, OnDblClick, OnEnter, OnExit are missing.

Here's the screenshot - it made me scale it way down... New check box property window shown on left - missing lots of fields.

I am finishing up a Access 2003 database in 2007 - retaining the .MDB format. I've noticed a few odd things, but have been unable to find any documentation addressing them. I'd like to know if anybody else has noticed the same things, or if I'm just weird or my computer is evil. 1) It seems...

I believe this is possible at the table level. http://allenbrowne.com/ValidationRule.html Evan

I'm about to start a new project and would like to get your thoughts on a few different issues: 1) Macros vs. VBA My last project didn't use a single macro (except AutoExec and AutoKeys). With error handling for macros in 2007, is there a case for using them to handle repetitive tasks? For...

I would like to have more options than the 60 or so generic images that come up when you click the ... in the picture field of a command button. But, I can't figure out how to save a BMP in a way that Access will load transparently. Has anybody made their own transparent BMP and put it in a...

Add a control for the date next to your import button. User types in the date, then presses import. Your append query can grab the date from the control and put in record at time of insert. Evan

I'm not positive, but after unreliable results using the SetFocus command in Enter/Exit or Got/Lost Focus events I think that the code runs before Access actually moves the focus. So, if you change the focus in the event, when you are done Access picks up where it left off and moves the focus...

MyString = Date() or Mystring = FormatDate(..... read the help file for all kinds of available formats, Date()) This will get you the date in any format you choose. I'm not sure about the string not being long enough - I've never ran out of room with a string. If this is the case, perhaps...

If you list all three fields in your index, but remove the index name from the second and third field, they will become part of a multi-field index. Evan

Open your table in design view and choose View:Indexes from the menu. Add all three fields but only give the 1st field and index name. This creates an index based on all 3 fields. Then you can set the properties for the index to - Allow duplicates: No The Access Help is also very helpful if...

Here's an idea: 2 Combo Boxes - 1 hidden, 1 visible. When you enter the visible one, it unhides the 2nd one and switches focus transparently. Evan

You could also setup a multi-field index in your table and disallow duplicates. Evan

I think you need Access 2007 - this is a new feature called Split View. You can also acheive this manually in 2003 but it will take a bit of work. Good luck, Evan

Here are two different ways you could do this: Dim strQueryName as String, qryDef as QueryDef strQueryName = "MyQueryName" Set qryDef as CurrentDb.QueryDefs(strQueryName) Or Dim qryDef as QueryDef For Each qryDef in CurrentDb.QueryDefs Docmd.TransferQuery qryDef .... or however...

First, I suspect that your data is not normalized properly as you are storing the Serial Number in two tables. Your Sales table should not contain any of the info from your Phone table EXCEPT for the PhoneID (or unique ID of Phone record). Second, you may want to read Allen Browne's article...

I don't really understand your question, but it is common to use an asterisk in queries as a wildcard. Here are two common uses: 1. "Select tblItem.*" will add all fields from tblItem to the query. 2. "Where tblItem.ItemName Like "*" & .... " - the asterisk is used as a wildcard in the...