Hi all, I need help coming up with a method to allow a user to export a query's results to an xls file on a button click event. I've tried using an Output To macro, but it doesn't work for a query containing 30,000+ records. Thanks in advance ...
Does anyone know of a tool that can create a MS-Access database from a configuration file? It needs to be able to do things outside of the SQL spec such as be able to create macros, modules, and forms, and make changes to the "Lookup" tab that's available in Design View. And if possible, I need to be able to export an existing database ...
i cannot see why this would be an issue. i use the msgbox to display my strSQL, but it looks perfectly fine. Dim strSQL As String strSQL = "INSERT INTO Jobs (Date, RefNo, ProjectID, PManager, PDesc, PONo, Src_Qty, WC_Qty, Rate, Total, Note, Company) " strSQL = strSQL & "VALUES (" & JobDate.Value & ", '" _ & T...
What if I want to connect to Oracle, MySQL or even MS Access ? ...
I'm working on a project atm, and I need to import data that is stored in a MS ACCESS database to mySql. For mySql I'm using phpMyAdmin on a Ubuntu machine, I have another Windows Machine where I can access the Access DB from, In MS Access 2003 I can't find an option to convert the data to mySql? Can this be done? ...
Hello, I need some help on writing some VBA/SQL code into a module in Access, which should do the following: Loop through Table 'Schools', with just one field (SchoolName). Use each value in the first table to select records from Table 'ChildData', with several fields about individual children, including which school they attend (Scho...
I have a continuous form that contains a drop down box whos control source is the id of a record in a support table. The bound column is this support element id. The row source of the drop down list is a query that gets 2 text fields based on the id in the bound column... the first text field is simply text that is displayed... the 2nd...
We have developed a consolidation function that will be used by other processes and want to position the function in its own MDB (call it "remote") so that it can be referenced and called from "caller.mdb" when its needed. The function is designed to return an array and works great when executed called directly from within "remote." Howe...
Specifically, I'm a n00b making a db. So far I have a form set up like I like it, but no values are bound b/c I need to switch between tables (I could probably just add all of the fields from the first table to the second table, but half of the point of me doing this myself was learning). I've encountered two problems. First, I'm havi...
I'm trying to build a database for a hospital program. I have two tables that are related in a parent-child relationship. I have a form to add new records (records that dont already have a parent record) and I want to build forms that allow me to view all of a parent record's "children" as well as allowing me to edit them. I want this...
Okay so this is another question about a previous question I asked: http://stackoverflow.com/questions/1435802/rookie-sql-inside-of-vb-question-msaccess-2003 I am pretty new at this so I appreciate the help guys! So lets say I have a form and I want the SQL string in the VB to fill out a form based on parameters selected by the user o...
Hey guys! Was wondering is anyone had any suggestions on books or other resources on learning novice to advanced VBA as it relates to access programming. I have bought and read the "Access Bible", "The only access book you'll ever need", and "Sams TY in 21Days" and they were all fine for learning the basics. Then I bought and read teh O...
Hi, I have Access 2003 with SQL backend. This query takes 10 minutes to execute and if I take out the Exists part it takes 10 sec. I can't put it in SQL as a passthrough query because I need it in a Access subreport. Any ideas how to improve execution time?? SELECT DailyLeaveLedger.dldEmployeeID, Sum(IIf([tolAnnualLeaveType]...
I would like to programmatically retrieve the query text of every query stored in an access database. I am thinking of using OleDbConnection.GetSchema or OleDbConnection.GetOleDbSchemaTable or even ADOX to get the required information. I am proficient in C#. Can this be done? Can you provide an example or link to good examples? ...
We have a database that contains information about time booked to projects. We have a live record for a project, that holds the correct time information (imported from SAP once a week). We also have archived records showing the time information at a point in time, these are taken once a week, essentially they are snap shots. It is possi...
what is the best way to store long texts (articles) in a database? it doesnt need to be searchable. i want to allow ppl to read the first chapter of every book in my bookstore. dumping it into a database field makes it difficult to style paragraphs using css.. EDIT: access database ...
Pretty simple question, I know. ...
I'm very new to Access and I don't have any experience. At work, I was ask to research about migration of MS Access 2003 databases to 2007. I have read on the Internet that usually if you open .mdb files in Access 2007 it will normally work. But in my case I'm getting an error: Action Failed Now I'm not sure if I'm getting the co...
I am helping a friend to streamline his little manufacturing business db. Currently, they have An address db bookkeeping db order mgmt db All the three are mdb files. They can't pay me really, so I am doing good will work. Thus, just doing the barely needed. It would be ideal to merge order mgmt and address, but that's maybe for l...
A client is receiving a "You don't have permission to read [REPORT NAME]" error message when attempting to launch a report in a MS Access database. When I go to the “Change Owner” tab under Tools > Security > User Groups and Permissions, the owner is <unknown>. If I attempt to change the owner, I get a "You don't have permission to cha...