Search results

I would follow plog's instructions...but just for the record, the control source would be the table you're adding records to, not the Zip code table. For now, keep it unbound.

Nor are any of the rest of us - despite our grandest delusions.

Are you sure that's correct? Try: DoCmd.OpenForm "AuditClicksUsers", acFormDS, , "[User]=" & Me.Logged_In

You're too quick on the draw, Access World Ninja. You replied to my deleted post after I saw the date of the last post. No matter - Just a guess, but I think it may depend on whether that field is locked. All of my hyperlink fields are locked with the hyperlink hand cursor and they stay blue...

I think we're thinking too hard about this... If your database has "Allow Default Shortcut Menus" unchecked or the Shortcut menu for the form is disabled, just right-click in the fields and you will get the same effect as tabbing.

I like the idea of a script, especially if I can run it daily with the Task Scheduler. That means even if I am away it will continue working (if I'm logged on - and that could be a problem). Up until this point my regimen has been rather mundane, just doing a manual copy. I think that has its...

It's also possible that your laptop has a display driver causing the issue or some other process running that interferes with the timer. Just thinking out loud.

Most of mine are bound, some of which are used for data entry and some of which are used for their lookup capability - disabled and locked. If you're doing data entry and need users to select from a limited list of choices, and can't afford the screen real estate for list boxes, well...there is...

If your users have the same 64-bit Access, just change your Public/Private Declare to Public/Private Declare PtrSafe Recompile and Save As .accde

I started grouping my queries with similar names or numbers when they are used together either as subqueries or for the same form.

I wish control tips still worked on disabled controls.

If you only have one or two API declarations it's very easy to get things working again. Keep in mind that if you deploy .accde files, your users will need 64-bit Access to run them.

It seems it's all manual. I can't do =[fieldname] or anything like that. Bummer.

Handy, but really finicky. And no way to include the product name for the series that I can see.

I changed to a Stacked Line chart and it seems to be improved, however I can't have both lines coexist or they don't play nice together. Removing the AQL field from the chart corrects the behavior. It should be possible to have both. I guess I'm not understanding how or why they would interact...

How strange. The chart seems to flatline at 50%. Here's another item - the blue line should reach 100% at all points except one.

The first percentage is simply: Quality Level: ([SumOfSamples]-[CountOfQS])/[SumOfSamples] The second is hard-coded. The value is 0.975.

I must be missing something here...attached is my data set and the chart result. Plotted (blue) line never exceeds 50%, yet my values reach 95%? Any insights?

Actually no, I don't think I do. I need the quality level at each point in time, probably the (sum of pieces-sum of defects)/sum of pieces from all inspections per day. I don't have that, but after playing around with the charts (both old and new) I've got some ideas to work with. At least I...

I sometimes find a C&R not enough, and do a full decompile and recompile. Directions here: Follow these steps to customize the Send To menu with an Access Decompile shortcut: Create a shortcut to the Access executable. Append the /decompile flag in the Target for the shortcut. The shortcut...