Search results

wish to a report to a selected client's email address where the client (Client ID) is selected by the user from a combo box. I have tried DoCmd.SendObject acReport, "Report for selected client", "PDFFormat(*.pdf)", "[ClientID]=”&ClientID, "", "", "", "subject", True, "" which leads to an...

I wish to a report to a selected client's email address where the client (Client ID) is selected by the user from a combo box. I have tried DoCmd.SendObject acReport, "Report for selected client", "PDFFormat(*.pdf)", "[ClientID]=”&ClientID, "", "", "", "subject", True, "" which leads to an...

Thank you again John. I have put a text box in the form and when after the user enters a postcode into the text box the focus is set to the combo box and the .dropdown property forces that list to appear and the query behind that combo includes the criteria [Forms]![PostcodeAndSuburbs]![pc]...

Thank you John. Yes it does as you suggest of course. Now I have to work out how. Something to do with the text box(es). But the query behind the suburbs gets the value from Combo0 which is the state not the postcode. I shall keep looking.

Big John helped as the .dropdown forces the list to appear - so that is useful. But the interface that he provided has choosing the state which populates the second dropdown with all the suburbs of that state and then the user chooses the suburb. Whereas the more common process these days is to...

Thanks for the reply. The sample here doesn't do what I was seeking. I wish to make able to make an interface where the user types in the postcode and then suburbs are shown in the list matching that postcode. As per many webpages these days when you enter a postcode. The .dropdown property...

thank you, but i think i have done this and I get an error Could not delete from specified tables The (Access) SQL I have is DELETE Clients.* FROM Clients INNER JOIN [ClientsOld] ON Clients.[Client#] = [ClientsOld].[Client#]; so I still have the problem

How do I delete specific records in a Clients where I know all the Client#s to be deleted, known from a query / a table made from the query. So the new table has (called OldClients) Client# so I want to delete all records in Clients where the client#s match between the Clients table and...

I wish to add to a form the interface that allows the user to type in a postcode and the system then displays the suburbs that match that postcode and the user then selects the correct suburb (for where they live). The structure I have is a PostcodesAndSuburbs table with the fields Postcode...

Thank you for your reply John, but I want to use value in a field on one record within the subform so trying Forms!SubformName.FieldName gives me the Enter Parameter Value dialog box unfortunatelt

I wish to run a query where the criteria for the query is the value of the text box where the cursor is I know how to get the value in the text box Me.[textboxname].Text but I don't know then how to correctly use this as the criteria in the query NB: the value is in a text box not a combo...

Hi I have a database system into the back end and front end and then created the accde file with the front end file to give this to users on their computer. The back end being placed on a server with a path of type \\servername\folder I have used the Linked Table Manager to point to the tables...

Thank you Pat, much appreciated. I have also found in addition to your advice is to also include the SaveRecord method on the button on the first form that activates the second form opening. Touch-wood, all working now.

Hi I have two tables where one Client has many jobs - and I have a switchboard with a combo box showing the existing clients where the user selects a client and then opens a Jobs form to enter a new job (Add mode) and so the user types in the details of the job but naturally I want the job form...

thank you kindly

I have two combo boxes on a switchboard where the second is based on the user's selected value in the first box. The values in the second combo box are determined from a query which gets the selected value from the first combo box. This works fine from scratch but how do I refresh the values in...

Hi Whilst I know how to open a form based on the value selected from a combo box (selecting a client) on a switchboard, I then want the second form to have a combo box (based on the selected value from the combo box on the switchboard , i.e. the contacts for the client) and to then be able to...

Hello from Adelaide, Australia. I teach students database systems using Access and I have developed a system for a business which I'm updating and I am running into issues so hopefully I can find some answers from people in this forum. Peter