Recent content by MrMerlotti

I need to upload a name file to the webserver each time. It seems it's not possible to pre-set the value when using Enctype="multipart/form data". Has anybody ever come across a solution to this where the user doesn't have to browse for the file name?

You could try removing your filter criteria to a seperate form and generating a SELECT statement based on your filter requirements as a string. You then open the results form with the Record Source set to the SELECT statement. I'm not sure what your underlying table looks like but for a simple...

I think the error is being caused by exceeding the allowed string length for the Form's filter property. You could try verifying the integrity of strWhere by outputting it to a MsgBox before setting the filter property and if this seems OK then try creating the Filter as a string to mock up a...

Thanks PH I have modified the original SELECT statement to include a join to a table where OrderWgt is held which does the trick. Still be nice to know though...

OrderWgt is a field to hold a (new) value as an integer. The product is sold by weight. OrderWgt is used to allocate the Sales Order order-weight across multiple Purchase Orders - until the order has been fulfilled. (At the same time other values with the Purchase Order can be modified).

That works - and gives a field to bind to the control but I can't get the control to update the underlying recordset.

When I try that it gives the following error message: Operation is not allowed in this context

I am using a disconnected recordset bound to a DS form. I would like to append a new field to the recordset, bind that form to a text box on the form and allow the user to enter a value, which is reflected in the underlying disconnected recordset. Everything else seems to work OK - the code...

Sorry PHV - posted this before I saw your response - had a quick look and it seems ideal... Will let you know. Thanks

If Access has never done temporary tables - this can't be a first time data requirement?! How are people doing this? I reckon a disconnected recordset is the answer. Create the recordset, append the required fields , bind the recordset to a form, allow the user to make the changes and then...

I need to extract data from a number of tables - for example Code, Desc, DefaultValue, Current period + 1. The data is then displayed in a datasheet form - the user can change (some) of the values and then append the records another table, say TblActCosts. I could select the records to a...

Version control!! Sorry think I must have got myself in a bit of a muddle with which file was which. Ran the mdb on the 2000 machine and it threw up the AccessConnection as an error. Modified it then re-compiled the mde (I could have sworn it compiled the first time without errors) - and it now...

Found a 2000 office installation and re-compiled. No joy - I think its something to do with a missing ADO/ODBC library on the 2000 runtime. Looks like I've got to re-write the code in DAO - Or re-package to install the 2003 runtime. Thanks for all your help and suggestions

As I am running an .mde on 2000 runtime its a tad tricky to tell exactly what the faulty line of code is. I'm guessing its somewhere in Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Set cn = CurrentProject.AccessConnection Set rs = New ADODB.Recordset With rs Set .ActiveConnection =...

I have an application developed in Access 2000 and distributed with the Access 2000 runtime. I have recently added some additional functions using ADO in Access 2003 (keeping the 2000 file format - as all the original 2000 stuff has been now been updated). The application runs fine on my...