Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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