Recent content by pepegot

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

Cannot copy forms I started the computer today and all the Forms were there. I combined to databases successfully. The went back to the Forms objects and they were gone. I exported the files from one db to the other and it tells they are there. Why the hell does not this program show them? Is...

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.

If -Then Ok Case NO Selena, I just tried it out and it works fine. I came to the same conclusion after submitting this post. We both agree and it works. Thanks for your quick reply. I knew it was something simple. Private Sub Frame1_Click() Select Case Me.Frame1 Case Is = 1...

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