Search results for query: *

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...

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...

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...

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...

hi, im trying to do the following but need help: 1.) i have a listbox containing 4 values, lets say bob, frank, sara, tara 2.) i have a textbox with no value, but i want it to show a specific value from the listbox. example: i want the txtbox to show bob. 3.) if tried this: =...

hi, im trying to do the following but need help: 1.) i have a listbox containing 4 values, lets say bob, frank, sara, tara 2.) i have a textbox with no value, but i want it to show a specific value from the listbox. example: i want the txtbox to show bob. 3.) if tried this: =...

hi i created a form. added a group of option buttons and then i set the forms record source to have a source of 1 table and 10 queries. SELECT * FROM tblname, query1 ... query 10 when i viewed the form in form view, it was blank ? can anyone help me? if i remove the record source, i can view...

here is some code i have written to add items to a table on the click of a button on a form. =========================================== Private Sub Creerbtn_click() Dim strSQL as string Dim no_res as integer Dim nom as string dim prenom as string dim etudiant_ouinon as string etc...

hi, i want to create code for an afterupdate of a combobox which will create and save a query under a certain "name", but each time it is run, it is saved under another "name" or the previous one is renamed, and the one being created stays the same. lets say i have three choices, bob, frank...

hi, here are two different versions i tried, but neither work. i don't know what to do. what im trying to do is: 1.) i have a form and with a combobox, when the user selects a name 2.) i want the value to be sent to the query 3.) and the result displayed in a txtfield on the same form...

hi, i have a problem, here is the code i wrote (i left out some of the declarations) but when i run it i get an error message which says the following: microsoft access can't append all the records in the append query. microsoft access set 1 field(s) to Null due to a type conversion failure...

hi, im quite new to microsoft access. I have been trying to figure out (searched the web, read books) how to create a query through VBA based on the choices in a listbox but so that the next time the choice is chosen, it creates a query without having to delete the old one. so in other words...