I have form with a textbox bound to the Name of a client in a query (Client_Name) and a combobox with a list of ID's (Client_ID's). When a user wants to edit the record, he would choose the ...
Am I missing something, or is there no way to display a split form as a subform? When I do that, only the single form view is displayed. Is there any way to make it work?
Hello Everyone,
I have a combo box that stores records from my form (FName, LName,Address, City, State, Zip). When I use this feature by clicking on a record in the combo box it adds this inf...
I have an Access 2003 db. I thought I had this but probaby confusing myself.
I have 3 tables.
tbl_Clinic
tbl_Provider
tbl_ClinicProvider
The tbl_ClinicProvider has the primary key from ...
I need to make a field on my form a required field. How would I do this. The user must fill in a required amount of digits or see an error message.
Thanks much!
I have a small snag on the command click code to add new record.
If a user enters data, clicks AddNew button to save the data and advance to a new record screen; and the code for mandatory ...
How can I do this?
I have a form with three tabs.
I want my users to be able to change records on tab one, but not on the others.
I have 2 issues both relating to an unbound form. The project is in Access 2003.
I have a product table that requires multiple serial numbers as well as a note field. The note field in th...
I am working on a tight deadline for this project and can not seem to find an answer to this one:
I have a sub-form where I want to use an IN clause to limit results to specific clients selec...
I have a form that I have a text field on . When I type something in the text field and click on a command button to open up a report I want that field to pass to a field onthe report.
In t...
I am wondering if it is possible to create a form that displays tabular records in the detail section. Then in the Form Header or on a main form (and the tabular would then be a subform) to h...
Hi,
When I entering new data to a new record in a text type field in Access 2007, what's the way of "auto-complete this field using previously entered values" ?
Thanks
I have a memo field in an Access 2003 database that my users want to paste into from tables in MS Word. The table loses all its formatting when it's pasted. Because the field can have differen...
I have a form to allow users to easily find records. When they find the record they need they click a command button which runs a macro and opens another forms and goes to a record to display...
As a relative novice I am trying to develop a solution in Microsoft Access 2003 and have now reached the limits of my capability and therefore require some expert knowledge.
The solution fu...
Hi everyone,
I have a number of combo boxes on a form. When select there is a textbox for each one that grabs the column(2) value.
How do I sum these textboxes?
Thanks
Jetera!
I have a form where the values are entered into a table called TblTrainingInfo. The form has a Combo box which has a SQL statement which provides the training types to pick from a table calle...
I would like to assure that the user enters a date more than 30 days in the past and is a valid date format.
<=Date()-30 works to prevent dates more recent than the past 30 days.
What is...
I finally figured out a way to stabilize my front end thats open 24/7. Disconnected recordsets. All works well, any additions made to the form, I just do an updatequery in the background to ac...
Right now I am using a temporary table, but I suspect there is a way to do it with a recordset. I'm using Access 2007 DAO FE with SQL Server 2005 BE. I have datasheet subform based on a temp t...
Hi Experts,
Thanks for your time and knowledge.
I have a form, with an unbound combo that serves as a record finder.
The code in the after update event of the combo is:
Private Sub...
Hi,
I have a form in Access. Everytime I need to open Access, then click on the form name to open the form.
How to make the form open automatically when I open Access?
I'm using MS Access...
Hello experts
I'm sure this is the simplest question ever, but I'm short on time so here it goes:
I have a table of information on teachers (Name, school, and notes). I want to have a f...
I have a table and or query with a list of bill #'s these and transaction dates
1. The bill # will duplicate with every transdate that is different
2. Every Tranaction date is not unique th...
I have a form which has five different "areas" on it where the user enters information. The first 'area' is a combo box (created via the wizard) where the user selects a customer name and th...
