Hello
My first form FormA filers to a specific record on FormB, FormB also has a subform which performs a calculation for each record, field called "Total". I use cmdButton to close FormB,...
I have a form with text boxes that look up values from a table. In the table the user inputs the value from a combo box based on a another table of set inputs. So like a list of inputs would...
I have a table "employees". One of the fields is a combo box where the user choses a value based on another table. When you click on the drop down arrow, you can view all of the correspondin...
Hi,
I am designing a search form that contains other 4 subforms(Based on 4 individual queries) which would desplay results on a button click. But when I press this button all the 4 subforms...
I am dealing with patient accounts being denied by insurance companies. When the denials of payments come in they are entered in a form by account number (Account# - a long integer - 9 digits...
I want to implement some sort of combobox or listbox in Access that "looks-ahead" as the user is typing. I used to have the code for one in VB6. I need it to only allow selection from the list...
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...
Hello
I have created a form from a table and would like to start my browser and go to a web page (ex: www.google.com) by clicking on a picture.
Everything works well when I insert the pictur...
Hi,
I have two tables. Customer and Order. Cust_ID is a primary key in both the tables.
I have created Form1 to Enter Order details.
I want to display customer name when user input Cust_I...
Hi,
I am a non-programmer who can code just enough to be dangerous. I have created a pretty sophisticated database that would benefit greatly from having a powerful "drag n' drop" function...
I have a continuous form for golf scores. I need to sum a row (only that row) in a textbox. I don't think that is possible. Can you create a sum in a table?
Example text:
Scores Hol...
I have a calendar with employees(10) appointments on a whole day basis. I would like to display these appointments in the same vertical position for the same employee accross days, such that a...
I have a login form and I would like to pull information from the User database to use later for example to limit access to forms,reports and tables. I have this code to check the login infor...
Hello:
I have a table that contains various URLs: some links go to web addresses, others point to files on a file server. I'd like to create a form that has a field which is bound to the URL...
The form is bound to a table.
I have a treeview control and can get the selected key.
Dim nodCurrent As Node
Dim objTree As TreeView
Dim strText As String
Dim strKey A...
I have an ubound main form (frmTest1)
on this form I have a Tab Control with three pages (tabMainTab: pagOne, pagTwo, pagThree)
on each page I have a subform (subTest1, subTest2, subTest3)
...
In MS Access how can I stop the user from losing focus on a text box if a condition is not met. For example if the box isnull I want a message box to appear and the user still be in the text b...
I have a table that contains bid information.
BidId - Autonumber
BidNumber - I want this to be a sequential number, but without skipping numbers.
Me!BidNumber = Nz(DMax("BidNumber", "tb...
I need some help with modifying a SQL function.
The code snippet below (below &&&&) shows a function that is based on a listbox. It strings one or more listbox values and then passes them...
Hi,
I have a form called frmPatients that has a grid what I want is when the user click on the grid
I should call frmPatientDetail for that specific record.
I did this but it's not work...
I would like to filter a list of returned values from a table listed in a form based on CurrentUser() name appears in specific field on that form.
Note I can get the filter work if I type ...
I have a form that has a subform.
The house_id copies to the subform as a foreign key when a record is added to the subform. I also want the state, which is another field, to copy automatica...
Hi,
The form called frmPatientDetail it has a list box called lbxPatMedicationList. when the user click on a row of the listbox it should populate the data to back to the fields cboMedicat...
There is an Access application developed on Access 97 and currently works on Access 2003. On the main form, fmCustomer, there is a dropdown menu for Client input.
The data source of this ...
I've got tabs ("pages") that have data and/or subforms on them. All of them work great. Except when I want a subform to show up in datasheet view. I need them to show up that way. But when...
