Search results for query: *

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?

...could build your select statement as follows: 'Command button on search form dim strSelect as String, strWhere as String strSelect = "SELECT * from tblExample WHERE RecID <> 0 " ' will select all records strWhere = "" 'empty string If Me.cboFilterFacilityEvaluation = -1 Then...

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

...control bound to the new field just displays #Name? and is not updatable. A sample of the code below - in the Form_Open event rsSELECT = "SELECT * FROM tblPO" Dim cn as ADODB.Connection Dim rsPO as ADODB.Recordset Set cn = CurrentProject.Connection Set rsPO = New ADODB.Recordset With...

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

It all works for me and returns the next number in sequence: ie 19979 I know this obvious but as users are allowed to over-write the field and as there are presumably now 19978 records has someone has over-written an early InvoiceID with 318512? The DMax function would then return 318513.

Thanks for the Belarc Advisor tip - I'll give it a try. As for the trendmicro scan - how do I get the internet connection to get to the site?

Device manager is still empty if added to the MMC - and still empty in safe mode.

I've run sfc /scannow - no errors reported. Have tried most of the fixes suggested on the links from linney and tried restoring Windows back to a point before this occured. My next problem is - this is not a branded PC and without device manager I can't establish the hardware manufacturers to...

This is a complete mystery and any help would be appreciated. I cannot get a PC to connect to the internet - plus device manager is completely empty and there is no sign of the Local Area Connection. I can see (and connect to the PC) in the workgroup and open the router settings in IE from this...