Recent content by ShredDude

On every form? It's consistent throughout multiple forms. I'd only been working on one form when this began. Very bizarre. Closing Access and restarting same thing. Rebooting windows, then going back to Access, problem went away. Very Bizarre.

I've got a gremiln! All of a sudden, every form in my DB stopped responding to mouse clicks in comboboxes. I can activate the dropdown list of the combobox with the mouse, I can point to any item in the list with the mouse, but clicking the list item does not select the item. I can still...

vbaInet: So, out of curiosity after your reply, I made a copy of the form in question and converted it to a Single Form. Works as intended. I'm fairly new with Access. Is using the Split Form view known to have "issues"? Any design advice when the look of the Split Form would be...

I don't know. Is that a known issue? The upper part of the form is what I was referring to; the "Single Form" Section of the form where I have bound controls.

I've created a split form. One record's data elements appear at the top, while data sheet of all records in recordset is visbile below. In the after update event for a combobox on the form I've placed the following code which works well: Private Sub cboJobtype_AfterUpdate() 'visibility...

Thanks for the reply. My routine does refresh the links. Post routine, the changes are visible in the Linked Table Manager's dialog window. After more tinkering, I discovered that this code does return the correct link definition: currentdb.tabledefs("tblEmployees").connect Still don't...

I've written a routine that facilitates changing the Connections on linked tables in my DB to different backends. This works well. However, when completed, I'm attempting to report the current connection link in a textbox on a form. On Form Open, prior to making a change, I populate the...

stopher: Thank you for the insight on using an invisible textbox with a running sum to number the footer. I learned something new! I'll give that try as an exercise. I've accomplished my goal by including an additional field in the underlying recordset and only populating the first record of...

I"ve achieved my objective by including an extra field in the temporary table that I'm populating with denormalized data for this report. Then when populating the recordset that updates this temp table, on the first record, I include the needed value for the firs week's calculation. Then on...

The first "week" will result in a varying number of days based on the start date of the report. For example, if the Start date is a Wednesday, the report's first "weekly" grouping will end up with 4 rows. The following groups will contain 7 rows, until the last group which will contain however...

I have a report that details data elements sorted by day, and grouped by week. In each of the Week grouping's footers, I have a bound text box for a running sum of one data element, and two unbound text boxes that contain the result of some calculations based upon the bound running sum. This...

Thanks again everyone. I did receive inspiration from the other thread about entering non normalized data with a temporary table. So, after teaching myself how to create a temporary table and a few other things, I think I'm about there. I hope! I now have a form that gets populated in a...

Gemma: Thanks for the reply and feedback. The Horizontal "requirement" for the times comes from my attempt to match their existing legacy form, which of course they've created in Excel. This printed hard copy form is in use by several hundred employees. Would like to avoid the introduction...

Lagbolt: Thanks for the encouragement. After creating a class to manage the XL linking etc. I find myself still coming back to trying to do it in Access in a way that will minimize the change of process to the users. I can handle the data validation required, and making the keystrokes as...

nvbc: Good points. I was winging it and it was late :) Thanks for clarifying. Shred