Search results

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 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

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...

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...

I am hoping someone can help me with this issue: I have a form with two subforms. Both subforms are in datasheet structure. If you highlight a record in the first subform and click a button to 'transfer' I can determine which record is selected, and code the transfer. If you click on the...

For an unbound field with a query as its drop-down list... If you create an input mask... say of format 00000... then as you start typing in the values, the system removes the zeros. Ex: When I enter the field, it shows 00000 If I type in a 1, it shows 10000 Then if I type a 3, it shows...

I seem to be having issues with Leading 0's: My table has a number field, and its format is 00000. My form has an UNBOUND field who's drop-down list is the table's formatted number field. The issue is that I need to LimitToList = yes, so that the user can only enter values that currently...

Hi, I was wondering if anyone can help me. I am trying to set the date format, but not of access dates. Rather, I am trying to set the date format of the users Regional Options date format, but from WITHIN MS Access. The problem is, that users create entries... a (medium) date is obtained and...

I think I should try and specify more what the issue is: There is a database that contains only the tables / data. There is an interface (copy) on multiple computers that allow interactions with this database. So, many users are adding entries to a specific table. There is a report that...

I was wondering if there is some setting that can be set such that certain records within a table are not visible when the table is opened, or a form is accessing its records. It seems from time to time, some records seem to 'disappear' from view?!? Other than a filter... Does anyone know how...

I seem to be having some major problems with one of our tables. Recently a table that has been fine for a long time has developed something corrupt, so it seems. I found that the LAST entry in the table is nothing but #Error in every single field. When I open the table, I get 'Invalid Entry'...

I am having difficulty formulating this query. I have 2 tables... 1 is customer info (name, address, etc...), and the second is shipments (ShipToCustomerName, ShipmentDate, etc...). Now, I wish to query the shipments table to get ONLY the LATEST shipment information for EACH customer. If...

I was hoping that someone could at least tell me if this is possible. I have a table that (among other fields) has an integer field (call it X) and a date field call it Y). I was hoping that I could create a query that captured these two fields (no problem), but also included a third, build...

I was hoping someone might be able to tell me how I can dynamically code in the modification to a fields control source. I have a (numeric) field in my report. When the report opens I have (VB Code) an if statement that checks if something is true or false. If it is true, I want it to set the...