Recent content by mkleino

Alright, the way I just mentioned of doing it ended up having some problems--there were situations where it didn't work. So, I came up with a foolproof solution: Option Compare Database Option Explicit Dim Statuslock As Boolean Private Sub Program_GotFocus() CheckStatus Me.Program.Locked =...

What you want to use is the IsNull function: If IsNull(textbox) Then...etc. Hope that helps!

Ok, I figured out what I needed to do, partially by looking at other posts in the forum. I don't think it's possible to make just one line disappear, and I want the other lines to always be visible, so I just used the Locked property instead of Visible. I made a private subfunction that sets a...

I tried, but that doesn't work--it just makes it so that everything in the columns disappears after I go to the next line. OnCurrent does the same thing, but when I'm on that record rather than afterwards. I just want it to apply for each line individually (a line being one record in the...

I warn you that I tried using the module linked to above, and it can be quite tough to get it to do what you want (for example, only format the tab part without the rest of the page background). In addition, keep in mind that you need to set fixed width and height for the tabs on the form (not...

I have a continuous form that lists Academic Progress for medical students as well as hospital residents. I'd like to make it so that certain fields (such as "Program") only appear as visible when another (Status) field lists one of four things (such as Resident). I want the visibility of the...

Thanks very much, worked like a charm! -Mike

Hi, I was wondering if anyone knows how to extract numbers from a text string. I have a notes field that often has year information somewhere in the midst of text, and I want to extract all numbers, but no other characters, from that field. Are there any functions/expressions I can use to...

Certainly, although it sounds like what you want to make is a report, not a form...I assume you mean you just want a list for reference, that will update with the data. If so, make a report with the report wizard, and it will prompt you for how you want to categorize the data in a list, along...

I don't understand...is the form based on a query that includes both sampleno and newsampleno? And why do you want to use the OnLoad property? Are you trying to update only the first record? In any case, OnLoad occurs before any data is loaded into the form. If you want to update the field...

Thanks for the suggestions; I'll keep them in mind if I ever run into problems such as these again .

I have a query that uses three tables, and a form based upon it that is very complicated, multi-tabbed and sub-formed. The form was running quickly and smoothly until one day I decided to try adding a table to the main form's query, and calculating the number of entries in that table per each...

What do you mean--that you want all fields in the query updated the same way depending on an initial choice the user makes, or that you want the user to be able to choose for each entry? In either case, I don't think it's possible to create pop-up list boxes using queries, so you either need a...

Thanks Fizzio. I did have to edit the code, using Access Help as guide, so it would work with the tab. This is a generic version what I came up with: If Me!NameOfTabControl.Pages("NameOfTab").Controls![NameofSubForm]![NameOfNotesField] <> "" Then Me.IndicateNotesTextbox.Visible = True Else...

Well, thanks to both of you. I did, after almost a day's fiddling, get the red tabs to work (nowhere does it mention that for it to work the TabCtl tab width and height settings must be fixed, and can't be 0", which was a very difficult discovery to make). However, due to the limitations I...