Search results for query: *

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!

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...

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...

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...

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...

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...

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...

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...

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...

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...

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!

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#?

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...

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...

Thanks for your help everyone!!

Can the ORDER BY go in the openargs part of openform?

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...

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!! :)

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...

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...