Search results for query: *

Do we still have a problem on Access 2010 of labels flashing on tab controls. I remember with 2003, 7 years ago, one had to use text boxes instead of labels. I seem to get a lot of form flashing when I am moving around controls (text boxes and Combo boxes) on an unbound form. It's driving me...

I have both Access 2007 and 2010 on two computers, laptop and pc In forms design, if I try to use any of the alignment features for vertical adjustments, none work. That is Increase Vertical, Equal Vertical, Decrease Vertical. I have searched the web and cannot see anyone with the same...

I have an unbound text box. I am trying to stop the return key going out of the box when it gets pressed. I have gone into Access Options, Client settings, and set it to not move after pressing entry. However it makes the cursor jump to the start of whatever text has been typed in and highlights...

I have a textbox on a form that spits out individual words comma seperated into a variable HTT HTT = Replace(Me.BSUM.Text, " ", ",") It works well, however is not protected against more than one hit on the spacebar between words. I tried HTT = Replace(Trim(Me.BSUM.Text), " ", ",") but it only...

I and trying to locate a record by its Primary key against a value in a numeric string PK4 strCriteria = "[ID2] =" & PK4 rs2.FindFirst (strCriteria) Can someone correct this, many thanks

I am getting a list box display #DELETED when I delete an item in a non linked table. The list box is bound to the table. Both tables are not linked. For Each item In Me.List547.ItemsSelected strlist = Me.List547.Column(1, item) ' Put Keyword in Keywords File rs6...

I have three tables. The first table contains many fields of which one is a memo field. The memo field contents is split into individual words (to be used later as Keywords). These words are put into Table 2, and Table 3 logs the record numbers where the words are in. This all works okay...

I get the error coming up "No record" when I try to add a record in a child record. Problem trying to get main tables AutoNumber to put in foreign key of child related record. I cannot seem to find how to insert the foreign key at the right time Dim i As Integer Dim sql As String Dim LKS As...

I have some code that runs ok in Access 2010, but coughs in Access 2007 Dim TmpKeywords() As String Dim tblKeywords As String Dim i As Integer Dim sql As String tblKeywords = "one,two,three" TmpKeywords = Split(tblKeywords, ",") For Each i In TmpKeywords sql = sql & " OR Documents...

Using Access 2010. I am finding when a textbox gets focus again the cursor goes to the beginning of text, and I want it to go to the end. Can someone tell me where Access now hides this setting. Thanks

I have an unbound form, with 4 controls on, 2 combo, 2 text boxes. The two combo boxes have row sources to tables, choice selection items. I am having trouble going from combo box to combo box,setting focus and using dropdown. I can move from a textbox after pressing return to a combo, and...

I have been away from Access for 7 years, and boy have I gone rusty. I am trying to do a search routine that allows words to be entered in a text box separated preferably by commas, that will select those records where those words are contained. I tried this, but did not get very far. Dim...

I am trying to use a program within Access if it's possible. It should be run from a command prompt (cmd) so I don't know if it's possible to do a shell alternative within an Access DB The instructions I found to run are: 1. You need to have FFmpeg installed in order to create the thumbnails...

I have a query by form that generates a SQL statement that fills a listbox which is then used for an Access report. That all works okay, but now I need to find an easy way to export the SQL or contents of the listbox into a spreadsheet, and later a word document. Concentrating on Excel first, is...

I am going round in circles and getting deeper and deeper with purmutation logic. I have a form with 3 listboxes. At present they thankfully are not multi select. The logic wanted is as the 3 listboxes are in turn selected (no order), the remaining 1 or 2 lists get requeried. I was going to have...

Can someone tell me how to overcome problems I am getting with Microsofts latest creation 2010. Grouping and Sorting. All the work is done in the lower panel, when more than a couple of lines of instructions, there is no scrollbar to navigate up and down the Grouping and Sorting instructions...

I have 3 related tables in a query. I am trying to get data from tables 1 and 2 if there is no data in the 3rd table (table named Progress) I have tried looking for Nulls etc etc but cannot work it out. Table 1 - Partners Table 2 - Activities Table 3 - Progress SELECT PARTNERS.Partner...

I have been plagued with Access 2010 bugs, but now I have a real problem. I deleted a query, and it went into a rapid succesion of dialogues asking do I want to remove table relationships which I said no, no,no. The database then started to empty of forms, and generated a 1k record locking file...

If I run an adhoc query, putting in a date, I get all my records. However I am missing records in a query by form. I have a listbox that gets dates via a query to a table (Updated On) field. The listbox is called DULISTMy query is using a where extension: ' Date Updated If...

Can someone tell me why the top (first) line of syntax works from a list, but the second line from a label does not work. Works MySql = MySql & " AND PROGRESS.Update = #" & Format([Forms]![TabbedForm]![DULIST], "yyyy-mm-dd") & "#" Does not work MySql = MySql & " AND PROGRESS.Update = #" &...