Search results for query: *

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

...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 Order", "Please refill the attached order", False, "" End Sub I do not understand why it is...

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

Here is the correct UPS code that gets around UPS websites check mark to agree to there terms before going to the shipment tracking: http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0&AgreeToTermsAndConditions=yes&track.x=20&track.y=8

I am building a report where the data is taken from a query. The main form that supplies the data has 12 check boxes with a small amount of text associated with each check box. I am wondering if it would be wise to construct one long IIF statement to allow the report to display the data for...

Thanks for the replies, My images are not showing at all. Or I should say images other than those that came packed with Apache in the icons folder. Any other image I try to display does not open at all. I have a feeling that it has something to do with AddIcons. Let me ask, do you display any...

I've setup Apache 2 on XP Pro. I've setup a directory named images in the htdocs folder. The web page comes up ok when I go to the URL. I can not figure why the images do not show or how to get the images to display on my web page. Any suggestions? Thanks, John

Ok great! Now it's loading with Apache. Apache/2.0.50 (Win32) PHP/4.3.7 Server at 4.4.208.11 Port 80 When I try to open a php page I get an Internal Server Error message. [Tue Jul 06 17:24:45 2004] [error] [client 4.4.208.11] C:/Program Files/Apache Group/Apache2/cgi-bin/Page.php is not...