Search results

old layout = http://web.archive.org/web/20030618011510/http://access-programmers.co.uk/

You're welcome. ;) I try to help out as much as I can to make up for all the questions I have! :p

Wow. More than 65,535 characters.. crazy. You'll probably have to use an OLE-DB.

The best (and possibly only) way to disable the (ctrl+p) autokeys is by a macro, not VBA. You will have to set ctrl+p to a different action which will override it's original Print-related action. Notice: I am copying this from Microsoft Access Help file. (Just in case someone does not have...

Hm, I thought I saw the code earlier today.. but it appears I am either confusing the code for some other code or the code I saw was not workable since I have came across this note. I suppose you have tried to convert the macro to VBA already, eh? Why can't you replicate your self-created...

Oops. My IE has been crashing randomly so I've been writing things in notepad and then copying them in their appropriate message. Wrong one. I do believe I found the VB equivilent though. Please hold. :p

Silly me. Almost always I think of the longer way to do something, eventually coming to a more simple way. In an Update Query's Update To field, put Round([price],2) price being the fieldname of the included table.

Thank you Wayne. As you can tell, I'm just stepping into VBA from other programming experience. Suppose VBA doesn't have the option to tack on ThisIsMyCodeIAlwaysUse.h too? :p (Just copy/paste previously generated code?)

There are a few things that could be causing this, 1) capability of the automation-enabled imaging software that is displaying the OLE Object, 2) file type converters that don't exist in one MS program compared to the other, 3) available memory, 4) corrupt files, etc... What are the OLE...

I have no knowledge of the above items but I was just dropping by to say.. Welcome to the forums yuman! (Hope I didn't raise your hopes with seeing a reply.)

Just a wandering thought, not too terrible or requiring an answer. In C/C++ this logic works: int a, b, c; c = 0; a = b = c + 1; printf("A equals %d B equals %d C equals %d", a, b, c); the output would be "A equals 1 B equals 1 C equals 0" is there any way VBA can be manipulated to do the...

Could you use an expression to search for the decimal point and then count how many characters are after it (X)? Then do your preference of code that only keeps the original price value minus X characters?

Cool. Forgot about the downloadable templates. Too bad none work for anything I'm currently working on. :p Great job with all help you've given Pat. Always fulfilling & concise yet interesting.

You could possibly create a session in Nero.. then reference the session through a script (or perhaps even VBA). However, you'll have to have the other fellows help you with that. The easier route would be to buy a third-party program to do it. Or stick with Ahead products and get Nero...

Since alot of the source is from Pat.. and this post is a few days old now, you may want to Private Message him with your question. Unless by me adding this it gets re-noticed. :) Good luck!

I prefer the old view. Nothing especially wrong with the new view though. I like not having that pop-up. :cool: :D

Also if you insisted on having the result data dump to a table, just finish the wizard, goto the design view of it, right-click any grey area on the query and goto Query Type (or click Queries on the toolbar), and select Make-Table Query. (Or append if you'd rather append to an existing table.)

The Find Unmatched Query Wizard should help you out. Queries -> New -> Find Unmatched Query Wizard. (: Edit: Aw bloody. That's for one table. Going to have to go with VBA it appears. Double Edit: :p I was wrong! The description of the Find Unmatched Query Wizard threw me off. I setup the...

You can set formats in the design of a table, with expressions in a query, or in the properties of an object (ie. the combo box on the form). i normally make all the formats done at the highest level (instead of in the table). i am not sure if one over-rides the other.. i'll have to check on...

He means as an expression, for the Criteria. If you wanted to sort out everything that had the word green in it, you would use <> *green* Or did we misunderstand you?