Search results

The_Doc_Man - I've always thought that the precedence rules were defined by mathematicians and compilers simply followed those same set of rules. You're right that there's an assumption being made about how one is to evaluate the expression, but I'll be darned if I can find a example of...

dan-cat, It'd be more convincing if we could stick closer to the original statement without adding a multiply operator. Out of curiosity, I tried this in VBA: ?48/2(9+3) 24 12 So, VBA doesn't handle implicit operators but it does at least hint that it didn't try to lump the (9+3) with the...

Though the statement appears ambiguous because it can be read as: 48 / (2 * (9+3)) or (48 / 2) * (9 + 3) There are specific rules on how one is to read a mathematical statement and proceed. Generally, do the inside first, then do multiply/division and add/subtract last. For that reasons, I...

Just to provide a perspective - because I run all of my development in virtual machines, i've observed that regardless of what OS / Access version I'm running if I'm not careful to quit Access before I suspend the virtual machine (to change for another virtual machine). Whenever I return back to...

Glad it helped!

I don't think that's good idea, either. I'm sure your hosting plan most likely has a bandwidth cap so if you exceeded X bytes in a given month, you may be then blocked or charged extra. Querying that frequently just to keep the connection alive will make that happen and you don't want it to...

Gina: FYI - in case if you don't want to rely on a mapped network drive, you should be able to use HTTP URL as the path directly to put your file in there. As for checking in/out, I would venture to guess you'd need to: 1) invoke a SharePoint web service CheckInFile CheckOutFile 2) Using...

Also, I'd consider using DSN-less connection instead of trying to create a DSN. Doug Steele's article on DSN-less connection Improving security of ODBC connections One more thing - why an ODBC connection to Access files? If you're doing it within Access, you will find that Access blocks you...

One potential consequence I can think of but am not sure if it'll apply to .Clone is that while the following is legal: Set Form1.Recordset = rs Set Form2.Recordset = rs If rs is edited via either one of form or by other method, then both form may need to be refreshed so they get the latest...

I should point out that this won't stop users from seeing the hidden objects if they know how to show the hidden objects via the Option dialog. Thus, this wouldn't be actually securing your objects. If you just want to ensure your users do not open or mess with wrong objects, converting your...

This would be a good start. Both have additional links as well. Beginning SQL Server Development Beginning Guide to ODBC

BTW, you may find it interesting...

The idea is that by splitting a new process for each tab, you won't see the browser as whole affected by one misbehaving page. Surely you've experienced the case where when you landed on one bad page, the whole browsers, regardless of which tab you are using is running slowly or even crash...

Well... there was indeed a project that did incorporate this but personally, I think it's far too much trouble to justify the investment. Also, I'm not sure it'll work for the continuous form because it's required to set focus to the new record somehow to update the highlighting.

Yes. Just use an unbound textbox and place it behind all other controls, as wide as the form is and make all other controls' BackStyle transparent.

Well... In past, where I needed more control, I just used continuous subform & conditional formatting and that worked well enough. If you format it right, you can even get it to look & feel like a datasheet or a listbox and nobody would be the wiser.

toplisek - I'm not aware whether Excel provides a built-in function for creating GUIDs/UUIDs. However, I've already linked to an API call you can use to create one and thus insert into cell. See post #2 above.

That's totally unexpected and I'm so sorry for his family and friends. I have enjoyed his postings. Here's one to David Crake.

Wouldn't it be better if the format is consistent, just to import into an empty table with column predefined? Whenever I can do that, I do it at all times instead of depending on Access to guess the data types same all times. I guess you also can get similar effect by using a Import/Export...

Yes. You'd execute it at the startup by either using a unbound form designated as the Startup Form OR called via AutoExec macro. Maybe if you download the sample I made for another poster will help? Link to the sample. Oh, BTW, you may notice I use DSN-less connection string, too. You could...