Search results

Hi, I've got an access database linked to an online ODBC DB with a PHP front end. I want to be able to use a HTML editor to edit details held in a memo field to add Bold Tags, underline etc, in a WYSIWYG type way on the Access Database. I've found some help in the forums... but none that I...

Hi, This error has occured on the DB since formatting and reintsalling a PC. (Its a file upload command to an FTP) It works fine on every other PC I've tried it on. I've checked for windows and office updates and to make sure the PC's got everything... checked the References in the VB Modules...

Hi... I've just upgraded to windows 64 Bit OS. I have some DBs set up with ODBC connections to a MySQL server. Problem being I crash access every time I try and Link/Import to a ODBC DB. I had Problems setting up the ODBC's first of all as thier isnt a 64 bit ODBC driver yet... had to use the...

Hi, I have an autoemail form, that emails fine for the email list, i.e. sending individual emails, but I want to add a REF link as a hyperlink in each of the message fields of the emails. Currently I only get 1 message field Ref. Not too hot on VB... so go easy... Cheers in advance.. Mike...

Hi, I've got a VB script to upload pictuires from a PC to my server, I want to log the file name of pic im uploading in a field. Currently the script I'm working off is giving me the path and name.... Private Sub cmdSelect_Click() Me.CommonDialog3.initdir = "C:\images" ' This Directory can...

Does anyone know the code to Filter By Form so I can use it as a command button Cheers Mike

Hi, I'm looking to get some PDA's to run a simlified Database... I just want to check that they run access. I used one a couple of years ago (2000ish) running Pocket Access on Windows CE OS. Anyone know of any... I'd be very gratefully I've been searching the net for more info but without...

Hi, I have a problem tyring to use my SQL in an update query.. It works fine as a select query but when I try to use it as an update I get trhe error message Field too small to small to insert the amount of data. Try inserting or Pasting Less I'm not sure of any other way around this. The...

Hi, I have a form listing a load of addresses and I would like to be able to order these addresses by an order value. Is there a way I can have temporary field from within the form to enter an order value by, just for printing purposes...? I've tried referring it back to the open form but...

I'm trying to get a query to work on a table pulling down all information in the table only by the latest dates for each AddressID (which is a foregin key from TblAddress). I'm having trouble using the TOPVALUE option as this will only display the information for the TOPVALUE of AddressID and...

Hi, I got quite a large SQl query that runs fine... but everytime I try to save it it just crashes instantly. The query stores 22 temporary fields as experessions, but it works fine untill I try to save the changes I've made. Any Ideas anyone...? I've tried reinstalling it & repairing it...

Is there an easy way of pulling fieldnames into a concatinated query field? If For Example... FieldNames are Option1, Option2, Option3, Option4 So that Concatined Field States... Option1 Option2 Option4 but only where these vaules are not Null... Thanks Mike ________ iolite portable...

Hi, Ive got a Access Form which I'm using to search a table and display the reuslts on screen. Users can enter data and it will search an Address Table and display the matching values below in an auto generated list box. I've been frankinstiening some different VB to get it going and it all...

On my form... I have a combo linked to Table A On 'Not in List' creates a popup to edit Table A . Is there an easy way of automatically updating the combo box or refreshing the forms data (so that the combo is refreshed also)? Many thanks Mike ________ TX311M

On a form I've a combo box wich pulls info from Table A I also have a 'Not in List' option to create a pop-up form to edit Table A. Is there an easy way of refreshing the combo box after closing the popup to inlcude the new addition to Table A...? or.. A easy way of automatically refreshing...

Hi, I'm not sure how I've done this but my copy of Access 2K seems to be missing its wizards (autoqueries/forms/buttons etc) (its as though I've turned them off). I've tried to turn on the wizards, re-install access but I cant get them to work again........ Any Ideas...

Here's the problem (And believe me its driving me MAD)....probably really simple but I cant seem to suss it. I have my own Logon form with a Combo Box txtUserName to pull up the username from an Employees table. This works fine. I want to pull the username from the form above into a field in...

ok, I have my own logon form (working fine no probs) but how can I store the current user to pull into forms automatically at a later stage....? is there session variables in Access (ASP style)...? I've found other help files that are similar but I cant get them to work - Do you have to set...

Trying to get back into access after quite a while and having touble getting macromedia flash files to play within a form. I can see that Access can work with Flash but I can't get it to display the file, just this error message. Error - There is no Object in this control I'm currently...

I'm having trouble with the security on Access. I need to pickup a user id from different people when they alter the DB. I have the access security system on the go with user id to logon, but where and how can I pull in the info on them ?? I know this will be really easy but I can't find how...