Search results

I have both a MySQL 5.1 backend and a MSSQL (don't know its version) backend that I connect to from an Access 2003 frontend. I'm trying to export data from MSSQL to MySQL. Now I don't have direct access to the MSSQL database so I've got a query pulling the data into Access.Then I'm trying to...

connection strings all the connection strings you could ever want. http://www.connectionstrings.com/

inserting records via forms would the "Mail Date(s)" be listed in the main form with "Job Name" in the sub form, or the other way around?

Hey guys, got another question for you. I have a table that has the follow fields (this is for a mailing schedule) Job Name, Mail Date, Job Number, ID #, Material Due Date, Quantity To Mail Here's the problem I'm having. For each "Job" that we have, it can have multiple "Mail Date(s)". I'm...

function questions I'm looking at ~ 600k records. I'm not the only person who hits this database, there's hundreds of people that do. Here's my current process. Create master file (making it a local file so I'm not hitting the server anymore) append invoice information (for some reason if I...

Use 1 function, or multiple functions? Hey Guys and Gals, I got a noob question for you. I have an access database that connects to an SQL server. Now I need to pull a file from the server, add information to it, then slice and dice it for some reports. I was left with about 12 queries that...

I have a rather large data file that I need to produce a report from, its basically a commision report with all a reps sales in the detail field with some calculations in the report footer, now in this file is about 50 reps and I didn't want to have to split it into smaller files so I'm thinking...

I am using Access 2003 and have made a report with a calculation in the report footer. When I export this to excel the footer is cut off. Is there any way that I can export it other than as an rft. then copying that to excel? Thanks

I have a module that takes a DB, separates out individual reps' accounts and sends it to them. now it works ok, but after like every 6th set of accounts that gets sent out I get an out of memory message, there's 50 or so reps I need to do this with each rep has between 0 and 2000 accounts, and...

question I've been trying to use the code above to send out my reps customers, but access keeps throwing errors about user-defined data types, is there something else I need to install to make access use this code correctly?

Thanks Guys! This helps Immensly, I can do VB code easy enough, the problem I was having was figuring out how to make it "Access Friendly", just the small differences in language. one last problem, the file that I pull the orders out of has other reps in it that I don't need/want, I'm assuming...

Here's my delema, I currently have a table that I pull orders out of, now every month I have to pull out each sales reps accounts and send them to the reps, I currently have a macro to do this, but I have about 55 reps and have to do a lot of changing when someone comes or someone goes. I...