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

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

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

I have a simple combo box that is taking its row source from a newly created table that has only two colums - the key (just a list of continuous numbers) and a...

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

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?

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

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

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

So, I posted this last friday, and I figure I'd repost it with my additional comments after John had already made some comments: -----Original...

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 a basic Combo Box/Employees form deal (with subforms, but the sub forms work OK). When I select a user from my drop down Combo Box, the correspdoniong...

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

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

I have just learned about using switch statements and have found them helpful except for the following: (a) I seem to be limited to 12 variations. If I use...

Hello, How do you place or set up a running clock on a form.Do you use a command buttom or label and what would be the properties setting?I have tried to use...

I have an Excel file needs to export to an Access table. The Excel file has one worksheet and it contains 103 rows of data in 12 columns. One of the column...