User Profile

Collapse

Profile Sidebar

Collapse
jmoudy77
jmoudy77
Last Activity: Dec 8 '08, 08:30 PM
Joined: Sep 24 '07
Location: Clarksville, TN
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • jmoudy77
    replied to Nested VBA append query doesn't append
    in Access
    Updated but still not working

    Code:
    Private Sub cmdimport_Click()

    Dim i As Integer
    Dim fromdb As String
    Dim fromdb2 As String
    Dim todb As String
    
    
    On Error Resume Next
    
    todb = "'" & Forms![AMS Import Utility].txtto & "'"
    fromdb = Forms![AMS Import Utility].txtfrom
    fromdb2 = "'"
    ...
    See more | Go to post

      Leave a comment:

    • jmoudy77
      started a topic Nested VBA append query doesn't append
      in Access

      Nested VBA append query doesn't append

      I've been using queries in VBA for a while and usually have a pretty good handle on them, but this one is kicking my butt. Using Access 2007.

      The form is designed to export(append) records from tables in the current database to identical tables in another database.

      I know the loop is working because the table names are printed to the immediate window, but when I check the database being appended to the information isn't...
      See more | Go to post
      Last edited by jmoudy77; Dec 8 '08, 05:54 PM. Reason: More specific
      • jmoudy77
        replied to Update primary back-end from multiple back-ups
        in Access
        Thanks Chip, what I ended up doing was changing the primary key from an autonumber to a text field and then combining the data from several different fields to create a unique value for the primary key.
        See more | Go to post

          Leave a comment:

        • jmoudy77
          started a topic Update primary back-end from multiple back-ups
          in Access

          Update primary back-end from multiple back-ups

          Hi, I've got a database with front-ends at multiple locations that pull from a primary back-end over a satellite network. Each time a front-end closes it triggers a back-up utility that creates a back-up of the primary back-end on that front-end's local network; so that in the event the link is lost to the primary back-end, that location's will automatically connect to the back-up back-end. Confused yet, good me too.

          My delima is...
          See more | Go to post
          • jmoudy77
            replied to DSum local variable as criteria
            in Access
            Thanks Stewart, worked like a charm.

            -Josh
            See more | Go to post

              Leave a comment:

            • jmoudy77
              started a topic DSum local variable as criteria
              in Access

              DSum local variable as criteria

              Hi,

              I'm trying to use a variable "FirstSemi" as the second criteria in a DSum function. The DSum function is used in the same Form_Load function that the variable was declared. I keep getting an error referencing the variable in the DSum function when the form loads. Any ideas?

              And [FltDate] > FirstSemi")

              -Josh
              See more | Go to post
              • jmoudy77
                replied to Auto Edit record by clicking on listbox
                in Access
                Thanks Stewart,

                I ended up using an update query. You're suggestion would have worked also, but I didn't have the "read status" field displayed in the listbox. This field is never displayed, and only used to update the user's unread mail status on their homepage. Thanks for the help though.
                See more | Go to post

                  Leave a comment:

                • jmoudy77
                  started a topic Auto Edit record by clicking on listbox
                  in Access

                  Auto Edit record by clicking on listbox

                  Hi,

                  I'v created an internal messaging system within my database. I've got a listbox that displays the current user's messages. When a message in the listbox is clicked on, a listbox below that is populated with the body of that message. My goal is to have the "read status" field for the messages table to change to "Yes" when I click on the listbox as well. I know I need to code this in VB, but really have...
                  See more | Go to post
                  • jmoudy77
                    started a topic Remove input boxes when report opens
                    in Access

                    Remove input boxes when report opens

                    Hi, I've got a form with a cmdbttn that prints a report. The query for the report has a criteria based on a combo box on this form.

                    When I press the cmdbttn to print the report, I get a popup box that asks for Name, then another that asks for Date. Both of these are the names of text boxes on the report, but not field names in the query.

                    Any ideas?

                    Thanks
                    See more | Go to post
                    • jmoudy77
                      replied to "'Save Record' not available" error
                      in Access
                      Thanks Linq, that worked like a charm.
                      See more | Go to post

                        Leave a comment:

                      • jmoudy77
                        replied to "'Save Record' not available" error
                        in Access
                        I don't want it to save an incomplete record. Here's the situation:

                        An aviator opens the form to log his flight info.
                        Once he's done and presses the Save cmdbttn, the msgbox appears asking if he wants to add another duty position for this same flight.
                        If no, the record is saved and the form resets to add a new record.
                        If yes, the record saves and then clears only the fields he needs to fill for his second duty...
                        See more | Go to post

                          Leave a comment:

                        • jmoudy77
                          replied to "'Save Record' not available" error
                          in Access
                          Hi S7,

                          Scott edited the code tags in for me, thanks Scott.

                          You hit the nail on the head. The record has already been saved; what I can't figure out is how to have it recognize this as a new record without deleting the information out of all the controls. The only controls I want deleted are the ones I null in the code. Any thoughts?

                          Thanks
                          See more | Go to post

                            Leave a comment:

                          • jmoudy77
                            replied to Reference/Library problems on 2003
                            in Access
                            Apologize for the late reply, but I got it working.

                            I opened the references and unselected the MISSING reference.

                            Thanks for the reply.
                            See more | Go to post

                              Leave a comment:

                            • jmoudy77
                              started a topic "'Save Record' not available" error
                              in Access

                              "'Save Record' not available" error

                              Hi, I've got a form that allows a user to imput their flight data. I programmed a MsgBox into the save button that asks if the user wants to input another duty position for the flight.

                              If no, the record saves and the formresets for the next rocord input.

                              If yes, the record is saved and the duty position and mode of flight fields are set to null, with the remainder of the fields retaining the data already entered....
                              See more | Go to post
                              Last edited by Scott Price; Feb 16 '08, 02:42 AM. Reason: code tags
                              • jmoudy77
                                started a topic Reference/Library problems on 2003
                                in Access

                                Reference/Library problems on 2003

                                Hi, I've built a database in XP and when trying to run it on a machine with office 2003 I get a bunch of reference and library problems. Does 2003 not include the same references and libraries that XP does? I tried converting it to 2003 on that machine, but still same problems. Thanks in advance.
                                See more | Go to post
                                • jmoudy77
                                  replied to runtime error 2001 only when open tabbed form
                                  in Access
                                  I recoded the form to pull info from the table rather than a query, that seemed to fix that problem.

                                  The only issue I'm having with it now is that it won't allow me to navigate between records. It pulls the first record and then shows an empty record when next or prev record is selected.

                                  BTW, I really appreciate the help.


                                  Private Sub Form_Load()



                                  [Stands] = DMax("[FltDate]",...
                                  See more | Go to post

                                    Leave a comment:

                                  • jmoudy77
                                    replied to runtime error 2001 only when open tabbed form
                                    in Access
                                    The error occurs when the main form loads. I don't think it has anything to do with the tabbed control, because I created a new form to troubleshoot and added a subform with this form as its object source(no tabbed control).

                                    I got the same error when I tried to open the new main form

                                    Should there be any reason to use master/child linking between the main and subforms if I nothing but the subform on the main form?
                                    See more | Go to post

                                      Leave a comment:

                                    • jmoudy77
                                      replied to runtime error 2001 only when open tabbed form
                                      in Access
                                      I cleaned up the Syntax a bit to try and fix the Day and Date issues and to eliminate comfusion.

                                      I'm still getting the error when I try and open the form that has this form nested as a subform in a tab control.

                                      I'm still not getting an error and everything works fine when I open the form directly. Here's the new code.


                                      Private Sub Form_Load()

                                      Dim DaySum As Integer
                                      DaySum =...
                                      See more | Go to post

                                        Leave a comment:

                                      • jmoudy77
                                        started a topic runtime error 2001 only when open tabbed form
                                        in Access

                                        runtime error 2001 only when open tabbed form

                                        I've got some vb code that gives me a "previous operation cancelled" error when I try and open the form as a subform in a tabbed control. When I open the form itself I don't get the error. Does DSum() not agree with the tabbed control?

                                        I'm posting the code below.

                                        Private Sub Form_Load()

                                        ERROR STARTS HERE and continues to the next line if I remove the previous function.
                                        DSumDay = DSum("[Day]",...
                                        See more | Go to post
                                        • jmoudy77
                                          started a topic Databinding with Combo?
                                          in Access

                                          Databinding with Combo?

                                          Hi, I've got a flight record table that is created every time I enter a new individual in my database. I created an autoform from the "flight record" table, with the hopes that I could add a combobox, select individual, input flight data into the text fields, and have it update that individuals "flight record" table. I'm stuck as to figuring out how to make the text fields bind to the individual's table that I've selected in...
                                          See more | Go to post
                                          No activity results to display
                                          Show More
                                          Working...