I think I know what's causing this but not how to fix it.
I have a subform tied to my main form and when I close the main form when
the subform has no records, I get a "No Current Record" error (no error
number, just the text).

I want my data should be entered (in text box object) only in capital letters
irrespective of Caps Lock status.  Is it possible??????

I am trying to create a field that will have a number and I want to set that
field to have the number change each time the form is opened.  Each form must
have a unique number.  I know how to do this with a date field but figure out
how to do this when the field just contains a ...

I have created a form in access. Whenever it is open, it opens in a maximied
view (fill screen), how can I set it up so that it opens in a minimised view

I need to create a subform that contains a list of items, where the items
are always in view like on a spreadsheet.
Using the Items as column 1 I need another column for data entry and the
other columns are for historical data. When I create a query for the Subform

Hi, I have a subform that is using a temporary table. The temp table is
deleted and repopulated via a query. The trouble is the amount of columns can
vary. Unfortunately the subform still shows the columns from the last time
the temp table was created. Is there a way that the ...

Is there anyway to specify addtional grouping headers and footers on
forms similar to the way you can on a report?
Thanks in advance

I am able to create a list of items with a drop down menu.  I can
select specific item but how do I select all item to get a query
output.
Your help would be much appreciated.

I am trying to use a table value function in a SQL server to fill a list box.
I keep getting the following error message “Microsoft OLE DB Provider for
SQL Server --> The parameter is incorrect.”   When I the objCmd.Execute is
Executed the statement in the code snipe below.  

i have two unbound list boxes. Listbox1 has list of tasks and Listbox2
represents a month.
By selecting listbox1 tasks and then click on listbox2 should update
to listbox2

I moved all of my tables in access to our SQL server. Ever since then my
forms that have subforms hve been very slow. Should I move everything back
into access?

I have a textbox on a continous subform.
The textbox is bound to the second column of an invisible combobox to display
the field from the related table.
I am using this code as source for the textbox: =cboUsager_temps.Column(1)

When I click on a Tab and it opens the form shifts down a bit, and you have
to scroll up to see the tabs.  
How do I get the form to show the tab and the entire form content.  Is there
a certain form height that must be adhered to?

Is there a way to do this instead of redesigning a data access page?

testtttttt