I have a form with a subform. When a change occurs on the form, I want to do requery on the subform. The error I'm getting is "wrong data type," # 2498. I've done research, and I'm writing ...
I am attaching a test database, which mimics the size of my actual form. My form takes up the entire page and I would like to set properties so that it comes up full size every time it is open...
Hello-
I am trying to create a table that calculates the number of open records in a given month, and then displays the data in graph. Here is the background:
Unique records are initiated an...
Hello All,
I would like to allow users of the database to select fields, add custom criteria, and print a report showing the custom criteria and fields selected from the current database. ...
Hi,
I am developing one Access Form.
I have two fields. Field 1 and Field 2.
Someone has developed Same Excel Form and has written VBA code to display result base on the Field 1 and Field ...
I have a form with a subform on it. I am trying to make the form smaller vertically so it will fit on smaller screens. The subform footer I reduced to nothing but there is a good 3/4 inches o...
I have the following statements executing when the user chooses a report to preview. The system doesn't wait for the dates to be entered on the New_frm_Date_Range form, yet, immediately displa...
I am having a problem with a subform working properly. I am using 2 tables with this form/subform-- 1 table has RMA information related to returned goods and the other table has detail on ite...
I had this solved for me by someone but now I cant recreate the solution. I need a step by step description of how the following page was altered: frm_CommericalSoftware The alteration was ...
I have a form (source:table) that contains part numbers that have alpha and numeric characters and I need them sorted in the form.
Example:
Nunit#1
Nunit#13
Nunit#2
ShopUnitPL#12-tr
Sh...
Hi,
I am creating a database for information that people can use when visiting customer sites (for potential interest, actions and customer details etc).
I have all the forms up and all...
It has been over 10 years since I have worked with Access. I am trying a database for my new business. I have created the tables and am pretty sure the relationships are good (I had help). ...
I created a subform and mainform, and auto populated the form using SQL to generate default values for a series of combo-boxes from the source object ( table) that the subform is associated wi...
I'm trying to open and use an Access 2003 datadase in Access 2007. Buttons on forms don't seem to work if they execute an Event Procedure when clicked. Nothing happens. I put traps in the p...
I want to add the field Used By to all of my forms, thus far all my attempts have failed. I would like to see on each form who is using this computer related to the record I am viewing.
Hi,
I have designed a form to use as a navigation sidebar, but i'm having trouble ensuring that the form is always open and visable.
I want the form to open and be positioned down the le...
I am currently using MS Access 2003, and what I would like to do is somehow make a combo box perform two separate actions. This combo box is on a subform, and one of the commands will be to s...
In an Access 97 form, I am forcing surnames entered into uppercase using input mask >CCCCCCCCC
I want names starting with Mc (McDonald etc.) to be stored as McDONALD.
I have tried StrConv,...
I jave a list box on a form that displays valids in one column the if the value is mapped or selected its shows a -0 or -1. I need to change that -0 or -1 to be No or Yes
The row source is ...
Hello,
I have created a simple database, with a subform on the main form.
On my laptop I can right click on any fields in the subform and the menu appears to filter by selection etc. Wh...
How can you trap validation rule violations when a user leaves a record for which they entered bad data (ie data that violates the validation rules)?
Note to self: make this a best practice...
I have a form on which I have two compbo boxes. THese combo boxes are populated through different tables and what I want to do is to have the user choose the appropriate record and then based ...
I have VBA code to send an email to the PM on a work order on Save, but if the issue is not on a work order, I need it to not send an email to the To:, but just to the CC.
I am in the process of transfering out database from an Access backend to an SQL backend linked to an access front end.
All is going well apart from 1 problem, i have this code =DCount("*",...
I have several boolean (true/false) fields in my Access database. In my forms, when I display the record, I replace the true/false values with text, i.e. yes/no or HTML/Excel or "Unique Part"...
