Search results

i inherited a table that has errors. i would like to write a delete query or go into the table and delete those records. however, when i try i get an eror message "could not delete from specified table". it is a linked table. how can i delete those records?

i have a subform in continuous form format. one field on that subform can be of various lengths. how can i set that field to grow if it is longer. can i make it shrink if it is empty? (cangrow and canshrink don't work in a form)

i have the dlookup on the afterupdate of one of the fields. once a user enters a member number, the dlookup gets all his info. on the oncurrent of the form, i have Private Sub Form_Current() If Me.NewRecord Then Me.AllowEdits = True Me.AllowDeletions = True Me.AllowAdditions = True Else...

i have a form that use dlookup to find info based on one field. that works fine. however, when i want to enter info for another prospect, the old one's info (that was obtained through dlookup) is still there. all the rest of the info is gone. i want to have a clear form with no info at all. i...

i have a combobox which must be filled with one of the records in the list. if it is not on the list i want to open a form (pop-up or otherwise) for the user to put in information. (this form is already created and has a subform where the data will be added. this form can also be used without...

it works now. the name of my function must have been a reserved word.

i don't have to pass any info or anything. it is just coding to gather a few fields to make a comprehensible note in a new field. (the user then clicks a button if she likes the note, otherwise she can make changes.)

i should know this, but ... i have some coding that is used as the afterupdate for many fields on my report. i know i should make a public function for it and then call it as necessary. but it doesn't seem to work the way i did it. ( i know the coding is fine) what should i be doing? how do i...

i am trying to make a subform that would include the notes for the particular member. i have made a query that will pull up all the notes for a particular member. the query shows many results, but on the form (in single form format), i only get the first one. if i do it in datasheet format, i...

this is what i did for those you are looking for a similar solution, this is what i did. while this may not be fancy coding, this works. first i made a subform on the form that contains the old notes and member id (linked by member id) and then this coding: 'add to notes Set db =...

the program he wrote is very limited and i have no access to the coding only to the tables. so i am writing a program for the users for the functions that are not included in his program. but for the functions that work in his program, they will still use his program. i don't want users to...

i inherited this problem. every member has notes. the problem is the way the system is set up now, each time a new note is added it is added to the notes field. for example: the notes field already reads "abc" then today i add a note "def" the notes field now reads "abc...

i have a few subforms on the same main form. the user can fill in as many subforms as necessary. in some of the subforms, if they fill in one field, another few fields must be filled in. before they move to the next record (on the main form), i want to check that all necessary info is on the...

i guess i wasn't clear. the dependent table has a field that says "spouse", "child", etc. i need to make the code based on the type of relationship. spouse will be "02", the first child will be "03". if there is another child, he is "04", etc.

i inherited 2 tables - one for members, the other for the member's dependents. the dependent table has a field for the relationship - spouse, child, parent, grandparent. they are linked by member id. i need to identify the type of dependent with a 2 digit code. but the tricky part is: the first...

i want to archive my transaction table. (i can do that). and then empty out the table. i need to update the transaction table with just the balances for each account. ( i can figure out the balances, as well). my problem is that i need to use transaction numbers for the record for each...

great!

i understand the if part of the statement. i do not understand teh MEPAGE. what i am looking for is: even page footer - "call us at 888-999-9999" and page number on the left. odd page footer - "for best prices" and page number on the right. how do i do that?

how can i make every other line (every other record) grey?

i need different footers for odd and even pages. i now in word it is very simple, but how can i do this in access?