Search results

Stupid I know...but I forget how to update a Field to itself in Uppercase.. Anyone? Thanks!

Thank you for reading this! I am not a spreadsheet person..BUT I have two spreadsheets - each have Employee ID #'s one has emails one does not... How do I "Link" the tables on Employee ID and add emails to the spreadsheet without them. I could do this in Access but this is a solution for an...

I have done this in the past but it has been sooo long since I consistently used Access that I am in a fog:confused: How can I create a timestamp or series thereof, so that each time data is added to a Memo field there is a date time record created? My goal is to allow people to enter notes...

Probably very simple but I cannot get the syntax right - it has been far too long since I used Access. I am trying to seperate a field NAME from these formats: LAST/FIRST M LAST/FIRST To two fields: Field LAST and field FIRST Can someone please help? Thank you! It is Friday and I want to...

I have an Access form linked to two SQL tables, I had to make a change to the field length/datatype of a field named notes. The form now tells me that the "text is too long to be edited" whenever I try to add data to that Notes field in my form. I went from char to nvarchar... how do I fix this?

Hello, I am really stuck - I have a form of companies with a subform of contacts. In the DB (SQL) the tables are related one to many CoKey to ContactCoKey. How do I synch these so any new contact record automatically gets a "new" ContactKey as well as the related ContactCoKey? Thanks,

Hi! I have corrected this problem once before - long, long ago - but my memory is failing me. I have a main form tabular and a subform(datasheet). When I scrooll to the bottom of my main form and hit the next record button - my subform "rolls up" over the main form, how can I correct this so...

Hello, I am trying to convert data from a standard contacts form into a custom contacts form in Outlook 2000. I have the data mapped to all standard fields and need to reassign it to the custom fields using a VBA module. I have found one example online but have had no luck getting it to...

I am in a bind. I am trying to calculate sales by month, compare those sales to what the client contracted for and look at the result as incremental growth. I can calculate monthly sales from start of Contract Date. I can subtract contracted units per month based on contract date like so ...

Is there a way in a query to only show a value that is duplicated across more than one record? Example: I have two columns Zip 1 and Zip 2 from two different tables. The tables are linked on city and state - I am trying to show a Zip overlay in a query. I need Zip1 to show only if it has...

I have a query that counts calls by date of call by user I am trying to run an expression to sum the calls by week So far I have something like: Week 1: Sum(IIf([calldate] Between #7/11/2004# And #7/17/2004#,[CountOfcallid],0)) But it is not counting the calls correctly..could someone please...

Hello, I am having an issue with the display of a crosstab query in a report. My query is based on a date renge entered by a manager Where date between[pbegindate], [penddate]. It groups by worker and branch (row headings) and displays the date(s) across the top as a column heading. The...

Is it possible to retain lines in a Report Header when exporting to RTF and if yes, how? Many Thanks, Ksaab :p

Hi friendly people :) I am running Access 2003 and office 2000 on an XP install and am encountering the following errors.. "Security warning: Unsafe expressions are not blocked" which prompted me to install new MS updates - which I did. NO use. I still get the error when I open any Access DB...

I would like to know how to make Access more able to deal with special characters found in languages other than English. I do a lot of importing /exporting from text files on an international level and haven't yet found a way to make Access keep characters well. Is this something I do at the...

I am getting this error and need immediate help...please! Run-Time error '-2147467259 (80004005)': [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.

Hello, I have several split DB's in Access 2000. Typically we use a template Data.mdb and Forms.mdb and import data into them..customize the forms..make a few .mde's for users.. For some reason the following error is happening on several PC's when attempting to open the Forms.mdb...

I have an Access mdb database with several mde "front ends" set up. It has tblCompanies where primary key = CompanyKey and tblNames where primary key = NameKey. There is a one to many relationship from tblCompanies.CompanyKey to tblNames.CompanyKey. Somehow this relationship was...

I have a series of split databases each with separate forms databases and data databases. Example: Data: Names.mdb has all the data and no forms Form: Names.mdb has all the forms and only data via links to tables in Data:Names.mdb. There are several of these setups, and each one has...

Question: How do I write a (very Large) query to exclude any updates where the "from" field is null ? Must I alter each Criteria line manually? I am lazy and trying to avoid this...can I write a script or macro to do this each time I need one of these large queries? Any help appreciated....