Recent content by bluesage

thanks, the code is useful. it works if i apply it to the on click event of a cmd button. but if simply do this: Sub Form_Load (Cancel ...) docmd.openform "formname", acformpivotchart end sub it gives me an error message saying: the view can not be changed at this time do you know what is...

hi i made a form, containing a field from a table. i viewed it in pivot chart view and the graph works well. however, i tried using VBA and in the form load, seting all views to false except the chart view, but doesnt work. it always opens in datasheet view. can someone show me how to do...

hi, i need some help with code. can anyone post an example or some code. what i need: lets say i made a database name DATA_TEMP and it contain tables without records but all the fields and validation rules are set. i want to create a form, on which when the user loads it, it gives 2...

thanks, but what if i don't want to re-design all my tables? i have the resident id set with the validation rule so i can't have a resident with an id greater than 10. for the rooms the same, the rooms id is 1 to 10. you think its possible to work with that. i understand what u were saying...

personilize in the sense that i dont want to have the navigation bar, instead in the form, have buttons i create which do the same thing.

hi, im planning a database for a boarding house containing 10 residents and 10 rooms. i need some sample code or if someone can post a sample database it would be most helpful. here is a description of what i want to do: ================================ tblRESIDENT id_person (PK) name...

the problem with autoform is that the record navigation is not changeable, i cant see the code behind it, because it is in the navigotor section. i want to personilize the navigation.

would it possible to post an example? it would be easier to understand, im not too sure what you're explaining. thanks

hi, its easy to make an autoform, but i would like to make a form my self with which we can add, delete, and see all the records in a table, or even in all my tables. can anyone give me some help? w/ code is welcome i tryed using cmd buttons, with find next record, but im having problems thanks

Private Sub Text21_Enter() hi, here is some code i wrote, but im having some problems. this works fine for calculating a diference in years. but im trying to CALCULATE THE NUMBER OF MONTHS between two dates IN TWO DIFFERENT YEARS this code, returns the number of months which is correct, but it...

hi, i need an example code. what i have is a continous form with data containing an Id in one field, a month (ie.jan) in another field and the rest. i want to create two option groups, one to filter by month, then the second to filter by id. i have done it with just one filter. ie. filter by...

is it possible to do the following for a query: set rst = dbs.OpenRecordset("queryname") i know it works with tables: set rst = dbs.OpenRecordset("tablename") thanks

hi, here is some code i got from a site. ive made some changes and tried it but doesnt work. need help ==================================== Private Sub cmdGetRows_Click() Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim strqry As String Dim strFieldValue As String Dim...

ok, why not but what does the code look like? what if i want to use a saved query? thanks

hi, i want to use a dynamic query but instead of opening it once it is executed, i want the result to be displayed in a text box. i would also like to know if anyone can tell me how to write code to select just a field from a recordset (is recordset = query ?). example: i have a query with...