Search results

Hi. I have an Access 2007 database with lots of passthrough queries that go to SQL server, such as Views etc . One View set up on the server for example, returns a list of house addresses in two formats, one for a mail address: 1 The avenue London and one for a list of properties: The Avenue...

This sounds like CAL is just a legal agreement then? So there's nothing actually stopping more clients joining, just it breaches the agreement? I find this odd as I'm used to Microsoft product keys which are activated online and you need to de-activate one to add a different client.

Hi. I'm interested in buying SQL Server 2008 Standard which is 1 license + 5 CAL licenses. How does this work? Do I need to install a product key on every client that uses the system, or is it 5 simultaneous users? And if I want say 10 clients, where do I buy JUST the CAL licenses from?

I'm talking about forms (I even gave a reason I'm not using a report). If you open a form, go to file>print> print preview, it shows a print preview of how the form would print if you pressed ctrl+p. If copying from a datasheet is only raw data and not cosmetics, then why is the font colour...

Hi. I have a split form with lot of Custom formatting on the background colours depending on the date. When vieing on the pc it works fine. When I go to print preview however, all the conditional formatiing is ignored and it goes back to the white/alternate row colour scheme. This is for...

so there's no chance of recovering it even with recovery software or anything else?

Hi. I have an Access 2007 database and am wondering, if I open it, does access copy it to a temp location first and then open it or does it read it directly? and does the same happen if it's on a usb stick? I don't want to open it on a client's computer to show them anything if they can...

I don't think it is because after th e code is done, pressing f5 doesn't work either. where as clicking out of the database and then pressing f5 works fine. I've tried doing a set .focus on something outside the database but it errors saying its not possible at this time.

just noticed that you are searching for a Bundle ID equal to "Crane.0". Is this right? That means your bundle ID is a string. so you should try: rsCable.Open "SELECT * FROM [Cable] WHERE [Cable!BundleID] = '" & midBundle & "'" Notice the apostrophes (one before " & midBundle and the one in the...

sql doesn't understand bangs the way access does. To reference the field ID on "table" it's table.ID, not table!ID. Try changing "WHERE [Cable!BundleID] " to "Where Cable.BundleID". (square brackets aren't needed, they are normally used if there is a gap in the field name or table name...

Hi. I've got a split form based on a pass through query of a list of names. When the user clicks on the name, it opens up the contact details for them to edit. When they close it, I want the list of names to reflect the changes. If I put the code to open the "details" form on the actual name...

In an effort to strip everything out to upload to here, i've found what i think is causing the problem. I had a group with a sum on one field. As soon as I deleted this the print function worked fine. If I go back to a previous version adn copy that textbox in (with only "=sum([Amount])"...

sorry didn't make myself clear. All I'm trying to do is print one copy of the report. and this works but with an annoying error. The button on the report with docmd.printout works fine but i want the file>print to work as well.

Hi. I currently open my reports using collections so i can have multiple instances. Option Compare Database Option Explicit 'Author: Allen J Browne, July 2004 Public clnDS As New Collection Function OpenADSReport() 'Purpose: Open an independent instance of form Dim rpt As Report...

nice solution! I guess I could just use a select statement. Sorry I switched to reports it's just the code for that was much tidier. and to your question about why i want multiple instances, it's very useful if you have a list of 4 or 5 hundred people and are doing something with only 5 of...

I've got this working without strings using the following: Public clnRm As New Collection Private Sub Command0_Click() Dim rpt As Report 'Open a new instance, show it, and set a caption. Set rpt = New Report_rptName rpt.Visible = True rpt.Caption = rpt.Hwnd & ", opened...

That's correct, I'm trying to create a new instance of an object. (otherwise I'd just use docmd.openform frmname. ) The compiler error with Set frm = New Form(frmName) is "expected end of statement" and it highlights the opening bracket after New Form. There must be a way to do this. i...

hi. I've got the following line of code: Set frm = New Form_frmClient At the moment, the Form_frmClient bit is hardcoded and so the module only works with one form. I now want to send the form name to the module. How can I use a string to reference the form name? I'm looking for something...

Ok slightly more info: The refresh works fine when the form loads. it's only when I open a record's details (seperate pop-up form) and close it that the DS's refresh doesn't work. THe code I use to open the details form is: Public Sub OpenForm(frmName As Form, Form As String, WhereFilter As...

Hi. I have two forms, RM and DS, which are nearly identical (DS started as a copy of RM). They are both based on their own pass through query (which is not complex, just "EXEC dbo.sp_RM" and "EXEC dbo.sp_DS". The recordsource of both forms is set to their pass through query. Yet with RM...