Search results

Hi, I have a replica database in Access 2000. I changed a form in the design master that had nothing to do with the date or a date field. Everything appeared fine. Now I updated the replicas, and an error is happening on all replicas as well as the design master. Any reference to Date() or...

With this code, I can open Word and Excel files, but not PDF. Please let me know what I'm doing wrong. (I tried changing strProg = "C:\Acrobat.lnk" including to a .exe file but nothing happens when I click the Open button) --------------------------------------------------- Private Sub...

Love this forum! It orginally helped me build a database to manage customers back in 2002 (using Access 2002). Becuase of our slow server, I was forced to spilt the database and it's been great for years (some glitches). Recently one of the users upgraded to Access 2003. When he sync's to the...

When users logon, sometimes they see a Popup Error Meesage: "This member of the replica set has conflicts from synchronizing with other members. Do you want to resolve the conflicts now?" I need them to click NO. I resolve the errors on the Master, when they update the briefcase, the conflicts...

Easy Questions? I created a button that runs a Macro to do the following: 1. OpenForm (Form Name: Business) 2. ApplyFilter (Where Condition: [Business]![City]="Columbus") It works fine, BUT I want to get away from Macros and write the code. So I assume I write the code using the On Load...

I have a button on a form that allows users to preview a report. I added "Anaylze with Excel Button" to the menu bar so users can open it with Excel after they view it in print preview. How do I write the code for the button on the form to Open directly to Excel? THANKS!

Greetings All..... I'm still new but doing OK. Thanks to a big part of this forum. I would like to add a drop-down date. I read on this forum to use ActiveX Microsoft Date and Time Picker. I selected Tools from the Top Menu bar, then clicked ActiveX. I scrolled through the ActiveX Controls...

I have an Address Field I want to seperate into two fields. So I created two more fields and populated it with the Address field. 1) StreetNo 2) StreetName Then I did an Update Query to remove the street numbers. I used the following in the Update to...

I'm using Access 2002. I have a subform that has a "Date" field. In the Form Properties, in the "Order By" box, I put the word "Date" It now sorts by "Date" - Ascending Order. 1) June 1st 2) July 10th 3) August 5th I want the sorting order to show the newest entry first. Such as: 1) August...

I'm using Access 2002. How do I disable the F1 - F12 Keys? Thanks

Another Rookie needs help! I'm using Access 2002. I have a MAIN table with 100 records. The field names are "ID", "Name", "Status" The "ID" field contains numbers 1 through 5. Therefore each "Name" has an ID of 1, 2, 3, 4 or 5. Their "Status" is either Customer or Non Customer. Through a...

Another Rookie Question... My forms are built from the tables. 1) My mian form is "Companies" with 2 subforms 2) One subform is "Equipment" Single Form View 3) The other subform is "Financial" Single Form View "Equipment" is related to the "Company" by DunsNumber "Financial" is related to the...

I don't know if this is a Form or Query question, maybe neither? a) My database had 7,000 records. b) Performance was acceptable when I used a form to review/edit records. The form source is a Query. c) I added 80,000 records. e) The performance dramactically decreased. It now takes 4...

a) My database had 7,000 records. b) Performance was acceptable when I used a form to review/edit records. The form source is a Query. c) I added 80,000 records. e) The performance dramactically decreased. It now takes 4 seconds on the form when I go to the next record. f) This will be a...

I read that you can improve performance by using a saved Query instead of a sql Query. Rookie Question...how do I make a Query I created using the Wizard a Saved Query? My problem.... When my table has 7000 and I use a Query to bring it in the form, the speed of going to the next record is...

I'm trying to increase speed. I did all the common tasks, such as changing field types and compress and repair. 1) The database has a Table with 7000 records. When I open a form, I could press "next record" and go to the next record in less than a second. 2) I added 80,000 records. Now when I...

I'm planning on using the Security Wizard. But I don't know if there is a better alternative. I need to set up logons for 25 different users. Each user can only access their assigned data. The manager can access all data. What is the best way to incorporate user security/logon's? :confused...

I'm using MS XP. Can a Date I enter into my Access db automatically be sent to MS Outlook Calendar so I receive a pop-up message reminding me of the appointment? If so, how? thanks!