How can I change the property of a text box in a form to change teh shading color after update? My problem is when I change the value in the field, the back color changes. But when I add a n...
Table = t-Projects
Field Name in t-Projects = ContactName
Form = f-Projects
ComboBox Name on f-Projects = cmboContactName
Contents of cmboContactName are derived from a Query
Control So...
I have tried both FindFirst and Seek to perform what should be a pretty simple task but continue to get errors on any attempt.
I want the user to key in a phone number in a subform and t...
ok so I am having a problem with getting #error in some of my calculated textboxes on a form.
so here goes.
I have a textbox call tboNPV. it is read out of a table. this box can sometimes ...
Hi
I have a table which, for this purpose, is accesses via a form. The form has a combo box for the surname (cboSurname), which is used to search the table for a matching entry. I've atta...
Hi,
I have a form in Microsoft Access 2003 with a button when the user clicks on the button, the button runs a macro, the macro prints out a report. However before the report is printed id ...
I have a form named "SysAcs". On the form, I have a button (Cmd21), and on the buttons onClick event, I'd like to have the form (with the current record) printed to a PDF.
I'm trying to ma...
My form has many text boxes for the user to update. After updating the focus in on the text box. When I click outside the text box in a blank section of the form the text box does not lose f...
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 the following VBA codes for inserting a recordset into a table, but have no idea about the syntax.
Dim NewRecords As DAO.Recordset
Set NewRecords = CurrentDb.OpenRecordset("SE...
Hello, I have a subform, which must be dsplayed as a datasheet - and it has a subsubform that is not a datasheet. right now, there's a little tiny "+" sign that the user must click on the data...
I've attached my code. I'm trying to findfirst using ado.
On the 'rs1.find' line of code I get the error...
Operation is not allowed when the object is closed.
Can anyone tell me what I'...
How can I format an image in a form that will not show the border and background? The image is already this way outside Access form, is I insert the (is a logo) picture in Excel, Word it looks...
I have a form where the user enters multiple records and since some fields in each record often repeat they asked for a duplicate button. That part works. However, now they'd like it to auto...
I am trying to clone a subform's recordset. The forms recordsource is set through code depending on a combo box.. I want to clone this recordset.
When I use the following:
Dim rst As DAO.Re...
Hi
i have a field [ampm], this is a yes/no field; is the job was done in the morning, this field value is yes, if it was done in the afternoon, the value should be no.
in a form, instead of ...
I have a continuous form with a label on it that i would like to call a form using the ondlick. However, because it is a label and not a command button which ever button (label I click it open...
Hi,
I have a form with a listbox on. The listbox has an evet on the doubleclick set. It opens a second form whch is filtered on the item that was double clicked.
My problem is that it ...
Hello,
I would like to create a button on my form which:
1) When pressed would prevent edits being made to information on the form. The label would change to 'locked'
2) When pressed ...
Hi
i do not knwo what i did, but all my forms are showing page width, even if i change the format, it's still showing page size.
please give me a hint how to solve this issue
best regar...
I have created a data collection form with the Access 2007 email wizard (InfoPath) but need to modify the form to include combo boxes. I want to send this form to users around the world who wi...
I have a piece of code for Access databases form that kind of works. The code is supposed to put the user name & time that users put comments in a comment box. It put the correct time, however...
I have a table wirth current stock levels. i.e. the level of stock beforme the implementation of a new system of adjusting stock daily.
I want to:
a) Replenish the stock, by adding, via ...
I have added an option group to a form in access. I do not want the option group to be linked to any data, it will simply determine what form will be opened when a command button is pressed. ...
I NEED TO SELECT FROM TWO COLUMNS. MY EXAMPLE IS 'SSN' AND 'SSN2'. THIS IS TWO PEOPLE IN THE SAME FAMILY THAT WOULD BE ELGIBLE FOR MY CRITERIA. i HAVE TRIED PRENTHESIS, AND/OR AND OTHERS. ...
