Search results for query: *

Hi, I am tring to get this query to work but have lost all hope ;) there is a yes/no field in one of my tables and im tring to get a count of true and a count of false so i can graph the results. However, im getting quite the mess! I got it somewhat working use this query/sql statement...

Hi, Is there a way to discover which events are firing as i do things? in the case that there isn't this is what im tring to do: there is a combo box with a bunch of stuff. if they type one in and find that it isnt in the list then there is an add button beside it. if they press the add...

Hi, I am trying to insert a find employee text box. I have it running and it finds the employee but...it doesnt do anything. How do i get it to display the records once it finds it. i have: Dim rs As DAO.Recordset Dim db As DAO.Database Dim find As String Dim name As String Set db =...

Hi, Is there a way to trigger a macro whenever a query is run? so eg, when any query is run the macro fires and does something... thanks, dave

Hi, I want to make the lengend say something besides countofemp. how do i change it so it will stay what i change it to. thanks, dave

Hi, Im trying to get my database to display the main menu when it is opened. How would i get the main menu to be displayed whenever the database file is opened in access? or can someone give me a suggestion for how to something similar. thanks dave

Hi, If i can recall my earylier semesters, we made an access database run like a windows app. I have two questions regarding this. 1- how do I get access to do that again :D cant recall how... 2- once that is done, will the created file still communicate with access. ie - if i make a new...

Hi all, I have combo box's on a main form connected to a table per combo box. Another form i have updates/changes the table that each combo box is connected to. Is there a way having the main form open to have the combo box's update their info to match the info if they change the table? ie...

Hi, I'm most likely doing something wrong but...why when i do this: txtnum = 50 txtnum = txtnum & "%" it makes the number = 0.5 the fields it is stored in isnt percent they are general. nothing is formated as percent because when it is it makes 50 = 5000% if you could solve either of...

Hi, Is there a way to sort the info automatically in a combo box. Yes i know i can sort the table/query that the combo boxes displays ... but what happens when enter a new record into that table, does it automatically re-sort itself or what? thanks, dave

Hi, Is creating a global recordset possible? If not can i run multiple recordsets on one table? thanks, dave

Hi, Everytime i enter a number to be a percent it's totally wrong... i enter .01 for 1% it displays 0.00% but then every now and again it will convert the number to like 1500% if i enter 15 or something... what is going on? thanks, dave

Hi, Is there a way to make an option group display the value that it connects to... i mean: in a table you have 2 records, yes and no. in a form you have a option button group with yes and no... is their a way to get them to look that up and display that. on the form it looks like this: (.)...

Hi, Is there anyway to select a name from a combobox and pass that value into a query as a input value? They do this on the form by pressing a "go" button which runs a report, which is created from a query. thanks, dave

Hey! I am using the calendar to update the date field with the code i read on this forum: " if me.dirty = true then me.dirty = false end if" however, that worked fine until i set up referencial integrity! now when i try to update the date field using tha...

Hello, How do you reference a table and field in a form using vba? i got a [Form]![whatever]![field] working but how do i do one that isnt in a form, but is just a table... thanks

Hi, Im tring to run the dsum function thru the form_current() trigger. The problem im having is that i get the vba error: " Run-time error '2001': You canceled the previous operation" here is the code im running: curTot = DSum("[cost1]+[cost2]+[cost3]+[cost4]", "table1", "table1![ANum] =...

Hi, I have tried to set the control source to a table...can u do that? i have in the properties: = table![Field] but when ran displays #Error. what do i have to do to get the field to go and access the record? thanks

Hi, after searching the forums for a bit I need to ask... how do I assign a field in one form to a value in a table that matches that record? i have tried the dao.database and it doesnt understand that command... any help would be....well helpful :D thanks