Hello,
I'm trying to create a new ID for any additional records we add into our database. I started out by creating an entry form that (all unbound text boxes) with 2 buttons one which I wi...
Using an Access ADP, in 2000 format. I have several forms with check boxes.
These boxes are bound to individual fields.
All works well on each pc, and for nearly all the Terminal Server user...
I have a text box that has the datefield of the table in its control source. When the user use my form they see a little calendar on the side of the text box and click on the date of their cho...
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'm trying to get a msgbox to inform user that, if there is no Serial (Item selected) for the specific Sale, there needs to be a Item selected before you can indicate "OK to Pay."
The chec...
Is there a way to cycle through each control in Access. I know in excel I can cycle through each sheet. Like using a for each sheet loop.
I have a bunch of controls and I would like to ...
Hello,
I am trying to integrate a mail merge function with Acces 2007. I want my users to be able to narrow the list of contacts that will recieve an email by filtering fields on a form. O...
I added date picker to a form inside a group box. I initially populate it onload with date and disable and lock the control. When the user clicks on the a modify button, I then unlocke and en...
Hello,
I may have to ask a more specific question- but I am hoping when I explain what I am doing somebody will have an idea.
I usually- when I want a text box automatically filled on a form...
The TextBox control in an MS Access form can have a scrollbar but does not recognize the mouse wheel for scrolling. I would like to scroll with the ctl-Up/ctl-Down keys, but can't find anythin...
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...
Hi,
I have Edit Order Details form. There is a combo box to select and display the Record on Order_Number.
The situation is, I want to use this order details for New Order.
I want user to ...
I have two forms:
frmHistory: record source "Pymts-Archived"
frmHistory-Archive: same record source
When I click on these forms: I have error message 2450 "Microsoft can't find the for...
I have been working on this ONE issue for over seven hours. I'm on the point of exploding.
My main form has tab controls. Tab1 is a subform, Tab 2 is not, and Tab3 is another subform. ...
I use the attached code snippet to change field names and, optionally, to change the field's description. How can I modify the code below to optionally change the field's data type too? Assu...
I use unbound forms to lookup records and it has worked well in Access 2003. I change the .recordsource on the subform using a sql statement and then do a .form.requery.
This no longer works...
Hi,
I have designed a db in access that uses 2 popup split forms. I am having problems getting the popup split forms to keep their size properly. They seem to resize themselves at will. Even...
What I want to do is save the record only if the Employee Number from the combo box and the underlying table match. here is the code I have I am getting an error message that an object is miss...
My client requires small thumbnail pictures of his product (shoes) on labels that will go on the boxes. He has taken many photos of the shoes - in jpg. No I must link these images to a product...
In my Access database, the combo box is previously linked to tblOrders:
SELECT tblOrders.OrderNo FROM tblOrders
However, this table contains hundreds of orders, it's difficult to find the o...
In an Access 2002 database, if a user doesn't enter info into a required box they get a "invalid value" error box, which looks really bad. I would like to know how I can replace that with my ...
I have a field on a form that stores a directory. What I would like to do is use a command button to open this directory.
Please see the attached picture.
Basically all you would do is clic...
tblOFInvDetail
OFInvDetailID Auto Key
OfInvDetail
Company Code
tblOFInventory
OFInventoryID Auto Key
OFInvTypeId Not required
OFInvDetailID Numeric key from...
Hi,
I have a form called tblPhysicalExam. On the onload event I want the TxtGeneral textbox to display a default text "No Fever, Chills, Fatigue, Malaise, Change of Appetite or Weight Loss"
...
I want to have a specified date field (called TaskStartDate) and a specified time field (called TaskStartTime) auto-populate when another field (called Task) is "updated" (i.e. task > event > ...
