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

Thanks I've used Wayne's method as I feel they probably will want to maintain the quotes at times. Works perfectly....thanks for all your help (both of you) :) Jo

Sorry I'm being dumb. This is what I have in the BeforeUpdate event of the form. =Replace([txtNCRDescription]," " "," ' ") I get an error when the after update code runs now: Syntax error (missing operator) in query expression... Jo

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

Indirect Synchronisation? Check out Indirect Synchronisation as detailed on Microsoft's White Paper "Database Replication in Microsoft Jet" This doesn't open each database directly, rather the synchornisers talk to each other and the synchronisation is then performed locally instead of over...

Got It!!!!! I needed the IsNull Statement rather than "= Null"

OK I told a fib :o The code doesn't work :( I have modified it as follows but still it skips past all of the statements until it gets to the last one. When debugging, all of the conditions are met as expected but the code doesn't execute the correct part. If Me.cboProcess <> "" And...

Almost Fixed! I've messed a bit and am getting the results I want with the addition of the following code If Me.cboProcess <> "" And Me.cboNCRStatus = "" And Me.cboNCCategory = "" Then sSql = "SELECT DISTINCT [AuditNumber], [AuditStatus], [ProgrammeName], [ProjectName]...

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

Thanks for your time Pat. I am aware that I need to close the recordset but since I don't use code to open the recordset I am a bit stuck as to how to reference it in order to close it using code. Does anybody know how to do this please?

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

It happens when both try to run the query within a short space of time. Your solution sounds like it might work well in my situation (database compacts when closed and only 10 users so this is frequent) I'll give it a go...thanks! Jo

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

Thanks Modest Thanks for your help modest....as ever! I'll stick with the solution I've found for this one but will bear your advice in mind for future recordsets. Thank you :)

Got it!!!!!! With a bit of messing I've found that the problem is my query. I tried to create a table in Excel with the idea that I would just create an object within my word document and the query returned the same error before it was even built. Further messing shows that the problem is...

Private Sub Document_New() Dim dbe As DAO.DBEngine Dim wks As DAO.Workspace Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim strDBName As String 'On Error Resume Next strDBName = "U:\APT\Release 3\Audit_Planning_Tool.mdb" Set dbe = CreateObject("DAO.DBEngine.36") Set wks =...

Thanks for your reply...I appreciate you looking at this. That piece of code is simply to delete the surplus row in the word table once the loop has ended. I think perhaps the problem lies with the way in which the recordset is created but not having ever used recordsets I'm just not sure...

Anybody? Can anybody help with this? :(

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

I've done it!!!!!!!! Yippeee.....I figured it out...thank you so much for your help modest. Here's the code if you're interested. Option Explicit Private ins As Outlook.Inspector Private itm As Object Private con As Outlook.AppointmentItem Private appAccess As Access.Application Private fso...