Search results

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

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

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

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

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

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

hey all. heres a bit of a challenge: i have 6 forms with about 100 controls(a mix of checkboxs, textbox, and group controls, and combo boxes as well as labels and each form varies in the number of controls) on each on. each control, that im concerned with, is named in this manner: Q000...

hi everyone. im trying to create a string builder and ran into a problem. i have a form with 185 controls on it. i want to create an automated sql insert statement using a for loop. (ie. insert into MyTable (q000,q001...q185) values...

anyone know a way to capture multiple key strokes when a form is open? when a form is open and the user presses a combination of keys at the same time (ie cntrl+j) i want an event to fire. (much like when you hit cntrl+alt+del in windows) microsoft access 2003

hey everyone. im trying to create a control that, when the report is opened, will change text according to a condition. example: on my report i have a group header. if the group header's text equalls "11" i want the text/caption to be changed to "Lobatse District". ive seen that you can...

in access 2003 i have created a form with a custom toolbar. on the toolbar is a menu with three choices. i want to create an immage by one of the items. when the user selects another item, i want that once to recieve the immage (and the last one chose to loose it). i know i can do this in...

hey everyone. can anyone look at my code and tell me what im doing wrong? im trying to open up a recordset with all rows from a table but when i do, it just has the first row. i know the sql string is correct because when i run it in the querry builder, it has all rows Option Compare...

one more thing. in the query design window, for an update query, you can enter criterias. what if your criteria is an empty (or null) value. i tried just using Is Null but it doesnt replace the old values. (ie, if value = "N/A" or null value, change to 99)

hey everyone, i need some quick help if anyone has time. i need to create a procedure that will go through a table and change all values that meet a criteria (ie. if a value is "N/A" then change it to "99"). does anyone know any good vba procedures for this? or can the actual access db this on...

hey guys, im new to creating reports. im hoping someone can help me. im trying to create a report with charts. heres what my situation is: i have a table with the responses to a survey. when the survey results are inserted to the table, i only enter the codes, not the strings (ie. ans1 = 0 or 1)...

hey everyone. i was wondering if anyone knows how to test a string to see if its formatted corretly. on a form, before sending it to the table, i have a field for Date of birth. because some of the people who will be filling in this form dont know their birthdays i need to be able to take in...