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 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 ...
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...
It is a very stupid question, but I am running out of patience looking on experts and google because I don't know how to express myself well enough to find useful answers. Supposely this shoul...
Hi Experts,
This one is a little crazy. I have a form that can be edited. There are five checkboxes on the form and I put some code in the form load event to make the checkboxes false whi...
I have the attached Database, I don't know if this is possible but i'd figure I'd ask. I need to make a form where the user enters the information for each field into a table. The think that I...
Hi,
I have a bound form 'DataCompo' (used for browsing the record of a particular component). The header of the form has three cascading unbound combos, 'AreaCmb', 'EquipCmb' and 'CompoCmb'. ...
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 have a select query (saved as a datasheet form) as a subform to be filtered on multiple fields based on one of 7 combo boxes that are placed on a form. I am trying to get it to select only t...
This has been a pet peeve of mine for a while. When created a report or a form when I intially add a textbox, combobox or label they are a slightly different size than a control where I have ...
Hi
I have 3 combo boxes on a subform: Product, Stock, part Number
Depending on the selection of the first two the record source of the part number combo box is change to filter records. ...
I have a form that contains a subform, in datasheet view, of various records within the database. The purpose of the subform is to provide a quick summary glance of records and provide an opp...
Currently, the stop button referenced in the attached database has the effect of bringing up frmAddOrSteal which is great.
I'd like it to also have the effect of entering a new task entitled ...
Hi all.
I have a list box on an access 2003 form that I would like to insert the values into a table once the user clicks the SAVE button. The user may choose multiple selection in the list...
I am trying to figure out the table structure that will allow me to add and subtract parts from my inventory. I've tried several things, but I mostly get caught in repeating equations. Amount ...
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...
I want to search a record in a form by entering an ID in a textbox. After finding the record, I want to edit it and save it by clicking a "Save" button, and as the same time, move to the next ...
I have a form showing up to 20 rows of data (records). The user has to check all rows for correct data with a paper document, created by someone from another office. The sequence of the rows a...
I am creating and if then statement in an Access for to have something show on a form if something is selected.
If me.checkbox1 = 0 Then
If me.checkbox1=0 then
Me.lable1.visible = Fal...
How do I mix text and field values on a control, and forcing line breaks?
Lets say I have fields firstName and lastName
and I have a textbox. How can i insert more than one control source?...
I use the following code (thanks to EE) to successfully add and delete fields programmatically. I need to modify the attached code snippet to delete a field's Index before I can delete the fi...
The attached code snippet works and creates a table with two columns, TableName (the names of all the tables in my .mdb file) and Field Name (all the fields in each table).
I need two more ...
