Search results

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

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

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

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

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

i have a small access 2000 mdb on a server. a combo box in a form populates its list with a field in a table in a sql server 2000 database. if i go through the steps and link it on one machine, the connection works, but it won't work from another workstation. i get: ODBC -- connection to...

i know there are existing threads on this, but i couldn't find the details i need using the forum's search. we have access 2000 mdb's as frontends on 35 workstations and a sql server 2000 backend. i would be absolutely thrilled if i could have the new mdb file automatically copied to the...

i have a field, FamOrTreat, in a report. the value for that field can either be "Family" or "Treatment." to save space on the report, i want it to show up as either "T" or "F" rather than the whole word. i know this is probably very easy, but i have no idea how to achieve it. help would be...

i have a table containing nearly 5,000 clients and need an efficient way to find a specific one. i want a search form where i can enter part of the name, click a button and all the matching names will be returned. from there i'll be able to double-click the name to take me to the specific...

I've done a search and was unable to find exactly what I need. I have a combo box, PerDiem, that has a list of rates that come from a table, tblPerDiemList. I have a button that opens a form, frmPerDiemRates, where you can add a rate to the list. I want to requery the combo box. The...

currently i have an accesss 2000 (.mdb) split database with security. i'm about to use the upsizing wizard to convert it to an Access project to work with SQL Server 2000. before i do that, i'm wondering if it would be best to recombine (unsplit) the DB first or if i should run the upsizing...

I want a subform to automatically display the last record when opened ( 14 of 14, etc...). How can this be acheived? Thanks.

I created an [EnteredOn] field to give a time stamp of when the record was added, and I plan on converting this field to the primary key. The problem is that I added this field after over 700 records were entered. For the existing records, I want to run an update query that fills in the...

I have a stripped down version of our DB (front-end and back-end) on a notebook computer so that certain people out of the office can enter info. I did have the VPN set up with the tables linked to our back-end, but the notebooks connect via analog dial-up. it works, but it's just way too...

I can't open my database. I get the error message: The Microsoft Jet Database engine stopped the process because you and another user are attempting to change the same data at the same time. The compact and repair utility doesn't work. Jetcomp.exe doesn't work. I have checked for an .ldb...

The SQL fragment below is the criteria for tblPlacement.DateOfAction. It filters records by ReferralID then returns only the Max(DateOfAction). WHERE (([tblPlacement].DateOfAction)=(Select Max([DateOfAction]) FROM [tblPlacement] AS t_1 Where t_1.ReferralID = [tblPlacement].ReferralID)) This...

I'm trying to run an action query using CurrentDb.Execute "qryAction" I get an error message stating that I have too few parameters and that 2 are expected. What other parameter do I need to make this work? Thanks

i'm trying to get all the records in a subform to equal [FosterID] on the main form. the following is in the onclick property of a command button: [Forms]![frmFPRecruits]![frmIndRecruit]![FosterID] = Me.FosterID when i click the button, the only record on the subform that gets its [FosterID]...