Recent content by isaacski

  1. I

    Public Function to assign a macro to all buttons with a certain name

    It will take me a while to figure out what is being said in these... thanks for the suggestions! I did some testing myself and found that really what I'm trying to do is create a set of vba instructions that I can call in a form OnLoad event. I tested it on the individual form and I can put the...
  2. I

    Public Function to assign a macro to all buttons with a certain name

    sounds like it save more time to just go through every form and assign each macro accordingly :( If I try something that works I'll definitely post it! Thanks for the reply
  3. I

    Public Function to assign a macro to all buttons with a certain name

    Hi Everyone!, I'm not even sure if this is possible but I'll ask anyways. I have built an access application that contains a set of buttons along the top of every form that serve as navigation.* These buttons each perform the same function on every form they are on. (menu opens the main menu...
  4. I

    SQL in unbound text box

    eeek! Thank you Thank you Plog!!!! Clearly I should not doubt SQL language so hastily. This has seriously opened my eyes to the coolness of queries. I really want to go through all of the other reports now haha. Sadly, I'm the only data nerd in my office so it will have to be a cyber...
  5. I

    SQL in unbound text box

    Hi All, I have a doozy for you. I have a query that tells me two things. Take the following: AnalystID AnalystCompleted Expr1 5 5 0 5 4 1 5 5...
  6. I

    Sharing one form with users who do not have access to the back end storage tables

    Hi All, I have a survey that I'm building in Access. This survey is intended to be sent to all employees. Where can I find information on options to share the ONE survey form with the floor, even if they don't have access to the shared drive that the back end tables are stored on. Is this...
  7. I

    OpenForm command where clause with 2 criteria

    You were right! It was the last quotation mark. It also doesn't help that I constantly misspell the word 'response'. :confused: Thanks very much for your help! K
  8. I

    OpenForm command where clause with 2 criteria

    :( Got a syntax error...
  9. I

    OpenForm command where clause with 2 criteria

    Hi Everyone, I am having trouble opening Form 2 to the same record as the record in Form 1. Form 1 is a continuous form of questions. When certain response is given, I want to be able to add more information to the "additionalcomments" column for that record. I want to have the additional...
  10. I

    Append query to check for existing values and add only those not present

    UPDATE: INSERT INTO tblassignment ( AnalystassignmentID ) SELECT refanalyst.AnalystID FROM refanalyst LEFT JOIN tblassignment ON refanalyst.AnalystID = tblassignment.AnalystassignmentID WHERE (((tblassignment.AnalystassignmentID) Is Null)); does the trick. It was giving me errors originally...
  11. I

    Append query to check for existing values and add only those not present

    Hi All, I'm stumped. I have a database used to manage teaching assignments (which kid is assigned to which teacher so to speak). I have this relationship defined through three tables, a teacher table, a student table, both with unique ID's. The third table is used to define the...
  12. I

    SQL Delete query in VBA

    I was able to work it out using the following code. Thanks for both of your suggestions! Dim strSQL As String strSQL = "DELETE * FROM reftblform " & _ "WHERE (reftblform.FormID=" & Forms!frmformmgt.cbofrmfilter & ")" DoCmd.RunSQL strSQL Me.subfrmformmgt.Requery End If
  13. I

    SQL Delete query in VBA

    Alright. I give... I have combed through these forums and tried a very simple delete query in VBA a couple different ways. I can't seem to get it. I have an unbound combobox on my form whose source is a two column form name and form ID (form id is the bound column). I have a button that I...
  14. I

    DB when split over network goes slowly - is it structure?

    Thanks for the reply, Steve. I've spoken to the tech mgr and his worry was that utilizing SQL Server Express would leave the data open. Is it that the data is stored on Microsoft's server(s) and accessed through a personalized account? (similar to a photobucket account?) I've researched the...
  15. I

    DB when split over network goes slowly - is it structure?

    It would help if I attached the file :)
See more
Back
Top Bottom