Search results for query: *

Thanks, no I did not use the form wizard as I never use it, build from a blank form. So that's interesting, bit silly making it only useable with wizard as all other alignments ie top,left etc work. But thanks, will try it out. Regards

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

Oh well thanks. At least I can live with it, but its a bit of a pain on the alignment having to do it manually. Horizontal functions all o.k. Regards

Thanks. No, nothing moves at all, no controls are overlapping. I thought because my Laptop and my PC did this with 2007 and 2010 then it must have been a bug. Also the tab setting problem is on both. Strange. Software was legitimate, Microsoft activated and has checked authenticity??

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

Thank you PHV, sorry for delay getting back. Worked like a charm, thanks again

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

Thank you PHV, that works perfectly. It is a request to be able to export a comma delimited file although nobody can tell me why at the moment. But thanks for fixing this one.

It seems my problem is in this line HTT = Replace(Me.BSUM.Text, " ", ",") I looked at HTT after putting in 3 words with 3 over entered spaces and I am getting this HTT="One,,,,Two,,,,Three,,,," Is there a cleaner way to break up text typed in a text box into single words separated by a...

Thanks PHV, I could have done, did not think at the time. Thanks Randy700, good idea, but did not sort problem, however you got me nearer. For i = LBound(TmpKeywords) To UBound(TmpKeywords) LKS = TmpKeywords(i) If Trim(LKS) = "" Then GoTo Z1 I stepped through the code and I was...

Thanks. However I get the same problems. If I type a word in the text box and then add more than one space, and then add another word and do the same etc etc, then I end up with an unwanted large space between the first and second words, but after that it's ok, the spaces are corrected. Maybe...

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

Many thanks MajP, I will pin that up on my wall. Thanks again

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

Many thanks. I carried on with what I thought was okay and so far seems logical. I did not want to have multiple words stored, and yes I am doing everything in vba. I am checking tables every time I add a keyword in the table etc. I have adopted a fourth table outside of the 3 linked tables...

Solved, I was not re-querying table Me.List547 Now shows cleared list

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 should be much clearer and moving forward, but have some queries, hope I can get answers. I have 3 tables. Table 1 is my main table containing reports. It has a primary key ID1 Table 3 will contain keywords that are contained within within a report field in Table 1. Table 3 has a primary key...

Thanks PHV. So I look in the word table, and if the word is there then use it's unique number in the junction table so only duplicating and storing numbers. Sounds a much better idea. I started with my Junction table having two foreign keys holding the primary keys of each side table. However...

Thanks Lionelhill, I am doing the actions in the same order you have suggested, however when the next record is added to the database, the same wanted word (as I am excluding common words, i.e. and,f etc) then the word gets added into the word table again as the junction table has to get...