Search results

Hi folks, I'm trying to establish a connection to a MySQL db and populate a listbox with data from a table in the db. I'm trying to trigger this on loading the form. I haven't done this before as I've previously used linked tables. This time around I've been asked to avoid DSN linked tables...

Just tried the MD5 option and received the attached MS VB error saying that MD5 is an undefined function....any ideas? Thanks, Dave

Thanks for that Sam....will prove v. handy. Also, if there is anyone with sample 'Access to MySql' connection scripts could they send them this way? I reckon I need to start using connection strings going forward instead of linked tables to provide a more secure environment. I just need to see...

Thanks guys. I played around with your suggestions and managed to get the following to work; [Forms]![Main Form]![Subform ctl].form.[Listbox].Requery Rgd's, Dave

Does anyone know how to requery a listbox within a subform? A popup form allows me to make changes to the underlying record source of the listbox. When I close out of the popup and return the main form I would like the list box within the subform to display the record updates. I've tried the...

Hi folks, I've recently begun to move all my db tables to MySql and have created ODBC linked tables to access the data. I have a number of tables however which contain confidential info such as passwords etc. As things stand, I can put an input mask on the table link in access but it's still...

Thanks SQL_Hell. Your comment re. Northwind put me in the right direction. Under the 'Other' tab in the properties window the last option allows you to select the mode(s) under which design changes are allowed. 'All Views' was selected by default on all my forms in Acc2K. I've changed them to...

Hi, I've noticed since moving to Access 2K that when a form is viewed in 'Form View' all a user has to do is hit Alt+Return to bring up the proberty window for that form. In fact, if I'm working on the database and forget to close the property window before closing the database, the property...

Thanks Pat. I had another go this morning and managed to get it to work (with a join). I've been messing around with the tables and queries for the last day or so and obviously hit on something. Not sure exactly what I did to make it work but I'm not complaining. Thanks again for your help...

I'm just moved tables in a db I'm building from Access to MySql. I have a query setup which comprises of two tables. 1) Employee Attendance Records 2) Employee Details Table 1 uses an employee id field to tie back to an Employee details table. I've created a Right Join from T1 to T2 to pull...

Thanks FoFa....sometimes you just can't see the wood for the trees.

I've just moved some tables to a MYSQL backend and have to rewrite an SQL query as the version of MYSQL I'm running doesn't support subqueries. Can anyone tell me how to work around this; SELECT TBL_Employee_list.[USERID], [Surname] FROM TBL_Employee_list WHERE TBL_Employee_list.[USERID] Not...

Speaking of list boxes, if all you want to do is view the data, you can add one or more list boxes to the main form and define the rowsource in each listbox. This will remove the need for subforms altogether.

If you go into the properties of the subform you can hide the navigation bar, record selectors etc under the format tab. You can get the subform looking like a list box in the main form.

Thanks Mile

Having used both options on numerous occasions, I would have thought either were appropriate leaving it down to preference based on circumstances. I still cannot see why OnOpen would cause problems in this instance. The list boxes are populating however, as I said, the form contents then...

Has anyone ever seen this happen?? I'm running Access 2003 though I'm not sure how relevant that is. The form in question has 3 list boxes. The first has it's rowsource defined in it's property box while I'm using an event procedure to select the first record in List Box 1 and then to populate...

Thanks Mile.....appreciate the help

Hi folks, I'm getting an invalid procedure call or procedure error when I try and use the following code on form activation; Dim Cutoff Cutoff = 31 / 3 / DatePart(yyyy, Date) If Date >= Cutoff Then ........ Else ........ End If I need to test if the current date is < or > than the 31st March...

msgbox "Button working o.k." I've just created a new db on my own pc, imported all objects from the original db into the new one and the problem has vanished! This is going to bug me now. I wonder if Win2K users will experience problems if I overwrite the old db with my copy?