Search results for query: *

I get data output from an online application. Basically it’s name and address. Since the data is being entered by the general public, there are no standards as far as using Proper Case or Title Case in any of the fields especially the Address Field. I get the data in Excel and I fix it using...

Hello: I'm cleaning up a ton of data and I've imported a number of Excel spreadsheets into my database. One of the fields is "PHONE" and, after spending a lot of time fixing messy records, I see that many of my phone numbers have taken on some weird formatting. The original field in Excel was...

Hello: I need to import customer records into a database. I am given rows of data that looks like this: PREFIX;FNAME;MNAME;LNAME;ADDR1;ADDR2;CITY;STATE;ZIP;PHONE;EMAIL Mr.;John;M.;Smith;123 Main Street;Apt.4;Anytown;PA;18331;6106812323; Mr.;John;M.;Smith;123 Main...

Hello: I have many users who share Outlook calendars. Two of my users both support the same supervisor and manage her calendar. The calendar is shared properly and both can edit and work with it just fine. The problem is, both these support users get all the supervisor's meeting invitations...

I have an Access 2003 db that runs just fine in 2003. But my company has upgraded to Access 2010. I made many modifications to the db and it was fine until, for no apparent reason, Access relayed the message "Microsoft Access has stopped working". Then it says "A problem caused the program to...

I'm running Office 10 in Windows 7 and I cannot either embed or link any audio file to a Powerpoint presentation. I have tried *.wav and *.mp3 and *.wma. Same results with each. Powerpoint just freezes and says "Powerpoint is inserting media". Nothing happens, application freezes and I have...

I am writing a simple query to pull all customers whose record was updated yesterday. My date field is date-time (4/16/2009 9:30:12 PM, for example). With a short date, I can just do date() - 1 for the criteria but I don't know what to do with a date time field. Any suggestions would be...

I want to query fields where there is a Space followed by a lowercase character. If I use criteria like: Like * a* I will get all entries with a space followed by an upper or lowercase letter "a". What can I enter in the criteria field to select ONLY space & lowercase "a"? Seems like it...

If I have named a query something like Query1 and used that query in other queries, is there a way of renaming the original Query1 to something that makes more sense and have it update wherever that query is used. So, for example, if I rename Query1 to be qryCustomer, is there a way of...

I must have changed some default setting (Access 2003) but "most" of the time now when I am closing a form to which I have made changes, I don't get the "save" dialog box. The form is saved regardless of whether I want to save changes or not. And, now today, when I close a query that I don't...

I am querying a table of salutations. I want to pull signor (salutation type) 2 if it exists or choose the default salutation if no signor 2 exists. I tried an iif statement sort of like this: SELECT IIf([signor]=2,[esal1_desc],IIf([default_ind]="Y",[esal1_desc])) AS Expr1 FROM TX_CUST_SAL...

I have a form that has a control button. The button's Event Procedure turns off warnings, saves the record, runs an append query and previews a report. It ran without errors yesterday. Today, I modified a table to add some new fields and then added those controls to the form (they were not...

I'm getting the error message when I enter data in a field on a subform: "The object doesn't contain the automation object tblTEST". The form is based on a query. Here is what I am doing. My main form has Actor Info. My subform allows the user to choose what scenes he's in by entering the...

Sorry my Subject sounds so cryptic. What I need is probably very easy... I have a table with CUST-ID, AMOUNT, DATE, REF_NO. I want to pull, for each Customer, the most recent item and report all 4 fields. I did: SELECT CUST-ID, Max(DATE) GROUP BY CUST-ID and do get the most recent date...

Hello: I am trying to query out just the last name from a "greeting" field. For the entry "Mr. Carlos A. Gibson", I just want "Gibson". Any assistance would be greatly appreciated. SAW

My question is about how to display the contents of a combo box on a form. I have a combo box that looks up the values in a table. The table (tblKeyWords) has only two fields ("KeyWord_ID" and "KeyWord"). I really only want the field "KeyWord" to display on the form. But I also want the user...

I have two queries pulling data from two tables. First pulls Money Pledged. Second pulls installments paid on the Pledge. I have a table that these append queries write to. Later, I use this table to query and perform subtotals, etc. It's very complex and a bit difficult to explain so let...

I have a report that is sorted on an alpha key. I want to begin each alpha section printing on the next odd numbered page. So, if the "A" section ends on page 11, I want page 12 to be blank and the first page of the "B" section to be on page 13. The reason for this is that each section (it's...

This is really peculiar. I am creating a very simple little db to demo how my user can store info. When I create a form with the Pop Up property set to Yes, the form will not retain the size it was in design view. I have created dozens of Access dbs (of one sort or another) and created...

I have a macro that creates a new record and then opens the form to display the records. The form opens to the first record. I want it to open to the record I just created. In the "where condition" of the open form step in the macro I tried a variety of methods to make [tblCustomer]![CustID]...