Hi When opening a form, I want to add a new record and set focus in the first field. Can someone tell me the code please - I cant seem to find it Thanks

I can't copy a cell from excel 2003 and paste it into an access 2003 find field. I do a edit, find in access, but when I right click on the "find what" with...

Hi there, I have a bug that I cannot trace. I use a short date format of d/m/yyyy. This is used throughout my database. However when I use dlookup through...

This happens to me too, in Filemaker 6.0. (using XP Home). Did you get any help on this? Please let me know if you did! Bob "MT" wrote: Whenever I try...

I have a currency field and a number field in a form that I would like to be blank until data is entered into them. How can I get this to happen? I have tried...

Hello: I'd like some advice! I am thinking about possibly using an unbound form for data entry, and I don't know if it would be a good idea or not. This is...

Is it possible to append new records in a subform, as it opens, to an underlying table using only certain fields from an existing table?

I have a form that is based on a table of information. I would like ther user to type in the primary key value and have the other related information appear on...

I have a form where all of the fields must be completed before 1. going back to the Find dialog box (to find a new record to update) or 2. closing the form. In...

I have a subform with fields Price, Quantity & Total (among others). The "Total" field is autopopulated by using =* as an expression in the Control Source. Is...

I have a list box on a form showing breif details of records so that the user can choose which record they wish to look at. The user can then double click the...

I have a table with a list of locations and another table with a list of multiple documents for a specific location. What I am trying to do is have a Tabular...

I'm receiving an "Invalid argument" error message when trying to add a record to an Access database file that approaches the 2 GB size limitation. Compacting...

I have an app in which a controls are added to a form dynamically. After creating the controls I want to code the KeyDown event. Here is what I...

Hello All, I created a table with a hyperlink field and a form to display it. I can insert a hyperlink in the form, but it displays the full hyperlink text,...

I'd like to make the font size in my message boxes several points larger than they currently are. Is there a way to do this? Is it a property of...

Is it possible to open another mdb file (i.e. close the current database and open another) using a command button? solution much appreciated peter

When the primary key is null and a record is being inserted I get this error: "Index or primary key cannot contain null values" I just want to change what the...

Hi, I have a date time field, which I have formatted to show the date in 'dd/mm/yyyy hh:nn' format. I would like users to be able to key in the data in the...

cannot save form after creating based on a specific table and unable to do so likewise for queries and reports '