Search results for query: *

Thanks everyone - xlhelp's formula works a treat. I'd never even thought about find and replace macropod, but will try this too as it may be something to remember for future. Thanks Phil

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 both LameID and TheAceMan1 and thanks for your suggestions. I did warn you that I was very basic at this, but I have tried both your ideas, and not had much luck with either. I think the problem that I am having, is that there are 30 fields in my table, all of which can be populated with an...

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...

Thanks both for your advice. I will definately look into Snapshot

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...

I'm using Autonumber to generate the original QUOTE ID in the quote table. The quote table and the Invoice table are linked by Quote ID (Primary key to foreign key), and using them I have created a query that gives me the fields for the single form. (where the error occurs) In the instance...

Hi AceMan, Since I made my post, I've been trawling the web to find a solution, but to no avail. I understand what you're saying (which seems to be the general consensus elsewhere), but I don't understand why the database thinks there is no record. The main table "Quotes" contains the...

Thanks for that. I have tried deleting the links between the tables, but that just prevents the form from working altogether, as it cannot locate the records it needs. The set-up is as follows: A main quote table that has QUOTE ID as it's primary key. This is linked to another table that I use...

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...

Many thanks for the advice. In addition to the "calculated" fields on the form not populating the table (due to them being unbound as you suggested), there are two other fields that also remain blank in the table, although populated on the form. I have a table called Products containing Product...

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, Thanks for the replies so far, however I'm not sure I understand !! Maybe my initial description was not full enough, so I'll tell you how it all links together. I'm actually using 4 tables: Customer: Includes name & address data, with a Customer ID as the primary key Staff: Includes name...

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

Simple really !!!! Many thanks

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...