Search results for query: *

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...

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...

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 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...

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...

I have a combo box that gets values from a table. A user selects a value and clicks btnSave. How do I get the combo box to automatically select the next value? I would like it to be in the Click event of the Save button, but am not sure of the code. Thanks, SKW

I have a form that displays two text boxes; the first(txtEntry) is blank and is for user input and the second(txtPrevious) is supposed to show the previous record (it is the basis for an error-checking routine: txtEntry must be > txtPrevious). My problem is: how do I get the contents of...

I have a form that displays two text boxes; the first(txtEntry) is blank and is for user input and the second(txtPrevious) is supposed to show the previous record (it is the basis for an error-checking routine: txtEntry must be > txtPrevious). My problem is: how do I get the contents of...

Hi, I have a field of values in Table1 that need to be entered into another field in Table2 via a list box. However, the values must be restricted to those that have not yet been entered into Table2. For example, if a user selects and saves a value (from Table1), that value must not be...

How does one clear an item from a list box? The scenario is: There are several items listed. The user chooses one and then clicks the "Save" button to save that record. I then want to have the item disappear and show only the remaining items. I am new to Access so please forgive me...