My form is based on a table that has many order numbers (not unique) and many item numbers (unique). My access form is a single form where I can view one item number at a time. Id like to i...
Hi,
I have form which has a list box on which lists all customers in the tbl_contacts table. What i'm trying to do is allow a user to double click one of the customers in the lb and have a...
I need to change the background color of a continuous form, showing them in groups of five. Similar to the old continuous feed green and white printout I need to have the first five records co...
When people are using a form on my Access 2003 database, they will press a button to activate the record (basicly go into edit mode), when they have finished the record is de-activated.
I...
Hi
I Used a Tab control in my form and I want these tabs starts from right to left. as u know It stat from the tab that is in left side of this control, by defult.
Is there any way That I ca...
This is the cenario:
I've a form that shows a record. One of the fields is IDCar (text type) and is displayed on txtIDCar textbox. This form is bound to a table tblConcerns.
On another ...
I have the following the following tables: tblCalls, tblCallers, tblProspectiveResidents, tblWorkOrders, tblResidentRequests. The last 4 tables are linked to tblCalls via a CallID foreign key...
Hi Experts,
Is it possible to have a combo box that displays a list of 5 possibilities (pulled from a table) and a 6th option to enter a manual comment? Please see attachment for details...
OK I am not even close to a novice on this but I am stumped so the easier the explaination the better.
I am creating a scan/verification app for pre-printed barcode tickets. The form called...
I need to be able to open the following directory from a command button on an access form.
Command197
H:\Generald\FileCabinet
In a table, I have a field called "Milk", holding a checkbox, and a field called "brk1-2". I wamt tp add up using the Access DSUM function to total up the numbers in "brk1-2" depending on whet...
I need a pair of .bmp files, one of a padlock closed, and one of a padlock open. Each can be no more than 15 pixels wide by 18 pixels high. Both MUST have transparent backgrounds.
They wi...
In previous versions of Access I was able to enter something in Query/Table/Form object Description, then Sort/Display the by Description. This helped me keep multiple related Queries together...
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?
I have a form built to run with my query, DB, and report. I've run Package and Deploy, but nothing comes up when I run the program. I have it set so the Runtime file goes with everything. It l...
I could just open the table in design view and add the text manually to the description column, but how can I do it programmatically?
I use the following code to change table field names pr...
In an Access database I've acquired
tblStaff has a field called StaffID, a field called StaffInitials and 3 Yes/No fields called Admin, Finance and TechSupport.
tblDepartment has a fiel...
I have two listboxes on a form and I want to move items from one to the other, and remove the item from the first listbox. I created a command button to do this. The following code works cor...
I have a form that has its data coming from a query that has a "name criteria". I recently added buttons to the top of the field columns in the form that allow you to sort each field by clicki...
I have a simple entry form that has a "save record" button. Problem is is that when the save record button is clicked, the cursor is no longer in the first field (so the entry person can conti...
Hello:
I have a form with a subform and would like to capture info, certain fields, from the parent form and have them saved into a the subform's table. The linked field automatically gets ...
This database (attached) records how long a particular task has been 'active' and is indicated by the check mark in the frmTasks 'active' check box. Notice though in the screenshot (also atta...
I have a form set up to collect information about a user. Once the user is done answering the questions, they hit a button that runs a macro. The macro is saving the record to a table, print...
I am using MS ACCESS as database and C# windows application..
While i am trying to insert a name with single quote(') access throws error.
Let me know about the syntax.
Thanks in advance
I am developing an application and have many system numbers that must be combined with another system code. System code is unique such as CBTT-( the number Located in this setion must start o...
