Recent content by johngordon

Could I use conditional formatting to set an ID field to red when a record is locked and green when it's not locked?

Greetings all, Here's my problem... I've built a small Access database that I placed on my server. I have one workstation connected to the database. The folder that the database is in on the server is shared and I've mapped the path to the database on the workstation. The advanced tab of the...

I need to remove the # (pound sign) from all of the records (9000+) in a table field. I have tried using Find & Replace, with no success. Does anyone have any other ideas on how to do this? Thanks, John

Actually your reply made me think about what I was trying to do. I finally used the following as a solution: rs.FindFirst "[ClientID] = '" & Me![Text73] & "'" Thanks for the quick reply!

DAO

Greetings, I use the following code to update a form based on a Name selected from a combo box: Private Sub Text73_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[LastName] = '" & Me![Text73] & "'"...

Greetings All, I have a 2000 db that is split. The front end(s) reside on several work stations and the backend resides on the server. On one of the forms there is a sub form that allows the users to link to scanned documents. The scanned documents reside in a seperate folder on the server...

I have a Access 2000 db with a front and back end. There are 15 users accessing the back end. The back end is on a Win 2000 server and front ends are on Win XP Pro workstations. In Tools > Options > Advanced I have each users front end set to: Default open mode: Exclusive Default record...

I am trying to pull all records that are greater than a date set in a field named [yearEnding] Can someone help me with this one. I have tried using different date criteria as listed in Access' help files and have been unable to make it work proplery. Gracias, John

Can Me.ShippingMode be changed to reflect a field from a table? ie [For] field of the [tblQuestionnaire]table. Mucho Gracias Again! John [afro]

I want to set the value of a field [For] based on a not null value of another field [ShippingMode]. How can I do this? Mucho Gracias! John [afro]

Hi and thanks for responding, The PharmacyEmail variable comes from a table field. I am using this same type of setup in another part of the db and it works fine. In this instance I am trying to email a report from a sub form that is getting it's data from a query. I have a small variable...

I left one thing out. The send object command button is located on a sub form if that makes any difference. John

I am trying to use send object to email a report. The problem I am having is that the report will only mail once. I have attached the code that I am using: Private Sub Command42_Click() DoCmd.SendObject acReport, "rptPharmacyOrder", "HTML (*.html)", PharmacyEmail, "", "", "Express - Refill...

I would like to get the sum of the field "ServiceFee" in a form based on "BillingID" and "OrderType". Anyone have any suggestions on accomplishing this small task? Happy Holidays! John