Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: misscrf
  • Content: Threads
  • Order by date
  1. misscrf

    Access VBA Subform Dynamic SQL Parent Form Count Slow

    I have a filters private function on a form, to dynamically generate the SQL for the record source on a subform, for searching records. I run this onload of the main form, and afterupdate of a series of text box (dates), comobo box, and check box controls. Below is the Filters code. When the...
  2. misscrf

    Access Combo Change - Check Before/After Values and Other Combos Before Change (Update)?

    I have 3 combos. The first one is to pick the type of voting panel. Some of the options are a panel type (column(2) - hidden) of a person, the others are a group. If the type of voting panel chosen is a type of person, a person combo is shown. If the type of voting panel chosen is a group, a...
  3. misscrf

    SQL Database Diagram - SQL Server 2014? Visio 2010 Won't :-(

    I typically make a Visio database model diagram, doing a reverse engineer feature. My issue now is that I have Visio 2010, but I need a model for a database on a 2014 server. It seems the Visio driver in 2010 is not compatible for SQL Server 2014 database connections. I tried the generic ODBC...
  4. misscrf

    Access Subform Datasheet View - DateTime Field?

    I have a subform with a datetime field (linked from SQL). It shows a calendar picker, but doesn't show the time. I switched the format to long date, and that didn't work. Anyone know what I'm missing? Users need to be able to pick or enter date AND time into the field. I've been...
  5. misscrf

    Analyzing/Documenting a Database?

    I'm looking for a tool (preferably free or free trial) so I can document all objects and such in an Access database. I am looking at replacing a linked SQL view, and will need to know everywhere I use it. Whether it's a record source for a form, row source for a combo or listbox, or if it's in...
  6. misscrf

    Debug.print time between functions?

    I have some functions, on certain forms in an application, which take a while to run. I want to set up some simple debug.print messages to capture the time I start the function, and the time I start and finish each step of the function. This way, I can isolate which step is taking the longest...
  7. misscrf

    Form Combo Filter In String (FAQ Help)

    I'm following through this thread: http://www.tek-tips.com/faqs.cfm?fid=6295 and I'm confused. It says the combo should have 3 columns, but only explains what 2 of them are. Anyone able to determine what I'm missing? This is the section of the code, about that part: ' Column Count 3 ' Keyed...
  8. misscrf

    Access and SQL - Best Practices for Allowing Deletes?

    I know this is a pretty general topic, but I hope no one will get mad at me for asking this question here. I have an application and because of how it will be used, I want to make sure it is set up in a way that has tight control over what records people can delete, and which combo values can be...
  9. misscrf

    Find Record Form - Include Related Records?

    I have the following structure: Contact (ID, txtContact, txtNotes) Match (ID, FKContact, txtMatch, txtNotes) Contact Match Record (ID, FKMatch, txtsomestuff, txtNotes) I user starts a new record by assigning it to a contact and a match. Now we have had to add 2 extra tables to the structure...
  10. misscrf

    Limit SubForm Combo Based on Existing Records

    I have been searching for a way to limit the values in a combo box, so that records already added in a continuous subform can't be chosen again. Weird thing is, I'm not seeing this as a common thing to do. I have a subform with "requirements". The sub form has a combo with requirement types...
  11. misscrf

    Add New Record From Pop-up Form, Reset RecordSource - Form Locked?

    so this is odd. I have ensured the recordsource is updateable. This was working prior, but who knows what of the 89097987 attempts I've made at getting this all to work, that was. I have a form for records. The detail is visible = false on load. The header shows with buttons to look up a...
  12. misscrf

    Add New Record on Another Form - Save Record to Get New ID

    I have a form that has the detail visible = false, until a user clicks 1 of 2 buttons 1) Look up Record (filter combos to view existing records in listbox - choose one, go to record) 2) Add New Record For #2, a form pops-up, and I make the main record form visible = false. The user has to...
  13. misscrf

    Form with Tab Control - Set visibility of Pages Based on Subform Records

    I have a database with a SQL back end. This is the process I am currently debugging: 1) Open application to Main menu 2) Click button on main menu to go to the "Main Record Form" 3) Main record form has detail hidden until an existing record is found or a new record is...
  14. misscrf

    DateDiff in Minutes - Round to nearest minute?

    I have data like this: actdate time1 time2 1/1/01 12:05 PM 2:10 PM I do a datediff formula in a query, as follows: DateDiff("n",[TimeTable]![time1],[TimeTable]![time2])/60 problem is that I get a result in the query like 2.08111111111 I want to round to the nearest minute/ 100th decimal...
  15. misscrf

    SQL Split Multiple delimited columns into rows?

    I have data that I received which is not normalized, and I need parse it out, so I can import it to a normalized structure. I have found cte's and split functions, but only for 1 multi-value column. Nothing for 2 or more. The data looks like this: ID fname lname projects projdates 1...
  16. misscrf

    First PHP Sql Query - Not Working - No Results or Errors

    I'm trying to just make a simple connection, so I can learn how to query info from sql server on a php page. So far, none of my attempts are working at all. I get no errors, no results, nada. Below is my code, if anyone can help me figure this out. Thanks! <?php echo "<h2>Project Group...
    • misscrf
    • Thread
    • Replies: 0
    • Forum: PHP
  17. misscrf

    Form Criteria Report Open Run-time Error 3075

    I get this error in my form command button control, in the on-click event: Run-time error '3075': |1 in query expression '|2'. -------------------------- This is the code in that event: Private Sub cmdExDetRptSel_Click() Dim strDocName As String Dim strcriteria As String Dim strOpenArgs As...
  18. misscrf

    Report - Turn Grouping On And Off?

    I have a report that has 2 groupings and 2 sortings. I want to use a form to dictate whether the top grouping (GroupHeader(0)) is on or not. I have it partially working, where it doesn't show the group or it's 1 textbox control. But the 2nd grouping still seems to group it's data by the first...
  19. misscrf

    Listbox Rowsource Public Function Paramaters Type Mismatch?

    I have a listbox, which I set the row source on click of a filter type button on a form. The row source I set is a public function, which takes 2 parameters. Originally I tried a stored procedure, but found that you cannot set the row source for a listbox to a stored proc. I converted this to...
  20. misscrf

    Form/Listbox Form Adding/Assigning Million of Records?

    I have an application with projects. In each project, there can be multiple pieces of media. We upload 2 inventories of that media. One is at a folder level and one at a file level. One piece of media could be a TB HDD. A subset of the media is what sources are on it. I have the front end...

Part and Inventory Search

Back
Top