Recent content by Rosebud

Hello all, I would appreciate any help anyone can provide with this: I have an html page that has a hyperlink to open an Access database on the same server the html page is located. Ideally, I would like when the user clicks this hyperlink, for the database to automatically open up. Instead...

Hello, I'm developing a small Access 2000 db and I'm having a problem with one of my forms. I have a main form that contains a subform of filtered records (the subform has filtered records). When I print preview my main form, the subform is no longer filtered, it shows all the records in the...

I think I found a way around it. What I did instead for my textbox is make the controlsource: ="$" & Format([delta],'#,##0') So now (for example): -18296.344 becomes $-18,296 which is exactly what I wanted,and Regional Settings don't matter. I think this should do. Thanks Scott for your help...

Thanks so much Scott, that got it to work. But does that mean that all of my users have to manually do that also? I'm still trying to see if I can write some code that does it automatically. Thanks. Rosebud

Hello, I'm wondering if I can have a negative currency value in a textbox. I have a field on a form where I'm showing the difference in two dollar amounts. If the difference is negative, I want to show that negative sign, but I also want to show the $ sign for that field. For example: $-18.00...

Thanks guys for all of the good ideas. I did download a demo of HyperSnap, which did exactly what I wanted, exactly. So thanks Rich for that suggestion. I also tried the cutting and pasting of different screenshots into Paint, which worked but takes a little more time and effort, but I'm still...

Thanks Unique for your help. Unfortunately, that was attempted early on and the resolution on my computer was already set at the limit. But good idea. Thanks. Rosebud

Hi, This may be impossible to do, but thought I'd give the question a shot in this forum. I'm trying to create a snapshot of a form, which I know can be done by pressing Alt+PrtScreen, but the problem is that my form is long, and the bottom of the form is not captured in the screen shot (I...

Hi Abby! Okay, well I actually have been to that site and I tested it, and for some reason I couldn't get it to work. Were you able to download that conform.zip file? On my computer when I tried to open/save it I just kept getting Acrobat Reader installation instructions but no sign of a...

Does anyone know how to activate conditional formatting not just for when the control gets the focus, but for when the record gets selected? I have a long list of students. When the user selects one of the records, I would like for all the controls in this record to be highlighted. Any ideas...

Sure Abby. Thanks!

Thanks a bunch Abby, I tried your code and it worked great! I do have one problem though. Suppose I edit the very last record on the main form. After editing this student and going back to the main form, now (after I added your code) the cursor makes that student the current student (which is...

Hello, I have a problem that seems pretty simple but I just can't figure out. I am trying to requery a main form without losing the current record. I have a form of students that shows basic info on these students. This form cannot be edited, but there is a button on the form that when...

Thanks Rich, that worked nicely.

Hi, I've searched the forum for a solution to my problem, but nothing I've found helped so .... I'm trying to assign a control source to a control on my form at run-time, but I can't get it to work. This is the idea I'm going for: txt24.controlsource = "=DateAdd("m", -1,date())" but this...