Search results

I have a very odd situation: I have a VBA code segment that I want to exit out if the recordcount = 0. This works great when I am in normal view, but for some reason it doesn't work when I am in dialog view. Has anyone ever experienced such a strange thing? And if so, is there a way to fix...

Hello, Is there a event that can be called if controls on the form change value after the user changes them? I want to change a boolean value in VBA that determines if the form has been altered and whether it needs to save the values on the form or not. The controls are unbound if that makes...

Hello, I have a multi column list box in which I display a date in the first column and a comment in the second. Sometimes, the comment is too long for the column width and I would like to know if there is a way to wrap the text to a second line on the listbox row without having to create a...

Hello, I have a multi select listbox in which I am trying to get the value of the listbox after I select or deselect a value. Normally, I would think that after you select or deselect a row in a listbox, the value would change to that row, but it doesn't seem to be doing that. Am I wrong in...

Hello, I am using the standard delete macro that the access button creator has. I added a line to the macro that runs a vba code segment, but I only want this to run if the user presses yes to deleting the record. Is there a condition that I can write that will allow me to determine if the...

I have these tables and fields: Status Table Status ID (auto number, primary key) Status Name (text) Student Table Student ID (auto number, primary key) ... Student Statuses Table Student ID (value from Student Table) Status ID (value from Status Table) Student Status (Yes/No) Ok...

I have a table in which a student's interest rating for a particular subject is recorded. The table links the fields of the student ID and the subject ID together to create a unique combination of the two. I am then trying to create a form that will allow the user to input the interest...

I creating a form that will require a lot of repetitive data to be entered in. I was wondering if there is a way to set up a default button on the bottom of the form that will set the default values for any field that contains a value when pushed. That way, the values can change from time to...