Search results for query: *

I need to copy all records that have the highest number in the [NoMonth] field. I.E. If the table has 168 records, with a value of 1 in [NoMonth] for 100 records, value of 2 for [NoMonth] for 8 records, and the remaining 60 records have a value of 3 for [NoMonth]. I need to have a button...

Currently when the user enters the form if there is a record they want to copy they go to that record and click the "Copy Record" button. However, what is happening is that they are having to go to several records and click the button. Each of the records have a common value in the [Month]...

Some background... There are areas that are reported on, and in an attempt to format the report as everyone is use to in Excel I have set the report up to have columns. The detail has 3 fields... [ACT] [BUD] [VAR] Therefore the report currently looks like [AREA1] [AREA2]...

I would have thought this would be rather easy, but Access has other ideas... Basically, (2) forms. Switchboard1 Switchboard2 Switchboard1 has (3) buttons TN MS CA Switchboard2 has an unbound text box named Facility When the user clicks (on Switchboard1), TN the unbound...

When the form opens it shows the records according to the order they were entered. However, I need them to show in order as to the date in the field [Date] then next ordered sequencially as to if the record was: Breakfast Lunch Dinner Example (I know the dates are wrong): If the user enters...

Currently the below is being used for spell check on the form. DoCmd.SetWarnings False 'turn off system warning if spell check returns no error' DoCmd.RunCommand acCmdSpelling DoCmd.SetWarnings True 'turn back on the system warnings' However, there is one field on the form that is...

Currently below is the code that is being used to &quot;SendObject&quot;. However, along with using vbTab, ect, I would like to have [Password] to be sent in BOLD. Any ideas?? Private Sub SaveMe_Click() If Me.Plant <> &quot;EXEC&quot; Then DoCmd.SendObject , , , [UserID], , , &quot;Capital...

Currently the following is being used to print: Dim strWhere as string strWhere = [Plant] = 'Altima Trim & Chassis'&quot; DoCmd.OpenReport &quot;Budget Reports&quot;, acViewPreview, , strWhere However, it has become to print just the current Record. Therefore, could the &quot;strWhere =...

There is a report that needs to be exported on a daily basis. Currently, since the previous days must be kept, the export is being done manually so that the file name can change. I.E. DSR 21504 DSR 21404 DSR 21304 etc.... *The &quot;21504&quot; is an actual field [EFF DATE] in the DSR* File...

Currently I have set up a switchboard that when an area is selected that area is automatically filled into the field &quot;Plant&quot;. However,when the user clicks on the button to go to the next aval blank record the field &quot;Plant&quot; goes blank. Below is the code on the &quot;Go to...

Currently there are approximately 11 options on a switchboard. Once the user clicks which one they want it opens the respective form. The form then has a default value based on the table. I.E. [] Cars [] Trucks [] SUV If the user clicks the button next to Trucks a form will open with the...

Is there away to &quot;Hide&quot; or make the MenuBar inoperable? I have tried: MenuBar.Visible = False But get &quot;Invaild Qualifier&quot; and goes directly to MenuBar I have done something like this before, but can not remember how... It is not like a toolbar where I can customize, but...

Currently this code is being used on a form that sends each user their password. However, I would like to force a new line in the e-mail at certain spots (just as if I was typing this in e-mail an pressed the &quot;Enter&quot; key to start a new line) In the code I have placed $NEW LINE$ where...

The form currently being used allows the user to update the records with the lasts' months totals. Then a report is ran based on if the field [Current Month] is >0. The problem is that currently the user must close the form and open the table and change all values in the [Current Month] to...

Without using a combo box, is there away I can open a specific record through a form? Currently in the query &quot;BudgetCoordinatorEMail&quot; there is [Enter UserID] in the criteria for UserID. However, when the form is opened, this seems to be skipped. This is to be used so that once a...

In the form there is a textbox &quot;Name&quot; which needs to hold the Name of the person according to their NetworkID. Therefore, I used the following on the On Open of the form (I have included all notes I made in the code): 'Following fills in the textbox &quot;NetworkID&quot;, which is...

When initally setup the databases' forms used input boxes for users to enter passwords to navigate from form to form. However, now a separate table has been set up to house the passwords. Here is the problem and oh boy, do I hope someone can help! 10 different areas. Each area has an...

Currently there are (2) option groups: Dim strWhere1 as string Dim strWhere2 as string 1) Me.grpSortBy Case1 strwhere1 = ...... Case2 strwhere1 = ...... Case3 strwhere1 = ...... 2) Me.Criteria Case1 strwhere2 = ...... Case2 Strwhere2 = ...... Case3 strwhere2...

In the below code the select case is working for me.grpSortBy, to pick up the correct type of sorting. However, the select case for me.Criteria is not working to allow the selection of Active, Deleted, All items (cases 1, 2, 3 respectively) Private Sub command3_Click() Dim PlantSort As String...

There is a horizontal line that I need to place in a specific place on the report. However, when I try to move its position via its properties, Access rounds the position which causes it to be too far left/right of the needed position. I know the below will draw a vertical line via code in the...