Search results for query: *

I am able to use the immediate window for debugging a specific global function, but I have to set a break point first. I just set it on the load event for my first form and go from there. Very cludgy and cumbersome...with all the awesome capabilities of .NET, how did this get overlooked...

I guess I'm not the only one who doesn't know...

OK, VBA spoiled me with the Locals pane of the debug window. I could evaluate functions in design time and not have to be in debug mode. VB.NET seems to have a similar tool in the Command window (Command or Immediate mode). However, whenever I try to use them, it states that "The expression...

I have a local database on my machine that allows me to access the New Stored Procedure option when right-clicking Stored Procedures in Server Explorer. However, when I attempt to access same on a network server from my machine using a logon that has the appropriate settings, I only have access...

PankajBanga, Your Solution is great! However, if one wanted to make 08 the month instead of 10, the following slight modification accomplishes it. Dim str As String = "08102004" Dim dt As Date = New Date(str.Substring(4), str.Substring(0, 2), str.Substring(2, 2)) MessageBox.Show(dt) Both...

Hi Bill, You are too kind - I am only glad to help after all the help I have received from other members... Thanks, Spaniard.

Bill's method works if you are tabbing into the field, but if you want to highlight it when you click on it, then for that text box's On_Click event, [code]Private Sub txtYourTextBox_Click() SendKeys "{F2}" End Sub[code] Good luck, Spaniard.

Beetee, Thanks for responding. After several hours of brow-beating, I figured it out. I'm relatively inexperienced with coding, so it takes me a little longer to figure out how to do what I need. I can post the code if you are interested (I'm sure there is a better way to do it!). SKW

Thanks, Bob. I figured out another way to do it, but your way gives me another, possibly better, alternative. SWK

Sorry about the previous post w/inappropriate subject... Hi, I want a report to show a 24 hour time line with the starting value being the start time of a product run and incrementing one hour for 24 hours. Example: Product starts at 3:00 PM Timeline should look like this: 3 PM 4 PM 5 PM 6...

Hi, I want a report to show a 24 hour time line with the starting value being the start time of a product run and incrementing one hour for 24 hours. Example: Product starts at 3:00 PM Timeline should look like this: 3 PM 4 PM 5 PM 6 PM 7 PM 8 PM 9 PM 10 PM 11 PM...etc Any...

Timer event won't do it...this is a user-initiated report and is not run regularly. This is a scheduling database and the timeline serves to show when the product is scheduled to run. If the schedule calls for the run to be from 3 PM to 5 PM, a bar fills in the specified time slot. Rather...

Hi, I want a report to show a 24 hour time line with the starting value being the start time of a product run and incrementing one hour for 24 hours. Example: Product starts at 3:00 PM Timeline should look like this: 3 PM 4 PM 5 PM 6 PM 7 PM 8 PM 9 PM 10 PM 11 PM...etc Any...

Hi all, We are experiencing intermittent data loss to Sequel 2K table. Record is being saved, but data from combo boxes is lost. This happens infrequently, but often enough to be a major concern. Has anyone else run into this? Any insight would be greatly appreciated. SWK

I probably should have said that I'm working with Access 97, so I'm not sure I can use your approach (couldn't find any help topics). A query (of two tables) is providing the results to the list box. That correlates to your SQL statement. All I'm trying to do is to compare a new date to the...

I have a list box that displays columns of dates (SchedBegin, SchedEnd). For verification purposes, I need to ensure that the new SchedBegin, SchedEnd does not conflict with the results displayed in the list box. How do I step through each of the records? I'm pretty sure that I am in the...

Thanks for all your input...I like the enum approach, but Access 97 doesn't support it. I think the array will work. Again thanks to all. SKW

Is it possible to have a global constant represent multiple values? In a Before_Update sub, I want a warning to the user that the value they are about to enter is probably wrong. The following may be more illustrative - the numbers represent machines that are seldom utilized... Global Const...

OK, I think I'm on track...I moved it from the button click and placed the code in the form after_update event. BUT...it says I may be at the end of a recordset (RTE 2105). What could be causing this? Thanks for your patience with a dunderhead such as I... SWK

Forget about the error message, I resolved that, but the code stays on the same value and doesn't bump to the next value.