Search results for query: *

Sorry, I was distracted and missed finishing my thought.. I do not know EXCEL (more of an Access VBA person) but I think the basic syntax would go like this: Public Sub ONCHANGE(CellName) SheetName!IncrementCellName = SheetName!IncrementCellName + 1 End Sub Perhaps one of the more adept office...

Are you saying you want to keep track of how many time the number was updated? <or> are you saying you want a number to cascade to another sheet as an equal? Example of Incrementing Number Sheet1!A1 = 4, Sheet2!A1 = 4, Sheet2,B1 =1 Change Sheet1!A1 to equal 20 ... Sheet1!A1 = 20, Sheet2!A1 =...

This is a bug from MS. I had it on one my students PC's. The only problem is that I cannot remember what the solution was. Seem to remember it had something to do with the install of office on that particular machine. Perhaps it was an update from a beta version of office or something like...

I recently imported my spouses birthdays to our home calendar. What I realized is that she has all of the reminders set to 15 minutes. This is not very good lead time if you know what I mean! Is it possible to update all 47 records that match my birthday search? I was going to export them as...

Thank you, I will look into your suggestions. JerseyBoy Remember: self-praise is no recommendation

I love a clever solution! :-) This really works well! Enjoy your star, Thanks! JerseyBoy Remember: self-praise is no recommendation

What I have found is a very complicated way around it... Using for loops I dynamically sized the controls base on this: len(controlname) * x amount of twips per character (90-105 in my case for basic font size 12 font with & without italics) After that, dynamically placed them next to each...

Sure should have been covered here, but I can't find it... I have to create a menu 'report' Multiple parts to the line item... Item | Description | What come with it...| Price| Add On | Additional Price...(whatever else they dream up to make it more complicated than it already is... What I...

I know what it does, but I haven't a clue to go about implementing it. I have a backup routine that copies the folder (where the database resides) to another location naming it with a NOW() type naming convention. That all works, but I would like to display a progress bar on how the copying...

I have a friend that is trying to install a Sony Printer on his XP system... Sony IJP-V100 &quot;all in one&quot; He cannot find the correct drivers.. Called Sony and they referred him to a lame website that has a bogus driver... He has researched and found a post that indicates that there is...

Thank you both, I did get it to work.. Here is the final statement for those who may follow this thread: strSQL = &quot;INSERT INTO tblTEMPEventAttendees ([EventID],[ContactNumber]) VALUES (&quot; & &quot;'&quot; & strEventID & &quot;'&quot; & &quot; , &quot; & &quot;'&quot; & intContactID &...

I can't see the forest for the trees! I am in VB trying to execute a [DoCmd.RunSQL strSQL] statement Here is the code and the resulting msgbox: _____________________________________ Private Sub cmdAddOne_Click() Dim strSQL As String Dim intContactID As Integer Dim intEventID As Integer...

It is so simple stupid, I wonder why I didn't think of it. All I would have to do is put an event in the setfocus trigger that sets the timerinterval to a value. It sounds much more reliable and much less prone to 'fat finger syndrome' I still would like to challenge the community to see if...

Chris, First, thanks for your response. Let me clarify my intent a little further... I usually place in the forms header section an unbound control or a label and manipulate the value of that control to display the status bar text. Your idea is good, but I already use the Form.Caption to...

I have tried many methods to increase the direction set that the users see. The small status bar text tucked neatly in the lower right corner is so out of site, that many users don't even know it exists unless you point it out. In the past I have included [Event Procedures] in the Got_Focus and...

A little...let me try to explain in further detail using my current project. The database is for a non-profit historical society and is primarily geared toward keeping track of the contact for the organization. They have a contact and that contact can be affiliated with the database owner in...

I appreciate your response. I agree that this is a very acceptable way of responding, but I should have been more descriptive in my circumstance. In my case, the dropdown was intended to pick an already established record (in another table) and tie it to this persons affiliation list. If the...

I have a combo box set to fire off the 'not in the list' event. I would like to tailor the message to my own (and have been able to accomplish that) but the the wizard commences to readdress the problem when the user addresses my message box. How do I supress the Access Message? I tried an error...

Sounds like you need a subquery... Create the first query the way you described.... Create a second query using the first query as the information in design grid. It will run the first query to retrieve the records for the second. Limit the second query set to match you final criteria. If...

If you have a form that has a subform, is it possible to sort the subform (either with a button or automatically)? The main form in my db lists events, and the subform list the many people who are scheduled to attend said events. The user can add attendess directly in the subform, but the...