Search results for query: *

Hello: I new to VBA, and I'm not sure if I have a code problem, or if I am calling the routine incorrectly. We want to generate tickets with varied data on them, but need to keep the numbers in sequential order for accounting purposes. I have built simple form to let the user input ticket...

Hello: I am trying to develop a quick application where "tickets" could be generated quickly for a transportation service. Basically, I am trying to print these with MS Access label function so they can be obtained on demand. The following sample code should take the text input in Ticket and...

Hello: I am having difficulty with an inner join generating thousands of records on query execution. We are matching addresses in order to load a geocentric address to optimize our routing. I have cleaned up the addresses to conform to the style provided by the software vendor. We have to...

Hello, we are planning to upgrade our server which is running SBS 2003. Our principal application for passenger reservations is running on MS Access 2007. Our network people (outside firm) want us to upgrade to SBS 2008, but JET SQL is not based on 64 bit architecture, so presumably it will no...

Hello: I am preparing a purchase order system with the first grouping level being the vendor and the second the equipment item number. I have a sub-report with the detail work to be done on the item. Group 1 Vendor Group 2 Equipment number Subreport New Page Repeat until...

Hello: I am trying to populate a field called UserID, contained in a subform using a module written by Dev Ashish. The module is cited in http://www.mvps.org/access/api/api0066.htm. We are using Access 2007, running Windows Small Business server 2003. The workstations use XP/Pro. I have...

Hello: I am trying to update a field based on the action taken on a checkbox as follows: Private Sub Dispatched_AfterUpdate() Dim strSQL As String Set strSQL = "UPDATE Ride SET TimeDispatched = Now()" DoCmd.RunSQL strSQL End Sub The error message returned is Object required (Error 424)and...

I received great help from Remou in the JET SQL/Queries forum and have now correctly calculated a value "fare" for each ride accepted. Normally, I wouldn't want to store calculated values in a database, but the auditors have decided that we need to save the results for audit purposes. The...

I need to update a table with a unique fare each time a reservation is taken. The user is working in a sub form (data source: Table Ride). The fare calculation is somewhat complicated, so an update with a combo box is not appropriate. Fares are $2, $4 and $6, depending on the qualifications...

This should be simple, but I can't seem to add two time values calculated using the DateDiff function. We want to calculate elpased driver time to reduce overtime. FirstRun:Format(DateDiff ("n",DriverStartTime,LunchOut)/1440,"ShortTime")...

I have a combo box that enables selection of a particular record. The SELECT statement selects seven fields that are defined as YES/NO, after the key field. Does anyone know of a way to display the YES/NO values as checkboxes (easier for user to read), rather than "YES" or "NO"? Thanks Pete

I am attempting to update a field when a checkbox is checked. I am using Office 2007 and VBA. This seems like such a simple subroutine, but when I run this code: Private Sub TimeDispatched_BeforeUpdate(Cancel As Integer) If Me.Dispatched= True, Me.TimeDispatched=time() Else...

I have a checkbox on a form that is used to indicate that an item has been dispatched. We want to update a field in a table with the time when the box is checked. I have the code in an event session "On Click." Private Sub Form_Click() Update Ride, TimeDispatched SET TimeDispatched = IIf...

We have recently installed MS Small Business Server 2003. The only "casualty" in the upgrade is that a principal form in the application will load under an administrator password, but not the user profile. Users have adequate privaleges and all other forms on the application will load under...

We have a MS Access database just migrated to Windows 2003 Small Business Server. Previously it ran on a file sharing star topology. The database is split and has a FE on each local workstation and a BE on the server. There is one form that will load only when the user signed on is an...

I have converted elapsed time into hours and minutes by using the DateDiff function and then the result into total minutes by using the Hour and Minute functions. This gives me total elpased minutes. However, when I attempt to add the result, for example by unit, I get a data type mismatch...

I have looked at all the relevant posts, and can't find an answer. After splitting the DB, I tried to distribute the FE to user workstations. When I try to start the applications, I get an error stating that the path (from the server (same for the development machine) is not valid. The copy...

We are filtering by form to obtain information from a table in order to correct it. This works fine until names with apostrophes are entered such as O'Donell and O'Brien. The filter by form retrieves them from the table, but not from the form. The form returns a blank record. All other...

We are trying to set up a notification system to get patients ready for transportation to a clinic. The ECF staff needs to be notified 1 and 1/2 hours before the patient's appointment. I have tried this approach: In the query grid, calculate the "warning time:" NoticeTime...

When a continuous form is opened, the user is requested to enter the relevant date (OnLoad). This form will be open consistently throughout the day. Therefore, the form must be refreshed and there are two forms that the user may wish to reference from a value on the current record. The...