Search results for query: *

its ok i got a workaround. my switchboard now runs a macro which in turn runs the code! thanks anyway!

my code is as follows Public Function MergeReportData() Dim strPath1 As String Dim strPath2 As String strPath1 = "P:\Apps\32BitWin\Office2000\PFiles\MSOffice\Office\WINWORD.EXE" strPath2 = "N:\MyWork\ASComp\ASCoursework\rawCompanyOverOneYear.doc" Shell strPath1 & " " & strPath2...

also in the original code IF NewlyaddedCompanyName = unique then InvoiceNumber = 1 End If IF NewlyAddedCompanyName = has appeared x times then InvoiceNumber = x NewlyAddedComanyName is pseudocode i should have rephrased to IfTheCompanyIJustAddedToMyQuery =...

i created a form with a new text box and built an expression but the value returned was "#Name?" also i did not know how to incorporate it into an existing query. SELECT [tblJobs].[JobID], [tblCompany].[CompanyName], [tblCars].[Registration], [tblTyres].[Tyre Type]...

also would i have to call this function and if so where would i do it?

= '" & NewlyAddedCompanyName & "'") was wondering do i need to amending this to my database? am thinking i dont need to touch this part of the code.

and would i put this code in a module or..?

pseudocode for the code i want like is as follows, i am just having problems applying the correct syntax. IF NewlyaddedCompanyName = unique then InvoiceNumber = 1 End If IF NewlyAddedCompanyName = has appeared x times then InvoiceNumber = x this code is an...

the relationship between tblcompany and tblcars is a 1 to many relationship between a companyID primary key in tblCompany and another in tblCars as can be seen here: www.v-loaded.com/stal1n/relate.gif

SELECT tblCompany.CompanyName, tblCompany.ContactName, tblCompany.Address, tblCompany.PostCode, tblCompany.TelephoneNumber, tblCompany.DateLeftIn, tblCars.Registration, tblCars.CompanyID, tblCars.CarID, tblCompany.CompanyID FROM tblCompany INNER JOIN tblCars ON tblCompany.CompanyID =...

This is the error message that is displayed in my form when i i try and add new details. The form runs of a query which runs of two tables which are related appropriatly. The whole point of the form being to add a company and attach a car to it. I can type in the company details fine but i...