Search results

Hi All, I'm working with Access 2010 and am trying to use the transferspreadsheet command to output data in a query to an Excel 2010 format file. Here is the line of code: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "q_calldetails_tmp", "c:\temp\testoutput.xlsx" It...

Hi All. Grateful for any help here. I've attached a simple database where I have two main tables - Products and Packages. A package is a selection of products. I think the database structure is correctly normalised with a link table that joins a single package ID to multiple product IDs...

Hi All, I've imported some historic user data from some spreadsheets and I have a field which is a unique PIN code for each user. This is set as the primary key on my new table. Duplicates are not allowed. It's a text field with values ranging from 0005 through to 9576. The maximum allowed...

Hi All, I've found a couple of old posts about this but nothing seems to work correctly. I've succesfully linked an Outlook Contacts database to my Access application and created a form that lists contacts. But I now want to open the Outlook Contact form with a specific contact selected. It's...

I have a simple database consisting of a table of driving school pupil details and a linked table of the lessons they take including how many hours for each lesson. I've created a form with a subform. Parent record details on the main form and a table of the lessons on the subform. When I...

I have an application that looks up an address and then takes the address found and puts it in to a string field in the main table. Not quite sure what's been happening (user error the most likely) but sometimes I'm finding a CR/LF at the beginning of the field (in the database, not the lookup...

Hi, I've reposted this as I originally didn't enclose the code properly within code tags. I’m having a problem with some form filters that were working OK. I’m loading a multi-record form based on a query: Q_UpdateRecords SELECT T_CallDetails.[Reference Number], T_CallDetails.custkey...

Hi, I’m having a problem with some form filters that were working OK. I’m loading a multi-record form based on a query: Q_UpdateRecords SELECT T_CallDetails.[Reference Number], T_CallDetails.custkey, T_CallDetails.CallDate, T_CallDetails.Name, T_CallDetails.Address, T_CallDetails.[Call In...

Hi All, I've taken over a database where the original developer created a field called Date in the main table. I'm having all sorts of problems in code where I try to do things with date as it's a reserved word. So I would really like to rename it to something like CallDate. Is there a quick...

Hi All, Still very new to MS Access but learning fast!! I have two tables. The following is a simplified example structure for each. Table_A Field_1; AutoNumber index Field_2; String of codes e.g. MAR;2CH;HOM;;;;;;; Field_3; String to hold expanded code descriptions. Table_B...

I have a multi-record form which opens and is populated from a query Q_JobsToPass which looks like: SELECT T_CallDetails.* FROM T_customers INNER JOIN T_CallDetails ON T_customers.custkey = T_CallDetails.custkey WHERE (((T_CallDetails.Job_Passed)=False)) ORDER BY T_customers.customer...

Hi everyone, I'm new to the world of Access and VBA. Have an excellent book, use VBA help and have scoured the web for a solution to my problems, but no joy so far. What I want to do is pretty simple. It's just a look-up and selection of an address from one form to another. I have 2 seperate...