Recent content by arm1

I always forget the exact definition of a continuous form, but I believe it IS. I am able to add a checkbox from the tools... the problem is that when I put it in the details section of my form (so that it applies to each record), it is binary (on / off)... so checking it for one record checks...

I was wondering if anyone knows: Let's say I have a form (or subform) that displays a bunch of records, in tabular form. Is there a way I can add a checkbox (or some other indicating control) that would allow the user to select any number of records. The application of this is simple: I have...

I was wondering if there is a way to modify the way text is entered directly into a field in a table. Currently... if you are entering text in a memo field, and press ENTER, the focus gets shifted to the next field. Is there a setting that i can change that would simply go to the next line in...

I was wondering if there is a way to modify the way text is entered directly into a field in a table. Currently... if you are entering text in a memo field, and press ENTER, the focus gets shifted to the next field. Is there a setting that i can change that would simply go to the next line in...

I understand the proposal... but there are a few glitches. Sometimes I have drop down lists that are Yes / No Sometimes its is Yes, No, Maybe. Sometimes it is Yes, No, Sometimes, Never etc... The point is that I couldn't be creating a new table every time I need a variation of a drop down...

I was hoping someone could assist: I open a form which accesses a table record. I have a field which is a drop down list that is a Value list with the values Yes;No. When this form opens and the record is displayed, the value that shows up in this drop-down field is (for example) "No". This...

I am hoping someone can help me with an issue I have: I have a report. It is unbound! There is a field on it that tries to ask the user for an input value (for this field, I have set the control source to " =[Please enter an value: ] ") This report also has 2 different sub-reports within it...

I have a form with unbound fields. One of the fields is a date that the user must enter. I ask the user to enter it as mm-dd-yyyy, but because the field is a medium date then obviously if the user enters 02-12-2009 the system converts this and puts 12-Feb-09 into the field. The issue seems to...

If I have a subform that is in datasheet view, is there a way to LOCK the order of fields so that the user cannot highlight a column and move its location? Thanks, - arm1

Good question. I too put '00' the Format property of this field... but running the form again seems to have changed nothing? I tried '000000' just to see... nothing. It keeps the value as 2... not 02... nor 000002. I don't understand why... I just figured it was something to do with it...

I was wondering if someone knew why I was getting this error: I have two MS Access Databases. Each database is linked to the same (separate) database containing the table, which are linked. I create the same query in both databases. When I run the query, it gives me (let's say) 10 records as...

I have a textbox that is unbound. When a user selects an item from a separate (also unbound) drop-down list, I associate the .column(1) data to this textbox. The issue is that the value is numeric. When I try comparing the value to a number X != X because one X is an actual number, while the...

Yes... the table itself allows Null values (for fields that are NOT part of the primary key, of course). The issue is in the VB code: str1 = "INSERT into <table> (<field1> <field2> <field3>) values (" &x &", " &y &", " &z &")" If y is Null... then executing doCMD.RunSQL str1 gives me an...

... and how can I use the Nz funtion to copy the blanks? Lets say the field is null... I also want to new record to have a null. It seems in the INSERT statement, it won't accept the Null... Nor will it accept "" or " " ??? Thanks for the help, - arm1

I am having issues transferring records using VB (actually, SQL) because of Null values within some of the record fields: Lets say I have a record that has 5 fields. The first 2 are part of the primary key, the other three are just descriptive fields. Within VB code, I create a string variable...