Search results for query: *

Hi, i'd like to know if its possible to change the horizontal size of a textbox. i'm building a report and i want to have a the width of my control to change so that all the text fits in it... access has cangrow and canshrink properties but that only affects the heigh, not the width. does...

hi, i'd like to know how i can pass a string containing an SQL String (which varies depending on the users selection) from a form to a Report. the SQL string needs to be used as the RecordSource of that report. I originaly planed on using OpenArgs but the openReport method does not seem to...

Hi, i'm having problems with the Sub and DSub method in my reports. everytime i use it to calculate the total of a field that is not in the detail section, the Sum returns the total of every record in my recordsource instead of the total of my subgroup do you know what i could be doing wrong...

hi, I'm having problems calculating my totals in a report i'm building.... i'm using the Sum() method but i doesn't give me the right results I have a large query contaning the information for the form (i use it as my control source) I then group the data from inside the report. (ps: the...

hi, i'm developing a system for my boss, everything going ok... i made every form so that is fits perfectly inside a screen with an 800x600 resolution, everything was going fine until i tested it on her system... the forms wouldn't fit in a single screen anymore, i did some research and...

hi, i would like to protect the system i'm programming with user accounts. I would want the user to enter his/her username and password when the database first opens... depending on the username, the system would enable and disable buttons on the main menu hence restricting access to some...

hi i'm having some problems with my remove button when clicked, it should delete the current record (displayed in the form) i finally got the button to work properly (i had to into the "form_Current" method to be able to change record after deletion but it works now) my problem is...

hello i want to make a form that onload, moves to the proper record. the record is identified by a name (name is a PK) i want the form to open to the record that matches the name that was given by the openArgs method thank you in advance Eric

hi everyone i'm starting to go nuts here :) i know this is a long post but please bare with me, i'm desperate i have a budget program to build for my boss and this is my first time writting an Access program (i'm only a student on a summer job) this is the third week i've been working on...

hello, i just have 2 quick questions i was wonderring if i can cause a query (that is not the control source of the form) to requery (in VBA) without having the form change record... i was able to make the query requery (simply by placing "Requery" in the code) but this makes my...

hello, i have navigation buttons on the bottom of my forms and i disable them to prevent the user from going out of bounds (that way, the user wont see an error message) i have it working but i was wonderring if there is a simpler way to find the last record that a form uses... right now...

hello i'm building a form to add budget entries in a table my problem is that i need to figure out a way to make a textfield display results from a query based on the employee that is selected in the same form... (this query cannot be the form's control source) i think i can best...

hello, (its me again :) i was wonderring how i could change the default value of a text field in a table from VBA... the text field is 5 char. long and represents a fiscal year (ei: this year is 02/03) so if i dont want the program to be absolete next year i need to give the user a method...

Hello i could really use help with an error i've been getting i'm trying to use a filter to filter out information in a form the filter criteria is chosen from a drop down list then the user clicks on a button, that button opens a form and in the OnOpen Sub i have this code...

hello just a quick question i was wonderring if i could use a form to create a table... all i would really have to do is have the form create a copy of a "dumy" table (an empty table with all the proper columns) then, all it would have to do is name (or rename) the copy of the dumy to...

hello, i need to make a form that can select either one of 2 tables as its source. i'm passing the table's name from a previous form (formA) as an argument of the openform method. I dont know how to tell formB to use that table (argument from formA) as its source... i dont even know if...

Hello, i'm trying to make a form that will load either one of 2 tables... (As the form's source) I figured i would push a button (on formA) that button has the openform function i would use that function to pass an argument to formB to determine which table the form would use... in formB in...

hi, i'm trying to make a confirmation message that only shows up when the user changes a value inside a form... I want to warn the user that changes to the table can be dangerous but i do not want to completely stop him from making them (because changes might actually be necessairy) up to...