Search results

I purchased a copy of Office 2003, on Ebay, for less than half the price it normally sells for. I created databases, which work well on my computer. However, when I copy them over to the office computer from my computer, via Flash memory stick, the program does not run. The message seems to...

I created a query with: Between [Forms]![Dummy]![StartDate:] And [Forms]![Dummy]![EndDate:] in it. I created a Form with two text boxes named StartDate and EndDate and appropriate labels and buttons. I then Created a Report, which prompts for dates and finds the data between the given Dates...

The on click event, for a Report, has the following: Sub DateEntry() Dim Start_Date As Date Dim End_Date As Date Start_Date = InputBox("Enter Start Date mm/dd/yyyy") End_Date = InputBox("Enter End Date mm/dd/yyyy") End Sub This works fine and allows for Input. I added the sub below, but it...

I imported some db objects from one db to another. I worked on the db, with the imported files, to make a new db. However, while working on the db suddenly, I lost all the imported files, as they were not visible via the objects panel. What a revolting development this was!! All that work for...

I cannot copy Forms from one db to another db. I can copy everything else, report, queries, tables, etc. When I "export" the Form, it appears to copy. However, it does not appear in the directory where it should be. If I recopy, it says "its already there and ask to overide the present Form...

Below is the code that I used to make a Menu. The only problem is that when a report is opened, it is placed under the Menu form instead of on top of it. How can I get it to stay on top? Private Sub Frame2_Click() DoCmd.Restore On Error GoTo MyTrap Select Case Me.Frame2 Case Is = 1...

Error Message: Run-time error '-2147024769 (800700f)': Method 'Connection' of object' _ CurrentProject'failed Debug: ' Open the table of Switchboard Items, and find ' the first item for this Switchboard Page. Set con = Application.CurrentProject.Connection 'error is to left as...

I created a menu, as my switchboard is not working, and it works fine. However, when I return to the form(menu)-the option button is highlighted. I added a refresh button that clears it, but this should occur automatically upon return to tht menu(form). How can this be accomplished? I am sure it...

I open the switchboard and it says "it can find the wizard, wizard not installed, or syntax error in declaration section of visual basic module." I reinstalled and the same thing. I cannot open the form wizard. Everything was working fine before-this just started. How can I fix it? I need this...

When I open a Form, it appears in the proper size. Then, I go and open a Report, which is a DoCmd.Maximum on open. This works well. The report is enlarged. Now, when I go to open a form, the size of the form is max. I tried Borderline dialog, fit window, DoCmd.MoveSize, and a couple of other...

When I open a Form, it appears in the proper size. Then, I go and open a Report, which is a DoCmd.Maximum on open. This works well. The report is enlarged. Now, when I go to open a form, the size of the form is max. I tried Borderline dialog, fit window, DoCmd.MoveSize, and a couple of other...

How can I add comments in an SQL Query mode? ",',?, ; None of these work with text following them.

I have an Option Box that contains three Report Choices, Report1, Report2 and Report3. I want to run the Reports. I coded using If-Then and it worked out fine. See code below: Private Sub Frame0_Click() If Me.Frame0 = 1 Then DoCmd.OpenReport "Report1", acViewPreview ElseIf Me.Frame0 = 2 Then...

When I type in the Input Box it gives me an error: Expected List separator. What are they talking about? The Input Boxes below are per spec. What tick mark do I need to enter and where-I haven't a clue. Private Sub Report_Open(Cancel As Integer) Dim StartDate As Date Dim EndDate As Date...

Microsofts says: "Calculating group or report totals To calculate the sum of the quantities ordered for the entire report, you place a text box control in the report footer and set the ControlSource property of the text box to the following expression:" =Sum([QuantityOrdered]) However, when I...

In an Input form, how can I blank out certain fields such that the field data is shown, but grayed out, and other fields are shown normally?

How can I delete a record from a form? I set Allow Datasheet view to yes, Allow Form No, and Allow deletions Yes. Nothing happens. Perhaps A delete button could be added, but I don't know the code? I do not want to use the Datasheet view as the means of deletion.

I run a Switchboard and everthing works well. However, the "Database Object Screen" remains in view. This is not a good thing, as unintended events may ensue by unwanted guests. How can I stop this screen from appearing and having only the Desired Switchboard displayed? It's probably an option...

I have a Combo Box that places the Address into the given Address field. How can I have it place the second and third cloumns, from the Combo Box into the next two adjacent fields on the Form (Last Name & First Name)? Please describe in detail, not just code, but where a how it goes. I am new at...

I have an Input form that does not clear the fields after I hit the Save button. Data Entry is set to YES. If I use the navigation bar, there is no problem, but I would like to have the fields empty after hitting the Save Button, so that the navigation bar can be removed. What is wrong?