Recent content by thingssocomplex

I have a query that I would like to 'Export' to multiple Workbooks I have a field named 'Adviser Name' and I would like a new workbook creating for each instance of a unique 'Adviser Name' for example if there are 3 unique 'Adviser Names' I would like to export to 3 separate workbooks. Is this...

I have managed to get back to earlier verions from a restore point and I am now work on a copy of the database. I have a contacts table and I need to add the email address to the form (from the master table) when I select it from the contacts table I lose the ability to add a new record, how do...

I added a field on an existing form from a different table, Access prompted me to create the relationship which I did and everything worked like clockwork and the new field appeared. However I have now lost the ability to change or add new records (simply greyed out) checked property setting...

I have one table (Helpdesk) that contains certain fields, one unique record per row, within this table is a field name 'Notes' I have a second table to store the 'Notes' how do I link these so that Helpdesk record can have multiple notes stored against it? I cannot limit a user to one note.

I need to remove leading zeros from a file that is exported and imported in to another application, the field must be text, I have used the below SQL but it is not removing some of the leading zeros, can somebody please help. For information the length of the code is always 7 digits and it can...

Hi I have reviewed the data in full all the dates in the one column of date are in american format, but because my regional settings are set for English it reads the dates incorrectly, I need a way of converting american dates to English format so they are read correctly.

I have received an extract of data from SQL Reporting Services, the date fields in one column are a mixture of UK and USA how do I correct the dates so they all appear dd/mm/yyyy? Many are the USA format so all my months are incorrect when grouping etc..... Any help will be appreciated.

Sorry for the confusion, I am working on 32-Bit, I however sent the DB to a number of colleagues and a couple of these had 64-Bit versions which generated the error initially raised. Many thanks for your help.

Hi this link/post should give all the answers that are needed http://gpgonaccess.blogspot.com/search?q=ptrsafe

I can confirm the it is declared, the VBA Macro works correctly when running on MS Office 32-Bit but fails when running on Office 64-Bit. I think I may have rectified just waiting for an end user to confirm by simplying PtrSafe after 'Declare' if this does resolve the issue I will confirm.

Hello, An error appears for the below code and the 'Function' is highlighted when the error is flagged, the error is below, could anybody assist with with how I can resolve? Option Compare Database Option Explicit Private Declare Function GetOpenFileName Lib "comdlg32.dll" Alias...

When exporting a query to Excel using the built in Wizard it removes the underlying SQL, why would this occur it is a select query?

Why don't you have a table with a field named Question, you then could have each question listed, you can have a second field with Code, a third field for date and so on. Question Code Q1 A Q2 C Q3 B Q4 D

Hi I have solved this by using the 'Val' in a query

It the file comes in Access text format to retain leading zeros which are required for some outputs from Access to Excel, however for this particular output I need to convert any number (which are currently text) to a general number, which I know will drop the leading zero which needs to occur...