Search results for query: *

Is it possible to format a hyperlink field and change its behaviour when clicked? I'm displaying a list of links in a subform in datasheet view and it looks messy with the underlining and colour changes.

Any help would be appreciated. A run-time error -2147024809, 'Invalid procedure call or argument' has suddenly appeared in a procedure that worked fine in earlier editions. The changes I've made since then have been cosmetic ones on form and report formats. I'm using Call...

I'm creating a map in Mapometer, exporting it as a gpx file and importing it into Google Maps. This works to a point but only segments of the route show, and then as dense collections of trackpoint flags. How can I get a simple line for the complete route? My objective is to be able to embed...

In a query that asks for a Start Date I'm trying to cater for people just hitting return when asked. If they do this I'd like the start date to be some default value. This SQL produces no results so suggestions what's wrong? PARAMETERS [Enter Start Date] DateTime; SELECT...

This is driving me mad. When modifying the fields used in a report I keep getting 'Enter parameter value' for original fields no longer in the source query. Running the query doesn't produce the same result, ie it opens properly. I can find no reference whatever in the report design and there's...

I'm setting up a selector form for people taking part in a series of activities. This will draw data from a table including Activity, Date, Person and ActivityType (Regular or One-Off). The selector form contains and an option group a combo and a list box. The option group sets the rowsource...

The form I want to open to a blank record displays data collected in an earlier activity booking form that builds records in tblBookings containing names and Activity. The new confirmation form uses tblBookings as source and there's an unbound 'Find Activity' combo using as source all unique...

My client uses a Jobs table with attachment field to store JPG scanned images of the work being done, maybe as many as 8 images. The backend database containing the table is growing rapidly, already up to 0.75GB and likely to go on growing at the same rate. Instead is there a way to store just...

My client is using the attachment field in a Jobs table so much that the backend file is already close to 1 GB. Without attachments it would be easy to append old records to an archive but this isn't possible when tables have attachment fields. Any advice on how to get round this? I could start...

I'm calling this function from a form but am getting a type mismatch error. It works fine in the Immediate window eg ?Points(8,11,5,5) returns 2. Public Function Points(ShotAllowance As Byte, SI As Byte, Score As Byte, Par As Byte) Dim Diff As Byte Dim Netscore As Byte If ShotAllowance >...

I'm using a command button on a Client form to move to a second form that displays the current option lists for a number of combos on the Client form and its Jobs subform. Each combo's NotInList event just instructs the user to do this. The second form has this update/close procedure Private...

I'm exporting data from a form to Excel but dates are coming out as mm/dd/yyyy even though I've include a format instruction like this Set rst = CurrentDb.OpenRecordset("Select * From tblSelectedClients") rst.MoveFirst Do While Not rst.EOF objSht.Cells(2,1).Value =...

I have four email accounts in Outlook 2010. The default one has folders for Inbox, Deleted Items, Sent etc and one called [Google Mail] that contains All Mail, Drafts, Sent Mail, etc. The Sent Mail folder has more recent sent messages than Sent so it's all very confusing. I'd like just to...

This may be a dim question but I can't see how to change what the Reading Pane displays. Currently it shows a list of the previous conversation items, not the message contents. 'Show as Conversations' is unticked. How do I view the current message?

I have a simple report based on this query PARAMETERS [Enter Start Date] DateTime; SELECT tblAllContacts.FirstName, tblAllContacts.Surname, tblAllContacts.[Record Created] FROM tblAllContacts WHERE (((tblAllContacts.[Record Created])>=[Enter Start Date]) AND ((tblAllContacts.Volunteer)=Yes))...

I'm using a master list of items to feed the dropdown lists of several fields in a form and its subform. This is so there's just one maintenance form where field names and list item names can be entered. When a user adds a new item I'm using NotInList to open the maintenance form. When he...

Is it possible to trigger a backend backup either from a command button on a frontend form or when closing the frontend?

I'm opening a form so its subform has AllowEdits set to No. A command button in the subform allows the property to be set to Yes in response to a correct password. How can I reset AllowEdits to No when moving to another record either using the record navigator or when a Finder combo in the...

I'm reporting players scores over a number of weeks. Each week I generate a list of each players scores and append them with round number onto tblScores. I then pick out the players' best N scores over a season, say best N qualifier scores out of however many rounds they play. I'd like to make...

I'm sending data to Excel from an Access selector form and would like to control the workbook dimensions so it is visible without scrolling. This is the early part of the code for exporting Dim objXL As Excel.Application Dim objWkb As Excel.Workbook Dim objSht As Excel.Worksheet...