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 derfloh 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: sdk
  • Order by date
  1. sdk

    Trouble Concatenating Dates

    Hi (without first checking what is in the FAQs) Is the textbox name included in the statement? ie is the name of the control "NoticeDate1", "NoticeDate2", or "NoticeDate3"? Also, the statement should read: =[NoticeDate1] & ", " & [NoticeDate2] & ", " & [NoticeDate3] Cheers S
  2. sdk

    connection to Oracle

    Hi Is the connection timingout (ODBCTimeout property)? I normally set this to 0, but that may create other issues for you. Cheers S
  3. sdk

    Built the database...What is next?

    hi just copy it to where your user community can see it - remember you only want one instance of the database for the users to share, not (or likely not) a seperate database each. There is no need to install as such, unless you are using Runtime. Most database properties are available through...
  4. sdk

    Query Question

    hi If you want only the full list of weeks, and only those entries that match weeks for your crtiteria, use an outer join. Dbl-click the link between the two tables in the qry design, then select the option that returns all values in Weeks and matching values in TimeLoggedOn. Also remove the...
  5. sdk

    Primary keys No longer Primary keys

    Hi I have the same issue a couple of times. I cannot put my finger on the cause, but seems to happen after either a dbase compression or a bad value corrupting the dbase necessitating a repair. I am absolutely positive it is not a user-hack - there is not point at the location this occurs...
  6. sdk

    Filter subform based on listbox

    Hi Does the list have a single value that can be used as a key? - that the Doc-Aircraft is a unique intersection suggests so - then include that key in your subform, make it the first col in you list (hidden if necessary) and link to the subform in a child-master relationship. Alternatively...
  7. sdk

    Calculate business hours between two times

    Hi take a look at thread181-51747 - options there to consider include mealbreaks, hols and weekends. Cheers S.
  8. sdk

    Report Recordsource

    Hi my rudimentary understanding is that the Queries are precompiled - unlike embeded sql, and that therefore there will be at least a slight drop in performance. Personally, I prefer to use sql as the source, but acknowledge that data mtce can become a bigger issue (although there are ways to...
  9. sdk

    Report/Query Error

    Hi The problem is that you are using a cartesian intersection of the results. If one query returns an empty dataset, then there can be no matching results. Duane's advice is correct - look at subreports, or look to shape your dataset differently (unions etc). If there is no data for a...
  10. sdk

    Calculation on a report

    Hi I think you want 2.x 2.A 2.B 2.C 3.A 3.B to come out as either: x, A, B, C, A, B or 2, 2, 2, 2, 3, 3 is this correct? There is no built-in functions to do this, but the code below, inserted into a module, can give you these results. Pls note I have made the length of the string optional...
  11. sdk

    Sorting Reports with multiple criteria

    Hi mea culpa - didn't read that problem into the question. Cheers
  12. sdk

    Report query for Two Date

    Hi on Duanes behalf: WHERE ((MyTable1.Complete_Date) Between [From-Date] And [To-Date]+0.999); Personally, I would add just one - it won't make any difference to your results, is more correct etc. Also, Duane's advice is correct - you really should look at having a form front-end to control...
  13. sdk

    Sorting Reports with multiple criteria

    Hi I think you will find that running a report wizard will give you the start you are looking for. (It would also be highly unlikely that the wizrd will give you the output format you are looking for :) Cheers S
  14. sdk

    database question

    Hi (You must have a common attribute between the two tables, eg the second table must have the old name and the new, or there is a common identifier between the two tables) Make a backup copy of the table you are changing (more on this later) Create a new query Add both tables join the two...
  15. sdk

    Count Total Distinct Records on Report

    Hi To get this into the header, you might need to explicity query the dataset and retrieve your value. This might get complicated: copy a clone of the report recordset and loop through counting each chnage in the group spelling (the recordset must be ordered by you group to achieve the desired...
  16. sdk

    Design toolbar appears in runtime environment

    Hi Below is some code I have used to control some aspects of after runtime. This is called in the autoexec macro, but the dbase has to opened twice for the process to work (first time sets, then the second acts on the new settings). One of those is the availability of toolbars. Pls note that...
  17. sdk

    Unbound Field Text Box Question

    Hi You must have a highly skilled user base to be this dependable on their typing skills! Why not use a listbox (multiselect) to build the list? Then loop through the selected values to set the target query's criteria? I think the results would be more dependable. Using the results will be...
  18. sdk

    database question

    Hi Is there a table with the names mapped to each other? you need a common key between the two, then run an update query to overwrite the exstg name with the new one. Link the common key from the two tables in a query, change the query type to an update (menubar: Query >> Update Query) and...
  19. sdk

    MS Access 97 question

    Hi, Not sure why the sql isn't happy, but try replacing ORDER BY min(id); with ORDER BY 1; (I find this is often a handy syntax) Cheers S
  20. sdk

    Recording Incomplete Dates

    Hi I tend to think that your solution is the best. Alternatives: - Have a flag (checkbox) that says the date is indicative only - change the field type to a string (but this will introduce mayhem) It does come down to the use of the date. If the attribute is really day-sensitive, then...

Part and Inventory Search

Back
Top