Search results

Excel 2007 Once again I have been asked to do something in excel - anyone that knows me understand that I do not get along with excel :banghead:. VB and Access yes - Excel just messes with my mind :banghead: Ok here is what I need to do I have two sheets. Sheet1 has 4 columns... Customer...

Access I understand - Excel I am almost clueless in :confused: I have 3 columns in a spreadsheet. Column A is numbers (1234), Column B is numbers (4321), Column C needs to have a formula that returns true of false based upon the numbers in Column's A and B. If possible this needs to look at...

I am using Excel 2007 - most of the company is still on Excel 2000. I can do this rather easy in Access however, the Boss man wants it in excel and I have basically zero knowledge of excel. Anyways what I need to do is this. If you look at the attached sample you will see a sheet called...

Here is what I need to do… I have a table with 8 columns… Date | Order Number | Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | Item 6 | How can I look at the Item 1 thru Item 6 columns and see how many times Part Number 45666 and 54667 were purchased together? The Part Numbers...

Here’s my question/problem: Let’s say I have a field in my table containing social security numbers. However on my form and report I only want the last four digits to show… How do I do this…? I can not for the life of me remember how to do this… Thks in advance, Don

This is one of those that will most likely turn out to be easy but, I can’t for the life of me figure it out… Here’s my problem… In one column in one of my tables I have about 61 different numbers assorted throughout some 50000 records. What I need is an update query or something to change...

I have reports of two different types… One type can be printed on plan paper (Tray #1)… The other needs to be printed on letterhead (Tray #2)… I know how to do this in the properties of the printer; and in the page setup on each report however, in the long run I think it would be better doing...

What I am trying to do is this: If the DateDiff between Today’s Date and a date entered in the NextSchContact field is say <= -90 then I want to put a message in an unbound field called Message. If the DateDiff is <= -180 then I would like a different message to appear…I can make it work by...

Ok I give… After reading numerous postings on “listbox” I still have no ideal how to do what I would like to do or, even if it’s possible. I would assume with the capability of Access almost anything can be, if you know how… I may have over looked a post that answers my question. If this is...

Is it possible to pull info from a table into a msgbox... I have a msgbox informing them that the record has already been added...I would like to tell them by whom and on what date... I have two fields I'd like to pull into the message... CreatedBy & EntryDate I'd like my msgbox to be...

I am not sure if this is a Query or Form Question...Maybe both... Here’s my problem… I have a SubForm based on a query. The query is designed so that only the current users records are shown. On the SubForm I have an AfterUpdate Event on the PhoneNumber field, to help Prevent one...

Here's my confusion... I have a form which contains 6 zipcode fields (ie... Zip, PrevZip, EmployerZip, CoZip, CoPrevZip, CoEmployerZip) I can use the code below on one field and it works great...However I can not get it to work on more then one field in the same table... I have even tried...

How does one take away the ability to edit a form by right clicking on it? I am using "DoCmd.ShowToolbar "Form Design", acToolbarNo" on an On Open Event to take the menu bar away... However I still have the ability to right click and edit the form... Thx... Don

I want to create a form that prompts for a username and a password. Can someone help me get going in the right direction on this, or send me an example database on how this works...? I've had no luck with it...

This is a two part Request... Part 1... I want to create a form that prompts for a user name and a password. Can someone help me get going in the right direction on this? Part 2... I am trying to build a prospect/contact database. I would like everybody to use the same database to enter...