Search results

Hi there, I'm beginning to to pull my hair out with this. My database that distribute to my team is failing to sync all columns on linked a SharePoint list I've added a button to the database to auto re link the SharePoint to resolve this issue: DoCmd.DeleteObject acTable, "tblPro" DoEvents...

Hi there, I have a list of tables like this: January_2014 February_2014 March_2014 ... Is there away I can create union within VBA that will search for tables like the above and add them to a union query or append them to a master table? Users will be importing a new table each month so I...

I have used the Application.SaveToText to save each forms source code. I'm looking to re-import each text file and append it to a table. like below ID | Object_Name | Script 1 | Form1 | SoruceCode 2 | Form 2 | SoruceCode I want to automate the process so it imports all txt files in the...

Hi there, I've got a script that exports all objects to .txt files using the Application.SaveToText, but what I want to do is save the objects script into a table along with the object name. Table would look like: ID | Object_Name | Script Is that possible? I want to avoid exporting /...

Hi there, I have vba that renames an external database, upon renaming the database it is not instantly updated unless you refresh the folder / desktop, is there vba that can refresh the windows desktop?

Hi there, I have a service pack database that a user opens which the user selects their database to update. After the service pack as exported its contents to their database, is it possible to rename their database file (accdb) lets say from "Version 1.0" to "Version 2.0" via VBA in the...

Hi there, I have a database that is shared across the country, I regulary issue service packs thats updates their database. which contains Updates & New forms / tables etc... anywho when they open up the service pack database it automactilly exports its contents to their database to update it...

Hi there, I have a query "qry_tmp" that changes depending on the sql statement, i'm looking to open the query in a popup form and display the results in Datasheet view. But as the qry_temp changes the fields change as they may be less / more columns depending on my sql statement, Is it...

Hi there, I would like to run a select query from a string. basically I want to store the SQL statements in a texbox and click a button to run the code. Textbox contents = SELECT CurrentVersion.AreaTeam, CurrentVersion.Version, CurrentVersion.Selected FROM CurrentVersion GROUP BY...

Hi there, Is it possible for me to store VBA Code in a table and execute on a form? For example: My table contains a field called VBA, that field contains the following code: Docmd.Quit is it possible to reference that VBA Code on a form? e.g. a button that will reference that VBA code from...

Hi All, I currently have a CSV Table consisting of 30 fields linked to my access database, now and again I need to add additional fields. but each time I do this I'm having to relink the csv and rename all the field names etc.. Is it possible for me to add a new field directly in the CSV...

Hi there, I am unable to link MySQL database to my local Access Database due to having a Dynamic IP (not the best of providers we chose)...anyway I had a thought! Is it possible to export a new appended record to a .php file which then sends data to MySQL via a hidden browser? sounds very...

Hi All, As the title says, i'm trying to requery a subform after update from a another subform which are both within a main subform that is on a main form. I have attached a image which makes it alot easier to explain on what i'm trying to achieve. (Please see image) goal is to requery...

Hi All, I'm having a right time trying to figure out the following. I have placed a text box in a subform with the following: =count([Risk Rating]) and a textbox in the main form =[QryRisk_Subform].[form].[Red] I'm trying to filter =count([Risk Rating]) again by adding "Red" at the end...

Hi all, I'm currently using the following VBA to export all tables within my DB to Excel on seperate tabs: Dim td As DAO.TableDef, db As DAO.Database Dim out_file As String out_file = CurrentProject.Path & "\" & "Backup.xls" Set db = CurrentDb() For Each td In db.TableDefs...

Hi there, I have a query that lists all tables within my access database. what i want it to be able to click the table name from the query list. for example my query list is: Rawdata Outcomes Reporter Tracker how would I click on Tracker and open in up the tracker table?? is it something...

Hi everyone, Basically i'm trying to link Access to Outlook to retrieve emails , When using the wizard to link outlook folder to Access it fails, i've been informed that this is due to the version of Access they have installed which is a ThinApplication. So i was wondering would it be possible...

Hi everyone, I'm trying to build a query that can parse Delimited text to columns, for example I have the following: ID,Name,Tel,Fax,Email,Directorate,DOB,AOCD,Reg,CD I would like to convert the above in 10 seperate columnns within a query? Is this possible? I know you can import delimited...

Hi all, I'm trying to export my table using the following code: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "incidents", "c:\Incidents.xls", True But unfortunatly I get truncated errors upon export via the vba above. is it not possible to export memo fields to excel via vba...

Hi all I have a csv file with one row containing delimited text via a comma Example 1, James, Smith, Manchester, email, telephone, notes etc.. Think there are 50 comma separations all together. Anyway when I go to import / link my csv into access the data that is on the first row...