Search results for query: *

Hi Guys, I'm looking for one of two solutions. I have a spreadsheet that has peoples names in column A, but this one cell contains the whole name (Mr Bob Jones). I need to remove the "MR" part of the name, so I can conduct a vlookup on just the name and surname. I've tried doing a text to...

Hi All, I'm trying to create a form that has drop down lists and blank table cells for text entry, but when I activate the drop down lists by protecting the document, the ability to enter text is taken away. Any ideas on how to do both in the same form? Many thanks Phil

Hi All, I have a form that is used to take card payments, and I would like it to calculate the charge amount based on the type of card used. The fields on the form are: Card type - combo box Net amount Charge Total amount I thought I could use an IF expression to say that "If the card type is...

Hi everyone, I have very basic knowledge of Access, so please bear with me. I have a database which is used as a small questionnaire. The only information collected (in one table) is Employee Name, Employee Number and then the answers to Question 1 to Question 30. Each Question field is linked...

Hi all, Whenever I send a report by e-mail, any images or lines/boxes that have been added do not appear. The only items that appear are the bound and unbound fields of the report, and text boxes. Is there something I can change in the properties to make sure that images remain on an e-mailed...

Can anyone translate the following into plain English for me? I sort of get the gist, but I need it clarifying. It appears when I try to enter an ID number into a form field. "The current field must match the join key "?" in the table that serves as the 'one' side of one-to-many relationship...

Hi all, Having trawled through the forums to no avail, I wonder if anyone can tell me how I can get the fields on a form, to populate a table. I have a very basic database that tracks customers and their orders. I have a customer details, product details, travel costs, and employee details...

Hi All, Is there a way that I can change the text box on my parameter query to a combo box, so rather than type in a parameter, the user can select one from the drop down list? Many thanks Phil

Hi all, I'm trying to design a form that allows users to enter a part number, and have the description and price populate automatically. I have designed a query from 3 linked tables (Customer, Staff, Products) which works wonderfully if there is only product to be entered. If I try to use the...

Hi all, Can anyone tell me how to resolve this error: Unable to open "www....." Cannot locate the internet server or proxy server. The error message apperas when I try to click a hyperlink I have created on a form. Any ideas? Phil

How can I get my switchboard to appear maximised upon opening. Currently it opens in standard view. This is the on open code: Private Sub Form_Open(Cancel As Integer) ' Minimize the database window and initialize the form. ' Move to the switchboard page that is marked as the default...

Hi all, I have designed a form to display the reults of a parameter query where the user inputs part of a word to find an item from a stock list. Because the stock list is so extensive, there can be too many results to scroll through quickly. Can I somehow run a second query on the results from...

Hi All, Does anyone know if Access has the ability to include a diary which allows you to book meetings etc, with the ability to review the diary and amend if necessary. If so, any help on how to build one into my database would be appreciated. Phil

Hi everyone, Is it possible to format the text boxes on a report (populated by a query) to only be visible if the word in the text box is "yes"? Many thanks Phil

Last one tonight I promise. Is there any way of having more than 8 items per switchboard? Phil

Me again, I have a form that contains order data, taken from a parameter query so I can view a particular order and update it's status if necessary. I have found that if I set the forms properties to "Data Entry - Yes" so I can make changes on the form, it does not appear when opened. If I set...

I'm trying to run a parameter query, using the Order ID field as the data to search for. The Order ID field is an auto-number field, and when the query runs, it returns no records. Is there a way around this? Many thanks :->

Hi, As a new Access user (I know I started late !!), I would like to know if it is possible to have one command button on a form that will open up a seperate form and close the existing one when clicked so that the user doesn't end up with a load of open forms on screen. Many thanks