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: *

  • Users: ZOR
  • Content: Threads
  • Order by date
  1. ZOR

    Dirty

    I have a command button which terminates entering a new record being created. I put my code in where I think the record has started being created, ie the first field has data entered, its autotab is set to true and goes to the next control. Its then I hit a button with code as below. However it...
  2. ZOR

    Cancel an on exit event

    If a textbox memo field has an on exit event, and whilst a user is typing in data during creating a new record, how can you kill the on exit event if they hit an abort/cancel record button? Thanks
  3. ZOR

    Record deletion problem

    I have a mainform and subform. They are both bound to related tables. On the subform I have a button to create a new record. However if after typing in data I change my mind and press an abort button it leaves a blank record in my child table. I am using: DoCmd.SetWarnings False...
  4. ZOR

    Query problem

    I have a query that works okay: mysql = "SELECT * FROM ( SELECT TOP 5 TXMASTERS.ID1, TXCLIPS.ID2, "" "" AS Persons," mysql = mysql & " TXCLIPS.ID2, TXCLIPS.Comments, TXCLIPS.Start AS [Time In], TXCLIPS.End AS [Time Out]," mysql = mysql & " TXCLIPS.ID1 FROM TXMASTERS INNER JOIN TXCLIPS...
  5. ZOR

    Replacement for MSCOMM AtiveX control

    Does anyone know of a way round or alternative in not using the MSComm control for serial port communication in an Access database. Regards
  6. ZOR

    Listbox vanishes and then returns

    I have a mainform with a listbox. When the listbox is selected, the mainform is set to the record selected. The mainform has a subform with a listbox on it. Its rowsource is in vb SQL code which fills the listbox with related data to the mainform. I originally put the subforms list query in...
  7. ZOR

    Access 2007 Ultimate edition - ActiveX

    Cannot enable activex controls. Been into Trust settings and there is no mention of activex security settings. Clicking an activex control produces a message "Because of your security settings and current security policy, this control is disabled" Any ideas, thanks
  8. ZOR

    mscomm cotrol for ms access 2007

    Is there any equivelant code/control for using mscomm control in Access 2007. User wants serial port communication from Access database. Thanks
  9. ZOR

    access 2007 module

    How/Where can yu create a module. I need to be able to go into references. Can someone tell me how you do it. Thanks
  10. ZOR

    Multiselect Listbox

    I have a query which produces 2 column data for a listbox. SELECT AthleteNames.Athlete, Mid([Athlete],InStrRev([Athlete]," ")+1) AS Expr1 FROM AthleteNames WHERE (((AthleteNames.Athlete) Like [FORMS]![Memos].[UU].[CAPTION] & "*")) ORDER BY AthleteNames.Athlete; If the list is made as a...
  11. ZOR

    Search based on changing text

    I have a textbox/memo field. The user types in descriptive text of a sports event. During typing in text, the word being typed in maybe of someones name currently stored in a names table. Has anyone attempted to do such a thing that searches during a word being typed in then rebuilds its search...
  12. ZOR

    Normal Case

    I know there is an upper and lower case instruction, but is there a normal case? Would like to convert this line to normal case. NName: Concatenate("SELECT Athlete FROM qselJunctionNames WHERE ID2=" & [TXCLIPS].[ID2]) PHV - If you are there, my last thread had a star for you. When I posted...
  13. ZOR

    Listclick Problem

    I have an event of a list click. If I click on the list, code is run which includes a query to fill another list. It works okay. However if I click on the list and use the up/down keybord arrows it halts displaying a notice - The macro or function set to the BeforeUpdate or ValidationRule...
  14. ZOR

    2003 and 2007 messup

    I have installed Office 2007, keeping 2003 programs. However each time I click a desktop icon for a program that was of 2003 origin, it opens up in 2007 version!!! I don't want to happen. Also if you don't open the program up in its native version and then close it makes it confused. In the past...
  15. ZOR

    Programatically set listbox position

    I am trying to get access to a listbox in design view but move its position when its displayed. Any advice how to do it as it seems to be a hit and miss job setting its top and height properties in code.
  16. ZOR

    Query based on Junction linked tables

    Having put in a junction table to avoid duplication of data has become a nightmare. I am trying to recover a way to produce reports. The code below works but only because old data is still in records SELECT TXMASTERS.Barcode, AthleteNames.Athlete, TXCLIPS.Comments, TXMASTERS.Competition...
  17. ZOR

    Select last 15 records

    The code below is the record source of a listbox. How do I modify the code so that it shows only the last 15 records in ID2 order. Many thanks SELECT TXMASTERS.ID1, TXCLIPS.ID2, " " AS Persons, TXCLIPS.NName AS Name, TXCLIPS.Comments, TXCLIPS.Start AS [Time In], TXCLIPS.End AS [Time Out]...
  18. ZOR

    Subform/Subreport opens formatt toolbar

    I have put a subform/Subreport on a form, its bound to a query. However when I go to type in it, an additional menu opens in the top of the application causing the subreport to drop down the page. How do I stop this extra toolbar which allows font color selection etc, opening? Many thanks
  19. ZOR

    Join expression not supported

    I had a query which worked okay. SELECT DISTINCT TXCLIPS.NName AS Name, TXCLIPS.Start AS [Timecode In], TXCLIPS.Duration, TXCLIPS.StarRating, TXCLIPS.Comments, TXMASTERS.Barcode, TXMASTERS.SeriesName, TXMASTERS.EpisodeTitle, TXCLIPS.NName, TXCLIPS.Start, TXMASTERS.Typeofmaterial...
  20. ZOR

    Cannot perform funtion while tables linked

    I have a query that won't run while table links are in force. I had this problem with a select query until making it append. Can I modify the code below to enable it to be run while links are in force? Many thanks. Set rsAllAthletes = CurrentDb.OpenRecordset("AllAthletes", dbOpenDynaset)...

Part and Inventory Search

Back
Top