Search results

so, does this mean i should use .text or .value. if i use .value how do i get the current value and not the saved one?

hi everyone. i was wondering if someone could explain this to me. i have several forms in my access application but only one form is being shown at any given time. i have a macro call a function to check to see which form is open. depending on which form is open i call a different function...

im sorry, i guess im not so good at describing problems. i appreciate your help. yes, its very possible to return more then two rows (i can return 1-4 rows, actually). i need to be able return all columns. let me try to explain again: table: LastName Gender City State smith M City1 PA...

that might work. so, after i pick out the records that are duplicates, how would i move to the next column and compare their values? ie: table: LastName Gender City State smith M City1 PA smith f...

heres the scenario: i have a table with about 100 records. each record has 50 fields. i need to create a function (or a couple of functions) that will go through every record and compare the field in column 2. if the there is more than one that has the same value i want to traverse the rest...

hi all, anyone know how to unlock vba code using vba code? i have a project that will open another access database and inject vba modules, forms, macros, etc into it. (this way i can easily update my projects). the problem is it wont work if the project im injecting the code into is locked...

hey all, when i put my access database on a computer other than the one i developed it on, it complains about a missing reference (Microsoft office 12 object library). the older computers only have Microsoft office 11 object library. how do i add a reference to Microsoft office 11 object...

that was the best way i could think of to design it. if you know a better way id appreciate the help. the database is meant to capture responses to a survey. the survey has 7 sections. each section has about 50-200 questions. i have 8 tables (one table as the master table, 7 as children...

hi everyone. when i send an sql statement to update a table or add a record i am using the replace function [ie, replace (something, "'", "''")] to remove all single quotes from my string. are there other characters i need to remove as well that might cause problems? here is an example of my...

oh, i forgot. i have a lookup table with all the values and coresponding text.

hi everyone, i got a question in my forms i have a control that has two columns, one with text the other with a value (ie value1;0;value2;1...etc). when it gets saved to a table, i only save the value not the text (0,1...). now, when i want to load the data from this table to the forms listbox...

just a bit of advice, too. i had to do a similar thing but didnt realize that there is a limit to the number of controls per form (i think its 250 but could be wrong and remember this counts lables,lines, as well as textboxes, etc)

1: Private Sub CheckBox1_AfterUpdate() On Error GoTo errorhandler 'my checkboxes give values 1 or 2. your's might not. to see what values you give, use msgbox me.checkbox1.value If Me.CheckBox1.Value = 1 Then Me.textbox1.value= "DefaultValue" Else Me.CheckBox1.value=...

thanks guys for all your tips

hey guys, i also have another request. i created a program with access and was wondering if anyone would be willing to look at it. i would like to get feedback on: 1. Table/DB design 2. User freindlyness/form design 3. anything else that you might find I am working with an NGO doing...

hey everyone. i was wondering if anyone can help me out. ill be starting a larger project in a few months and was wondering if anyone had any good articles i could read. im looking for: 1. something about database design. this project could concievable be used on a very large scale. i want...

thats what i was afraid of. so, no way arround this huh?

i think i should explaine more: as an ex, i have a form with a check box and a text box. the check box has thsi onclick event: Private Sub CheckBox1_Click() If Me.CheckBox1.Value = -1 Then Me.TextBox2.Enabled = True Else Me.TextBox2.Enabled = False End If End Sub if the user checks the...

hi everyone. im looking for some help. when i programatically set a value for a control (ie, check a check box) why doesnt the associated event fire? for example, if i programatically set checkboxA to checked, the checkbox will become checked but the onclick event doesnt fire. how do i get...

hey everyone, i have a question about splitting an access db into front end and back end. ive never done this before and just wanted to ask some questions. heres what im doing: ive created a survey (7 forms, each form has about 3-5 tabs, each tab with 10-30 questions). the purpose of the...