Search results

  1. Adrianna

    Append and Delete without 2nd prompt

    Okay...I know there have been alot of discussions about this, but this is not exactly the same. I have an option on my main switchboard allows the users to Archive certain records by running an append query. The users are prompted for the two fields that make up the Primary key...then the...
  2. Adrianna

    Append Query problem

    I read throught the message very carefully and noticed that it seemed to be running into a key conflict. So, I removed the key from the Master field and I was able to APPEND some of the new data. Unfortunately only 167 of 288 records were able to transfer. The warning only mentions loosing 6...
  3. Adrianna

    Append Query problem

    Bummer.....I guess it's not my day. Access 2002 errors all day and then this: I have a simple append query adding fields from an imported table into my Master Table. Only two of the friends are different and I'm not really worried about them defaulting to null. When I run the query it tells...
  4. Adrianna

    Update Field Based on Another Field

    Rich, THank you so much. I figured there had to be a way to call a "method" or "function" from another event. That's exactly what I was looking for. Thank you so much!!! :)
  5. Adrianna

    Update Field Based on Another Field

    Rich, That was the question....I was wondering if there was a way around placing the same code in 33 locations. Seems very redundant to me. Can't I place it in the OnCurrent and the OnChange events of the form without having to place the code in every single field that affects that...
  6. Adrianna

    Random number generation

    Read this link....it might be a great help: Random number thread from an old posting
  7. Adrianna

    Update Field Based on Another Field

    Same thing on a Grander scale Pat....or anyone else that can help! Okay....I'd tested everything out on the question above and all seems to be working well....but if I have to place the code into each variable as well as the form, then this next problem is going to be cumbersome and seem...
  8. Adrianna

    Update Field Based on Another Field

    Like always..You're Brilliant Pat! That fixed it like a charm! I knew that it had to be something simple that I was over looking. I think my mind is just on holiday with the rest of my office:) Thanks All!
  9. Adrianna

    Update Field Based on Another Field

    Graham, Thanks for the input about the checkbox. I actually decided to delete the checkbox all together. Who needs to see a check box if there is already a date. I'm hoping that it will be obvious enough that having a date means that it has been completed. As for the second...
  10. Adrianna

    Update Field Based on Another Field

    I know...I know...this topic is highly exhausted, but I just can't figure out what the heck I'm doing wrong. So...please bear with me. I have two fields that I want to automatically full based upon information in other fields. I'm not looking up values...just assigning them based upon other...
  11. Adrianna

    Populating Fields

    Okay...i think that I would work with a different structure then the idea that you are working with...but if you must stick with that...I would add your one to many relationships to link your EmpID fields. Make the row source for the listbox "Table/Query" and pull from your EmpID table. If you...
  12. Adrianna

    Populating Fields

    Hmm...you want to populate a totally new table with EmpID information off a drop down list. Hmmm...this doesn't seem to make sense, but I would suggest using a "make a table macro". Where your drop down list provides the variable to be queried againt. :rolleyes: Still sounds strange to me...
  13. Adrianna

    Access 2000 Listbox - Multiselect Reports

    Benny! Are they thankful enough to provide me employment!!;) I'm actually employed at the moment, but I had been thinking about switching coastlines! Anyway, as for the all selection: Simple Examples of various functions The site above addresses one of your questions. As for...
  14. Adrianna

    Background images.

    No...it doesn't matter where the mage file is when you link it because the database stores the path. BUT if you ever intend on moving the database, then your path may change, so by keeping the image in the same folder on your hard drive as your database, you can use a UNC path that will...
  15. Adrianna

    Background images.

    how large is your picture? and did you choose to link it ....or embed it? if you embedded it, then you probably have the same image 14 times....because it is stored for each report. if you link the picture....then you will have to keep the picture in your database folder, but it will not (or...
  16. Adrianna

    Query's result in text field

    Wow...I'm either really tired and confused, or you are trying to perform something that I just can't reason with. Are you asking to have all of the query records presented on the same form? If you run the form off the query you will limit the records that you see to the query fields. Each of...
  17. Adrianna

    Access 2000 Listbox - Multiselect Reports

    Wrong Zip File Benny, I didn't mean for you to download the problem database. I wanted you to scroll down and download the musicsolution.zip file that I posted. I was a little confused trying to figure out why my solution would not function on your computer...then I realized that you'd...
  18. Adrianna

    Query's result in text field

    The query only selects the records with fields the meet the criteria that you provide. Are you wanting to place each of the results into individual fields? If you want to use the resulted information from your query, just base your forms or reports on the new information by setting the...
  19. Adrianna

    Access 2000 Listbox - Multiselect Reports

    Benny, It is always a good idea to Search the forums before posting a question or request. I know that sometimes it is hard to find something that works exactly like you want. That is when you ask for help! Anyway, this old posting should help you out: Old MultiSelect ListBox Posting :D
  20. Adrianna

    Contains data that the form doesn't recognise ??

    I would suggest trying to delete that errorred form and then importing it from the 2000 database into the 97. Or If the form doesn't have to many bells and whistles...then just recreate it. Sometimes you can waste much more time trouble shooting then you would if you just recreated what you...
Back
Top Bottom