Search results

I am trying to import the data in. However, I am only familiar with MS Access, not mySql, hence my problem. Without having images in one of the fields, using the append query works without issues, but when the image is involved, that particular field turns to garbage in mySql.

Hi, I need to migrate a table of data that one of the field contains images which is OLE Object datatype. Via ODBC, I tried to use update query and append query. All the fields would migrate over, but neither type of query would transfer the image from Access to mySql correctly. Has anyone...

This is way beyond me. I tried to follow but without success. I noticed that as long as I am updating the database, I can stay connected. I know this is probably not a good practice, but what if I constantly query the database to keep the connection alive? Is there a way I can automatically...

Below is what I had, which I commented out. DoCmd.MoveSize 10500, 0, 11800, 13000

Bob, Have you used Runtime? I am creating the application for other folks to use with Runtime. I want the form to be shown about short of half on the right hand side of the monitor. The users will be using another application concurrently on the left side of the monitor. I cannot get Runtime...

Again, sorry for sounding ignorant, but when you refer to a query, you do mean query, not a form? If it's a query, how do you ensure that it's the first thing it runs when you open Access? The VBA referenced in the link you provided, I essentially copy and paste to a module and change the...

OK. It took awhile to read the entire thread, but basically he suggests the following Create a pass through query with the following properties: Connect property: ODBC;DRIVER={MySQL ODBC 5.1 Driver};SERVER=xxx.xxx.xxx.xxx;DATABASE=YourDatabaseName;OPTION=35;INITSTMT=SET...

I just chatted with my hosting company. The tech told me that because I am on a shared server, my wait_timeout=3600, so it sounds like it's being timed out. I can use Navicat, an application that can query the database. I don't quite understand why that connection stays on much much longer...

Below is the error message I received. ODBC Error 2006 [MySQL][ODBC 5.1 Driver][mysqld-5.1.52]MySQL server has gone away ODBC Error 3146 ODBC--call failed.

I am excited now that I have moved my database to a new hosting company that allows remote connection to my mySql database. I was able to link the tables via ODBC connection. However, I can only view the data for a short period of time before I get that "ODBC --called failed" error message. I...

Bob, Your code works perfectly fine. I had a different code which I copied from the VBA after I converted from a macro. It was not exactly the same. Thanks for your help with this.

That is the only printer I have installed on this computer and it's set as a default printer. It is a receipt printer. I'm not sure if that makes a difference.

I have this code in VBA and it does send to the printer automatically without preview, but I have to click print in the printer dialog. Please see attached for reference.

Is there a VBA code that would allow me to bypass the print dialog, you know the pop-up window that allows you to select which printer, pages, etc.? I want to skip skip that process.

When implementing your suggestion, it seems to work fine in MS Access itself when viewing between design and form view. However, when I exit and launch the application again, the forms do not save in their dimensions or location. I cannot get MS Runtime to work either.

I want to make my form a certain size and be displayed at certain location of the monitor when open with Access Runtime. I don't see it, but is there a form setting I can modify, or this has to done with macro or VBA with an event procedure on open? This was so easily done in Access 2003, but...

Your suggestion works great with it. I was not aware you can do that with a form. Thanks. I now need to add a form to allow the restaurant owner/workers to insert a discount on a bill. I also need to carry this out to the end when printing out the ticket and store it for historical record...

I'm sure this is not ideal or a sophisticated approach, but this is what I'm thinking of doing. I am creating a POS system that needs to store sales tax rate, so the total can be calculated accordingly. As sales tax rate changes periodically, I want to create a form to allow the user to be...

Yes, naym. It is exactly what I want, but the driver I downloaded for this particular printer, TSP600, somehow has it's own margin setup. I cannot get the bottom margin to go less than 5.172". Every time I set it lower, it goes back to 5.172" Any suggestions?

In a report you can "serialize" the data by putting "=1" in the control source and set the Running Sum property to "Over Group" or "Over All", depending how you want to sequence the data shown in example below. Can you do the same for forms? I do not see the Running Sum property for a text box...