Search results

Thank you. That gave me the idea to take care of it at the query level: Coalesce([Filled], 0) AS Filled Nz isn't supported in .adp's. I found that out about a week ago. Richie

okay, the only problem i'm facing now is this: The source for the report is a query that joins [tblFosterParents] to [vwAvailCount]. The calculated field from the query that I use on the report is [Filled]. I have a field on the report [Available] and its source is =[Capacity]-[Filled]. The...

pat, thanks for pointing out my inefficient design. i took your advice, and it works beautifully and SO much faster. richie

Thanks, but I couldn't get either of those work. just to make sure I'm not crazy, I went back to the mdb file where it worked, and it was just like the first example in my post. i remember just playing around with the syntax of that until it worked. there's got to be a way to make it work in...

Thanks a lot. It'll take me a little while to set up the way i need it. I'm sure I'll be back needing some help with dealing with the calculations to keep inventory straight. Richie

this works in my Access (.mdb) report as the control source for an unbound text box: =DCount("*","[qryCurrentClients]","[NewResidence] = [Report]![rptAvailability].[Identification]") ...but it doesn't work in the Access project (.adp) environment. i've narrowed it down to the way I'm...

Thank you. It now works exactly as I want it to.

I forgot to mention that I'm working with an Access project (.adp) frontend. That IS a lot simpler, and it works. Thank you. Edit: The only problem I have with that is that it filters the record. if i leave the form open and double-click on another name, nothing comes up. Maybe a find...

The double-click part of this is written in DAO. I need to covert it to ADO to work with our SQL Server 200 backend. Can anyone help? It's a lookup form. When an item in the list is double-clicked, a form is opened to the specific record. Thank you. Hopefully with this knowlege, I'll be...

thank you very much. i guess the last table i have to create is a transactions table.

thank you. i still have trouble using & in Access projects. is it because the data type is nvarchar? i get this error when trying to concatenate with &.

thanks for your help. it pointed my research in the right direction. i believe you must use + instead of & in Access projects (.adp). also, access projects do not support the Nz function. i found out that you can use the coalesce function instead which returns the first non-NULL expression...

I'm not sure what the best way to set this up is, and I'm hoping someone can point me in the right direction. I have a long list of different parts that I have acquired and taken inventory of. I am selling kits that contain different amounts of certain parts. For example, Kit 1 contains 2 of...

Access 2000 project. SQL Server 2000 backend. here's my problem. in data source query for a list box, i concatenated first name and last name fields to show up as one. when one of those fields is blank (LastName or FirstName), the spot is blank in the list. i can still click on it, and it...

okay. it seems like that was the problem. thank you. i included AutoNumber in the query, but i got a different error: "3622-You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an Identity." i forgot to mention that the backend was a SQL Server...

i modified this code to suit my db (unsuccessfully) based on a db (MembershipV3A2K.mdb) that pat hartman posted in another thread. my intention is to be able to select multiple choices in a list box and append records with the click of a button. here's the code: Option Compare Database Option...

thank you. that helps a lot. richie

sorry, i may not have explained it exactly right. there are times when a home (main) is "Active," but one of the individuals within a home (sub) is not. but when the home is deemed "Inactive," all of the individuals within the home should be automatically marked "Inactive," as well. thanks.

i have a main table: tblFoster and a linked table: tblIndFoster they are linked as such (one to many): tblFoster.Identification ---> tblIndFoster .FosterID there's a yes/no field called "Active" on tblFoster where if it is changed to "Inactive" or 0, i want the field "Active" on tblIndFoster...

using Access 2000 in an SQL statement, i have: [Enter Date] AS PlacedDate DateAdd("yyyy",1,[PlacedDate]) AS 1Year DateTraining what i want the query to do is to show only the records where DateTraining falls between PlacedDate and 1Year. i've tried: Where DateTraining Between PlacedDate AND...