Search results

Hi Folks, I have a small database containing a table of questions and a table of teams who would be asked the questions. There's a third table to link them. I have a form where the user can select a number of teams to create a word document containing all of the questions (sorted by team)...

Hi, I have several memo fields in my application which all work well until someone uses quotation marks in their text. At this point the operation to update the table fails. Is there a way round this please? Or is there a way to display a message if the memo field contains a certain...

I'm creating a search form for my application and have copied code from one of the example search forms that I found on this forum. :D So, here is my code so far: Private Sub cmdSearch_Click() 'On Error Resume Next Dim sSql As String Dim sCriteria As String sCriteria =...

Hi folks! I've got my application working wonderfully and now have set up some reports in Excel. People want to be able to manipulate the data and I figured this was easiest...the users don't know how to create their own report within Access but are Excel literate. My workbook has two queries...

Hi guys! I have my word template set up such that some data is copied from the open form into the document and some data is taken from a table which is created from a query based on the content of the form (the record number). This works well HOWEVER (there's always a however isn't there...

Hope you can help with this one....I'm sure you can! In my database I want to open a word document that has a table populated from data depending on the current record that's open. The menu item to open the document and populate some bookmarks is as follows: Function...

What's wrong with this code please. I have an appointment in outlook and I want to use the following code to update the access tables with the custom fields in outlook. The variables are showing the correct data as is in the outlook form, however it is picking up only the first record in the...

Firstly does anyone know if this scenario is possible within Office XP? I have a database that amongst other things can be used to record the date and duration of audits. Using the code from MS KB I have successfully managed to create a button that adds the audit to my calendar. What I want...

OK guys....nearly there with this DB of mine, however the customer is now asking for things that are miles over my head. I need to programmatically retrieve the first two words of my memo field (before the record is created) so that they can be added to a table. I haven't the first clue where...

Hi, I have a main form that is unbound. On that main form is a subform which is bound to a query and displays the results in datasheet format. There is nothing else to the subform. My users want to be able to click on a record in the subform and have the corresponding data displayed in the...

Hi there :) , I have written this code to check for an entry in my table and return an error if the entry already exists....this works for the first entry in each case but not for subsequent entries.....why? Private Sub cmdAddToAudit_Click() If IsNull(Me.txtAuditNumber) Then MsgBox "You must...

Is this possible and if so how? I have two fields in the same table. I want to combine these so that they are formatted in a particular way. For example, if the first field has the value 21 and the second has the value 24 I want my resulting field to show 21/24...the forward slash is very...

Hello :) Does anyone know of a tidier way to write this or is this ok? ElseIf IsNull(Me.txtResponsiblePerson) Then MsgBox "You must complete all relevant fields to continue", vbOKOnly, "Error" ElseIf IsNull(Me.txtEmailAddress) Then MsgBox "You must complete all relevant fields to continue"...

Hopefully this is simple but I am quite new to Access... I have a combo box that populates two text boxes on my form. This is working great; however I now want to have the option of entering data into my text box and have the corresponding record show in the combo box. So....cboProgrammeName...

Hi I really hope you guys can help me with this one. I have a form with 2 cascading combo boxes on it. cboProgrammeName feeds cboProjectName and the following text boxes: txtProgrammeManager txtProgrammeID cboProgrammeName gets it's data from QRYProgrammeData (I need to filter the data to...