I have a listbox containing text records (many of which have multiple commas). Per advice from a previous question (http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Codi...
Hi all.
I have an Access 2003 form that has a SAVE button, I would like to do the following:
When the user clicks the SAVE button, saves the data (already got it to do that) but I also w...
I have an Access 2003 system.
I display a form with several large size text boxes on them.
I pre poluplate the objects with data from my database.
As you would expect only so mucjh of the t...
I have to get the first date of the given month based on a combo box
cboMonth and cboYear
cboMonth
RowSource= SELECT tblMonths.ID, tblMonths.MonthName FROM tblMonths;
cboYear
RowSource=
...
Hi all,
I am trying to construct a dlookup on a text field to find the 'Attainment Comments' from the table 'risk2' where classcode(in table risk 2) is equal to the mondaytxt textfield on m...
Hello,
I am having a touch of bother deleting a record from a form command
The code I want to run will ask a question before the code is fully run. Once the user presses OK, the script th...
I have an unbound form for calculating costs of a product and what we should charge. There are several calculated controls such as yields and totals. I have entered the calculation formulas ...
Have a continuous form, given a field condition I want a bitmap to either show or hide.
The following works on a single form but not when I change to continuous:
Private Sub Form_Curren...
When using access to work out the time difference between Start Time and End Time I'm using:
=DateDiff("n",[StartTime],[EndTime]) in the Control Source field in a form.
This returns the ex...
I have a one page report that prints out all the people in a phone number list. The list is made up of a query. The report groups the entries by location. There are 6 different locations, and ...
Hello-I am building a database in MS Access 2003. I have a main form, "frmMain", and a subform, "frmSubDash". The subform is in the main form and displays two items, "txtReportName" and "txt...
I am trying to multiply the two fields:
Private Sub gw2_AfterUpdate()
Me.gk2 = gw2 * 0.454 & "kgs."
Me.gw2 = gw2 & " " & "lbs."
End Sub
Shouldn't this work?
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 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...
I have a split database. I have a button on a form bound to table (tblCalls). The intent of this button is to delete the current record. I am using the following code in the OnClick event t...
I am trying to use the following error handling code so that if a user wants to enter a brand new client the code takes them to the first field and doesn't let them leave until they fill it ou...
I have a very complex database that does not requrie explination. Within this web of database h-e-double-hockysticks is a very simple table with some simple forms.
The table is a notes tab...
I have a form with 10 little subforms which are 9cm wide and 0.6cm high. They are placed on the form one after each other like the rows of a column. When the user clicks on a field in a subf...
I have an Access 2007 form. On the form I have a ClientID field. I would like to have a Select Client button that the user will click and open a Select Client form. On that form, I would ha...
I have a pivot table which is showing totals on the left hand side (even though I am not displaying numbers) and I need to get rid of the totals, any help would be appreciated. I then need to...
I am creating a database using MS Access 2003. I created a data entry form with several command buttons. I am having an issue with the "Cancel and Close" button. What I want is even if some...
I have a form I want to display as a sub form on a parent. Things like font size, column widths and row heights seem to have minds of their own! How do I control those attributes of the sub ...
This question does not relate to the funtionality of my database, but I believe that it will increase the level of professionalism in the database's appearance. I have numerous subforms, all ...
I have an checkout form for an Item. The user can enter an item number to select an item. Once they select an item, the "after update" function fires and the "item inactive" field in the item ...
I have an Acces 2003 form. In the form I have a combio box that I use to pull up a record. THe combo box shows thw primary key but not any of the other fields. THey are blank. If I go into
...
