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

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

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]

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

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

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

I've installed Apache 2.0.5 (Windows Installer Package) and PHP 4.3.7, I'm running XP Pro. Apache is up and running no problem. I've read everything I can find on configuring PHP and have done most everything I have read about. I still can not get PHP to interface with Apache. Can someone help...

I am very new to Perl and CGI. I know how to create a login page and pass the Users variables along using ASP, however I don't know how to do it using PERL. I've figured out how to install Perl, DBI and get a DB connection. Now I some help, my project is stalled at the Login page. I have been...

Greetings all, I do work all day long in my database, creating invoices and reports. At present when I complete each record entry or update I print the invoice and or report. What I would like to be able to do is print everything in batch at the end of the day or perhaps from a command...

I use the following code to create record numbers for my database: =DMax("[ID]","Process")+1 Works ok in a stand alone enviorment, but in a multi use enviorment it seems to not work so well. I do not like using Autonumber and would like to use a simple numbering system like Autonumber. Can...

I have a command button on a form that when clicked duplicates specific data into a new record. I would like to have a message box pop up and ask the user if they want to continue, giving the user a choice of OK or Cancel. Can anyone help me and give me some guidance with making this happen...

My main form is a tabbed form which I designed at 800x600. How do I get the form to open at 800x600 no matter what resolution the PC is set to. Example, if my PC resolution is set to 1024x768, I would want the main form to always open at 800x600. I have checked the FAQs and several threads on...

I have several tabs, of those three have sub forms. How do I set the tab to the first field of the sub form when the tab is in focus. Thanks everyone! John

I need some guidance. How well would this autonumber do on a network? = DMax ("[YourFieldName]","YourTableName") + 1 If I enter a record based on the above expression, and someone else on the network enters a record, does the next higher number come from the table or from their form? I am...