I think this is an easy one, but I can't seem to find out how to do it.
Have a query against a field in a table that has multiple values...for each line item, the values in the field could be A or AB or even ABC or AGC or any combination of letters.
What is the syntax for the criteria...
Hello...
Hoping to get advise from you experts. Although I did read that 200+ postings thread about certifications -and it definitley was a downer - I think I need to go ahead and get something, but as a newbie I would like you advise of the best methods to use.
In brief, I am in my mid 30's...
Hello,
I have created an inventory database for my company that successfully tracks the entry and selling of widgets and comes up with a current inventory on hand form/report for the user.
Unfortunatly (for me!) the users have come back and decided (after i finished building it !!) that they...
I have a report that that the user creates based on an existing query. I have it set up so that the criteria the query runs on is based on a start date and an end date
Between [Start date] and [End date]
Works great - question is... how can I put the two dates selected by the user into two...
I have a presentation in Director 7 that closes with an AVI that I created / compiled out of 3d studio max 3. I have it set to Direct to stage with music playing at the same time - can't think of anything unusual I'm doing to it that I haven't done to any other AVI.
When I run the presentation...
Hello,
I have created a presentation in D7. I have a sound file looping in channel 1 throughout the entire presentation. In one section, the user clicks a button and a D7 projector (.exe) launches and runs a new presentation, with the original D7 presentation paused in the background...
Hi,
I have created a presentation which has a section that links to / runs a very large Quicktime video (300mb). You get to that section from the main menu of another Dir movie (In the "main" movie, you roll over an icon and then click it. on Mouseup you go to the "video"...
Hello,
I have recently bought a copy of D7 (the box doesn't day D7 Shockwave Studio...just D7). It works fine, but in looking at some D7 books, it seems that in the drag-and-drop library palette (I think that's what its called - where you can drag pre-built behaviors and scripts onto...
Probably a simple question - but I am new at this...
I have a small "cover program" that when a button is clicked on it, will launch a movie. both the program and movie are burned onto a cd. Since someone's cd drive could be any letter, how do I code it so it looks for the movie...
Ok - kind of a newbie question, but that's what I am...
I (finally) have a legal version of Director (7), but I have been tinkering with a copy of Director 8. I notice that in D7 I have far less stuff in the Library Palette - especially, I'm missing those in D8 for animation. I even tried to...
Can anyone show me or point me in the direction of how I would write code (a module?) that says something like "if some field gotfocus, change the color to X, on all lostfocus fields, change the color back to default. So - whatever field the user is currently in with their mouse changes...
Hi,
I have a form that is tied to a query. on the form I have two dropdown boxes - one lists all the possible "names" and the other lists all the possible "ranks" I want the user to be able to select a value in each dropdown to search on, then click a button which will...
Hello,
If you care, this is a continuation of a post I wrote on 3/12 about "Inventory Tracking..." I have not been able to make your suggestions work - I think I boxed myself into a corner because of dropdown boxes, format, and subforms. Anyway, this is my new solution to flag...
Hello
This forum has been fantastically helpful to me as an "advanced novice" Access creator - I have learned tons!
I would like to ask you all for recommendations for a good reference/learning book about VBA. I am not a programmer, nor do I want to study some 800 page programmer's...
As mentioned briefly in a previous post, I have a macro button that executes an append query and then a delete query to "save" records that have been entered into a form - actually, these saved records are within a subform. My problem is that when the macro executes and does it's job...
Hello,
I have created a macro that executes an append query and then a delete query. It is executed when the end user presses a button on a form. The macro works perfectly, except I don't want to confuse or labor the user with having to answer all of those "are you sure you want to do...
I know this is probably a no-brainer, but I've never done it before..I just need to see what the VBA code looks like and I can go from there...
I have a product invoice report - based on a query that asks the user for a company name and an invoice date. It works perfectly. What I want to do...
I know this is probably a no-brainer, but I've never done it before..I just need to see what the VBA code looks like and I can go from there...
I have a product invoice report - based on a query that asks the user for a company name and an invoice date. It works perfectly. What I want to do...
Hello,
I am creating an inventory database. I have a form (based on a query) that indicates if the current inventory is below the reorder point- I am using an IIF statement in my query. What I am trying to do is write a macro that is attached to the startup switchboard form, so that before...
Hi,
Is there a way I can do a string search in a field of a table using a prompt box? Ex...I have a field in my table of names in a format like, "Mr. and Mrs. George Bush." I would like to set up a query that pops up a box that prompts the user to enter the name/word they want to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.