Search results
-
A
MS Access - Calculating Estimate Form
I cannot figure out what you really what to do until I see the actual database. Try removing some of the object which are not part of the database so you can save space (make sure to do a backup of the original one.) And then zip it... -
A
forms cannot save the data
once you close the form and re-open it, it will display the first record on your table attached to that form. however, you can do the follwing: 1. create a query based on the table and set the property to descending provided that you have at least a primary key or index field, or 2. create a... -
A
Form based on criteria from 2 other forms
Here I will do on this: On the Module Section of the Database, define a Public (Global) variable: i.e: nProjID as long (you can set your own data type) Create a Public Funtion that Pat Hartman wrote (but this also on module section) And then, on the exit on form ProjectID (wher you... -
A
simple question
Here what you can do: On the OnOpen event of the Form. set the default value of your Check box or option box to zero. Now you have to put a code in OnClick Event of the object to make it zero or one. Here how it goes: Private form1_OnOpen ....... chk1.defaultvalue = 0 ... -
A
Refresh or requery problem
Can you not put the grand total inside the subform 2 so you can actually see the output in real time instead of saving it and doing the calculation? The only solution I can see in here is that you can do the calculation inside no 2 otherwise your no3 will wait until you save the data in 2 and... -
A
Combo box not working in subform
Is your serial no inside the subform... Is there a chance you can attached your db ? -
A
Message Box Formatting
There is no othger way you can alter the appearance of messgax box. All you have to do is create a form that will act as your message box -
A
new to access
does your form does not alow you to add new data? if all form property are set to yes, it will allow you to ad new record. maybe you haven't set the control source of each field on the form to a respective field on the table or you dont have a record source value on the form. checked the form... -
A
#Deleted showing on form and Error 2455
To avoid seeing the #Deleted, put me.refresh after you delete a record (this should on the button Delete). -
A
MS Access - Calculating Estimate Form
Can you post /attached your DB ? :confused: -
A
Using a combobox to to filter info into a listbox
ListBox Here I will do... You may put your code on the command button. Once the user click this button, it will trigger the code that will change the rowsource of the listbox. Your code should be a sequel statement which will extract the data based on the value of the combo box, or you... -
A
Updating linked fields on Forms
linked are you saving the record before you press any buttons?