Search results

Didn't realise that the type of connection (ADO V DAO) could be causing the problem. I changed it to DAO and its working now: Set qdfTransmittal = dbs.QueryDefs("qselRecentTransmittal") 'most recent transmittals sent with qdfTransmittal.Parameters("DrawNum") = DrawingNum...

Thanks so much for the reply - have been tring to get this work for ages. To be honest I didn't even know about DAO when I started this and its quite a big project so it would take alot of work to change everything to DAO now. The reason I'm using a recordset is that I need to get the...

Any ideas?

Hi, I have the following code in a module - Im creating a recordset in ADO. The sql code is fine - I've tested it in a query but I'm getting the "Jet cannot find your query or table" error. This is because the sql refers to two other queries:NewestTransmittal and LatestRevTransmitted. How can...

I figured it out. This tutorial/sample was very useful: http://www.techonthenet.com/access/queries/max_date.php

Hi, I have two tables: tblOutTransmittals and tblTransmittedDocs. A document is sent with a transmittal document which the recipient signs to confirm that they received it. I've created a query that will show all the drawings/documents and the information about the associated transmittals. What...

I have done something similar in my database - I have a text box called tctElectronic that contains the path of a file and the filename. When the user double clicks on it the file is opened: Private Sub txtElectronicCopy_DblClick(Cancel As Integer) 'Opens the drawing specified in the...

By the way you can use the Right function in a query: - just create a query that includes the Zip code field - create an expression to show the results of the expression

I know this is an old post but just came across it now. A very easy of doing this is just set the Caption property in design view of the table. Access uses the field names if there are no captions set.

You could just pass the recordset that you want updated as a parameter or arguement to the module. Public function yourFunctionName( calculation as String) If calculation = "button1" Then Select Case Valuta Case "EUR" Set rsInput =...

Thanks a mill for that lagbolt. I actually did think of checking the options there and it 'break on all errors' was selected - thought that would cover it.. I changed it to 'break on unhandled errors' and it works perfectly. (Thanks RG - I did have Err.Raise 3022 but it gave the same result)

Hi, Am having a very strange problem: The ErrorHandler does not get executed. There must be a mistake in the code but I'm not seeing it! Here is a pared down version of my code: Public Function createAssignRecord(lstPart As ListBox) On Error GoTo Err_createAssignRecord Error 3022...

Hi, Is the number of the note the first number in the string? For instance do you need to extract the number 2 in this example?: 2. 23/08 PM KC If you need to extract that you need to use string functions. For instance use inStr to find the position of the full stop and the Left function to...

Thanks again Pat, I don't have any memo fields in it at all and I'm not using the standard Switchboard - the startup form is an unbound form. I'll try to get them to close any other forms when they are not using them. I imported everything into a new DB again and that seemed to do it - still...

To be honest I have never really used macros so maybe someone else could answer that. However you don't need to change much of the code to modify it for yourself. You just need a table called DBNames with the following fields: DBID DBFolder DBName DBBackupPath Put the pathnames, filenames and...

Have tried importing the tables from the backend into a new database and compacted it using the JET utility. Didn't work. Have to say I am really at a dead end - does anyone have any experience of anything like this? Its always fine when I enter the first new revision, then I click on the...

I've just tried reinstalling Office 2003 but it made no difference.

Ok have just discovered that it always crashes in this case - user adds a new revision - user clicks on the received tab and fills in info (num of copies received, date etc) - user goes back to the first tab - fills in the drawing number and revision - message comes up asking if they want to add...

Does anyone have any suggestions on this? The code was working fine before but I think that maybe this code is causing corruption now. Basically I have a form to input new drawings and new revisions of drawings. The main form is for the drawings and the subform shows the revision information...

Thanks Ghudson - I'm hoping it is fixed for good! (Thats prob too much to ask tho - going on what I've read..)