Recent content by saross

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

Thanks for this. As it transpires, I had mis-named one of my fields. When I corrected that, the string gathered up all the text no problem! Thanks again.

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

Thanks for this. Do you think then that rather than use VBA, I should create a query that uses the input box of the form as it's search criteria instead? Would that resolve it? :confused:

Thanks! Wow thanks that's great! I'll use that code in the module and output the initials direct to the job creation sheet rather than creating an additional field in my table! Thanks again! :D

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

Thanks Ok, thanks I'll have a trawl!

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

Thanks. Actually once I knew what I was looking for I found it in Access VB Help! It's the File Dialog Object (you need to enable the Office 10.0 Object Library too). Just posting this in case anyone else looks for this too. :)

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

Errr.. thanks ghudson. The information won't remain the same, it will be updated. It's converting a tender that's been submitted and won into a contract... Can anyone explain how I work with the null value assigned to a date type?

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