Search results

Well, if your major concern is keeping the pop-up box about update queries from appearing, i recommend: DoCmd.SetWarnings False 'The rest of your code DoCmd.SetWarnings True

Private Sub Station_AfterUpdate() On Error GoTo Err_Station_AfterUpdate Dim strSQL As String If Me.Station = "---All Locations---" Then strSQL = "SELECT * FROM tblStations;" Else strSQL = "SELECT * FROM TblStations WHERE StationName = '" & Me.Station & "';"...

ick. His or mine? i've been using that syntax throughout my whole project, but if its bad form i'll change it.

Um, is this all in one function? I don't think you need any refresh, requery, or repaint for this Me![High School ID] is a text box, right? the changes should be immediate. It could be that control isn't reaching that branch. (allthough i assume you checked for that). I would put a button...

At first this made sense to me, but I am starting to disagree. Access is whacked. :mad: Following SJ McAbney's excellent advice, I began to experiment with the "Bring to Front" and "Send to back" menu commands. Somehow, defying all logic, these commands are related to the tab index of a...

Thank you for the suggestion. Maybe I'm doing it wrong, but when i try this solution, the rectangle becomes invisible (it doesn't change the visible property, just makes the control disappear). So there is no background color, even the border is gone.

i know :( it is :( when i create a rectangle control, it covers up other controls. how do you make it go underneath? Edit: Here's what I'm doing exactly, I'm probably doing something incredibly wrong. 1) Have a form with a combo box on it. 2) click the rectangle control button 3) drag the...

Yeah, that is a work around solution, but if anyone else has a good idea, i'm all ears!

Good suggestions, but I was really hoping there was a way to layer controls. It seems to choose which control to put on top arbitrarily. I thought the most recently created control would be on top, and for a while that worked, but when i changed the tab order of the controls, the important...

This project is in Access2000. I have a form with a really large tab control on it. All of the other controls belong to one of the 4 pages of the tab control. The tab control is so large, it has to be scrolled up and down. (I would make it smaller if the design of this project was up to me...

This was the point it got hard for me to read. You just want the percent of records that are yes, out of all the records for some month? I wouldn't wonder. It seems to me like you want 'yes' to be equal to 1 and 'no' to be equal to 0. This way you can sum the column, divide it by number of...

I'm using controls like textbox and rectangle to prettify my form. For example, putting a background under a control or group of controls to help the user visually seperate them. I'm having problems making the right control appear ontop though. For example, there is a combobox on one page of...

Well, it's hard to interpret what's going on here, but I'm going to take a stab at it. You have a table, maybe called something like "tblTroubleTicket" where techs keep track of the work they are doing. You have a form for the trouble ticket table, where the tech puts in all the data about...

So, I have one query in two databases. The query works correctly in a minimal database, where the only existing tables and fields are the ones involved in the query. The query will not work at all in my real database, and in fact will crash Access in quite a hard manner. This is the minimal...

I'm having the same problem right now. All of the iterations of the continuous form have the same controls. Unless they are bound to a control source, I cannot figure out how to make Access treat treat the controls on each iteration individually. Example: there is a checkbox control on a...

I wish I could!!!! The post-doc I'm designing this database for has specified all of the controls to be used, and their behaviour. At first she wanted a checkbox for each gene, and only relented when I reminded her that the gene info was dynamic data and that the form would need to be updated...

Ok, i think i understand now. The undesirable sequence of events occurs like this: Form is opened. The checkbox is false and the textbox is invisible.[/*] User checks box, textbox appears.[/*] User moves to next record.[/*] Textbox is visible when it should be invisible.[/*] Is this what...

In the format properties, make it have two columns. Make the width property something like: 0";1" a width of 0 makes it hidden. in the data page of the properties, your row source should be a query selecting the two values, the hidden one first. set the bound column to the hidden column.

I am also pretty green with access, but it seems like to me that you are using the wrong event. GotFocus doesn't seem like an event you can reliably predict. trying: Private Sub NS_EVENT_ID_Click() would be my first suggestion.

I've learned alot from everyone here, and I really appreciate it. So many of my problems and frustrations are due to a lack of experience with Access, which everyone here has in abundance.you all are the coolest. Today, besides almost taking a hammer to my workstation of some check boxes, I've...