Search results

Thanks, Rich! It does work but not at all times. I wonder why? the onfocus forecolor stays even though the focus is already in another control. And it only happens with the first few controls I set the focus on when the form opens.

Oh, well. I guess I just have to continue doing the tedious work and just hope someone will come up with the shortcut. :)

I'm only doing this to labels as the associated control (textbox/subform/command button,etc) got/lost focus or on enter/exit properties.

I can change the forecolor of a control on got/lost focus but I have to rewrite the code over and over for each control. How can I do it in a function? I tried using the activecontrol property but I don't have any luck to make it work. Thanks in advance for any help.

Thanks! I tried it but it still showed th # sign. Anyway, I tried the hyperlinkpart function and it did the trick!

I have an ubounded text box in my report that contains a formula like: [text1] & [text2] & [url] When I preview the report, a # are appended at the start and end of url. I tried to have a separate text bos for url and it showed fine. I want to do it this way (concatenate) in order to save...

Travis, Thanks a lot! It worked like a charm!!!!

Travis, I was so excited to try your code but then when I tried to run it, it was looking for a function named replace! Thanks!

I would like to create a function that will take numbers as inputs and generate a certain combination of 5 letters. Let's use A,B,C,D,E for example. a user inputs how many A's or B's and so on, he wants to have in the output. It is not necessary that there is an input for every letter. So, a...

thanks! i'll try that.

I have the following that shows me which record I am curently viewing out of total records. Dim Myrst As Recordset Me.CurRec= Me.CurrentRecord Set Myrst= CurrentDb.OpenRecordset("SELECT field1, field2 FROM tbl1 WHERE tbl1.field1='" & Forms!frminfo!field1 & "'") Myrst.MoveLast Me.totalrec =...

I found the Microsoft QBF sample and edited it. I am getting a Syntax error in one of the lines I added and wondering if it is really possible to do it. The error happens in the line that has the datediff function. I would like to be able to enter something like <=30 or >=30, etc. in the...

I would like to create a database that will keep track of documents being handed off from one person( or department) to another. I thinking of setting up an events table that will show the info about the document, who received it, to whom it was passed when and other info. However, I only want...

How will I be able to compare a current record with the previous record using rst?

I have a table that looks like this: SID..Field2(y/n)..Field3..Marker(Y/N) 1....-1...........85......0 1....-1 ..........21......0 1....-1...........12......0 1....-1...........28......0 1....-1 ..........15.....-1 1.....0...........21......0 1.....0...........13......0...

Thanks! I'll try that.

I also tried it but it didn't work. Thanks, anyway!

I need some ideas on how I would create a budget variance report. I am a bit confused on how I would start it. I have 2 tables, transactions and budget tables. Records would contain Account numbers, date of transaction, and amount. I need to create a report that will show the accounts, MTD...

I tried to use the code in MS's Article :How to Create an audit Trail of Record Changes in a Form. It does not seem to work in subforms. What should I do?

I have a report that takes its parameters from a form. I don't have any problem generating the report.When I try to click cancel (cancel button, on unload event, there's a macro to cancel event) or close the form without generating the report, the query associated with the report still executes...