Search results

Doesnt seem to work :/ Tried creating a button with the code on click but no joy

Hi, I have tried various suggestions on here as to refreshing a subform but they havent worked - i guess that is because my form is different and doesnt have any filters etc I have a multi tabbed form and the particular tab in question has a button that imports new data to a table that is...

Hi, The form is indeed bound to the table - if I have understood you correctly though is there no way to show the information whilst in the form but before leaving the record or closing the form? I'd be concerned that if someone enters the wrong account number by mistake then the wrong...

Hi, Still rather new to access - was wondering if it is possible to update some fields on a form while data is being entered - specifically to pull client name and surname from an odbc linked table when an account number is put in - to save entering the name by hand and any errors that could...

Hi - sorry you are right - shall try to explain better.. The database processes product spend and credits - source data is provided to me and unfortunately can not be altered - this source data is unfortunately not all that accurate as it is just a dump of 'what has happened' so includes wrong...

.. I need to restrict 'usage' of the second table so that when a match is found the particular line in the second table doesnt get used again (as you can tell i am still rather new to access) Is there some easy way to do this? Or am i going about this the wrong way with a join? Thanks :D

Hi, I have been asked to build a database to capture client information - the difference being that the data would need to 'update' every day (or period) itself, where as I am used to only building databases that I control - eg transferring data, manipulating with a query etc. As an example...

Think ive got a working solution with update queries Will look in to understanding recordsets better though - thanks for the help :)

Hi, Not sure if this would be best tackled as a query but struggling with how else I could go about doign it. What I want to do is add a £100 charge to orders that are delivered - but I want to build this in to the price of the item ordered rather than showing it as a delivery charge on a new...

Thanks vbaInet - much appreciated :)

query level - the query is then used as a source for a pivot table and the names need to be anonimised

I dont unfortunately have the client name split out to first/middle/last as I am importing off data that is given to me :/ What about selecting capital letters? is that just as long winded and inaccurate?

Hi DCrake, Thanks for the info - does that function need to be used in vba ? I was hoping to use something that could go in to a select query (says undefined function when run) Cant seem to find any google results either besides for people having trouble with the LEFT and INSTR functions as...

How can I create an 'anonimised' field for a client's name (eg Joe Bloggs) to something like just the initials (say J B or JB)? Need something like this excel formula but for access: http://chandoo.org/wp/2008/09/02/get-initials-from-name-excel-formula/ Many thanks :)

Hi, I just get all the results back including the ones where the two account types match SELECT * FROM [Customers] INNER JOIN CMI ON [Customers].ID = CMI.ID WHERE CStr([Customers].Account_Num) <> CMI.Account_Num; CStr as customers table account num is a number field in access where as...

Hi, Still rather new to access but have some sql experience.. using access 2003 Have two tables inner joined in a select query (customers and client_index) and both have a field called account_type. client_index will have the most up to date accout type and so i want to select all the lines...