Search results

Hi everyone I am using a database developed in Access 2000. One of the controls does not work at all when I open it in Access 2003 - it's a combo box that's sited on a sub form (frmBudgets which sits within frmElements) and controls what's displayed on two other sub-sub forms...

Hi all. I've searched the forum for an answer to this, someone had a similar problem but never came back with the code for a solution to be posted so hope I'm not wasting anyone's time! I am using string strSQL to take on an SQL statement that takes data from several tables to output to Excel...

Hi all, I've searched the forums on this and although I've found several threads with similar issues, none of the suggestions have worked for me. I don't know if it's because I'm using Access 2003??? Anyway, I'm running a search option for users that allows them to enter a date (English format...

Hi all, I'm not sure if this is possible ... I have a table which has contact details in it... two fields are FirstName and Surname. I want to create a new field called initials which takes the first letter from each of the former two fields. Is it possible to do this using an update query...

Hello everyone. I've been getting my head (a little) around exporting from Access to Word using the objWord method and think it's fantastic! BUT I feel that there's loads more I need to learn - is there a resource that guides through all the different possibilities with this code? For example...

Hi all. I want to set up a 'keyword search' facility on my dbase. I would like the user to enter a keyword in a dialog box and for this to then open my main FRMContractInfo form with a recordset that shows all the records where this word appears in any or each of four fields (Summary...

Hi all. I've searched the forums and can't find an answer to this I'm afraid... can someone help? I learned how to set a form as acHidden in my database so that I can check first that there are records matching the search-criteria and then make it visible if there are... However, it doesn't...

Hi everyone. I have designed a database that keeps track of certain elements of our work and it includes a table which holds links to key word documents and reports for each contract. I have built this in by merely allowing users to type in the location of the relevant file on our shared drive...

Hi all. I'm copying the record from one table (shown in a form) over to another table. This is the code I've done (no doubt you'll all be disgusted at it... I've only learned off these forums really so I know I don't code correctly!) lngTenderID = Me.TenderID.Value strJobNo = vbNullString &...

Hi all. Still struggling with this... I've used 0;0;0;0 on the Format of the text boxes in the report to force a 0 where NULL is present, but how do I change this so it forces a £0.00 instead? The problem is that in forcing a 0 I've lost my original formatting where there is a positive currency...

Hi, I'm trying to convert Null values from a query upon which my report is based into '0'. I noted on this forum a posting that suggested I go into the query and field properties and put 0;0;0;0 in Format to force the input to be 0 for neg, pos, 0, or null values... but this hasn't worked. I...

Can anyone advise me on why the following isn't working properly: Set rs = db.OpenRecordset(strSQL) objWord.ActiveDocument.Bookmarks("Wards").Select With rs Do Until .EOF objWord.Selection.Text = .Fields(1) & ", " .MoveNext Loop End With the recordset returns several...

Hi all. Thanks to this forum, I managed to work out how to throw my data out to a word document (I hope! I haven't quite finished testing it yet!) But, I need to move the cursor across cells where I can't use bookmarks and am not sure how to do this! Previously, I've called datasets from...

HELP!!! I want to set the controls for a button so that it opens a report, changes the text in it's title label, prints it and closes it again. Can someone help me work out the code to do this... what i've written doesn't seem to work... :(

I have a generic report which I want to print with different data depending on which option a user selects. I've worked out how to do that by opening it to print based on a query, but I need to change the title of it too and the code I've tried to develop isn't working. Can anyone advise me...

Is this possible in VBA? I have a form, FRMContractInfo, which is based on the query QRYAll. However, on a specific search, I would like to change its value to QRYStaff Contracts... is this possible? My reason for this is that FRMContractInfo includes a subform FRMStaff which lists staff...

Hi. HAve constructed the following If statement but I get an 'Expected End Of Statement' compile error on the last ElseIf line: If IsNull(Me.cmbSearchList) Then MsgBox "Please make a valid selection", vbOKOnly Else If Me.txtSearchType = "Client" Then intOrgID =...

Hi. I'm working with a hyperlink field for the first time so I'm totally lost. Secondly, I want to create a form so that users can attach hyperlinks to relevant documents to contracts. I need to create the form so they can input the hyperlink, and it will be displayed as the name of the...

Is it possible (I'm sure it is but unsure how) to ouput records from a query into a string that can then be displayed in a text box. Query would ouput between 1 and 20 records and I would want to use one of the fields only which are text. I would like to link them together into a string with a...

Hi everyone. I'm very proud of the following code which I managed to work out myself: If Me.ChkHealth = True Then intSubCat = 1 strSQL = "SELECT TBLContractSubCat.ContractID, TBLContractSubCat.SubCatID FROM TBLContractSubCat " strSQL = strSQL & "WHERE...