Search results

Thanks CJ that is exactly what i'm trying to do, I have managed it with a double click event now, I just thought there might be a control to do that. Cheers

I dont know if this is possible but I want to change a yes/no field from a list box. I can load data in fine I can even loop through it to see what value each item is but, is it possible to allow a user to change a value from a list box? If not do I have to use the Datasheet view?

JHB it works a treat in on-load why is form-open different? When would I use form-open over form-load? Thanks again!

Hi txtMyID is bound to a standard number field, Will try putting it in the on-load event cheers

:banghead: Not sure whats going on here, nothing on the table that stops this from working. I just get Run-time error "2448 You can't assign a value to this object" When the code runs. Any ideas what I am doing wrong? Private Sub Form_Open(Cancel As Integer) Dim rst As DAO.Recordset MySQL = "...

How would I update all SQL stored within all forms to change its syntax? I am returning all the row-sources for all the comboboxes on all forms in an Access db. Most work fine but some have syntax errors, for example double quotes instead of single. Is there any way of finding these stored...

err no. that was a bit obvious really! Couldnt see the wood for the trees :) Thanks pbaldy!!!

I want to create a table of all fields in a form, their datatype and their controlsource. I have done the first 2 parts easily enough using the forms.formname.controls.name property and TypeName(forms.formname.controls) But I am unable to pragmatically read the controlSource. EG...

mdlueck that is exactly what I am trying to docode. It is an AIS message. Looks like most of the solution is there. Thank you :)

I think I have a table of 6-bit ASCII, a sample message looks like this: 13M@F0@000wN7GPPWesdWRin05kd How do I convert this to standard ASCII? Thanks Rich

In Excel there is the web query. How would I do the same thing in Access VBA to bring in data from a web XML table?

Hi want to move a file onto a server and need to provide the user name and password within the VBA. How would I do this?

In EXCEL I bring in a large volume of data in recordsets. All the dates are in mm/dd/yyyy format is there anywhere to specify when setting up the recordset the date format as dd/mm/yyyy?

Hi Shrimp, You mean like this? SELECT a.ID, b.ID FROM table1 a INNER JOIN table2 b ON a.id = b.id; Same result, even if I do this: SELECT a.ID, b.ID FROM table1 a left JOIN table2 b ON a.id = b.id;

I have a VERY simple query that looks something like this: select a.id, b.id from table1 a, table2 b where a.id = b.id; Now table1 has 3 records with the same ID and table2 has three records with the same ID. I expected to get 3 records returned. I actually get 9. This query has worked...

oooh handy thanks bob!

I have been trying to do this for ages and couldn't find it online. Well here it is: string = the file you want to launch. Shell "RunDLL32.EXE shell32.dll,ShellExec_RunDLL string"

Hey i dont mind muddy waters/code as long as the users are happy and dont moan at me :)

Thanks ChrisO, the only thing I changed was to include a rst.close to all the instances of a rst opening and it seems to have solved the issue on the machine in question. I found reference online to different installs not liking the set.rst = nothing and this does seem to be the case. I would...

I couldnt post the entire DB its HUGE. I think i have solved it. It seems the Set strRecordsetName = Nothing was not working in some places as it did not have a strRecordsetName.Close.