Search results for query: *

Hi there I tried to link some tables that reside on the mysql-Server on my local machine into a new access database using the ODBC 3.51 driver everything worked fine with no errors. But when I open the linked table in Access, all entries have #deleted values, although when I check via...

Hi out there Is there a simple way to export the tables (and maybe the relationships as well) of an Access 2003 Database into SQL-Format, so that it can be read into mySQL? Or does anyone have another suggestion on how to transfer a database from Access to mySQL? Thanks in advance for...

Hi out there Great Forum! But couldn't find an answer for this one... I'd like to stop the closing process of access when a user hits the X in the upper-right corner of the application window. I'd like then to ask the user if he is sure and if he clicks yes close access, if he clicks no cancel...

Hi out there I have a Front-End database that contains links to tables in a password protected backend database. The two databases reside on a server and the user start the database from there. Due to IT-restructurisation, the location where the databases are saved will change a few times...

Hi there This must be a common problem but I couldn't find a thread that helped... I would like to print a group footer with the last detail (if it doesn't fit on the page and a new page is required). Right now I sometimes get the group footer on a new page without any data and that's quite...

Hi out there I have a report that - using VBA - is configured based on user input. That input is possibly invalid and then opening the report will throw an error, which I would like to intercept and then let the user know in a decent way. This is the code that I use to try to open the report...

Hi there Is it possible to change the background color of a toolbar button (on a toolbar that I created) in code? Thanks for your help Simon

Hi there I am currently writing code to create a custom toolbar. At runtime, this toolbar will be populated with buttons - one for each open form - to give one-click access to all open forms. For that i need to have the OnAction-Property call a function with an argument (the name of the...

Hi I use this to send emails: Call ShellExecute(hwnd, "open", stext, vbNullString, vbNullString, SW_SHOWNORMAL) where stext is e.g. the following: mailto:john@doe.com?CC=maria@doe.com&Subject=Test&Body=Blablablablabla&Attach="C:\Boot.ini" Everything works fine except the attachement. When...

Hi guys. I am sure there's plenty of info out there, but the one I found didn't work for me, so a dare to ask here. Can anyone point me in the right direction as to how to send an email over a mozilla thunderbird client using VBA in Access. Thanks a lot

Hi there This must be a common problem but I couldn't find a thread that helped... I would like to print a group footer with the last detail (if it doesn't fit on the page and a new page is required). Right now I sometimes get the group footer on a new page without any data and that's quite...

Hi there I would like to embed files into an access-db (links are fine but the original files are likely to be moved quite often...) How can I, given the path to a file, embed it in an access table using VBA? I searched the forums quite a while but didn't find a decent answer... so if anyone...

Hi there I have a report that groups stuff on 3 levels. Now the outermost group Footer sometimes gets printed on the last page, while the last subgroup is printed on page before that one (which looks a little stupid because this footer holds name and signature of an official document and is...

Alright, this might be a tricky one: I have an Access database that stores people and what they do during their stay at the university. I tried to create some kind of curriculum for everybody. To do that one can choose from about a dozen "events" that can happen during the university carrer...

Hi there I have Apache, PHP 5, MySQl 4 up and - as it seems - running smoothly on my desktop computer. Now I have created a classic login-page using Dreamweaver 8: My problem is that when I submit the login-page, i cannot access the post-data on the called page. i.e. the $_POST variable is...

Hi out there I would like to show the DropDownMenu of a combobox programmatically if another button is clicked. Is that possible? Any help greatly appreciated. Simon

Hi there. On a form I have an ActiveX-Slider Control that can be bound to a field in a table just like any other control. But when i change the form type to continuous form, the activeX won't allow it because it is required to run in single form mode. Is there any way around this limitation...

Hi out there. I would like to use the MS Datagrid Control in one of my Access databases. I have found the msdatgrd.ocx on the internet, but when I try to add an instance to one of my forms, i get a message saying that the datagrid control must be registered first. How do I do that? Involves...

Hi there I would like to use the MouseMove-Event on a MS DateTimePicker V6.0 Control. But when I write the declaration (that I got directly from the MSDN Library) like Private Sub DatePicker1_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single, Index As Integer) I get an...

Is there a way to have a richt text label on a report or form? Thanks for your help Greetings Simon