Search results

Hello! I need to have the form evaulate code when a new record is open.... there are a couple of drop down boxes that determine whether or not fields are shown. I want the code to be evaulated every time the user either does a find or browses to a new record. How do I do this? Thanks!

So, is there a way to have an Update Query update based off of a spreadsheeT? The tutorial seems to indicate that you can only do an Update __ with ___ if X condition is met.

Okay, so I've ready over the tutorials and Help sites that were provided to me. It looks like a Update Quary only allows you to update information built in.... which doesn't help. (Replace ___ with ____ if x condition is met) What I have is a spreadsheet with a list of requisition numbers...

Actually... this helps a lot. Thank you :)

I'm working with Access 2007. Thanks for the tutorial! I'll take a look at this and let you know if I have any more questions. :0)

Hello! I originally posted this in the general forum because I did not know where to begin with my problem. (Link: http://www.access-programmers.co.uk/forums/showthread.php?t=148131 ) According to the person who responded, I need to create an update query. How do I do that? Thanks!

In noob speak please :)

Hello! So, I'm currently teaching myself Access as I go along. I have basic VB knowledge as well. The problem that I need to tackle is the following: I have a table that contains several fields... The 3 that have to deal with this are: Req#, Status, and Status date. Req number: primary Key...

Oh sweet! That worked. Thanks :0) I'm totally teaching myself as I go, if you can't tell. :0)

Hello, I need to write an if statement to base its action on if the character length is > 0 . I cannot figure out how to do this, as the length property doesn't seem to exsist. Any ideas? Thanks!

Oh! Yup that worked. Thanks a ton :)

Hello, I'm trying to code a button so that when it is clicked it creates a summary of the data that was entered. The following is my code so far: Private Sub GenerateSummary_Click() Dim tempsummary As String tempsummary = "Requisition generated at the request of" & Director.Text...

Oh, it makes sense. I'll have to try this out a little later today. Thanks again for all of your help!

Oh I just read this: The other way to do it is to create a form to popup when they click to run the query and from within that form have the Multiple Choice Combo box and then run the query from there. That's if you want a combo box to control the input. Do you mind walking me through this? I...

Actually yes.. that solves my problem. Sorry for being so confusing... Although I know what you guys just taught me will come in handy... So it wasn't a waste. :) Thank you!!!

Ohhh... No... :0) Basically, I want to setup a query so that it pulls up All of a type. So either All Additions or all Replacements. The thing is, I want it to provide a prompt at the time of the query for the user to pick rather then the query base itself off of the record that is currently...

I'm not sure that I'm following you... :0)

Oh okay, so I was taking some screenshots for you and I think I figured it out. What the query does, is it bases its results on the record that I have open, and what in particular that record has picked. So, if I have one open that has an "Addition" selected, it pulls all of the Additions...

Oh... it was because the form was closed. I didn't realize that caused it. Okay, so new problem! :0) Now, instead of getting a prompt it just pops up with everything that is "Addition". I still need the user to be able to choose which they want. (Replacement or Addition).

Okay, so I put that in. When I run it, it prompts the box to ask for the user to type in the parameter. What I'm wondering, is if the user can have something to pick from rather then having to know what the choices are from prior use of the form. IE: Combo Box has: Replacement and Additional...