Search results for query: *

I have a text field using a Combo Box lookup. The values been displayed are queried from a table listing the possible values. If the user types a value that is not listed is it possible to have that new value added to the table so it will be displayed in the combo box in the future? Thanks.

I just picked up a PPC6700 and am trying to get it to sync via exchange activesync. I'm running Exchange 2003 SP2 on a Windows 2000 Advanced Server SP4 machine. Everything looks like it is configured correctly however when I try to sync I get the following error on my PPC: Your account in...

I have had this problem for the last while where 2 WXP workstations can not update their roaming profile to the WIN2003 DC. This is the error from the event log Event Type: Error Event Source: Userenv Event Category: None Event ID: 1509 Date: 2005-11-09 Time: 8:39:57 AM User: DOMAIN\jeremy...

I have a form that a user fills out to specify the criteria to run a query. It then generates reports based on the queries. I now have a new query that rather than being used in a report needs to be exported to Excel and e-mailed out. If possible this is what I am trying to achieve: 1. Run...

I have a report that works great for records entered this year. I enter in the start range into a form with an unbound text box txtstart and the end range into an unbound text box txtend. I then select the report I want and it selects the appropriate query and runs the report. I am now trying...

I'm a little bit lost here so any help I can get would be appriciated. I need to query some records containing specific text in a memo field. When I try to enter into the criteria Contains "text" I get an invalid syntax. Is there a way that I can query these records? If you need further...

I am having trouble with a query that is used for retreiving Year to Date information for a report. The user enters in date range information in Forms!RunReport. This form contains three unbound text boxes: txtyear, txtstart, txtend. This date information is used to run the report. In qryYTD...

This sounds easy but for some reason I can't seem to get it to work. I have an unbound text box. When the form is opened I want it to display the current year. I do not want the month or day in this text box. If you know how to do this I'd appriciate the help Thanks

I am running a report based on a query which requires the user to input a date range (Criteria: Between [start]AND [END]). This report displays the information within that range and sums the financial information. I am having trouble with two items. 1. How can I display the date range...

I've been using an access database where until recently if I hit <ESC> all that would happen is the information in the current record would be cleared if the record had not been refreshed. If the record had been refreshed the <ESC> key wouldn't delete that information. Now when I hit they key...

I'm working at specing a server for our office and am debating going with dual Xeon CPU's or a P4 EE. The server would be running Windows 2003 Enterprise Edition and MS SQL Server 2000. Looking at 5 SCSI HDD's running in a Raid1/Raid 5 configuration. If you know of any reasons why one CPU...

On my main form (frmApplication) I have a delete records button. The onclick command is to open a popup form that prompts the user for a password before deleting the record. I have the correct password stored in tblpassword. I've taken a shot at the code for how to delete the record from the...

I'm just looking for some input on the best way to avoid users from deleting records in my database. I'm trying to avoid having to use logins so if you know of any good ways I'd appriciate the help Thanks -Jeremy

In my main form, frmApplication, I have a command button to open frmAdminReview with the following code: Dim stDocName As String Dim stLinkCriteria As String Me.Refresh 'refresh the record stDocName = "frmAdminReview" stLinkCriteria = "[AdminReviewID]=" & "" &...

Is it possible to export a report in access to MS Word? So far the best option I've found is to export it as an HTML file however that's not the solution I need. If you have any idea's I'd appriciate it. Thanks -Jeremy

Using Access 2002 I have a memo field in a table that loses all text after 265 characters after I tab out of the field. It does this when I enter the text in the form or directly into the table. The help file says that the memo field stores up to 65,000+ characters. Would anyone know why my...

I have no idea how to code this so if you can help at all it would be greatly appriciated. I hope my explination is clear. Using: Access 2002 I have an application form that is the same for two different types of applications (information for both apps is stored in tblApplication). The...

There is probably a simple solution for my problem however I just can't seem to get past it. I am trying to Query a table to show all the records where the value of field is Null. When I put ="" in the Criteria section I don't get any records. When I put <>"" then all the records that have...

I'm very close on completing my db and puting it on my network for use. I have some plans for some possible additions down the road to the db. Is there a way to place a working copy of the db on the network but keeping a maintenance copy on my PC to work on and then when I've completed an...

I've been searching the site for this one but I can't seem to find exactly what I'm looking for. I have a form that I want filtered so that when it opens, only the records with a check box value "true" will be displayed. at the same time, I would need to be able to enter new records with this...