Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MeldrethMan

    Format Hyperlink Fields

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

    Sudden Run-time Error -2147024809

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

    Importing GPX Files into Google Maps

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

    Parameter query to use default data when none is entered

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

    Report looks for field not in source query

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

    Clear List Box

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

    Open Form to Blank Record

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

    Alternative to Attachment field

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

    Attachment field making backend file very big

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

    Type Mismatch Using Function

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

    Requerying Combos Causes Form to Revert to First Record

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

    Exporting date to Excel causes day/month to reverse

    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 =...
  13. MeldrethMan

    Outlook account has [Google Mail] folder

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

    Reading Pane

    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?
  15. MeldrethMan

    Report asking for parameters

    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))...
  16. MeldrethMan

    Dropdown List Maintenance

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

    Do backend backup from front end?

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

    Resetting AllowEdits to No

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

    Report based on table with variable number of fields

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

    Workbook dimensions

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

Part and Inventory Search

Back
Top