Search results

WhatsThisButton Property (Access 2003 VBA Language Reference)

These links should assist:Inventory Control: Quantity on Hand UA: Inventory Control, Software Inventory Control, Demo of techniques by Allen Browne

I have no idea what you are referring to, as you didn't give a reference! I do not privately assist individuals for free with their databases offline; however, I gladly assist in public forums where everyone can learn (including myself). Post your questions in whatever thread it was, and I...

Re: button created to copy and paste a field Had a peek. No Data? Some of the things I noticed... 1. "Name" is a reserved word, changed Control to txtName. 2. "Mr/Mrs/etc" is an improper field/control name, changed to NameTitle. 3. Modified your Copy Address Command - proper Control Name...

Re: button created to copy and paste a field In that you are saying "Header", I guess you are talking about a report? The simplest solution is to evaluate for this in the Query which is the RecordSource of the report. Let's 'assume' you have two fields in your table: CompanyName &...

Report Controls don't have OnClick events like forms, so what you seek cannot happen. It will have to be a form as a 'report' to get that feature.

:) Good job working through it! Sometimes when we are programming, we overlook that the very problem could simply be the data we are attempting to work with.

Yes, please do, along with the Make/Model in case someone else tries the same. Good luck!

I see, but if the printer's manufacturer has troubleshooting documents available, they may assist you. Might it be the margins? Try setting them to 0 -- if the printer has a minimum margin it will adjust to it.

Perhaps overlooked, but what would be the answer to the example dates I gave? Perhaps some of the field values for [File received Date] and/or [File Started] are not proper date formats, or are Null?

Excellent recommendations Simon! If I may add... Your field in the table for the product image should just be the filename (including extension). Have a table to hold Configuration data: tblDefaults ------------------------ DefaultID, AutoNumber, PK DefItem, Text DefValue, Text Description...

Just a thought, but have you looked at the POS DM printer's 'Method of Use' notes? It may have it's own driver-induced peculiarities.

In addition, see this thread.

His code will first check if [Field2] on the Form is Null. If it is, varSecondParameter will be set to "*" so your resulting query will not restrict returned records based on this field. If it is not Null, then varSecondParameter is set to the entered value for [Field2] on the Form. He then...

HiTech was suggesting that, in your Temp Table, include a field [SortOrder] which would be numbered in the Order that your rows are currently displayed. I'm thinking you would have a table named "tblCycleRecordOrder" with fields CROrderID (PK AutoNumber), SortOrder, Identifier. Identifier...

With the Query in view using the Query Builder (Design View), in Toolbar click "Query", "Append Query". You will be prompted for the TableName to append to. Select and click [OK]. You will see the Query format changes. For each field in the fieldlist, in the "Update To" row, select the...

The only difference I see is the number of (). Made to match the one that works: Avg((([A INVESTOR SETTLEMENT TABLE].[Purchase Date])-([Closed Loans Mainsail].[Closing Date]))) AS [Avg Days from Close to Investor Purchase] If the first Date is 02/10/08 and the second Date is 02/26/08, what is...

What is an "INFORM" ? I'm assuming an Access form. In addition to Gizmo's suggestion, you can also use FollowHyperlink (see Access Help) which would take a regular {Drive}{Path}{filename} combination and load the document with the associated application. Another method that is more versatile...

You haven't mentioned how you limited their ability to update the form. What I would surmise is a Private Sub in your code module of the Form named (perhaps) "LockControls(blnState As Boolean)". In this procedure you would have each Control like "Me.ControlName.Locked = blnState". Whatever...

I'm just curious, why the first format example didn't work??? Did you not include what I gave before/after Now() ?