Search results

thank you very much I feel so dumb for it to have been that simple. (Strange that the help cant index that info in a way where people can find it) thank you and good health. Alfred

Id like to put a field in the header of my form that will jump to a record based on partial entries typed in. For example... Jump to: Donh will jump to the Donhoo, Keneeda record. Is this possible? It would help with multiple entries. Im going to search for articles about setting up a...

Im trying to import from an existing Excel database, but the fields arent the same..which is causing problems. Since I know its easier to point from field to field in Excel, Im thinking of making a new,blank spreadsheet with the field headings from the Access Database that I ultimately want to...

but Ok. Im an idiot. Thanks. Ive just realize that my switchboard stays open even after it opens the correct form...Ill just make one that closes the form your in. Thanks though.

Im trying to make a command that closes the form you're in and goes back to the switchboard. The Wizard only gives you one command...how/where do you add another?

Ah.. ok Ah ok...I believed the help file that told me it was supposed to be in Tools...Add-Ins...Add-In Manager. I swear thats what it says. Now how do I give two commands to the same button? I want to make a navigation button that takes you back to the switchboard after you are done with...

Ive looked in Tools...Add-Ins...but theres no option for Switchboard Manager. Id really like to have a switchboard. Is there another way to create/edit one? Thanks

THANK YOU THANK YOU!!! Thank you from the bottom of my cold dark heart. It just so happened that I had re-named a field on the fly...and the disarity between the name in the table and the RE-name in the form properties was causing the problem. Lesson, kiddies? Its to make sure everything...

The program is corrupting ITSELF! I was getting help setting up references from one text box to another. Well I got one to work fine then I did another and they both flashed the #error field. I go back into the expressions...and there are extraneous [] marks around certain values...

Arrgh! The program is corrupting ITSELF! When I go back into the forms, the []'s are coming off...and it continually adds the [] around [Form]! Why is this happening? I had the first sum working...now both are in #error. This is the last part of this form...and Ill be done...sigh. Help...

thanks hmm... I just put that in and am getting an #error. Let me check the references (since I got the first sum to work) and see whats up.

Ok... Ok GREAT...got it to work Now...how do I do part 2? Each Amt has a date that it's attatched to...I need it to be summed if and only if the date it has attatched to it is earlier than today Now()

Two questions: First I need to put the sum for a range of values in a subform in the master. Im thinking I use the DSum(expr, domain[, criteria]) model. But I get an #error when I use: =DSum([Forms]![ReferralTable subform]![Referral Amt],[ReferralTable subform]) Am I getting the error...

GREAT!!!!! now.. Ok...THANK YOU! (bow) (bow) Now... I need to sum the values of one of the fields in the subform BASED on a value in another field. Im thinking I use the DSum(expr, domain[, criteria]) model. First question is the comma REALLY supposed to be inside the [ ]? Second question...

How do I set up a "form inside a form" like in the MS Access example template called "Service Order Manager ?" I say "form inside a form" (see attatched pic) because when I put the "Service Order Manager" db into design view , the object which allowed ongoing entries looked another form. How do...

Yes..thats a start Thanks thats a start. Can I insert a field that is a date using that command? E.g. DateAdd("m",1,[Field])?? Let me describe the way things happen. Let me say that I really appreciate any and all help. Im an independent re-seller of phone lines for $35 or $60 per month. If...

Great...getting closer Ok..Ill reformat using actual date fields...and learn those specific commands. Here's my next question....how would I insert a specific DAY to be auto inserted into a formula for mm/dd/yyyy ? (So that whatever variable the month becomes, the day stays constant)

Ok. Im new to Access and obviously need some help. I've just made a Table/Form to track the free credits my home business gives to customers. Generally, I record incoming credits that customers will have applied to their balance in the future. Each customer has a unique Bill Day, which is the...

thank you very much I got it to work thanks to you....DEEPLY APPRECIATED

sorry Im sorry. I double posted because I wasnt sure which of two avenues to pursue. Accept my apoloogies. I took the formula you gave me and posted it, but am getting a "#Name" error...is that because one of the field names in the formula is incorrect? Edit: I re-inserted the right fields...