Search results

  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 :)
  16. I

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

    Hi All, This is my 4th or 5th db created since November which at the time, I knew nothing of Access or vba. This db was created with the hopes of being "normalized". I am now worried that I've pushed the limitations to far which is causing the db to be slow and barely work when split and put...
  17. I

    VBA for main form On Open event to show tabbed controls only if there is data

    Perhaps I'm not understanding. I assumed you advised to put a stop and step through so I could determine at what point the code was telling a newly added record to show both tabs instead of leaving them as not visible. How would I be able to do this if the form doesn't open until the end of...
  18. I

    VBA for main form On Open event to show tabbed controls only if there is data

    Something new I learned, thanks! I put a break point around the first if, then and clicked the button on the report to open the form and step through. The form didn't show up until I F8'd (:D) through the code, then it just popped up to the first record... am I stepping through incorrectly?
  19. I

    VBA for main form On Open event to show tabbed controls only if there is data

    Hi All, I've stumped myself. To summarize as best I can, I have a report that tracks scores for our employees. From the report, you can click a button to add a new score in a form or edit an existing score(frmscoretracker). On this form there are two subforms, in a tabbed control to track...
  20. I

    SQL update query to set a record field to null

    As usual I over complicate things and Paul sets me straight!!! Thanks Paul!
Back
Top Bottom