Search results

Hello all I have a report with a subreport which I want to export to excel. problrm is, it is exporting just one line of the data. When I preview the report, it contains all the information I need but in the excel sheet, it contains just the first line of the firstpage of the excel sheet. Is...

Hello All, I am trying to run this code: Dim strIn As String Dim rst As DAO.Recordset Dim strSQL As String Set rst = Me.RecordsetClone Do Until rst.EOF strIn = strIn & rst!ChildHSReferenceNumber & "," rst.MoveNext Loop If Right(strIn, 1) = "," Then strIn = Left(strIn...

hello all, I am building an application that is supposed to run from a shared server. I am about to conclude the development but I am not sure how to release it for use. I have created the startup options and copied the application to the shared server but when the other users open the...

Hello All, I am working with a form which has a combobox with which I display all the addresses on my system. The user is able to search thru to find an address. If the address does not exist, the msgbox pops up asking if the user want to add the new address. If the user says yes the a new form...

Hello guys, Please I need your help!!. I have pull up some records from my database. Now I want to set a property to yes. for example, I've pulled up records for clients who need to receive a letter. After the letter has been printed correctly, I want to set the status of the letterprinted field...

Hello All, I need some help. I am trying to run the following code and I keep getting the error message " A RunSql action requires an argument consisting of an SQL statement". I have no idea why its not recorgnising strSQL as an SQL statement strSQL = "SELECT COUNT(*) FROM HSMum WHERE...

Hello All, I am wondering is it at all possible to combine results from different queries to display them in one control like a list box.? All the records will be linked by an Address ID but they reside in different table e.g mum, child, carer all with the same AddressId. I want to run a query...

Hello all, I am trying to create a search form with the following code: Dim stDocName As String Dim stLinkCriteria As String Dim strFilter As String If (fraKeywordType = 1) Then 'Family name stDocName = "frmSAHSearchResults" strFilter = "[SAHCarerLastName]='"...

Hello all, I am looking for a way to generate the next number for a reference number field. I want to be able to get the ref.number for the last record in the table and then increment by some factor maybe 1. many thanks for your ideas.. TY

Hello All, I have a form from which I want to print out a report. Right now, when I click the button, all the records print out. i want to print only the record that is currently being viewed. How do I set this 'criteria'? thanks The code behide the button is as follows: Private Sub...

Hello All, This may sound bizzare but I have not been able to fine my way round it!! I need to add a criteria to my programme to select records for children who have turned 6 months in the week ending a particular date. i.e if i put in this friday as the date, I want all records for children who...

Hello All, I have to write a query in my application to select some records. When these records have been selected, I need to access each record and update a particular field. I think this is done thru Recordset but I have no idea how to go about it. All I need is how to retrieve the ID for each...

Hello all, I have the following code running and keep getting the above error. all looks fine to me . can somebody please help? Private Sub cmdShowRecord_Click() Dim rs As DAO.Recordset Set rs = Forms!frmSAHCarerdetails.RecordsetClone Call rs.FindFirst("SAHCarerReferenceNumber=" &...

I have created a report based on a query. I now want to access the records selected by the query i.e the records that show up in the report and update the printed field from no to yes. how do I do it. My thinking is to use a while (!EOF) Do... Statement. But being a vb newbie I dont know how to...

Hello All, I need to extract some records from my table based on a particular date. for example I need to extract records with a DueDate on or before 12/08/2008. I need this because there are reminder letters that need to be printed and sent to the contacts and this is done once a week for all...

Hello all, I have a query which I have used to build a form. I want one of the field to be fields to be filled in automatically once it gets focus with one of the values from the query that creates the form. Thanks a mil Toyin

Hello All, I have a table where I want to genrate the contactID automatically. The format is HS+mmyy+serialnumber I.e HS is the prefix for all the contactIDs followed the month and year followed by the serial number. so if a contact is introduced today as the 2nd contact for the month, the...

Hello, I am trying to use a subform to get some extra information about my contacts. for example for a parent, have a command button to open the subform to add a child. I need this subform to pick up the parents ID and then save the childs details in the child table. Also in view mode, I want...

Hello all, I have greated a query in the query designer. I want to know how to add a where clause. Is this supposed to go in the criteria column? Many thanks

Hello, I have created a look up field in one of my tables. The look up data shows in the table view. but when i created a form with the field the look up data did not show up. what am i doing wrong here please? Thanks TY