Search results

Hello gurus, Some users of a database I created have reported times when they would enter 10+ lines in Datasheet view, close the program, and those newly entered records would be gone. The old ones from days past are still there. Furthermore, this behavior of not saving data happens...

I fixed the error, though I have no idea why it works... I created a new combobox for the ES1,S1,ES2,S2 fields and applied the same rowsource, name, internal column widts, etc, so that it was an exact replica, and now the columnwidth VBA statement can change them. What's up with that? So...

DCrake: You're right, the users never manipulate the columns internal to the combobox, but they do change the width of the combobox itself either to match the contents of the cell (20%) or moreover to condense the columns for better visibility (80%). I'll try deleting the cells ES1,2 and...

DCrake: Thank you for the reply. The way it works is this... the user has their subform columns customized the way they want it through dragging the column's head. Whenever I send an update to the main form, though, it wipes out the users subform columnwidths. So, using the code the the person...

Hello, ?:: Are there instances where the ColumnWidth property of a textbox & combobox cannot be changed through VBA? I have a form with two buttons (save & load) and a sub-form (30+ columns). When the save button is pressed, I have a VBA sub pull the name, sequence, and width of all...

Idea. Is the query reading the textbox as a string and not as a command? Ex. Does a query pointing to a textbox with... Like "*" & Forms![Expenditures]![txtCCVar1] & "*" Or Like "*" & Forms![Expenditures]![txtCCVar2] & "*" ...reading "Like" as a string, and instead of a command? Can form...

Hello all. I have a query with a field A. The criteria for field A is dynamic with 10 user fields on a form, which the user can select only 1 or as many as 10 options to limit the search. After the user makes his/her selection, the form builds the criteria statement from the user choices and...

Hello All, I am just beginning my jump into DAO Objects in Access, and had a quick question or two. 1. Is a QueryDef the same as an Access Query object? My meaning is, does it function like a SQL "CREATE TABLE" statement to create a clickable object, and if not, what does the code: Dim db As...