Search results

ok, this is really annoying me now.. i've managed to get this to work.. but i dont understand why.. In solution properties within visual studio.. on the Build tab i set 'Register for COM interop' to true, and within 'Application>Assembly Information', i set 'Make assembly COM-Visible' = TRUE...

Have just read this on http://richnewman.wordpress.com/2007/04/15/a-beginner%E2%80%99s-guide-to-calling-a-net-library-from-excel/: Possible Problem with these Examples One problem we have had with these examples is that Excel can get confused about which version of the .NET Framework to load...

Hi Gemma.. I create the tlb file using regasm.exe and then add that file to the project references.

Re: .net and Access 2003 fixed that and still got the same problem.. the error occurs on this line: 'Set f = New SBG_TestWithVBA.TestHello'

Re: .net and Access 2003 I am struggling with this.. I have compiled a dll in c# 3.5.. where i set the solution properties to register the build for COM interop. using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Runtime.InteropServices...

I have macro that deletes and existing report sheet and recreates it from scratch. the macro outputs tables and graphs for each client in the spreadsheet.. in vba, i manually add a pagebreak after every 4 client outputs. However, excel still keeps the default pagebreak that exists two rows...

Is there a way to import tables and their relationships? I have created a new module. Its been tested by users in a test environment. Now i need to import the tables and relationships into the live database. Is there a way that i could do this with wizards or VBA.. or do i have to manually...

Hi Pat Thanks for your comments. Not sure why you suggest putting CompanyID in the phase table, as its a one-one relationship.. so in my mind it wouldnt make any difference ??? I hear your second point.. I never use autonumbers when i am designing a database from scratch as i find them...

sorted !! it appears that the relationship diagrams do not update. I must have set the index no duplicates on the foreign key after i created the relationship..

I am documenting my database and just realised that my relationship diagram is showing one of the relationships oncorrectly. The foreign key field is set as indexed with no duplicates, but the relationship diagram displays it as a one-many relationship.. am i missing something here?

Worked !! thanks very much...

I want to show/ hide a sub report.. I can do it easily by setting the visibility using a global variable.. eg Private Sub Report_Open(Cancel As Integer) Me.Controls("rptBlockWindowsDetail_Sub").Visible = gShowSubReport end sub I would like to control this based on the value of a...

use a group by query ???? SELECT U.Yr, U.Mth, U.CNo, U.Customer, U.AON, U.AOC, U.CON, U.COC FROM (SELECT Yr, Mth, CNo, Customer, AON, AOC,Null as CON,Null as COC FROM qry_Sub_AO UNION ALL SELECT Yr, Mth, CNo, Customer,Null as AON,Null as AOC,CON, COC FROM qry_Sub_CO) AS U GROUP BY U.Yr...

Is the error message something like 'Object Error - Read Only Object'.. I had a problem like this where the back end mdb had become read only, even though all users had closed down the front end app. I had to ask Domain Admins to kill all connections to the file. I put this error down to a...

deleting indexes I think this thread will help.. http://www.tek-tips.com/viewthread.cfm?qid=1338393&page=8 you might have to delete the index using vba.. this should do it.. Public Sub DeleteIndex(TableName As String, IndexName As String) Dim db As Database, tdf As dao.TableDef, Idx...

sub CreateInvoice(ClientID as long, description as string, InvoiceNumber as string) dim db as dao.database, rs as dao.recordset, sql as string SQL = "SELECT ClientID, InvoiceNumber, Description, Date FROM tblInvoices" set db = currentdb set rs = db.openrecordset(sql,dbopendynaset) rs.addnew...

Hi Guus I know normalisation. I've been developing for 5 years... As far as i can see, your solution doesnt help me achieve anything.. or is it that i don't understand it.. Could you make the changes to the file I uploaded and then re-upload. It will help me better to understand.

Write some VBA that gets triggered from AutoExec which checks the system date. If 1st of the month then loop through all of your clients and create your invoices.. Easy.. public sub CreateInvoices if not FirstDay then exit sub dim db as dao.database, rs as dao.recordset, sql as string SQL =...

Guus2005 Hi Guus Thanks for your help. I cant remove PhaseID as its a key field. It has to stay in the SOR table as the costs of the SOR items are Phase specific. The database contains data for a property repair/ maintenance project. PhaseID is the phase of the project. The HEADER...

Guus2005 RE: "Question: how can a SOR_ID exists in DETAIL but not in SOR? This compromises the referential integrity" Thats what i want to avoid. I have attached the database with some sample data.