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: *

  1. punderful

    database locks if user is inactive for time

    I have a multi user database, and if one of the users has a form open but inactive for a period of time the database locks other users from opening the database. Any way around this? Thanks!
  2. punderful

    page setup for queries

    I have the page setup for the database set for landscape, and have "perform name autocorrect" turned off in options, and while my reports print just fine I still have issues about my queries defaulting to portrait when they are all landscape. This is quite puzzling. I'm opening these...
  3. punderful

    Need help with data type returned from a function

    I ran a query with the ID#, TaskName, DueDate, (using the same sql as my function) - here's the results: txtSiteID Document dtmDueDate SA13 NIER (empty) TA01 NIER 3/5/2003 SA12 NIER 3/5/2003 TA18...
  4. punderful

    Need help with data type returned from a function

    The date data is fine, of the 31 records 4 have dates. When I run a query based on the sql I wrote for my function they come up fine, but when I run a query using the function (containing that sql) it comes up incorrect. It's giving me a time of 12:00:00am for all the records that were empty...
  5. punderful

    Need help with data type returned from a function

    I asked a question in the reports forum, it appears my question should really be related to queries. My function works in the sense that I don't get anymore errors, but the results are not correct. It should return a date, and it's returning a time (12:00:00am). Here's where my original...
  6. punderful

    need report showing subform details in spreadsheet format

    Sorry, forgot to add the "new and improved code" to solicite help in getting the right results. I ran a query with the ID#, TaskName, DueDate, and in the fourth field my function - here's the results: txtSiteID Document dtmDueDate RS function SA13 NIER 12:00:00...
  7. punderful

    need report showing subform details in spreadsheet format

    Hey, I'm making progress! I'm not getting any errors anymore, but I'm also getting weird data. I know I need to write more code, including error trapping. Here's what I am getting: There are 31 records currently. When I take my SQL statement and run a query I get 4 records (records with the...
  8. punderful

    need report showing subform details in spreadsheet format

    Your perception of the report is correct. I put (header) in there to signify a label at the top of the column, then (data) to signify the fields. To answer "why not put the data in there vertically", they want the report to look like the clients, and to be honest, I have a similar...
  9. punderful

    need report showing subform details in spreadsheet format

    I realize now that I'm trying to do something in a report that really is in the query. Here's what I have: tblProject has fields txtID, txtProjectAddress, etc. tblChangeOrder has: txtID, txtTask, dtmDue, dtmSent, dtmPaid etc. Typical Data in the table: txtID txtTask dtmDue dtmSent...
  10. punderful

    need report showing subform details in spreadsheet format

    I have to create an spreadsheet style report that takes data from a sub table like so: Each owner has a main record and sub records for each animal: (item) birth shots spay sold Dog dateA dateB DateC DateD cat dateA dateB DateC DateD bird1 dateA dateB DateC DateD...
  11. punderful

    Can I open a folder via access?

    I had this great idea roughly "wouldn't it be nice to be able to click a button on my form that would open the folder that relates to the current form record". Does anyone know how I would go about coding the on click event? Thanks!
  12. punderful

    need help creating a function

    So if I am using this function to fill a cell in a report, how do I feed the projectID into the function? Is there something similar to me.object that will look at the projectID the report is currently printing and use that record#?
  13. punderful

    need help creating a function

    I'm getting an error: (user defined type not defined) error on "dim db as database". Also, I am confused on whether or not I need to include the projectID in the incoming arguments. Using the function in a query or report wouldn't it pull the data from the recordset from the...
  14. punderful

    need help creating a function

    I'm new to writing functions, and can really use your help before this project is pulled from me!! tables: projects, changeorders Changeorder table fields: projectID, taskName, due, complete, billed problem: have to be able to pull ONE of the 3 dates (due, complete, billed) for a specific...
  15. punderful

    docmd openform question

    Thanks for your help everyone!!
  16. punderful

    docmd openform question

    Can the ORDER BY go in the openargs part of openform?
  17. punderful

    docmd openform question

    First let me say - this is a fantastic forum!! I am trying to build a form that will use the value from 3 option groups (one of which is a ORDER BY), and also take the name from a combo box. What complicates matters is that the name can appear is one or more of 4 fields in the table. I can...
  18. punderful

    option group issue

    Thanks for the advice! I did use select/case the 1st round, didn't work there, either. Overall, I knew it was something insanely stupid such as an incorrect name. Option explicit!! :)
  19. punderful

    need help in retrieving specific data

    I am working on a db of projects and project details. In the project details I have: projectID, taskDescription, due date, complete date, billed date. I have to create a report thats formatted like our clients, sorted by project, listing for each project the details (like this:) project1...
  20. punderful

    option group issue

    I have an option group fraFormSelection with 3 options. The value for these options is 1,2,3. I am trying to write code that will select a form based upon the selection of the option group, placing the form name in the string strFormName for later use (to open the form with filtered records...

Part and Inventory Search

Back
Top