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...

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?

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...

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...

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...

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...

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...

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...

Hi. I have a split form based on a pass through query with only 400 records. The form however has loads of controls (about 20). The passthrough query opens in less than a second, but the form takes nearly 6. this is too long as it's the main form of the program. Trying to find out what's...

Hi. I've got a form which is very similar apart from a few texts boxes, so I hide the relevant textboxes that I don't need dpending on the OpenArgs. E.g. Me.cmbHB.Visible = True Me.cmbHB.Height = 0 I want to make a function like this: Private Function HideControl(ctr As Control)...

Hi. Ive got a template in Excel which has references in it that have the same name as the controls on the form that i want in the template. so far I have: Dim objExcel As Excel.Application Dim oReference Set objExcel = New Excel.Application Set oWB = objExcel.Workbooks.Open("Y:\RDN.xls")...

Hi. I've got a Word document which has an embedded Excel object. I am changing values of the word document and its excel object from VBA in Access. So far I have: For Each oIShape In .ActiveDocument.InlineShapes If InStr(1, oIShape.OLEFormat.ProgID, "Excel") Then...

Hi, I'm using a Access 2007 front end with a sql express server backend on a windows server machine. I have a form with a sql table as a datasource. I've got a problem where if i edit an existing record (doesn't matter whcih field), when i go to close the form it hangs for around 5 minutes...

Hi. I've got a report with a comments field. I want this to print out if the user wants it to, but otherwise hide it (i don't want the client to see the comments). At the moment it's set to display on screen only. Is there a way i can add a button that changes it to print only, prints the...

Hi. I'm trying to create an archive for my database. i'm going to append from multiple tables to another databse, adn then delete the originals. THis is fine, but I'm worried somehting will happen during append and then all teh originals will be deleted. what's teh best way to handle...

Hi. I have a query which has a tick box that i need to be able to change in a form. when the query only has one table in it, this works fine. However as soon as i add a second table to the query, i can no longer edit the tick box. I've tried changing the relationship but doesn't work. Is...

HI. I've got a form with a few records in it, and once you click on a record, a report comes up with the details. I need to be able to print say 20 of these easily and quickly. I've added a link to each record that when i click, will just print the report without opening it, but this still...

Hi. I have a form with a box on it that points to a currency field "Rent" on a table. In VBA, i need to use this value to find the Rent per day (the user enters rent per month in the form). at the moment i have: Dim RentPerDay As Double MsgBox Me.Rent RentPerDay = Me.Rent * 12 / 365 MsgBox...

Hi there. I've got a table called Issues, and a while ago i moved the backend to a server and linked the table into my front end. nwo i want to copy the backend to my pc so i have a local copy so i can edit stuff without being on the network. WHen i change the linekd table address it says...

Hi there. I need to clear all the data from a form before requerying it. is this possible? at the moment i've found if i press Esc to remove all the data i've got so far, it's fine. is tehre anyway to "press esc" with a macro?